cb2010ÔõôʹÓÃSQLiteÊý¾Ý¿â£¿
×îºÃÊDz»ÐèÒªÁíÍâ°²×°Çý¶¯»ò×é¼þµÄ·½Ê½¡£
ʹÓÃSQLiteµÄAPI, ËüÌṩÁËdll ÐÎʽµÄAPI
ÄѵÀCBÌṩµÄÊý¾Ý×é¼þ²»Ö§³Ö£¿
2010ÊÇÖ§³ÖµÄ¹Ø¼üÊÇÇý¶¯ÒªÑ¡¶Ô£¬ºÃÏñÊÇoffice 11ʲôµÄ
ºÃÏñCB2010ûÓÐÌṩ·ÃÎÊSQLITEµÄ×é¼þ.
µÚÒ»,ÎÒ²»ÖªµÀÄÄÀïÏÂÔØÕâ¸öDLL
µÚ¶þ,ÓÐûÓо²Ì¬µÄµ÷Ó÷½·¨?
È¥sqlite¹ÙÍøÓÐdllÏÂÔØºÍÔ´´úÂë¡£
cb×Ô´øµÄ×é¼þûÓÐÖ§³ÖsqliteµÄ¡£ÓеÚÈý·½×é¼þ°üÖ§³ÖsqliteµÄ£¬Ãû×ÖÍüÁË¡£
sqliteÓÐ×Ô¼º°ü×°ºÃµÄsqlite3.dll£¬ÌṩÁ˵¼³ö½Ó¿Ú¸øÄãʹÓÃ
http://blog.donews.com/jetport/archive/2007/06/25/1179461.aspx
http://topic.csdn.net/u/20090427/10/47e56aae-0698-487e-903e-e6e1b14d6b72.html
лл¸÷λ´ó´ó»Ø¸´.
ÎÒÏÖÔÚÒѾ¸ãºÃÁ˾²Ì¬Á´½Ó,²»ÐèÒªDLLÁË.
ÁíÍâÇëÎÊsqliteµÄsqlÓï¾äÊÇutf-8µÄ,»¹ÊÇansiµÄ?
Õâλ´ó´ó£¬Çë¸æËßÎÒSQLÓï¾äµÄUTF-16·½Ê½ÈçºÎµ÷Óã¿
{{----
Ïà¹ØÎÊ´ð£º
ûÓÐÖ÷¼ü£¬ÎÒֻҪɾ³ýǰNÌõ¼Ç¼¡£nÊýÖµ´ó¸ÅÔÚǧÍò¼¶±ðµÄ¡£
ÓÃset rowcount n
ÒýÓÃ
ÓÃset rowcount n
Ö§³Ö
SELECT IDD=IDENTITY(INT,1,1),* INTO #T from TB
DELETE #T WHERE IDD NOT I ......
Java code:
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=stmt.executeQuery("select * from table");//±¨´íµÄÐÐ
rs.last()
ÓÃrs.last( ......
C# code:
System.Data.SQLite.SQLiteConnection conn = new SQLiteConnection(@"acs.db");
try
{
conn.Open();
}
......
mdb.execDML(L"insert into faultcode values('stu.szNumber', 'stu.szName','stu.szReason', 'stu.szStep')");
ÎÒÏë°Ñ½á¹¹Ìå±äÁ¿stu.szNumberÖеÄÄÚÈÝ´æ´¢µ½Êý¾Ý ......
visual studioÏÂÔÚwmÄ£ÄâÆ÷À³ÌÐò²Ù×÷sqlite¶¼Ê§°Ü£¬µ«ÔÚÊÖ»úÉÏûÎÊÌ⣬´ó¼ÒÆÕ±é¶¼ÊÇÕâÑùÂð£¿ËÓнâ¾ö°ì·¨£¿±Ï¾¹ÔÚÄ£ÄâÆ÷Éϵ÷ÊÔЧÂʱȽϸߡ£
¶÷£¬²»»á°¡£¬PPCµÄÄ£ÄâÆ÷ÊÇ¿ÉÒԵİ¡..
ÒýÓÃ
¶÷£¬²»»á°¡£¬PPCµÄÄ ......