VC++µÄADOÁ¬½ÓAccess²½Öè
1:ÔÚStaAfx.h ÖÐÌí¼ÓÈçÏ´úÂë #import "C:\\Program Files\\Common Files \\System\\ado\\msado15.dll" no_namespace rename("EOF","adoEOF")rename("BOF","adoBOF")
2:ÔÚBOOL CXXXApp::InitInstance()Öгõʼ»¯COM»·¾³
::CoInitialize(NULL);
ÊÍ·ÅCOM»·¾³
::CoUninitialize();
3£ºÔÚCXXXAppÍ·ÎļþÖж¨ÒåÁ½¸öÖÇÄÜÖ¸Õëpublic
Ö¸ÏòRecordset¶ÔÏóµÄÖ¸Õë
_RecordsetPtr m_pRecordset;
Ö¸ÏòConnection¶ÔÏóµÄÖ¸Õë
_ConnectionPtr m_pConnection;
4:ÔÚvoid CXXXApp::OnInitADOConn()
{
//ÓÃÓÚÈ«¾Ö±äÁ¿µ÷ÓÃÁ¬½ÓÊý¾Ý¿â
try
{
//´´½¨Á¬½Ó¶ÔÏóʵÀý
m_pConnection.CreateInstance("ADODB.Connection");
//ÉèÖÃÁ¬½Ó×Ö·û´®
CString strConnect="DRIVER={Microsoft Access Driver/ (*.mdb)};uid=;pwd=;DBQ=canyin.mdb;";
//ʹÓÃopen·½·¨Á¬½ÓÊý¾Ý¿â
m_pConnection->Open((_bstr_t)strConnect,"","",adModeUnknown);
}
catch(_com_error e)
{
CString temp;
temp.Format("Á¬½ÓÊý¾Ý¿â´íÎóÐÅÏ¢£º%s",e.ErrorMessage());
::MessageBox(NULL,temp,"ÌáʾÐÅÏ¢",NULL);
}
}
5£ºvoid CXXXApp::ExitConnect()
{
//ÓÃÓÚÈ«¾Ö±äÁ¿µ÷ÓùرÕÊý¾Ý¿â
//¹Ø±Õ¼Ç¼¼¯
if(m_pRecordset!=NULL)
m_pRecordset->Close();
m_pConnection->Close;
}
5£º
<1> //´ò¿ªÊý¾Ý¿âÁ¬½Ó
OnInitADOConn();
1£© //´´½¨Á¬½Ó¶ÔÏóʵÀý
m_pConnection.CreateInstance("ADODB.Connection");
&n
Ïà¹ØÎĵµ£º
<?php
$connstr="DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath("data.mdb");
$connid=odbc_connect($connstr,"","",SQL_CUR_USE_ODBC);
$issuetime=date("Y-m-d H:i:s");
$sql="insert into test values("","",...)";
$result=odbc_exec($connid,$sql);
if($result) echo "successful";
else ec ......
ÊìϤSQL SERVER 2000µÄÊý¾Ý¿â¹ÜÀíÔ±¶¼ÖªµÀ£¬ÆäDTS¿ÉÒÔ½øÐÐÊý¾ÝµÄµ¼Èëµ¼³ö£¬Æäʵ£¬ÎÒÃÇÒ²¿ÉÒÔʹÓÃTransact-SQLÓï¾ä½øÐе¼Èëµ¼³ö²Ù×÷¡£ÔÚ Transact-SQLÓï¾äÖУ¬ÎÒÃÇÖ÷ҪʹÓÃOpenDataSourceº¯Êý¡¢OPENROWSET º¯Êý£¬¹ØÓÚº¯ÊýµÄÏêϸ˵Ã÷£¬Çë²Î¿¼SQLÁª»ú°ïÖú¡£ÀûÓÃÏÂÊö·½·¨£¬¿ÉÒÔÊ®·ÖÈÝÒ×µØÊµÏÖSQL SERV ......
http://uncrustify.sourceforge.net/
Ident code, aligning on parens, assignments, etc
Align on '=' and variable definitions
Align structure initializers
Align #define stuff
Align backslash-newline stuff
Reformat comments (a little bit)
Fix inter-character spacing
Add or remove parens on return ......
Technorati ±êÇ©: C++ ÔÎĵØÖ·£ºhttp://www.byvoid.com/blog/c-int64/ ÔÚC/C++ÖУ¬64ΪÕûÐÍÒ»Ö±ÊÇÒ»ÖÖûÓÐÈ·¶¨¹æ·¶µÄÊý¾ÝÀàÐÍ¡£ÏÖ½ñÖ÷Á÷µÄ±àÒëÆ÷ÖУ¬¶Ô64ΪÕûÐ͵ÄÖ§³ÖÒ²ÊDZê×¼²»Ò»£¬ÐÎ̬¸÷Òì¡£Ò»°ãÀ´Ëµ£¬64λÕûÐ͵͍Ò巽ʽÓÐlong longºÍ__int64Á½ÖÖ(VC»¹Ö§³Ö_int64)£¬¶øÊä³öµ½±ê×¼Êä³ö·½Ê½ÓÐprintf(¡°%lld¡±,a)£¬printf ......
1¡¢http://snippets.dzone.com/tag/c/ --ÊýÒÔǧ¼ÆµÄÓÐÓõÄCÓïÑÔÔ´´úÂëÆ¬¶Î
2¡¢http://www.hotscripts.com/category/c-cpp/scripts-programs/ Hotscripts --ÌṩÊýÒ԰ټƵÄCºÍC++½Å±¾ºÍ³ÌÐò¡£ËùÓгÌÐò¶¼·ÖΪ²»Í¬µÄÀà±ð¡£
3¡¢http://www.planetsourcecode.com/vb/default.asp?lngWId=3 --³¬¹ýÍòÐÐCºÍC++Ãâ·ÑµÄÔ´´úÂë
4¡ ......