3.ѧÉú±í£¬Ñ¡¿Î±í¡£¿Î³Ì±í¡£Èý¸ö±í£¬ÕÒ³öÑ¡ËùÓпγ̵ÄѧÉú¡£
4.ѧÉú±í£¬Ñ¡¿Î±í¡£¿Î³Ì±í¡£Èý¸ö±í£¬ÕÒ³öÑ¡ÁË5ÃÅÒÔÉϿγ̵ÄѧÉú¡£
5.ѧÉú±í£¬³É¼¨±í¡£¿Î³Ì±í¡£Èý¸ö±í£¬ÕÒ³öËùÓпγ̵ķÖÊýÔÚ80·ÖÒÔÉϵÄѧÉú¡£
ÁíÓи߷ÖÏàËÍ¡£¡£¡£
ÄãÕâ¸öÌ«³éÏóÁË Äܲ»ÄÜÏêϸµã°¡
Ôõôд³öÀ´¶¼ÐУ¬ÊÇSQLÓï¾äÄܱí´ïÒâË ......
SELECT ×Ö¶Î1
from ±í WHERE (...) AND ×Ö¶Î1=function()
×Ö¶Î1ÓпÉÄܵÄÖµ Ϊ 0 »òÕß -1
function ·µ»Ø 0 »òÕß -1
ÕâÑùµÄËÙ¶ÈÌ«ÂýÁË Çë¸ßÊÖ°ïæ
¶¨£¡
ÎÒд³ÉÕâÑù ËٶȹûÈ»¿ìÁË
select ×Ö¶Î1 from ±í where(...) and ×Ö¶Î1 in (select function( ......
SELECT Count(*) from In_fo WHERE Reader_Time between #" + time1 + "# AND #" + time2 + "# and id=" + userid + ";
ÉÏÃæÊÇÎÒдµÄsqlÓï¾ä Reader_TimeÊÇʱ¼äÀàÐÍ idΪÊý×Ö
µ±ÎÒÓÃOleDbDataReaderÖ´ÐдËÓï¾äʱ»á³öÏÖ ¡°´Ó×Ö·û´®¡°SELECT Count(*) from In_fo ¡±µ½ÀàÐÍ ......
Microsoft SQL Server 2005 JDBC Driver Õâ¸öÇý¶¯´ó¼ÒÓÐÓùýÂð£¿ÓÃʲô°æ±¾ºÅ¡£Î¢Èí¹ÙÍøÓÐ1.1µÄ»¹ÓÐ2.0µÄ£¬ÎÒÓõÄIDEÊÇJBuilder9
ÏÖÔÚÓÃ2.0µÄ°É£¬È¥Î¢ÈíÍøÕ¾ÏÂÔØ¼´¿É¡£Á¬½Ó×Ö·û´®ºÍÒÔǰÉÔÓв»Í¬£¬¿ÉÒÔËÑÒ»ÏÂÀ²¡£
......
×îÏÈϵͳװÓÐsql2000£¬ÀïÃæÒ²ÔËÐÐÁ˺öàÍøÕ¾Êý¾Ý¿âÓ¦ÓóÌÐò£¬ÏÖÔÚÓиöÍøÕ¾ÐèÒªÅÜÔÚsql server2005ƽ̨ÉÏ£¬ÇëÎÊÎÒ¿ÉÒÔÖ±½ÓÔÚÕâ¸ö°²×°ÓÐsql server2000µÄ·þÎñÆ÷ÉÏÖ±½Ó°²×°sql server2005Â𣿻᲻»áÁ½¸ö°æ±¾µÄ·¢Éú¼æÈÝÐԵijåÍ»£¿µ¼ÖÂÁ½¸öÊý¾Ý¿âÒ»¸ö¶¼Óò»ÁË£¬»òÕßÖ»ÄÜÓÃÆäÖеÄÒ»¸ö£¿
Çë¸ßÊÖ¸æÖª£¬Ð»Ð»¡£
¿ÉÒÔ,µ«Òª¿¼ÂÇ¶Ë¿Ú ......
PBÖпª·¢µÄ¡£
DateTime startTime=DateTime(em_1.Text)
DateTime endTime=DateTime(em_2.Text)
string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+"') and (EndTime < '"+endTime+"')"
ÕâÑùдÓÐÎÊÌâÂð£¬StartTi ......