CString str1=_T("˵Ã÷");
CString str2=_T("˵Ã÷");
CString str3=_T("˵Ã÷");
CString str4=_T("˵Ã÷");
CString str5=_T("˵Ã÷");
CString str6=_T("˵Ã÷");
_variant_t recodsaffected;
CString strSQL;
strSQL.Format("INSERT INTO yinpian6(worker6,state6,suntitle6,benshu6,jihao6,time6) VALUES('%s','%s','%s','%s','%s','%s')",str1,str2,str3,str4,str5,str6);
m_pConnection->Execute((_bstr_t)strSQL,&recodsaffected,adCmdText);
yinpian6(worker6,state6,suntitle6,benshu6,jihao6,time6) VALUES('%s','%s','%s','%s','%s','%s')",str1,str2,str3,str4,str5,str6);
Õâ¸öÊÇÎÒÔÚDÅ̵Ľ¨Á¢µÄÒ»¸öACCESS±í¸ñµÄ×Ö¶Îworker6,state6,suntitle6,benshu6,jihao6,time6£¬¶¼ÊÇÎı¾ÐÍ£¬²»ÖªµÀÎÊʲôʧ°Ü°¡¡£¡£¡£
ÔËÐоÍÊÇrutime error¡£¡£¡£
¿ÒÇë´óÏÀ°ïæ°¡¡£¡£¡£
MessageBox("¹§Ï²Äã¼ÓÈëÐÅÏ¢");
C/C++ code:
try{ //sql²Ù×÷£ý
catch(_com_error e)
{
CString strComError;
strComError.Format("´íÎó±àºÅ: %08lx\n´íÎóÐÅÏ¢: %s\n´íÎóÔ´: %s\n´íÎóÃèÊö: %s",
e.Error(), // ´íÎó±àºÅ
e.ErrorMessage(), // ´íÎóÐÅÏ¢
(LPCSTR) e.Source(), // ´íÎóÔ´
(LPCSTR) e.Description()); // ´íÎóÃèÊö
::MessageBox(NULL,strComError,"´íÎó",MB_ICONE
rt£¬ÎÒÊÔÁËÍøÉÏÖ±Á¬AccesÊý¾Ý¿âµÄ·½·¨,windowsÏÂûÓÐÎÊÌâ,µ«ÊÇÔÚlinuxϲ»ÐУ¬ËÄܸøµãÌáʾ£¿Ð»Ð»
ÄãÔõôÁ¬µÄ£¿
AccesÊý¾Ý¿â..
ÄãÔõôÁ·µÄÄØ£¿
Java code:
static String DBDRIVER = "sun.jd ......
¸Õ¸Õ½Ó´¥VB.NET£¬¶Ô.NET»ù±¾Ê²Ã´Ò²²»¶®£¬Çë¸ßÊÖ¸øÒ»¶Î½ÏÍêÕû´´½¨accessÊý¾Ý¿âµÄʾÀý´úÂ룬ÈÃÎÒѧϰһÏ¡£
Ëùν½ÏÍêÕû´´½¨Êý¾Ý¿âʱ¶¨Òå¸÷¸ö×Ö¶ÎÀàÐ͵ıíʾ·½·¨£¬ÈçÕûÊýÐÍ£¬¸¡µãÐÍ£¬×Ö·ûÐÍ£¨¶¨Ò峤¶ÈÈçºÎ±íʾ£©¡£Ð»Ð» ......
¾ÍÊÇÊÇ·ñÖ§³Ö¶à¸öÁ¬½ÓµÄ²Ù×÷£¿ÔÚÒ»¸ö³ÌÐòÁ¬½ÓÕâ¸öÊý¾Ý¿âʱ£¬ÁíÒ»¸ö³ÌÐò»¹ÄÜÔÙÁ¬½ÓÕâ¸öÊý¾Ý¿âÂð£¿
×î¶àÖ§³Ö¶àÉÙ²¢·¢Á¬½Ó£¿
Ö§³Ö¡£
http://msdn.microsoft.com/en-us/library/ms810829.aspx
×î¶àÖ§³Ö¶àÉÙ²¢· ......
ÎÒÏë±£Áô±íÖÐ×îеÄ30¸öÊý¾Ý£¨ÓмǼʱ¼äµÄ×Ö¶Îaddtime£©£¬ÆäÓàµÄɾ³ý£¬ÇëÎÊsqlÓï¾äÔõÑùÐ´ÄØ£¿Ð»Ð»¡£
End_rbody_64466527//-->
¸Ã»Ø¸´ÓÚ2010-04-27 08:37:30±»°æÖ÷ɾ³ý
¶ÔÎÒÓÐÓÃ[0]
¶ª¸ö°åש[ ......