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
Ïà¹ØÎĵµ£º
HTML clipboard
Revealing the revolutionary fingerprint access clocking in/out system for
businesses. No more cards, no more paperwork, no more hassle! This digital
fingerprint access terminal and data logger registers finger prints for time
management plus also works as an authorized pe ......
µÚÒ»ÖÖ·½·¨£º
<?php
class Access{
function getConn(){
$conn = @new COM("ADODB.Connection") or die ("ADOÁ¬½Óʧ°Ü!");
$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath(__IMP ......
Double action
fingerprint
and access code security door lock for your home,
office or small business. Get modern biometric security at your entry point with
this standard door handle style double action doorlock.
This is the most secure and convenient method in assuring only authorized peo ......
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µÄ˳ÐòÒ»Ö±£¬·ñÔòÎÞ·¨¸ ......