Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÓйØSQliteµÄÒ»¸öÎÊÌâ

³ÌÐò´úÂëÈçÏ£º
sqlTime = "select SUM(onlineTimeSpan) from T_OnlineTimeSum where ipAddress = :a AND onlineDate BETWEEN :b AND :c";
                daSpan = new SQLiteDataAdapter(sqlTime, conn);
                daSpan.SelectCommand.Parameters.Add(new SQLiteParameter("a", DbType.String));
                daSpan.SelectCommand.Parameters.Add(new SQLiteParameter("b", DbType.String));
                daSpan.SelectCommand.Parameters.Add(new SQLiteParameter("c", DbType.String));

                daSpan.SelectCommand.Parameters[0].Value = Address;
                daSpan.SelectCommand.Parameters[1].Value = startDate.Date.ToString("yyyy-MM-dd");
                daSpan.SelectCommand.Parameters[2].Value = endDate.Date.ToString("yyyy-MM-dd");
ÕâÑùд²éѯʱ¼äÌìÊýÊÇһλµÄ׼ȷµÄ±ÈÈç 2009Äê12ÔÂ4ºÅ µ½ 2009Äê12ÔÂ6ºÅ ÈçÏ£º
select SUM(TimeSpan) from TimeSum where Address = 'xxxx' AND lineDate BETWEEN '2009-12-4' AND '2009-12-6'
µ«ÊÇÈç¹ûʱ¼ä¿ç¶ÈΪ 2009Äê12ÔÂ14ºÅ µ½ 2009Äê12ÔÂ16ºÅʱºòÕâÑùд¾Í»á²úÉúÎÊÌâÖ»ÄܺϼƵ½ 14£¬15ºÅ2ÌìµÄÖµ£¬
µ«ÊÇÈç¹û¸ÄΪÈçÏ´úÂ룺 <


Ïà¹ØÎÊ´ð£º

ÇósqlÓï¾ä£¬sqliteÊý¾Ý¿â

µç»°±¾Æ¥Åä²éѯ£¬Ï£ÍûÒ»ÌõÓï¾ä¸ã¶¨
 
¼ÙÉèºÅÂë±¾(numtable)ÈçÏÂ:

ºÅÂë(num)      ÁªÏµÈË (relationname)     
10086          ÒÆ ......

sqliteÊý¾Ý¿â²»ÄÜÁ¬Ðø´æÈëÊý¾ÝµÄÎÊÌâ

ÎÒÓÃevc±àдµÄ³ÌÐò£¬½«¶Ô»°¿òÖеÄÊý¾Ý´æÈëÊý¾Ý¿â£¬µÚÒ»´Î¿ÉÒÔ´æÈ룬²»¹ýµÚ¶þ´ÎÊäÈëµÄÊý¾Ý²»ÄÜ´æÈëµ½Êý¾Ý¿âÖС£
ÏÂÃæÊÇÎҵijÌÐò
UpdateData(TRUE); // TODO: Add your control notification handler code here ......

BC ±àÒë³öµÄSqlite DLL Ϊʲô²»Õý³£

BC Éú³ÉµÄSqlite DLL Ö»ÓÐ7K £¬ÊDz»ÄÜÓõÄÎļþ£¬ÎªÊ²Ã´»áÕâÑù£¿£¿
±àÒë¹ý³Ì£¿¿ÉÄÜij¸öÔ¤´¦Àí¿ª¹ØûÉèÖúã¬Ã»Óе¼³öº¯Êý¡£

ÓÐÒ»¸ösqlite3.def ÎļþÎÒ°ÑËüÍϵ½¹¤³ÌÀïÒ»Æð±àÒ룬ÕâÑùÐв»£¿ÒªÔõÑùÉèÖã¬ÎÒ¶ÔBC ²»Êì ......

WM³ÌÐò²éѯSQLite¿â×Ü˵±í²»´æÔÚ

.netµÄ³ÌÐò£¬ÓõÄSystem.Data.SQLite DLL
¿âÊÇdb3µÄ£¬²éѯʱ×Ü˵no table **
·¾¶Ò²ÊǶԵÄ
¶øÄǸötableÊÇ´æÔÚµÄ
ÔÚPCÉÏÄÜ¿´µ½
ÇëÎÊÕâ¸öÊÇÔõô»ØÊÂÄØ£¿
ÊÖ»úÉÏÎļþʱûÓÐÏà¶Ô·¾¶µÄ¸ÅÄîµÄ£¬

±¨Ê²Ã ......

delphi Á¬½ÓsqliteÊý¾Ý¿â£¬insert±¨´í

¿ÉÒÔÌí¼ÓÊý¾Ý£¬µ«ÊǵãÌí¼Óºó»á±¨.access violation at address 0049AB84 in module 

Ô´Âë
procedure Tstudent.add_buttonClick(Sender: TObject);
var
  sqlstr:string;
begin
&nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ