vbÖ´ÐÐaccess sqlÓï¾ä¹ÖÎÊÌâ
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 ¡±µ½ÀàÐÍ¡°Double¡±µÄת»»ÎÞЧ¡£¡±
Çë¸ßÊÖÖ¸µãһϠid="+ userid +" ÈçºÎд²»»á³ö´í
SELECT Count(*) from In_fo WHERE Reader_Time between #" + time1 + "# AND #" + time2 + "# and id=" + userid + ";
userid Ó¦¸ÃҪת³É×Ö·ûÐ͵İÉ
ÎÒÒ²·¢ÏÖÁË Ð»Ð»
Ïà¹ØÎÊ´ð£º
login.aspx.vb:
Public ReadOnly Property nameT() As String
Get
Return TextBox1.Text
&nb ......
sql table±íÓиöÎı¾ÀàÐ͵Äa×ֶΣ¬´æ´¢µÄÄÚÈÝÈ«²¿ÊÇÊý×Ö£¬ÀýÈç2009001£¬2008578ÕâÑùµÄ¸ñʽ£»b×Ö¶ÎÎı¾ÀàÐÍ£¬´æµÄÒ²ÊÇÊý×ÖÀýÈç 001£¬123
aspÀïÃæ strday=100£¬strb=001
ÎÒÏë¶Á³ö£¬´Óa×ֶεÄÊý×Ö°´´óµ½Ð¡µÄË ......
Á½ÖÖ´íÎó£º
1.Èç¹ûÎÒÕâÑùÉêÃ÷£ºResultSet rs;´íÎóÌáʾÈçÏ£º
An error occurred at line: 51 in the jsp file: /index.jsp
The local variable rs may not have been initialized
48: ......
ǰ¼¸Ìì¹«Ë¾ÃæÊÔ£¬¼ûµ½Ò»Ìâ,Çë¸ßÊÖ°ïÎÒ½â´ð£¬Ð»Ð»£¡
ÄÚÈÝtable:
id name parentid
1 aaa null
14 bbb 1
......
3.ѧÉú±í£¬Ñ¡¿Î±í¡£¿Î³Ì±í¡£Èý¸ö±í£¬ÕÒ³öÑ¡ËùÓпγ̵ÄѧÉú¡£
4.ѧÉú±í£¬Ñ¡¿Î±í¡£¿Î³Ì±í¡£Èý¸ö±í£¬ÕÒ³öÑ¡ÁË5ÃÅÒÔÉϿγ̵ÄѧÉú¡£
5.ѧÉú±í£¬³É¼¨±í¡£¿Î³Ì±í¡£Èý¸ö±í£¬ÕÒ³öËùÓпγ̵ķÖÊýÔÚ80·ÖÒÔÉϵÄѧÉú¡£
......