SQL serverÊý¾Ý¼¯³ö´íÇóÖú
Á½ÖÖ´íÎó£º
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: {
49: out.println("Òì³£!");
50: }
51: while(rs.next())
52: {
53: %>
54: <td width="11%" height="20" align="center"> <div align="center">
2.Èç¹ûÎÒÕâÑùÉêÃ÷£ºResultSet rs=null;´íÎóÌáʾÈçÏ£º
org.apache.jasper.JasperException: An exception occurred processing JSP page /index.jsp at line 51
48: {
49: out.println("Òì³£!");
50: }
51: while(rs.next())
52: {
53: %>
54: <td width="11%" height="20" align="center"> <div align="center">
³öÏÖÕâÖÖÇé¿öÔõô½â¾ö£¿Çó¸ßÊÖ°ï棡±È½Ï¼±,лл~~£¡£¡£¡£¡´úÂëËäÈ»³¤£¬µ«ÊǺܶ඼ûÓбØÒª¿´£¬Ï£ÍûµÃµ½°ïÖú¡£¡£¡£¡£¡£
ÎÊÌâ²¹³ä£¨rs³õʼ»¯ÔÚÏÂÃæ´úÂëÖкìÉ«±êÇ©´¦Ã÷Ã÷³õʼ»¯ÁË
Ïà¹ØÎÊ´ð£º
....½Óµ½Ò»¸öС³ÌÐò..¹¤×÷ÔÀ´´ó¸ÅÊÇÕâÑùµÄ...ǰ̨ÊÇWEB·þÎñÆ÷.¼Ü¹¹¾ÍÊÇASP+SQL..ǰ̨ÓÉASPÏòSQLÌí¼Ó·þÎñÀà±ð(±íµ¥).È»ºóÓÖºǫ́³ÌÐò¶ÁÈ¡±íµ¥..Ҫʵʱ¶ÁÈ¡..È»ºóÏÔʾÔÚ·þÎñÆ÷ÉÏÃæ..´ÓÀíÂÛÉÏÃæÄÜÐÐͨ²»?Èç¹û¿ÉÒÔ..ºǫ́ ......
Ôõô°ÑÏÂÃæµÄ¸Ä³Ésql serverµÄ·½·¨£¿
to_char(img_comm_metadata.scene_centre_time,'yyyy-mm-dd hh24:mm:ss')>='1990-10-13 09:41:20'
SQL code:
datediff(ss,'1990-10-13 09:41:20',img_ ......
ÒªÊäÈëUSE <Êý¾Ý¿âÃû>ʱ£¬ÒªÓõ½SQL±à¼Æ÷£¬µ«²»ÖªµÀÔÚʲôµØ·½£¬¸ßÊÖ°ï°ïæѽ£¡
SQL2005 µã»÷ÓÒÉϽǵÄ--н¨²éѯ(N)
Êó標選擇Òª²é詢µÄ數據庫£¬È»á ......
ÏÈÀ´Ò»¸ö´íÎóÓï¾ä¡£¡£
select * from [aa] where a1 in (select max(a2),a1 from [aa] group by a1 )
ÎÒ´óÌåÒâ˼£¬
¶ÁÈ¡Ò»¸öͳ¼ÆϵͳÖÐ ²»Öظ´µÄ IP °´ÕÕ ×îºóʱ¼äÅÅÐò£¬²¢ÏÔʾ³öËùÓÐ×ֶΡ£¡ ......
ÈçÌ⣺select name from table1
µÃµ½½á¹û£ºname
СÍõ
СÕÔ
СÀî
......