ÕâÊÇÎҲ鵽µÄ×ÊÁÏ
http://www.cppprog.com/2009/0108/43.html ÒѾ´æ½øÍ¼Æ¬ÁË£¬ÏÖÔÚ×öµ½ÕâÒ»²½ÁË£¬
¡°ÕâʱÊý¾Ý¿âµ±ÖÐÒѾÓÐÁËÒ»Ìõ°üº¬BLOB×ֶεÄÊý¾Ý¡£½ÓÏÂÀ´ÎÒÃÇÒª¶ÁÈ¡ÕâÌõÊý¾Ý£º 1. //ѡȡ¸ÃÌõÊý¾Ý
2. sqlite3_prepare(db, "select * from list;", -1, &stat, 0);
3. sqlite3_step(stat);
4. //µÃµ½¼Í¼ÖеÄBLOB×Ö¶Î
5. const void * test = sqlite3_column_blob(stat, 1);
6. //µÃµ½×Ö¶ÎÖÐÊý¾ÝµÄ³¤¶È
7. int size = sqlite3_column_bytes(stat, 1);
8. //¿½±´¸Ã×Ö¶Î
9. sprintf(buffer2, "%s", test);¡±
ÇëÎÊ ±àÒëµÄʱºò ×îºóµÄbuffer2䶨Ò壬ÓдíÎó£¬ÎÒÓ¦¸ÃÈçºÎÐ޸ģ¿ÎÒÏë°ÑͼƬÏÔʾ³öÀ´£¬Ó¦¸ÃÏÔʾµ½Ê²Ã´¿Ø¼þÖÐÂð£¿Ó¦¸ÃÔõôÏÔʾ³öÀ´°¡£¿
´ó¼Ò°ïæ¿´¿´£¡¸Ð¼¤°¡£¡£¡ÎÊÌâ½â¾ö¿ÉÒÔ¼Ó ·Ö~~
»¹ÊÇÕâ¸öÎÊÌâÓ¦¸Ã·¢µ½±ðµÄʲô°æ£¿
Ïà¹ØÎÊ´ð£º
ÎÒ°²×°ÁËÒ»¸ösqlite developer,Ò»¸ö¿ÉÊÓ»¯µÄ¹¤¾ß¡£
½Ó×Å£¬ÎÒÓÖ°²×°ÁËSQLite.NET,²¢ÔÚVSÀïÃæÌí¼ÓºÃÁËdll¡£
ÏÖÔÚ£¬ÎÒÔÚsqlite developerÀï´´½¨ÁËÒ»¸öÊý¾Ý¿â£¬¿âÖаüº¬ÎÒ×Ô¼º¶¨ÒåµÄÒ»ÕÅ±í¡£
ÎÊÌ⣺ÈçºÎ ......
ÒªÔÚlinuxÉÏʹÓÃsqliteÊDz»ÊÇÒªÏȱàÒë°²×°£¿Ôõô°²×°£¿
c#+sqlite+linuxµÄÏà¹ØÓ¦ÓÃÓÐûÓÐһЩÏà¹Ø×ÊÁÏ£¿
linux ÉÏÄÜÔËÐУ㣡¡?
Äã¿ÉÒÔÏÂÔØ±àÒëºÃµÄ£¬Ò²¿ÉÒÔÏÂÔØÔ´´úÂëÔÙ×Ô¼º±àÒë
http://www.sqlite.org/downl ......
¹ØÓÚjuliandayº¯ÊýµÄÎÊÌ⣬ÎÒÏÖÔÚ±íAÖÐÒ»¸ö×Ö¶Îbʱ¼äÀàÐÍ£¬ÈçºÎbΪ½ñÌìµÄÊý¾Ý£¿Ð»Ð»
select * from ±íÃû where datediff(d,getdate(),×Ö¶Îb)=0 ÕâÑùÄã¿´Ðв»£¿
ÎÒÓõÄÊÇsqliteÊý¾Ý¿â£¬Ëü²»Ö§³ÖdatediffµÄ¡ ......
Êý¾Ý¿âÖÐÓÐÒ»¸öusers±í¡£
create table users(name text, number text);
Ñ»·²åÈëÒ»°ÙÌõ£¬²»Ê¹ÓÃÊÂÎñµÄ»°£¬ÔÚÎҵĻúÆ÷ÉÏÐèÒª6s¡£
¶øÔÚÎÒÅóÓѵĻúÆ÷ÉÏÕâÑùµÄ²Ù×÷»¨·Ñ²»µ½1s¡£
¿ÉÄÜÊÇÄÄ·½ÃæµÄÔÒòµ¼ ......
±ÈÈ磺
1¡¢Á¬½ÓÊý¾Ý¿â£»
2¡¢½¨±í£¬insert ¡¢update,delete,selectÈçºÎд£¿
ÊDz»ÊÇÒªÏÂÔØ ADO.NET 2.0 ÒýÇæ£¿
sqliteʹÓÃÊÖ²á
ллqshurufa£¬ÎÒÏëÖªµÀÈçºÎͨ¹ývb.netʵÏÖ£¬¾ÍÊÇÓï¾äզд£¿
Dim Conn As New ......