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¼ò½é
SQLite ÊÇÓÃCÓïÑÔ±àдµÄ¿ªÔ´Êý¾Ý¿â£¬Ö÷ÒªÓÃÓÚǶÈëʽ£¬ÄãÒ²¿ÉÒÔ°ÑËü¼¯³ÉÔÚ×Ô¼ºµÄ×ÀÃæ³ÌÐòÖУ¬Ò²ÓÐÈ˽«ÆäÌæ´úAccess£¬ÓÃ×÷ºǫ́Êý¾Ý¿â¡£
SQLite Ö§³Ö¶àÊýSQL92±ê×¼£¬ÀýÈ磺Ë÷Òý¡¢ÏÞÖÆ¡¢´¥·¢ºÍ²é¿´Ö§³Ö¡£
Ö§³Ö NULL¡¢INTEGER¡¢REAL¡¢TEXT ºÍ BLOB Êý¾ÝÀàÐÍ£¬Ö§³ÖÊÂÎñ¡£
¶þ¡¢ÏÂÔØSQLite
SQLite¿ÉÒÔµ½¹Ù·½Õ¾µ ......
ʹÓù¤¾ß£º
SQLite Expert SQLiteÊý¾Ý¿â¹ÜÀí¹¤¾ß£¬·Ç³£ºÃÓã¬ÀàËÆÎÒ֮ǰ½éÉܵÄEMS SQL Manager 2007 for MySQL
System.Data.SQLite SQLite For ADO.NETÇý¶¯,ÀàËÆÎÒ֮ǰ½éÉܵÄMySql.Data.dll
Õâ2¸ö¹¤¾ß¶¼°üÀ¨ÁËSQLiteµÄÒýÇæ
1¡¢´Óhttp://www.s ......
2010ÄêSQLiteѧϰ±Ê¼ÇÖ®¶þ
Ò».½¨Á¢Êý¾Ý¿â
sqlite3.exe test.db
¶þ.Ë«»÷sqlite-3_6_16Ŀ¼ÏµijÌÐòsqlite3.exe£¬¼´¿ÉÔËÐÐ
Èý.Í˳ö
.exit
»òÕß
.quit
ËÄ.SQLiteÖ§³ÖÈçÏÂ5ÖÖÊý¾ÝÀàÐÍ
1.NULL£º¿ÕÖµ¡£
2.INTEGER£º´ø·ûºÅµÄÕûÐÍ£¬¾ßÌåÈ¡¾öÓдæÈëÊý×ֵķ¶Î§´óС¡£
3.REAL£º¸¡µãÊý×Ö£¬´æ´¢Îª8-byte IEEE¸¡µãÊý ......
½ñÌìµÄѧϰÄÚÈÝÊÇsqliteºÍPDO mysql¡£
ÓÃ×Ô¼ºµÄ»°ËµËµÁ½¸ö¶«Î÷°É£º
sqliteËãÊÇÒ»ÖÖ²»ÏµÍ³µÄÊý¾Ý¿â´æ´¢·½Ê½£¬ËüµÄ´æ·Å¸ñʽÊÇÒ»¸ö.dbºó׺µÄÎļþ£¬ÔÚphpÖÐËü´æ·ÅÔÚµ±Ç°µÄĿ¼Ï£¬Ã²ËƲ»ÓÃÓû§ÃûÃÜÂ룬°²È«ÐԽϵͣ¬È´±È½Ï·½±ã¡£PHP5ÖÐ×Ô´øµÄһЩϵͳº¯Êý£¬¶¼ÊÇÒÔsqlite_¿ªÍ·µÄ¡£
PDOÈ«³ÆPHP Data Object£¬¹ËÃû˼Òå¾ÍÊÇPHPµÄÒ ......