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 ......
¾ÍÊÇÊÇ·ñÖ§³Ö¶à¸öÁ¬½ÓµÄ²Ù×÷£¿ÔÚÒ»¸ö³ÌÐòÁ¬½ÓÕâ¸öÊý¾Ý¿âʱ£¬ÁíÒ»¸ö³ÌÐò»¹ÄÜÔÙÁ¬½ÓÕâ¸öÊý¾Ý¿âÂð£¿
×î¶àÖ§³Ö¶àÉÙ²¢·¢Á¬½Ó£¿
Ö§³Ö¡£
http://msdn.microsoft.com/en-us/library/ms810829.aspx
×î¶àÖ§³Ö¶àÉÙ²¢· ......