Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

SQLiteÖÐÎÄÂÒÂëÎÊÌâ

ÓÃevc±àдӦÓóÌÐò£¬¿ª·¢Êý¾Ý¿â¹ÜÀíϵͳ¡£ÉèÖÃencodingΪUTF-8£¬Äܹ»²åÈëÖÐÎÄÊý¾Ý£¬ÓÃSQLite Expert Personal¿´Êý¾Ý¿â£¬ÖÐÎÄÕý³£¡£±ðµÄ³ÌÐò²éѯÊý¾Ý¿â£¬²¢ÏÔʾÓÚEDIT¿Ø¼þÖУ¬Õý³£¡£µ«ÊÇʹÓÃlist control ¿Ø¼þ£¬²éѯÊý¾Ý¿â£¬ÏÔʾ¿Ø¼þÉÏ£¬³öÏÖÁËÖÐÎÄÂÒÂëµÄÎÊÌ⣬Çë½ÌÒ»ÏÂÊÇʲôԭÒò


ÒýÓÃ
Ó¦¸Ã»¹ÊDZàÂëµÄÎÊÌ⣬

ÔÙ³¢ÊÔһϸıä±àÂëÉèÖ÷½ÃæµÄ²âÊÔ

ÎÒÈ·¶¨ÁË´íÎóµÄµØ·½£¬¾ÍÊÇÔÚ¶ÁÊý¾Ý¿âÊý¾Ý£¨UTF-8£©ÏÔʾÔÚlist control¿Ø¼þÊÇ£¬list¿Ø¼þÈç¹û¶Áµ½µÄÊý¾ÝΪUTF-16µÄ£¬¾ÍÕýÈ·ÁË£¬ËùÒÔÎÒÐèÒª½â¾öµÄÊÂÇé¾ÍÊÇ£¬¶ÁÊý¾Ý¿âÊý¾Ý£¨UTF-8£©£¬×ª»»ÎªUTF-16£¬È»ºóÏÔʾ£¬Ó¦¸Ã¾ÍokÁË¡£
¼ÌÐøÑо¿£¬acmain_chm£¬ÓкõĽ¨ÒéÇëÖ¸µã¹þ~~~~ÏÂÃæÊdzöÎÊÌâµÄ´úÂë¶Î
void CKLMDlg::OnRefresh()
{
    int i = 0 ;
    int nrow = 0, ncolumn = 0;
    char **azResult=NULL; //¶þάÊý×é´æ·Å½á¹û
char *zErrMsg = 0;
    int index,j;
    int nItem;
    int result;
    CListCtrl * pListCtrl = (CListCtrl*)GetDlgItem(IDC_LIST2);
    CRect rt;
    pListCtrl->GetClientRect(&rt);
    char *sql = "SELECT * from Fault";
/****************************************************************************************************************/
    result=sqlite3_get_table( db , sql , &azResult , &nrow , &ncolumn,&zErrMsg );
    index = ncolumn;


Ïà¹ØÎÊ´ð£º

Çë½Ì£ºVCÖеÄTree¿Ø¼þÓëSQLiteÊý¾Ý±íµÄʹÓÃÎÊÌâ

ÎÒÒª°ÑÊý¾Ý±íÖеÄÊý¾Ý£¬ÒÔÊ÷µÄÐÎʽÏÔʾÔÚ¶Ô»°¿òÖС£
±ÈÈ磺
Ö»ÒªÊý¾Ý±íÖÐÓÐ3¸ö×ֶΡ¢id¡¢parentid¡¢name
ÇëÎÊÎÒÈçºÎдһЩ´úÂ뽫Êý¾Ý±íÖеÄÄÚÈÝÌîµ½Ê÷¿Ø¼þÖÐÈ¥ 

ÒýÓÃ
Ò»°ãÊÇÓõݹéµÄ·½·¨À´ÊµÏ ......

sqlite3 linuxÏÂCÓïÑÔµÄÎÊÌâ

ÓõÄÊÇsqllite3£¬ÇëÎÊÔÚlinuxÏÈÈçºÎÓÃCÓïÑÔµ¼³öÊý¾Ý¿â°¡£¿
"µ¼³öÊý¾Ý¿â"ÊÇÊÇʲô£¿

½« tab_xx ÖеÄÊý¾Ýµ¼³öµ½Îļþa.txt
sqlite> .output a.txt
sqlite> select * from tab_xx;
sqli ......

sqlite ×Ö¶ÎĬÈÏÖµµÈÓÚidÖµ

sqlite ÖÐ
CREATE TABLE table1 (
id integer primary key autoincrement,
name text default '',
[index] integer default ROWID
)

ÓÐûÓÐÀàËÆµÄ¹¦ÄÜ£¬Èà index µÄֵĬÈϵÈÓÚid£¬ ......

windowsץȡlinuxÉÏsqlite db問題

´ó¼ÒºÃ, ÉÏÀñ°ÝÓÐÀ´ÎÊ˵ÈçºÎ´ÓlinuxÉÏ·ÖÏí³ösqliteµÄdbÊý¾ÝÈÃwindows²Ù×÷, ºóÀ´Ò»Ö±ÎÞ·¨Ö±½Ó͸¹ýip·½Ê½Äõ½µµ°¸, Ïë˵¸ÄÓÃftp·½Ê½¶ÁµµÐ´Èëºó, ÔÙÉÏ´«»Ølinux server, ÏÖÔÚÓиöÎÊÌâµ±win pc¿ªÆôdbµµ°¸ºó, ºÃÏñ»áËø×¡Ë ......

sqliteÒÆÖ²wince

ÎÒÏëÔÚpdaÉÏÓÃSQLiteÊý¾Ý¿â£¬ÎÒ³ÌÐòÊÇqtдµÄ£¬µ«ÊÇÎÒÓ¦¸ÃÔõÑù½«SQLiteÒÆÖ²µ½winceƽ̨ÉÏÄØ£¬ÎÒÏÖÔÚÓÐÁËSQLite.dllºÍSQLite.lib£¬Ö®ºóÎÒ½»²æ±àÒëÉú³ÉÁË.exeÎļþ£¬ÎªÊ²Ã´ÔÚÄ£ÄâÆ÷Éϲ»ÄÜÔËÐÐÄØ£¿
ÆÚ´ýןßÊֻشð£¬Ð»Ð» ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ