sqliteÊý¾Ý¿â²»ÄÜÁ¬Ðø´æÈëÊý¾ÝµÄÎÊÌâ
ÎÒÓÃevc±àдµÄ³ÌÐò£¬½«¶Ô»°¿òÖеÄÊý¾Ý´æÈëÊý¾Ý¿â£¬µÚÒ»´Î¿ÉÒÔ´æÈ룬²»¹ýµÚ¶þ´ÎÊäÈëµÄÊý¾Ý²»ÄÜ´æÈëµ½Êý¾Ý¿âÖС£
ÏÂÃæÊÇÎҵijÌÐò
UpdateData(TRUE); // TODO: Add your control notification handler code here
if (!CheckVaild())//¼ì²éÊäÈëÐÅÏ¢ÊÇ·ñÍêÕû
{
AfxMessageBox(L"ÊäÈëÐÅÏ¢²»ÍêÕû!");
return;
}
int result;
CString str;
char *sql="INSERT INTO\"faultcode\" VALUES(NULL,'a','a','a','a'); ";
str="INSERT INTO faultcode VALUES(NULL,'";
str+=m_Snumber;
str+="','";
str+=m_Sname;
str+="','";
str+=m_Sreason;
str+="','";
str+=m_Sstep;
str+="');";
memset(sql, 0,100);
WideCharToMultiByte(CP_ACP, 0, str, -1, sql, 100, NULL, NULL);
str=sql;
RETAILMSG(1, (TEXT("%s \n\r\n"),str));
result=sqlite3_exec( db , sql , 0 , 0 , &zErrMsg);
if(result !=SQLITE_OK)
printf("zErrMsg = %s \n", zErrMsg);
m_Snumber = _T("");
m_Sname = _T("");
m_Sreason = _T("");
m_Sstep = _T("");
UpdateData(FALSE);
AfxMe
Ïà¹ØÎÊ´ð£º
ÎÒÏëÒª½«sqliteÊý¾Ý¿âÖеÄÊý¾Ý£¬ÒÔÊ÷¿Ø¼þµÄÐÎʽ¶Á³ö£¬²¢ÇÒÏÔʾÔÚ¶Ô»°¿òÉÏÃæ£¬²»ÖªµÀÔõô×ö£¬À´Çë½Ìһϡ£
ps£º¿´µ½ÓÐʹÓÃÊ÷¿Ø¼þºÍaccessµÄ£¬ÀïÃæÓÐÊý¾Ý¿âÒýÇæÀ´Á¬½ÓÊý¾Ý¿âºÍ³ÌÐò£¬ÎÒ²»ÖªµÀSQLiteÈçºÎÓë³ÌÐòÁ¬½ÓÆð ......
¸üÐÂÓï¾äÖУº
UPDATE sc SET AA=INT(BB)
ÎÒÏëÈÃAAµÃµ½BBµÄÕûÊýÖµ¡£¿ÉÊÇÔËÐб¨´í¡£
²»ÖªµÀSQLiteÏ ȡÕûÊý²¿·ÖµÄº¯ÊýÊÇÄĸö£¿£¨ËÄÉáÎåÈëµÄº¯ÊýÓÖÊÇÄĸö£¿£©¡£
Èç¹ûÖªµÀ»¹ÓÐÆäËûº¯ÊýÇëÒ»²¢¸æÖª£¬Ð»Ð»¡£
ROUND
......
ÓÃevc±àдӦÓóÌÐò£¬¿ª·¢Êý¾Ý¿â¹ÜÀíϵͳ¡£ÉèÖÃencodingΪUTF-8£¬Äܹ»²åÈëÖÐÎÄÊý¾Ý£¬ÓÃSQLite Expert Personal¿´Êý¾Ý¿â£¬ÖÐÎÄÕý³£¡£±ðµÄ³ÌÐò²éѯÊý¾Ý¿â£¬²¢ÏÔʾÓÚEDIT¿Ø¼þÖУ¬Õý³£¡£µ«ÊÇʹÓÃlist control ¿Ø¼þ£¬²éÑ¯Ê ......
ÄǸö¸ßÊÖ½Ó´¥¹ýsqlite£¬·¢µã¶ÔsqliteµÄÏêϸԴÂë·ÖÎö£¬Ð»Ð»~~
Ô´´úÂëµ¹ÊDz»ÉÙÈËÏÂÁË,Ò²¿´ÁË,µ«ÍêÕûµÄ·ÖÎöûÓÐ.
ÒýÓÃ
Ô´´úÂëµ¹ÊDz»ÉÙÈËÏÂÁË,Ò²¿´ÁË,µ«ÍêÕûµÄ·ÖÎöûÓÐ.
ÓÐûÓÐһЩ¹ØÓÚSQLiteÄÚ´æ·ÖÅä· ......
ÇëÎʸ÷λ´ó¸ç,ËÓÐÉú³É·ÃÎÊsqliteÊý¾Ý¿âµÄ´úÂëÉú³ÉÆ÷,·üÍû´ó¼Ò°ïæ...
СµÜ¼±ÓÃ
wuyq11
(ÈËÉúÈçÃÎ) ÄúºÃ,wuyq11
UcfarDBAÊÇÔõôʹÓõÄ,СµÜ¿´µ½ÀïÃæÖ»ÓÐcstÎļþ,Ó¦¸ÃÊÇÄ£°å,ÕâЩģ°åÒªÔõÃ´Ê ......