SqliteºÍSQLCEÔÚWindows Mobile 6ÉϵÄÐÔÄܶԱÈ
×î½ü¹«Ë¾ÐèÒª½«×ÀÃæϵͳ²¿Êðµ½PDAÉÏÃæÈ¥£¬Ñ¡ÔñÁËWM6×÷Ϊ²¿Êðƽ̨¡£ÔÚÑ¡ÔñÊý¾Ý¿â·½Ãæ³öÏÖÁËÒ»µã¹ËÂÇ£¬ÒòΪ¶ÔÓÚPDA¶øÑÔ£¬ÐÔÄÜÊÇÊ×Òª¿¼ÂǵÄÒòËØ¡£
ÔÚ¿ªÔ´µÄÊý¾Ý¿âSqliteºÍSQLCEÖ®¼äÅÇ»²£¬ËùÒÔÕë¶ÔÕâ¸öÇé¿ö£¬¶ÔSqliteºÍSQLCEÔÚWM6ÉÏÃæ×öÁËÐÔÄܲâÊÔ¡£ÎÒÒ²½«×Ô¼ºÔÚ×ö²âÊÔ¹ý³ÌÖÐÅöµ½µÄÎÊÌâÔÚÕâÀïÂÞÁÐһϣ¬ÒÔ±ãÈÃÄÇЩÔÚÍøÉϲéÁ˺ܾö¼ÕÒ²»µ½´ð°¸µÄÅóÓÑÉÙ×ßһЩÍä·¡£
´ÓÁ½¸ö·½ÃæÀ´·ÖÎö£ºµÚÒ»£¬Åöµ½µÄÎÊÌâÒÔ¼°½â¾ö·½°¸£¬µÚ¶þ£¬²âÊÔÐÔÄܵĽá¹ûºÍ½áÂÛ¡£
µÚÒ»£ºÊ×ÏÈÔÚ²¿ÊðµÄʱºòÐèÒª½«Êý¾Ý¿â¿½±´µ½PDAÉÏ»òÕßWMÉÏÃ棬¿½±´µÄ·¾¶ÊÇÔÚ³ÌÐòÖÐдºÃµÄ·¾¶¡£²âÊÔʱ£¬Îҵķ¾¶ÊÇ"Program Files"smartdevicetestÏÂÃæ¡£
¿ªÊ¼²¿Êðʱ£¬ÒòΪÎÒÏȲâÊÔSQLCEµÄ£¬³öÏÖ “ÎÞ·¨ÕÒµ½ PInvoke DLL“sqlceme35.dll” ”µÄ´íÎó£¬ÔÒòÊÇÒòΪÔÚVS×Ô¶¯²¿ÊðµÄʱºòûÓн«sqlceme35.dll²¿Êðµ½Ä£ÄâÆ÷ÉÏÃæÈ¥£¬µ¼Ö±àÒëͨ¹ý£¬µ«ÊÇÔËÐгö´í¡£
ÔÚÍøÉÏÕÒÁËЩ½â¾ö·½°¸£¬ºÜ¶à²»ÄÜÓã¬ÒÔϽâ¾ö·½°¸ÄÜÐУºhttp://blog.csdn.net/flyjimi/archive/2008/12/11/3500606.aspx ÔÎĵØÖ·ÊÇ£ºhttp://blogs.msdn.com/sqlservercompact/archive/2007/10/26/can-t-find-p-invoke-dll-sqlcemenn-dll.aspx µ«ÊÇÔÚ½â¾ö·½°¸ÖУ¬Ã»ÓÐдÃ÷°×¾ßÌåµÄ²Ù×÷·½·¨£¬¾ßÌåÊÇÄÄÈý¸öCABÎļþ¡£È»ºóÎҾ͵½ÒÔÏÂĿ¼ÏÂ
ÔÚÕâ¸öĿ¼ÏÂÓкܶà¸öCAB£¬ÒòΪÎÒÓõÄÊÇWM5µÄ£¬ËùÒÔ¹ØÓÚWM5µÄÎÒ¶¼¿½±´µ½Ä£ÄâÆ÷ÉÏÈ¥£¬ ½«Ñ¡ÖеÄÎļþ¿½±´µ½WM5ÉÏÃ棬Ȼºóµ½WMÉÏÃæÖ´ÐÐһϣ¬ÔÚÖ´ÐÐÕâЩÎļþµÄʱºò»á³öÏÖ“ÒѾ°²×°ÁË֮ǰµÄ°æ±¾£¬ÐèÒªÖØа²×°µÄµã»÷È·¶¨”¡£µã»÷È·¶¨¾ÍºÃÁË¡£Îҵݲװ˳ÐòÊÇ£º´ÓÏÂÍùÉÏÒÀ´Î°²×°¡£ÖØбàÒ룬²¿Êð£¬ÔËÐУ¬SQLCEͨ¹ý¡£
ÂÖµ½SQLiteÁË£¬»¹ÊÇ°´ÕÕÔÀ´Ò»Ñù½«Êý¾Ý¿â¿½±´µÄĿ¼ÏÂÃ棬ÕâÀïÊý¾Ý¿âÖ§³ÖµÄÀàÐÍÔÝʱÎÒÖªµÀÊÇÓГ.DB”£¬“.DB3”.ºóÀ´Í¨¹ýÓÃUltraEdit´ò¿ªSQLiteµÄÊý¾Ý¿â·¢ÏÖÀïÃæÓÐSQLite3µÄ¹Ø¼ü×Ö£¬ËùÒÔÖ»ÒªÓÐÕâ¸ö¹Ø¼ü×Ö£¬ºó׺Ãû²»¹ÜÓÃʲô¶¼ÊÇÖ§³ÖµÄ¡£Ã»Óкó׺ÃûÒ²ÊÇ¿ÉÒԵġ£
»¹ÊÇ°´ÔÀ´µÄÒ»Ñù¡£²¿ÊðÔËÐУ¬³öÏÖÁË“ÎÞ·¨ÕÒµ½ PInvoke DLL 'SQLite.Interop.064.DLL'”ÔÒòµ±È»Ò²ÊÇVS²¿ÊðµÄʱºò²»»á½«Õâ¸ö²¿ÊðÉÏÈ¥¡£ÓôÃÆ£¬Ã»ÓÐÏÈÀýµÄ¶«Î÷¾ÍÊÇÎÊÌâ¶à¡£Ã»°ì·¨£¬Ö»Óг¢ÊÔ¡£ÕÒµ½SQLite.netµÄ°²×°Ä¿Â¼Ï¡£
Ïà¹ØÎĵµ£º
SQLite°üº¬ÁËÈçÏÂʱ¼ä/ÈÕÆÚº¯Êý£º
datetime().......................²úÉúÈÕÆÚºÍʱ¼ä
date()...........................²úÉúÈÕÆÚ
time()...........................²úÉúʱ¼ä
strftime().......................¶ÔÒÔÉÏÈý¸öº¯Êý²úÉúµÄÈÕÆÚºÍʱ¼ä½øÐиñʽ»¯
datetime()µÄÓ÷¨ÊÇ£ºdatetime(ÈÕÆÚ/ʱ¼ä,ÐÞÕý·û,ÐÞÕý·û...)
......
1.ÔÚSQLiteÖвåÈ뵱ǰʱ¼ä,±äÁ¿¶¨Òå²»Óöà˵
char *sql = sqlite3_mprintf("insert into Log VALUES(datetime('now', 'localtime'), '%q', '%q')", cUser, cLogContent);
int ret = sqlite3_exec(Sqlite3, sql, NULL, NULL, &pErrMsg);
ÒÔÔ·ÝΪµ¥Î»Í³¼Æ³ö·ûºÏµ±Ç°Ô·ݵļǼ, TimeΪÊý¾Ý¿âÖÐ×Ö¶ÎÃû:
char *sql = s ......
°ÝGoogleµÄScott Hessͬ־Ëù´Í£¬SQLiteÒ²ÍƳöÁËÈ«ÎÄËÑË÷¹¦ÄÜ¡£
SQLiteͨ¹ý½¨Á¢Ò»¸öÐéÄâ±í£¬½«ÊäÈëµÄÎÄ×Ö¸ù¾Ý¿Õ¸ñ¡¢±êµã·ûºÏµÈ¹æÔò½øÐзִʣ¬×éÖ¯³ÉÒ»¿ÃBÊ÷£¬ÒÔ´ËÀ´Ìá¸ßËÑË÷Ëٶȡ£
ÈçºÎʹÓÃÕâÒ»¹¦ÄÜ£¬ÐÔÄÜÉÏÈçºÎ£¬´ó¼Ò¸÷×ÔÑо¿È¥°É¡£
ÔÚÕâÀ ......
SQLiteѧϰ±Ê¼Ç
1.²é¿´ÓÐÄÄЩÊý¾Ý¿â,ÏÔʾÊý¾Ý¿âÁбí
show databases;
2.ÏÔʾ±íµÄ½á¹¹
·½·¨Ò»£º
use student;
describe student;
·½·¨¶þ£º
des student.student;
·½·¨Èý£º
show columns from student;
3.ÏÔʾMYSQLµÄ°æ±¾
select version();
4.ÏÔʾ¿âÖеÄÊý¾Ý±í
use mysql;
show tables;
5.½¨¿â
......
SqLite.netµÄdllΪSystem.Data.SQLite.dll£¬ÕâÖÖdll·ÖΪ32λ¡¢64λºÍÊÊÓÃÓÚcompactframeworkÈýÖÖ£¬ÔÚÒýÓÃʱҪעÒ⣬ѡÔñÕýÈ·µÄdll¡£
½«Òª±£´æͼƬµÄ×Ö¶ÎÀàÐÍÉèΪblob¡£´úÂëÈçÏ£º
private void savePicture£¨£©
{
using (SQLiteConnection cnn = new SQLiteConnection(dbPath))
......