ΪaccessÊý¾Ý¿â´´½¨ÓµÓв»Í¬·ÃÎÊȨÏÞµÄÓû§
JavaÅàѵ¿Î³ÌÖ®Êý¾Ý¿â¼¼Êõѧϰ
¿´µ½ºÜ¶à³õѧÕß·´¸´ÎÊÕâ¸öÎÊÌ⣬дÁËÒ»¸öºÜ¼òµ¥µÄÒ»¸ö½Å±¾£¬ÓÃÓÚ×Ô¶¯ÉèÖû·¾³±äÁ¿¡£°Ñ´úÂ뿽±´£¬Áí´æΪjavaEnv.bat¡£°²×°ÍêJava 2 SDKÖ®ºó£¬¿ªÒ»¸öÃüÁîÐд°¿Ú,ÊäÈëjavaEnv java2SDKDir(java2SDKDirÊÇÄãµÄjavaµÄ°²×°Ä¿Â¼£¬²»´ø·¾¶×îºóµÄ\¡£Èç¹û°²×°Â·¾¶ÖÐÓпոñ£¬ÇëÓÃjavaEnv "java2SDKDir"¸ñʽ)²¢ÔËÐС£(×¢£ºÒ»¶¨ÒªÔÚjavaEnvºó±ß¼ÓÉÏÄãµÄsdkµÄĿ¼)
@echo ÄãÌṩµÄjdk°²×°Ä¿Â¼Îª£º%1
@echo off
IF EXIST %1\bin\java.exe (
rem ÈçÊäÈëÕýÈ·µÄ Java2SDK °²×°Ä¿Â¼£¬¿ªÊ¼ÉèÖû·¾³±äÁ¿
@setx JAVA_HOME %1
@setx path %JAVA_HOME%\bin;%path%
@setx classpath %classpath%;.
@setx classpath %classpath%;%JAVA_HOME%\lib\tools.jar
@setx classpath %classpath%;%JAVA_HOME%\lib\dt.jar
@setx classpath %classpath%;%JAVA_HOME%\jre\lib\rt.jar
@echo on
@echo Java 2 SDK »·¾³²ÎÊýÉèÖÃÍê±Ï£¬Õý³£Í˳ö¡£
) ELSE (
IF %1=="" (
rem ÈçûÓÐÌṩ°²×°Ä¿Â¼£¬Ìáʾ֮ºóÍ˳ö
@echo on
@echo ûÓÐÌṩ Java2SDK µÄ°²×°Ä¿Â¼,²»×öÈκÎÉèÖã¬ÏÖÔÚÍ˳ö»·¾³±äÁ¿ÉèÖá£
) ELSE (
rem Èç¹ûÌṩ·Ç¿ÕµÄ°²×°Ä¿Â¼µ«Ã»ÓÐbin\java.exe£¬ÔòÖ¸¶¨µÄĿ¼Ϊ´íÎóµÄĿ¼
@echo on
@echo ·Ç·¨µÄ Java2SDK µÄ°²×°Ä¿Â¼,²»×öÈκÎÉèÖã¬ÏÖÔÚÍ˳ö»·¾³±äÁ¿ÉèÖá£
)
)
Çë´ò¿ªÁíÍâÒ»¸ö´°¿Ú²âÊÔ
ÔËÐÐ
path
set classpath
Ïà¹ØÎĵµ£º
н¨±í£º
create table [±íÃû]
(
[×Ô¶¯±àºÅ×Ö¶Î] int IDENTITY (1,1) PRIMARY KEY ,
[×Ö¶Î1] nVarChar(50) default 'ĬÈÏÖµ' null ,
[×Ö¶Î2] ntext null ,
[×Ö¶Î3] datetime,
[×Ö¶Î4] money null ,
[×Ö¶Î5] int default 0,
[×Ö¶Î6] Decimal (12,4) default 0,
[×Ö¶Î7] image null ,
)
ɾ³ý±í£º
Drop table [±í ......
public static DataTable GetSchemaTable(string connectionString) //»ñÈ¡AccessËùÓеıíÃû£»
{
using (OleDbConnection connection = new
&n ......
ÔÚSQL ServerÖÐÄ£ºý²éѯͨ³£ÊÇÕâÑùµÄSelect * from articleTable where authorName like '%jacky%'
µ«ÊÇÔÚAccessÖÐÓÃÕâÌõÓï¾äÖ´ÐеÄʱºò¾¹È»·¢Ïֲ鲻³ö½á¹û£¬Ôõô¿ÉÄÜÄØ£¿
ºóÀ´²éÁËÏÂ×ÊÁÏ£¬·¢ÏÖÎÊÌâÈçÏ£º
Òª½øÐÐÄ£ºý²éÕÒ£¬Ôò±ØÐëʹÓÃͨÅä·û£¬ACCESS¿âµÄͨÅä·ûºÍSQL SERVERµÄͨÅä·û²»Ò»Ñù¡£
ACCESS¿âµÄͨÅä·ûΪ£º
*& ......
ACCESSÔ¶³Ì±¸·ÝÒ»Ö±ÊǸöÁîÈËÍ·ÌÛµÄÎÊÌâ ¿´µ½Ò»¸ö²»´íµÄ±¸·Ý·½·¨ ·ÖÏíÏ£º
ÔÎĵØÖ·£ºhttp://www.cnblogs.com/catcat811/archive/2009/12/31/1637186.html
ÍøÕ¾ÓÖ¹ØÁË~~~¹ØµÃºÜͻȻ£¬Êý¾ÝÒ²À´²»¼°±¸·Ý¡£ÒòΪ¹«Ë¾Óиö²Ö¿âµÄϵͳÔÚ×âÓ÷þÎñÆ÷ÉÏ£¬Èç¹ûÍ£Á˾͵ÃÖØеã²Ö£¬ÄÇÊǺÜÀÛÈ˵ÄÊ¡£×î½üÍøվʱ³£¹Ø£¬ÕæÈÃÈËÍ·Í´¡£ÎªÁ˱Üà ......
1:ÔÚStaAfx.h ÖÐÌí¼ÓÈçÏ´úÂë #import "C:\\Program Files\\Common Files \\System\\ado\\msado15.dll" no_namespace rename("EOF","adoEOF")rename("BOF","adoBOF")
2:ÔÚBOOL CXXXApp::InitInstance()Öгõʼ»¯COM»·¾³
::CoInitialize(NULL);
ÊÍ·ÅCOM»·¾³
::CoUninitialize();
......