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 Sub Create(ByVal mdbPath As String)
If File.Exists(mdbPath) Then
Throw New Exception("Ä¿±êÊý¾Ý¿âÒѾ´æÔÚ£¬ÎÞ·¨´´½¨")
......
ÎÊÌâ:
Óжþ¸ö±í
A±í:
id Comment yuyan lanmuid
1 aaaa chinese 1
2 bbbb english 1
3 cccc chinese 2
4 ddddd english 2
B±í:
id lanmu
1 ¹«Ë¾¼ò½é
2 ÁªÏµ·½Ê½
3 ¾Óª·¶Î§
ÔÚɾ³ýB±íµÄÒ»ÐÐÊý¾Ýʱ»á°ÑA±í¹ØÁªIDµÄÊý¾ÝҲɾ³ý,ÇëÎÊÓÐʲôºÃ·½·¨?ÎÒ²»Ïë²Ù×÷2´Îɾ³ýµÄÓï¾ä.
½â¾ö·½ ......
HTML clipboard
Presidential edition double action fingerprint and access code security door
lock for your office, business or home. Get 100% safety at your entry point with
this maximum security style deadbolt double action lock.
This is one of the best and most secure methods in assuri ......
½ñÌìÔÚÐÞ¸ÄÒÔǰ¿ª·¢µÄÒ»¸öÍøÕ¾µÄʱºòÓöµ½Ò»¸öÎÊÌ⣬ÒòΪ¹¦ÄܵÄÐèÒª£¬ÒÔǰµÄÒ»¸öÊý×ÖÀàÐÍ×ֶθıäΪÎı¾×ֶΣ¬ÒòΪÕâ¸ö×Ö¶ÎÐèÒª°üº¬¶à¸öÀà±ðµÄID£¬ÒÔǰÕâ¸ö×Ö¶ÎÖ»¶ÔÓ¦Ò»¸öIDµÄ¡£
ÍøÕ¾ÊÇASP VBÓïÑԵģ¬Êý¾Ý¿âʹÓõÄÊÇAccess
ÐÞ¸ÄÊý¾ÝÀàÐÍÖ®ºóǰ̨µÄ²éѯ´úÂë¾Í²»ÄÜʹÓÃÖîÈçxID=1ÕâÖÖÌõ¼þÁË¡£ÓÉÓÚÏÖÔÚ¸Ã×ֶαäΪÎı¾ÀàÐ ......
Á¬½ÓACCESSÊý¾Ý¿âµÄ¼òµ¥JSP´úÂ룺
<%@ page language="java" contentType="text/html; charset=GB18030"
pageEncoding="GB18030"%>
<%@ page import="java.sql.*" %>
<%
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ;
String url="jdbc:odbc:Driver={MicroSoft Access Drive ......