sqliteÅúÁ¿²åÈëÊý¾Ý¿âÎÊÌâ
ÎÒÏÖÔÚʹÓõÄÊÇDatalogic µÄmemorɨÃèÆ÷(intel XScale PXA255@200MHz,ϵͳÄÚ´æ 64M,ϵͳÉÁ´æ
128M)£¬²Ù×÷ϵͳΪWinCE
5.0,Êý¾Ý¿âΪSqlite3£¬ÔÚ.net»·¾³ÏÂÃæÓÐûÓпÉÄÚ½«Ò»¸ö20ÍòÐÐÊý¾ÝµÄtxtÎļþ¶Á³ö²¢Ð´µ½SqliteÊý¾Ý¿âÖÐ?
ÎÒÏÖÔÚµÄ×ö·¨ÊÇ£ºÖðÐжÁ³öÎļþÄÚÈÝ£¬·Ö¸îÊý¾Ýºó×÷Ϊ²ÎÊý£¬ÓÃdc.Parameters.add()·½·¨¼ÓÈëSQLiteCommandµÄinsertÓï¾äÖУ¬µÈÎļþÈ«²¿¶ÁÍêÓÃÒ»¸öÊÂÎñÌá½»£¬ÏÖÔÚ×î¿ìµÄËÙ¶ÈÊÇ7·Ö¶àÖÓ£¬ÄÄλ¸ßÊÖÓÐûÓиü¼Ó¸ßЧµÄ·½·¨£¬ÄÜÔÚ5·ÖÖÓÄÚÍê³É£¿
ÎҵĴúÂëÈçÏ£º
SQLiteCommand dc = ss.CreateCommand();
dc.CommandText = "insert into tests values (?,?,?,?)";
SQLiteParameter dp1 = dc.CreateParameter();
SQLiteParameter dp2 = dc.CreateParameter();
SQLiteParameter dp3 = dc.CreateParameter();
SQLiteParameter dp4 = dc.CreateParameter();
dc.Parameters.Add(dp1);
dc.Parameters.Add(dp2);
dc.Parameters.Add(dp3);
dc.Parameters.Add(dp4);
FileStream fs = File.OpenRead(file);
StreamReader sr = new StreamReader(fs);
this.lfinishtime.Text = DateTime.Now.ToString();
s = sr.ReadLine();
Ïà¹ØÎĵµ£º
sqlite-3.3.6±àÒë°²×°Óë½»²æ±àÒëÈ«¹ý³ÌÏêϸ¼Ç¼
ÏÂÎĽéÉܵÄÄÚÈݶ¼ÊÇ»ùÓÚ Linux RedHat 9.0 ƽ̨µÄ¡£
Ò»¡¢PC»ú±àÒë°²×°
ÇëÔĶÁÔÚ°²×°°üÀïµÄ INSTALL Îļþ¡£»òÕßʹÓÃPEAR installer with "pear install sqlite"¡£SQLiteÒѾÄÚÖÃÁË£¬Äã²»ÐèÒª°²×°Èκθ½¼ÓµÄÈí¼þ£¨additional software£©¡£
Windows users¿ÉÒÔÏÂÔØSQLiteÀ©Õ¹ ......
1¡¢ÈçºÎµÃµ½×îºó²åÈëÏîµÄ×Ô¶¯Ôö³¤IDÖµ£¿ ¶ÔÓ¦µÄC#´úÂë¶ÎÈçÏ£º
using (SQLiteConnection cn = new SQLiteConnection (¡°data source = Test.db¡±))
{
cn.Open ();
SQLiteCommand cmd = new SQLiteCommand ......
ÒªÓÃASPÀ´²Ù×÷SQLiteÊý¾Ý¿â£¬Ç°ÌáÌõ¼þÊÇÔÚ·þÎñÆ÷Éϵð²×°SQLiteµÄODBCÇý¶¯³ÌÐò£¬¿Éµ½Õâ¸öÕ¾µãÉÏÏÂÔØ°²×°£ºhttp://www.ch-werner.de/sqliteodbc/£¬°²×°ºÃºó¾Í¿ÉÒÔÏñʹÓÃAccessÒ»ÑùÀ´Ê¹ÓÃSQLiteÁË£¡Ï±ßÊÇÒ»¸öSQLiteÊý¾Ý¿â½á¹¹£º
ÒýÓÃÄÚÈÝ
Create TABLE admin(username text,age integer);
ÎÒÃÇÔÙÀ´ÓÃASPÑÝʾÏÂÈçºÎ¶ÔSQLi ......
2010ÄêSQLiteѧϰ±Ê¼ÇÖ®Ò»
Ò»£® ÈçºÎ»ñÈ¡SQLite×îа汾
¹Ù·½Õ¾µã£ºhttp://www.sqlite.org/
´Óhttp://www.sqlite.org/ÍøÕ¾µÄDownloadÒ³Ãæ»ñÈ¡
¼´ÈçÏÂÒ³ÃæÏÂÔØ
http://www.sqlite.org/download.html
¶þ£®WindowsϵÄSQLiteµÄÔ´´úÂëÊÇÄĸöÈí¼þÑ¹Ë ......
1:³£ÓýӿÚ
¸öÈ˱ȽÏϲ»¶
sqlite,
ʹÓÃ×î·½±ã£¬Î¨Ò»µÄ×¼±¸¹¤×÷ÊÇÏÂÔØ
250K
µÄÔ´£»¶øÇÒ×÷ÕߺÜÈÈÐÄ£¬ÓÐÎʱشð¡£
ÒÔÏÂÑÝʾһÏÂʹÓÃ
sqlite
µÄ²½Ö裬ÏÈ´´½¨Ò»¸öÊý¾Ý¿â£¬È»ºó²éѯÆäÖеÄÄÚÈÝ¡£
2
¸öÖØÒª½á¹¹ÌåºÍ
5
¸öÖ÷Òªº¯Êý£º
sqlite3 &nbs ......