Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ : access

AccessÊý¾Ý¿â¹Ø¼ü×Ö

ÒÔÏÂΪAccessÊý¾Ý¿â¹Ø¼ü×Ö:  Èç¹ûÓõ½INSERT INTO Óï¾äµÄÓï·¨´íÎó¡£
-A
ADD
ALL
Alphanumeric
ALTER
AND
ANY
Application
AS
ASC
Assistant
AT
AUTOINCREMENT
Avg
-B
BETWEEN
BINARY
BIT
BOOLEAN
BY
BYTE
-C
CHAR, CHARACTER
COLUMN
CompactDatabase
CONSTRAINT
Container
Count
COUNTER
CREATE
CreateDatabase
CreateField
CreateGroup
CreateIndex
CreateObject
CreateProperty
CreateRelation
CreateTableDef
CreateUser
CreateWorkspace
CURRENCY
CurrentUser
-D
DATABASE
DATE
DATETIME
DELETE
DESC
Description
DISALLOW
DISTINCT
DISTINCTROW
Document
DOUBLE
DROP
-E
Echo
Else
End
Eqv
Error
EXISTS
Exit
-F
FALSE
Field, Fields
FillCache
FLOAT, FLOAT4, FLOAT8
FOREIGN
Form, Forms
from
Full
FUNCTION
-G
GENERAL
GetObject
GetOption
GotoPage
GROUP
GROUP BY
GUID
-H
HAVING
-I
Idle
IEEEDOUBLE, IEEESINGLE
If
IGNORE
Imp
IN
INDEX
Index, Indexes
INNER ......

AccessµÄDBHelper.cs

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.OleDb;
using System.Configuration;
namespace TaobaoDAL
{
public class DBHelper
{
//Òýµ¼Êý¾Ý¿âÁ¬½ÓÊý¾Ý¿âµ÷ÓÃWeb.ConfigÎļþ
private static OleDbConnection connection;
//´´½¨Á¬½Ó|DataDirectory|\SchoolDB.mdb
public static OleDbConnection Connection
{//Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.mappath("tushu.mdb")";Persist Security Info=False
get
{
OleDbConnection myConn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\taobao.mdb");
string connectionString = myConn.ConnectionString;
if (connection == null)
{
connection = new OleDbConnection(connectionString);
//´ò¿ªÁ¬½Ó
connection.Open() ......

AccessµÄתÒÆ×Ö·û

AccessÖÐÊý¾Ý¿âתÒå×Ö·û¹æÔò£º
 
²åÈë¡¢¸üС¢=Æ¥Åä Êý¾Ýʱ£¬Îı¾ÀàÐÍÈçÓÃ''À¨ÆðÀ´£¬Öмä¿ÉÒÔÓÐ ",*,%,[,],\,/,?,(,),{,}µÄÈÎÒâ×éºÏ£¬ÈçÒª²åÈëÒ»¸ö',Ðèд''²¢ÔÚÕû¸ö±í´ïʽÍâÌ×Ò»¶Ô''
È磬²åÈë 'ÕÅ''Èý',Êý¾Ý¿âÀï¾ÍÊÇ ÕÅ'Èý£¬Ó÷½À¨ºÅÊDz»¿ÉÒÔµÄ
 
²åÈë¡¢¸üС¢=Æ¥Åä Êý¾Ýʱ£¬Îı¾ÀàÐÍÈçÓÃ""À¨ÆðÀ´£¬Öмä¿ÉÒÔÓÐ ',*,%,[,],\,/,?,(,),{,}µÄÈÎÒâ×éºÏ£¬ÈçÒª²åÈëÒ»¸ö',Ðèд''²¢ÔÚÕû¸ö±í´ïʽÍâÌ×Ò»¶Ô""
È磬²åÈë"ÕÅ""Èý",Êý¾Ý¿âÀïÊÇ ÕÅ"Èý
Ä£ºýÆ¥Åäʱ£¬Îı¾ÀàÐÍÓÃ''À¨ÆðÀ´,Öмä¿ÉÒÔÓÐ ",*,],\,/,(,),{,}ÈÎÒâ×éºÏ,¶Ô[,%,?,ÐèÒªÔÚÿ¸öÌØÊâ·ûºÅ×óÓÒ½ô¸ú×ÅÌ×Ò»¶Ô[],
           ÈçҪƥÅä[?,Ӧд Like '%[[][?]%',²»ÄÜд Like '%[[?]%',ºóÕß»áÆ¥Å京ÓÐ[»ò?µÄ¼Ç¼£¬¶ø[?²»Ò»¶¨»áÆ¥Åäµ½½ô°¤Ò»Æð¡£
×ܽ᣺
²åÈë¡¢¸üС¢µÈÓÚÆ¥Åä Êý¾Ýʱ£¬Í³Ò»½«Îı¾ÀàÐÍÓÃ''À¨ÆðÀ´£¬Ö»ÐèÒª½«´ý²åÈë±í´ïʽÖеÄ'ת»¯Îª''
ÔÚÄ£ºýÆ¥Åäʱ£¬Îı¾ÀàÐÍͳһÓÃ''À¨ÆðÀ´£¬½«'תΪ'',ͬʱ¶Ôÿһ¸ö[,%,?,¶¼ÓÃÒ»¶Ô·½À¨ºÅÀ¨ÆðÀ´
ʾÀý£º
insert into Test(Name) values("ÓÃ'Ë«''Òý\/*%%_[[]ºÅ""À¨ÆðÀ´")
      &nb ......

access sql server Êý¾Ý¿â Êý¾Ýµ¼³ö

×òÌìŪÁËÒ»¸ö±È½Ï¼¬ÊÖµÄÎÊÌâ¡£´ÓÍøÉÏÏÂÔØÁËÒ»¸öÈí¼þ£¬ËûµÄÊý¾Ý¿âÊÇaccessµÄ£¬´ò¿ª¿´ÁËһϣ¬¸Ð¾õ²»´í£¬ÊʺÏÎÒÏÖÔÚÏîÄ¿µÄÐèÇ󣬴󲿷ÖÄܹ»Âú×ãÎÒµÄÏîÄ¿ÐèÒª£¬¾ÍÏëÄÃÀ´Ö÷Òå¡£¿ÉÊÇÎÒÃÇÏîÄ¿µÄÊý¾Ý¿âÒ»Ö±¶¼ÊÇÓõÄsqlserver£¬ÓÚÊÇ£¬¾ÍÔÚÍøÉÏ·è¿ñµÄ£¬ÕÒ¹ØÓÚaccessת»»ÎªsqlserverµÄ×ÊÁÏÔÚÕâÀïÎÒÏë˵һÏÂÓйصÄ×¢ÒâÊÂÏ
Êý¾Ý¿âÉýǨת»»access---sqlserver£º
   1.Ê×ÏÈҪ˵µÄÊÇÄãµÄÊý¾Ý¿â±ØÐëÊÇ£¬Í¨¹ý°²×°Ïòµ¼°²×°µÄ£¬ÂÌÉ«°æµÄaccess²»ÐС£ 
   2 .Èç¹û±»×ª»»µÄÊý¾Ý¿â°æ±¾±È½ÏÔ磬ÀýÈçÊÇaccess97£¬ÐèÒªÏȽ«Êý¾Ý¿âÓÃaccessת»»ÎÊ2000»òÕß2003¡£
   3.ת»»µÄ¹ý³Ì²½Öè¾Í²»ËµÁË£¬ÍøÂçÉϺܶࡣȻºó´ò¿ª×ª»»ºóµÄaccessÊý¾Ý¿â£¬Ö´ÐГ¹¤¾ß”---“Êý¾Ý¿âʵÓù¤¾ß”---“ÉýǨÏòµ¼”£¬½«accessÊý¾Ý¿âת»»ÎªsqlserverÊý¾Ý¿â£¬×ª»»Íê³Éºó£¬´ò¿ªsqlserverÊý¾Ý¿âµÄ“ÆóÒµ¹ÜÀíÆ÷”¾Í»á·¢ÏÖÊý¾Ý¿âÒѾ­ÔÚÀïÃæÁË¡£
Êý¾Ý¿âÊý¾Ýµ¼³öÎÊÌ⣺
   ½ñÌì·ÑÁ˺ܳ¤µÄʱ¼äÍê³ÉÕâ¸öÄÑÌâ¡£»¹ÊÇÓ×ÖɵÄÔÚGoogleÉÏÃæËÑ“sql Êý¾Ýµ¼³ö ”Ö®ÀàµÄ¡£
    ·½·¨Ò»£ºÀûÓÃÊý¾Ý¿âµ¼³öÏòµ¼sqlserverÀ ......

access sql server Êý¾Ý¿â Êý¾Ýµ¼³ö

×òÌìŪÁËÒ»¸ö±È½Ï¼¬ÊÖµÄÎÊÌâ¡£´ÓÍøÉÏÏÂÔØÁËÒ»¸öÈí¼þ£¬ËûµÄÊý¾Ý¿âÊÇaccessµÄ£¬´ò¿ª¿´ÁËһϣ¬¸Ð¾õ²»´í£¬ÊʺÏÎÒÏÖÔÚÏîÄ¿µÄÐèÇ󣬴󲿷ÖÄܹ»Âú×ãÎÒµÄÏîÄ¿ÐèÒª£¬¾ÍÏëÄÃÀ´Ö÷Òå¡£¿ÉÊÇÎÒÃÇÏîÄ¿µÄÊý¾Ý¿âÒ»Ö±¶¼ÊÇÓõÄsqlserver£¬ÓÚÊÇ£¬¾ÍÔÚÍøÉÏ·è¿ñµÄ£¬ÕÒ¹ØÓÚaccessת»»ÎªsqlserverµÄ×ÊÁÏÔÚÕâÀïÎÒÏë˵һÏÂÓйصÄ×¢ÒâÊÂÏ
Êý¾Ý¿âÉýǨת»»access---sqlserver£º
   1.Ê×ÏÈҪ˵µÄÊÇÄãµÄÊý¾Ý¿â±ØÐëÊÇ£¬Í¨¹ý°²×°Ïòµ¼°²×°µÄ£¬ÂÌÉ«°æµÄaccess²»ÐС£ 
   2 .Èç¹û±»×ª»»µÄÊý¾Ý¿â°æ±¾±È½ÏÔ磬ÀýÈçÊÇaccess97£¬ÐèÒªÏȽ«Êý¾Ý¿âÓÃaccessת»»ÎÊ2000»òÕß2003¡£
   3.ת»»µÄ¹ý³Ì²½Öè¾Í²»ËµÁË£¬ÍøÂçÉϺܶࡣȻºó´ò¿ª×ª»»ºóµÄaccessÊý¾Ý¿â£¬Ö´ÐГ¹¤¾ß”---“Êý¾Ý¿âʵÓù¤¾ß”---“ÉýǨÏòµ¼”£¬½«accessÊý¾Ý¿âת»»ÎªsqlserverÊý¾Ý¿â£¬×ª»»Íê³Éºó£¬´ò¿ªsqlserverÊý¾Ý¿âµÄ“ÆóÒµ¹ÜÀíÆ÷”¾Í»á·¢ÏÖÊý¾Ý¿âÒѾ­ÔÚÀïÃæÁË¡£
Êý¾Ý¿âÊý¾Ýµ¼³öÎÊÌ⣺
   ½ñÌì·ÑÁ˺ܳ¤µÄʱ¼äÍê³ÉÕâ¸öÄÑÌâ¡£»¹ÊÇÓ×ÖɵÄÔÚGoogleÉÏÃæËÑ“sql Êý¾Ýµ¼³ö ”Ö®ÀàµÄ¡£
    ·½·¨Ò»£ºÀûÓÃÊý¾Ý¿âµ¼³öÏòµ¼sqlserverÀ ......

AccessÓëSqlServerÊý¾ÝÀàÐͱȽÏ,timestampʱ¼ä´ÁÏê½â

Ò»¡¢AccessÓëSqlServerÊý¾ÝÀàÐÍ±È½Ï Microsoft Access Êý¾ÝÀàÐÍ SQL Server Êý¾ÝÀàÐÍ ÊÇ/·ñ£¬£¨0ºÍ-1£©
1 룬²»ÔÊÐíÓÐ Null Öµ¡£ bit(1¡¢0 »ò NULL) Êý×Ö£¨×Ö½Ú£©£¨0~255£©
1¸ö×Ö½Ú£¬ÎÞСÊýλ tinyint£¨0~255£©
´óСΪ 1 ×Ö½Ú Êý×Ö£¨ÕûÐÍ£©£¨-32768~32767£©
2 ¸ö×Ö½Ú, ÎÞСÊýλ smallint£¨-32768~32767£©
´óСΪ 2 ¸ö×Ö½Ú Êý×Ö£¨³¤ÕûÐÍ£©£¨-2,147,483,648~2,147,483,647£©
ĬÈÏÖµ£¬4¸ö×Ö½Ú£¬ÎÞСÊýλ int £¨-2^31 (-2,147,483,648) ~ 2^31 - 1 (2,147,483,647)£©
´æ´¢´óСΪ 4 ¸ö×Ö½Ú¡£int µÄ SQL-92 ͬÒå×ÖΪ integer Êý×Ö£¨µ¥¾«¶È¸¡µãÐÍ£©
¸ºÖµ:3.402823E38 ~ -1.401298E-45
ÕýÖµ:1.401298E-45 µ½ 3.402823E38 ......

AccessÓëSqlServerÊý¾ÝÀàÐͱȽÏ,timestampʱ¼ä´ÁÏê½â

Ò»¡¢AccessÓëSqlServerÊý¾ÝÀàÐÍ±È½Ï Microsoft Access Êý¾ÝÀàÐÍ SQL Server Êý¾ÝÀàÐÍ ÊÇ/·ñ£¬£¨0ºÍ-1£©
1 룬²»ÔÊÐíÓÐ Null Öµ¡£ bit(1¡¢0 »ò NULL) Êý×Ö£¨×Ö½Ú£©£¨0~255£©
1¸ö×Ö½Ú£¬ÎÞСÊýλ tinyint£¨0~255£©
´óСΪ 1 ×Ö½Ú Êý×Ö£¨ÕûÐÍ£©£¨-32768~32767£©
2 ¸ö×Ö½Ú, ÎÞСÊýλ smallint£¨-32768~32767£©
´óСΪ 2 ¸ö×Ö½Ú Êý×Ö£¨³¤ÕûÐÍ£©£¨-2,147,483,648~2,147,483,647£©
ĬÈÏÖµ£¬4¸ö×Ö½Ú£¬ÎÞСÊýλ int £¨-2^31 (-2,147,483,648) ~ 2^31 - 1 (2,147,483,647)£©
´æ´¢´óСΪ 4 ¸ö×Ö½Ú¡£int µÄ SQL-92 ͬÒå×ÖΪ integer Êý×Ö£¨µ¥¾«¶È¸¡µãÐÍ£©
¸ºÖµ:3.402823E38 ~ -1.401298E-45
ÕýÖµ:1.401298E-45 µ½ 3.402823E38 ......

VC++ÖÐʹÓÃADO·½Ê½²Ù×÷ACCESSÊý¾Ý¿â(תÔØ)

VC++ÖÐʹÓÃADO·½Ê½²Ù×÷ACCESSÊý¾Ý¿â
תÔØ£ºhttp://www.programbbs.com/doc/3078.htm
ADO(ActiveX Data Object)ÊÇMicrosoftÊý¾Ý¿âÓ¦ÓóÌÐò¿ª·¢µÄнӿڣ¬Êǽ¨Á¢ÔÚOLE DBÖ®Éϵĸ߲ãÊý¾Ý¿â·ÃÎʼ¼Êõ£¬¼´Ê¹Äã¶ÔOLE DB£¬COM²»Á˽âÒ²ÄÜÇáËɶԸ¶ADO,ÒòΪËü·Ç³£¼òµ¥Ò×Óã¬ÉõÖÁ±ÈÄãÒÔÍùËù½Ó´¥µÄODBC API¡¢DAO¡¢RDO¶¼ÒªÈÝÒ×ʹÓ㬲¢²»Ê§Áé»îÐÔ¡£±¾ÎÄÏêϸµØ½éÉÜÔÚVisual C++¿ª·¢»·¾³ÏÂÈçºÎʹÓÃADOÀ´½øÐÐÊý¾Ý¿âÓ¦ÓóÌÐò¿ª·¢¡£
Ò»¡¢ÊµÏÖ·½·¨
¡¡¡¡ÍòÊ¿ªÍ·ÄÑ£¬ÈκÎÒ»ÖÖм¼Êõ¶ÔÓÚ³õѧÕßÀ´Ëµ×îÖØÒªµÄ»¹ÊÇ"ÈëÃÅ"£¬ÕÆÎÕÆäÒªµã¡£ÈÃÎÒÃÇÀ´¿´¿´ADOÊý¾Ý¿â¿ª·¢µÄ»ù±¾Á÷³Ì°É£¡ËüµÄ»ù±¾²½ÖèÈçÏ£º
¡¡¡¡£¨1£©³õʼ»¯COM¿â£¬ÒýÈëADO¿â¶¨ÒåÎļþ
¡¡¡¡£¨2£©ÓÃConnection¶ÔÏóÁ¬½ÓÊý¾Ý¿â
¡¡¡¡£¨3£©ÀûÓý¨Á¢ºÃµÄÁ¬½Ó£¬Í¨¹ýConnection¡¢Command¶ÔÏóÖ´ÐÐSQLÃüÁ»òÀûÓÃRecordset¶ÔÏóÈ¡µÃ½á¹û¼Ç¼¼¯½øÐвéѯ¡¢´¦Àí¡£
¡¡¡¡£¨4£©Ê¹ÓÃÍê±Ïºó¹Ø±ÕÁ¬½ÓÊͷŶÔÏó¡£
¡¡¡¡ÏÂÃæÎÒÃǽ«Ïêϸ½éÉÜÉÏÊö²½Öè²¢¸ø³öÏà¹Ø´úÂë¡£
¡¡¡¡1¡¢COM¿âµÄ³õʼ»¯
¡¡¡¡ÎÒÃÇ¿ÉÒÔʹÓÃAfxOleInit()À´³õʼ»¯COM¿â£¬ÕâÏ×÷ͨ³£ÔÚCWinApp::InitInstance()µÄÖØÔغ¯ÊýÖÐÍê³É£¬Çë¿´ÈçÏ´úÂë:
BOOL CADOTest1App::InitInstance()
{
¡¡AfxOleI ......

VC++ÖÐʹÓÃADO·½Ê½²Ù×÷ACCESSÊý¾Ý¿â(תÔØ)

VC++ÖÐʹÓÃADO·½Ê½²Ù×÷ACCESSÊý¾Ý¿â
תÔØ£ºhttp://www.programbbs.com/doc/3078.htm
ADO(ActiveX Data Object)ÊÇMicrosoftÊý¾Ý¿âÓ¦ÓóÌÐò¿ª·¢µÄнӿڣ¬Êǽ¨Á¢ÔÚOLE DBÖ®Éϵĸ߲ãÊý¾Ý¿â·ÃÎʼ¼Êõ£¬¼´Ê¹Äã¶ÔOLE DB£¬COM²»Á˽âÒ²ÄÜÇáËɶԸ¶ADO,ÒòΪËü·Ç³£¼òµ¥Ò×Óã¬ÉõÖÁ±ÈÄãÒÔÍùËù½Ó´¥µÄODBC API¡¢DAO¡¢RDO¶¼ÒªÈÝÒ×ʹÓ㬲¢²»Ê§Áé»îÐÔ¡£±¾ÎÄÏêϸµØ½éÉÜÔÚVisual C++¿ª·¢»·¾³ÏÂÈçºÎʹÓÃADOÀ´½øÐÐÊý¾Ý¿âÓ¦ÓóÌÐò¿ª·¢¡£
Ò»¡¢ÊµÏÖ·½·¨
¡¡¡¡ÍòÊ¿ªÍ·ÄÑ£¬ÈκÎÒ»ÖÖм¼Êõ¶ÔÓÚ³õѧÕßÀ´Ëµ×îÖØÒªµÄ»¹ÊÇ"ÈëÃÅ"£¬ÕÆÎÕÆäÒªµã¡£ÈÃÎÒÃÇÀ´¿´¿´ADOÊý¾Ý¿â¿ª·¢µÄ»ù±¾Á÷³Ì°É£¡ËüµÄ»ù±¾²½ÖèÈçÏ£º
¡¡¡¡£¨1£©³õʼ»¯COM¿â£¬ÒýÈëADO¿â¶¨ÒåÎļþ
¡¡¡¡£¨2£©ÓÃConnection¶ÔÏóÁ¬½ÓÊý¾Ý¿â
¡¡¡¡£¨3£©ÀûÓý¨Á¢ºÃµÄÁ¬½Ó£¬Í¨¹ýConnection¡¢Command¶ÔÏóÖ´ÐÐSQLÃüÁ»òÀûÓÃRecordset¶ÔÏóÈ¡µÃ½á¹û¼Ç¼¼¯½øÐвéѯ¡¢´¦Àí¡£
¡¡¡¡£¨4£©Ê¹ÓÃÍê±Ïºó¹Ø±ÕÁ¬½ÓÊͷŶÔÏó¡£
¡¡¡¡ÏÂÃæÎÒÃǽ«Ïêϸ½éÉÜÉÏÊö²½Öè²¢¸ø³öÏà¹Ø´úÂë¡£
¡¡¡¡1¡¢COM¿âµÄ³õʼ»¯
¡¡¡¡ÎÒÃÇ¿ÉÒÔʹÓÃAfxOleInit()À´³õʼ»¯COM¿â£¬ÕâÏ×÷ͨ³£ÔÚCWinApp::InitInstance()µÄÖØÔغ¯ÊýÖÐÍê³É£¬Çë¿´ÈçÏ´úÂë:
BOOL CADOTest1App::InitInstance()
{
¡¡AfxOleI ......
×ܼǼÊý:314; ×ÜÒ³Êý:53; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [22] [23] [24] [25] 26 [27] [28] [29] [30] [31]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ