VC/MFCÖеÄACCESSÊý¾Ý¿â·ÃÎÊʵÏÖ(·½·¨3)
½Ó 2
·½·¨3 :
ÕâÖÖ·½·¨Ò²ÐèÒªÓû§×Ô¼º´´½¨Ò»¸öÊý¾ÝÔ´£¬µ«ÊÇ£¬ËùÐèÒª½øÐеIJ½Ö裬±È·½·¨2ÒªÉÙÉÏÐí¶à¡£
´´½¨ºÃÓû§±í¡£
´´½¨Êý¾ÝÔ´£¨¿ØÖÆÃæ°å->Êý¾Ý¹ÜÀí->Êý¾ÝÔ´ Ë«»÷ -> Ñ¡Ôñ Îļþ DSN -> Ìí¼Ó -> Microsoft Access Driver -> ÊÖ¶¯ÊäÈëDSN ±£´æµÄλÖü°Ãû³Æ -> Ñ¡Ôñ(S) ²¢Ñ¡ÖÐËù´´½¨ºÃµÄÊý¾Ý¿âÎļþ -> È·¶¨ -> È·¶¨ ... Íê³É £©
´´½¨Ò»¸ö»ùÓÚMFC¶Ô»°¿òµÄ¹¤³Ì¡£ÆäËû¹¤³ÌÒ²¿É¡£
ÔÚÖ÷´°¿ÚµÄº¯ÊýÍ·²¿¼ÓÈë #include <afxdb.h>
ΪÖ÷³ÌÐò¶¨Òåһȫ¾Ö±äÁ¿ CDatabase cdb1 ;
ÔÚ³ö´°¿ÚµÄ³õʼ»¯³ö¼ÓÈëÈçÏ´úÂ룺
cdb1.open("Äǻᴴ½¨µÄÊý¾ÝÔ´Ãû³Æ");
ΪÖ÷´°¿ÚÌí¼ÓÒ»¸ö°´Å¥£¬²¢Ìí¼Ó°´Å¥µÄÏàÓ¦º¯Êý¡£
ÔÚÏìÓ¦º¯ÊýÖеĴ¦Àí´úÂëÈçÏ£º
CString strTmp = "Insert into mydb(SUserName, SSex) values ('ÀîËÄ','ÄÐ')";
cdb1.ExecuteSQL(strTmp);
ÕâÑùµÄ»°£¬µÚÈýÖÖ·½·¨Ò²½áÊøÁË¡£
PS£º
¶ÔÓÚCDatabase Àà £¬Èç¹ûÏëÏêϸÁ˽âµÄ»°£¬¿ÉÒÔµ½ÍøÉÏÈ¥ËÑË÷Ï¡£
¶ÔÓÚÀàÀïÃæµÄOpen£¨£©·½·¨£¬ÕâÀïÓÐÒ»¸öÁ¬½ÓÊǶÔËû½øÐн²½âµÄ
http://www.sunxin.org/article/1042.html
Ïà¹ØÎĵµ£º
private const string ACCESS_UPDATE_ADMIN_PASSWORD = "UPDATE [Admins] SET admin_pass=@adminPass WHERE admin_name=@adminName";
dbInstance.SetParameters("@adminPass", _adminDObj.Admin_Password);
dbInstance.SetParameters("@adminName", _adminDObj.Admin_Name);
²ÎÊýµÄ˳Ðò±ØÐëºÍSQLµÄ˳ÐòÒ»Ö±£¬·ñÔòÎÞ·¨¸ ......
1.Á¬½ÓÊý¾Ý¿âConnDB()Àà
package tool;
/****************************
**
**ÊôÐÔÎļþÓëÊý¾Ý¿â¾ùÔÚtool°üÏÂÃæ
**
*****************************/
/* Êý¾Ý·ÃÎÊ×é¼þ */
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
impor ......
´´½¨»ùÓÚ¶Ô»°¿òµÄÓ¦ÓóÌÐòADO,Ïò¶Ô»°¿òÖÐÌí¼ÓÒ»¸öÁбíÊÓͼ¿Ø¼þ£¬²¢ÎªÆäÌí¼Ó±äÁ¿m_Grid
µÚÒ»²½£ºADO¶ÔÏóµÄµ¼Èë
ÔÚStdAfx.hÍ·ÎļþÖУº
// stdafx.h : include file for standard system include files,
// or project specific include files that are used frequently, bu
// are ......
½ÓÉÏÃæµÄһƪ¡£
·½·¨2£º
´´½¨Ò»¸öµ¥ÎĵµÓ¦ÓóÌÐò -> ÏÂÒ»²½ -> Ñ¡Ôñ Database view without file support £¬
µ¥»÷ Data Source ÔÚµ¯³öµÄ "Êý¾ÝÁ¬½ÓÊôÐÔ" ¶Ô»°¿òÖУ¬Ñ¡Ôñ " Microsoft Jet 4.0 OLE DB Provider " ¡£
µ¥»÷ ÏÂÒ»²½ ÔÚ"Ñ¡Ôñ»òÊäÈëÊý¾Ý¿âÃû³Æ ÖУ¬Ñ¡Ôñ Êý¾Ý¿âÎļþËùÔڵķ¾¶¡£Í¬µÚһƪËùÊö·½·¨£¬Ê¹ÓÃĬ ......