ÓйØ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ÌìµÄÖµ£¬
µ«ÊÇÈç¹û¸ÄΪÈçÏ´úÂ룺 <
Ïà¹ØÎÊ´ð£º
µç»°±¾Æ¥Åä²éѯ£¬Ï£ÍûÒ»ÌõÓï¾ä¸ã¶¨
¼ÙÉèºÅÂë±¾(numtable)ÈçÏÂ:
ºÅÂë(num) ÁªÏµÈË (relationname)
10086 ÒÆ ......
ÎÒÓÃevc±àдµÄ³ÌÐò£¬½«¶Ô»°¿òÖеÄÊý¾Ý´æÈëÊý¾Ý¿â£¬µÚÒ»´Î¿ÉÒÔ´æÈ룬²»¹ýµÚ¶þ´ÎÊäÈëµÄÊý¾Ý²»ÄÜ´æÈëµ½Êý¾Ý¿âÖС£
ÏÂÃæÊÇÎҵijÌÐò
UpdateData(TRUE); // TODO: Add your control notification handler code here ......
BC Éú³ÉµÄSqlite DLL Ö»ÓÐ7K £¬ÊDz»ÄÜÓõÄÎļþ£¬ÎªÊ²Ã´»áÕâÑù£¿£¿
±àÒë¹ý³Ì£¿¿ÉÄÜij¸öÔ¤´¦Àí¿ª¹ØûÉèÖúã¬Ã»Óе¼³öº¯Êý¡£
ÓÐÒ»¸ösqlite3.def ÎļþÎÒ°ÑËüÍϵ½¹¤³ÌÀïÒ»Æð±àÒ룬ÕâÑùÐв»£¿ÒªÔõÑùÉèÖã¬ÎÒ¶ÔBC ²»Êì ......
.netµÄ³ÌÐò£¬ÓõÄSystem.Data.SQLite DLL
¿âÊÇdb3µÄ£¬²éѯʱ×Ü˵no table **
·¾¶Ò²ÊǶԵÄ
¶øÄǸötableÊÇ´æÔÚµÄ
ÔÚPCÉÏÄÜ¿´µ½
ÇëÎÊÕâ¸öÊÇÔõô»ØÊÂÄØ£¿
ÊÖ»úÉÏÎļþʱûÓÐÏà¶Ô·¾¶µÄ¸ÅÄîµÄ£¬
±¨Ê²Ã ......
¿ÉÒÔÌí¼ÓÊý¾Ý£¬µ«ÊǵãÌí¼Óºó»á±¨.access violation at address 0049AB84 in module
Ô´Âë
procedure Tstudent.add_buttonClick(Sender: TObject);
var
sqlstr:string;
begin
&nb ......