SQLiteÊý¾Ý¿âÊʺϹ«Ë¾×öÍøÕ¾ÓÃÂð£¿
֮ǰ ¹«Ë¾×öÍøվʹÓõÄÊÇasp+access£¬ÏÖÔÚÒ²ÔÚʹÓÃsql server 2005 + asp.net £¬Ç°Õ߿϶¨Òª»»´ú£¬ºóÕßsql serverÌ«ÅÓ´óÁË£¬ËùÒÔÏë»»×öÆäËûµÄÊý¾Ý¿â£¬Ñ¡Ãâ·Ñ¿ªÔ´µÄÀàÐÍ£¬Ö»ÒªÂú×ãÆÕͨÆóÒµÐû´«ÐÍÍøÕ¾£¬ÏÖÔÚ ¿´µ½ÁËSQLite£¬ÇëÎÊËüÊʺÏÎÒÃǹ«Ë¾Âð£¿ÓÐûÓиüºÏÊʵģ¬MySQL¸÷·½ÃæÊʺÏÂð£¿Ð»Ð»¡£×îºÃÏêϸµã¡£
ºÏÊÊ
Ãâ·ÑµÄ¿ÉÒÔÑ¡SQL 2005 Express£¬¿ªÔ´µÄÆäʵûÓÐʲô±ØÒª£¬ÄãÓÖ²»ÊÇÒªÔÚÉÏÃ潨Á¢Ð©Ê²Ã´
ËüÓëSql Server ExpressÓï·¨ÉÏÇø±ð´óÂð£¿
¹Ø¼üÊÇSql server expressÌ«³ÔÄÚ´æÁË£¬ÎÒÃǹ«Ë¾ÉÏһ̨·þÎñÆ÷Óм¸°Ù¸öaspµÄÍøÕ¾°¡£¬ÅÜsql serverÅܲ»ÆðÀ´¡£
¿ÉÒÔʹÓÃ
µ«Óï·¨ÓëSQL SERVER»¹ÊÇÓв»Í¬µÄ
ACCESSÓëSQLiteÏà±È½ÏÄØ£¿
MySql²»ÊǺÜÊìϤ£¬ËüºÃÏñÊÇ»ùÓÚÒýÇæµÄ°É£¬²»Êǵ¥ÎļþµÄ¡£ÊÇÕâÑùµÄ°É£¿
Ïà¹ØÎÊ´ð£º
Java code:
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=stmt.executeQuery("select * from table");//±¨´íµÄÐÐ
rs.last()
ÓÃrs.last( ......
visual studioÏÂÔÚwmÄ£ÄâÆ÷À³ÌÐò²Ù×÷sqlite¶¼Ê§°Ü£¬µ«ÔÚÊÖ»úÉÏûÎÊÌ⣬´ó¼ÒÆձ鶼ÊÇÕâÑùÂð£¿ËÓнâ¾ö°ì·¨£¿±Ï¾¹ÔÚÄ£ÄâÆ÷Éϵ÷ÊÔЧÂʱȽϸߡ£
¶÷£¬²»»á°¡£¬PPCµÄÄ£ÄâÆ÷ÊÇ¿ÉÒԵİ¡..
ÒýÓÃ
¶÷£¬²»»á°¡£¬PPCµÄÄ ......
×îºÃÊDz»ÐèÒªÁíÍâ°²×°Çý¶¯»ò×é¼þµÄ·½Ê½¡£
ʹÓÃSQLiteµÄAPI, ËüÌṩÁËdll ÐÎʽµÄAPI
ÄѵÀCBÌṩµÄÊý¾Ý×é¼þ²»Ö§³Ö£¿
2010ÊÇÖ§³ÖµÄ¹Ø¼üÊÇÇý¶¯ÒªÑ¡¶Ô£¬ºÃÏñÊÇoffice 11ʲôµÄ
ÒýÓÃ
ÄѵÀCBÌṩµÄÊý¾Ý×é¼ ......
ÇódelphiÔõÑùÁ¬½ÓSqlite Ôöɾ¸Ä²éÀý×Ó
ÓÃASqlite3Query,ÉèÖÃËûµÄconnectionΪASqlite3DB
ASqlite3Query.Sql.text := 'insert into ....';
ASqlite3Query.Execsql;
sqlstr:='insert into stude ......
¿ÉÒÔÌí¼ÓÊý¾Ý£¬µ«ÊǵãÌí¼Óºó»á±¨.access violation at address 0049AB84 in module
Ô´Âë
procedure Tstudent.add_buttonClick(Sender: TObject);
var
sqlstr:string;
begin
&nb ......