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

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³õʼ»¯ÔÚÏÂÃæ´úÂëÖкìÉ«±êÇ©´¦Ã÷Ã÷³õʼ»¯ÁË


Ïà¹ØÎÊ´ð£º

ÃÅÍ⺺ÇóÖú...¹ØÓÚºǫ́+SQL+ASP

....½Óµ½Ò»¸öС³ÌÐò..¹¤×÷Ô­À´´ó¸ÅÊÇÕâÑùµÄ...ǰ̨ÊÇWEB·þÎñÆ÷.¼Ü¹¹¾ÍÊÇASP+SQL..ǰ̨ÓÉASPÏòSQLÌí¼Ó·þÎñÀà±ð(±íµ¥).È»ºóÓÖºǫ́³ÌÐò¶ÁÈ¡±íµ¥..Ҫʵʱ¶ÁÈ¡..È»ºóÏÔʾÔÚ·þÎñÆ÷ÉÏÃæ..´ÓÀíÂÛÉÏÃæÄÜÐÐͨ²»?Èç¹û¿ÉÒÔ..ºǫ́ ......

ÇóSQL£¿

´ó¼ÒºÃ£¬ÇëÎÊÔÚ±íMÖÐÓÐ×ֶΣºa b c d e 
ÎÒÏë²é³öÆäÖÐÂú×ãÏÂÃæÈÎÒâÒ»ÏîµÄÊý¾Ý£¬1.×Ö¶Îa µÄÖµ²»ÊÇ ¡®Êé»ò±Ê»ò±¾¡¯ÖÐÈÎÒ»£¬2.aΪÊéµÄʱºò×Ö¶Îb,cÊÇ¿Õ;3.µ±aֵΪ±ÊµÄʱºòdÊÇ¿Õ;4.µ±aΪ±¾µÄʱºòb,d,e¶¼ÊÇ¿Õ;5.È ......

sql server ´æ´¢¹ý³ÌÑ­»·¸³ÖµµÄÎÊÌâ

СµÜÊǸöÐÂÊÖ ÏÖÔÚÓиöÎÊÌâÒ»Ö±²»Äܽâ¾ö
ÀýÈç
procedure produce_proc
    @p001 nvarchar(8000),
    @p002 nvarchar(8000),
    @p003 nvarchar(8000),
  & ......

ÇóÒ»SQLÓï¾ä¡£Ð»Ð»

id    name    sfz

1    aa    410654198001204562
2    bb    410654198120461287
4    cc    41065419850 ......

ÇóSQLÓï¾ä

ÏÖÔÚÓÐÁ½Õűí
a±íºÍb±í

a±í:
¹¤ºÅ  ÐÕÃû  ËùÊô²¿ÃűàºÅ
001              A
002              B
003&n ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ