½ðµûÃÔÄã°æAccessÊý¾Ý¿âµÄadoÁ¬½Ó×Ö·û´®
[oledb]
; Everything after this line is an OLE DB initstring
Provider=Microsoft.Jet.OLEDB.4.0;Password=ypbwkfyjhyhgzj;User ID=morningstar;Data Source=C:\Program Files\Kingdee\KIS\BZB\±±¼«ÐÇ.AIS;Persist Security Info=True;Jet OLEDB:System database=C:\Program Files\Kingdee\KIS\BZB\system.mda
Ïà¹ØÎĵµ£º
1.Á¬½ÓÊý¾Ý¿âConnDB()Àà
package tool;
/****************************
**
**ÊôÐÔÎļþÓëÊý¾Ý¿â¾ùÔÚtool°üÏÂÃæ
**
*****************************/
/* Êý¾Ý·ÃÎÊ×é¼þ */
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
impor ......
×î³£¼ûµÄÊý¾ÝÀàÐÍÓ³ÉäµÄÁбí
ϱíÁгöÁËÔÚ Microsoft Access ºÍÈçºÎÕâЩÊý¾ÝÀàÐÍÓëÏà¹Ø Microsoft.net ¿ò¼ÜÊý¾ÝÀàÐÍ£¬²¢ OleDbType ö¾ÙÖÐʹÓÃ×î³£¼ûµÄÊý¾ÝÀàÐÍ¡£
ÊÕÆð¸Ã±í¸ñÕ¹¿ª¸Ã±í¸ñ
·ÃÎÊÀàÐÍÃû³Æ
Êý¾Ý¿âÊý¾ÝÀàÐÍ
OLE DB ÀàÐÍ
.NET ¿ò¼ÜÀàÐÍ
³ÉÔ±Ãû³Æ
Îı¾
VarWChar
DBTYPE_WSTR
System.String
OleDbType.V ......
¸ù¾Ý±í´ïʽµÄÖµ£¬À´·µ»ØÁ½²¿·ÖÖÐµÄÆäÖÐÒ»¸ö¡£
Óï·¨
IIf(expr, truepart, falsepart)
IIf º¯ÊýµÄÓï·¨º¬ÓÐÏÂÃæÕâЩÃüÃû²ÎÊý£º
²¿·Ö ÃèÊö
expr ±Ø ......
½â¾ö°ì·¨£º
´Ó Windows µÄ“¿ªÊ¼”²Ëµ¥£¬Ö¸Ïò“³ÌÐò”¡¢ “Visual Studio .NET 2003”¡¢“Visual Studio .NET ¹¤¾ß”£¬È»ºóÑ¡Ôñ“Visual Studio .NET ÃüÁî Ìáʾ”¡£ÔÚ´°¿Ú´ò¿ªºó£¬¼üÈë aspnet_regiis /i¼´¿É¡£
²»¿ÉÐеķ½°¸£º
1¡¢ÖØÆôµçÄÔ¡£
2¡¢É¾³ý»º´æ¡£
3¡¢ÖØÐ ......
×¢ÊÍ ±¾Ö÷ÌâÖеÄÐÅÏ¢½öÊÊÓÃÓÚ Microsoft Access Êý¾Ý¿â (.mdb)¡£
Óи÷ÖÖ²»Í¬µÄ²ßÂÔÓÃÀ´¿ØÖÆ¶Ô Microsoft Access Êý¾Ý¿â¼°Æä¶ÔÏóµÄ·ÃÎʼ¶±ð¡£ÏÂÃæ´óÖ°´ÕÕ°²È«¼¶±ðµÄ˳Ðò£¬¼òÒª½éÉÜÕâЩ²ßÂÔ¡£
±àÂë/½âÂë
ΪÊý¾Ý¿â±àÂëÊÇ×î¼òµ¥µÄ±£»¤·½·¨¡£ÎªÊý¾Ý¿â±àÂë¿ÉѹËõÊý¾Ý¿âÎļþ£¬²¢°ïÖú·ÀÖ¹¸ÃÎļþ±»ÎÄ×Ö´¦Àí³ÌÐò¶ÁÈ¡¡£µ« ......