ADOÊý¾Ý¿âÁ¬½ÓAccess
´´½¨»ùÓÚ¶Ô»°¿òµÄÓ¦ÓóÌÐò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 changed infrequently
//
#if !defined(AFX_STDAFX_H__D5ADC0DF_B5B2_4973_A035_4F2F1585998F__INCLUDED_)
#define AFX_STDAFX_H__D5ADC0DF_B5B2_4973_A035_4F2F1585998F__INCLUDED_
#if _MSC_VER > 1000
#pragma once
#endif // _MSC_VER > 1000
#define VC_EXTRALEAN // Exclude rarely-used stuff from Windows headers
#include <afxwin.h> // MFC core and standard components
#include <afxext.h> // MFC extensions
#include <afxdisp.h> // MFC Automation classes
#include <afxdtctl.h> // MFC support for Internet Explorer 4 Common Controls
#ifndef _AFX_NO_AFXCMN_SUPPORT
#include <afxcmn.h> // MFC support for Windows Common Controls
#endif // _AFX_NO_AFXCMN_SUPPORT
//ADO¶ÔÏóµÄµ¼Èë´úÂë
#import"C:\Program Files\Common Files\System\ado\msado15.dll"
no_namespace rename("EOF","adoEOF")rename("BOF","adoBOF")
//{{AFX_INSERT_LOCATION}}
// Microsoft Visual C++ will insert additional declarations immediately before the previous line.
#endif // !defined(AFX_STDAFX_H__D5ADC0DF_B5B2_4973_A035_4F2F1585998F__INCLUDED_)
µÚ¶þ²½£º³õʼ»¯COM»·¾³
BOOL CADOApp::InitInstance()
{
AfxEnableControlContainer();
AfxOleInit();//»òÕß::CoInitialize(NULL);
··················
··················
return FALSE;
}
µÚÈý²½£ºÁ¬½ÓÊý¾Ý¿â
Ïà¹ØÎĵµ£º
½ñÌìupdate accessÊý¾Ý¿âʱ£¬Ê¹ÓÃÁ˲ÎÊý»¯µÄ·½Ê½£¬½á¹û²»±¨´í£¬µ«ÊÇÊý¾ÝҲûÓиüС£¾¹ýgoogle·¢ÏÖaccessʹÓòÎÊý»¯Ê±£¬²ÎÊýλÖñØÐëºÍ¸³ÖµË³ÐòÏàͬ²ÅÐУ¬·ñÔò¸üÐÂʱ¾Í»á³öÏÖÊý¾ÝÎÞ·¨¸üе«ÊÇÒ²²»±¨´íµÄ¹ÖÏÖÏó¡£
ÀýÈç:update tablename set [a]=@a,[b]=@b ......
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 ......
ÎÊÌâ:
Óжþ¸ö±í
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´Îɾ³ýµÄÓï¾ä.
½â¾ö·½ ......
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 ......