Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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³õʼ»¯ÔÚÏÂÃæ´úÂëÖкìÉ«±êÇ©´¦Ã÷Ã÷³õʼ»¯ÁË


Ïà¹ØÎÊ´ð£º

ÈçºÎÓÃc#£¬sql2000 ¿ª·¢c/sÏµĹ¤×÷Á÷£¿

±¾ÈËc#ÐÂÊÖ ¿ÉÊÇÒªÇóÒªÓÃc# £¬sql2000¿ª·¢c/sµÄ¹¤×÷Á÷£¬Ò»Í·ÎíË®£¬Çë´ó¼Ò°ïæ°ï棬¸øµã˼·£¬ËµµÄÔ¼¾ßÌåÔ½ºÃ£¬ÎÒÒ²ºÃÍùÄǸö·½ÃæÈ¥Ñ§Ï°
http://www.hxzi.com/view/61402.html
B/S°æµÄ£¬»ù±¾Ë¼ÏëÓ¦¸Ã²î²»¶àµÄ¡£¡£ ......

sql ʱ¼äÎÊÌâ

sql table±íÓиöÎı¾ÀàÐ͵Äa×ֶΣ¬´æ´¢µÄÄÚÈÝÈ«²¿ÊÇÊý×Ö£¬ÀýÈç2009001£¬2008578ÕâÑùµÄ¸ñʽ£»b×Ö¶ÎÎı¾ÀàÐÍ£¬´æµÄÒ²ÊÇÊý×ÖÀýÈç 001£¬123
aspÀïÃæ strday=100£¬strb=001

ÎÒÏë¶Á³ö£¬´Óa×ֶεÄÊý×Ö°´´óµ½Ð¡µÄË ......

ÇósqlÓï¾ä

×Ö¶Îaa,¹²ÓÐ178¸öÊý¾Ý,ÏÔʾʱÊÇÒ»ÁÐÖ±ÅÅÏÂÀ´µÄ,ÎÒÏëÈÃÕâ178¸öÊý¾Ý,ÿÁÐÖ»ÏÔʾ5¸ö,¶àÁÐÏÔʾÍê,ÈçºÎʵÏÖ?

¼ÓÒ»¸öIDENTITYTÁÐ,°´ID%5À´·Ö

ÒýÓÃ
¼ÓÒ»¸öIDENTITYTÁÐ,°´ID%5À´·Ö

ID-1/5À´·Ö


SQL co ......

sql server 2008 sql serverÉí·ÝÑéÖ¤ÎÊÌâ

ÎÒϵͳʽwin7 £¬Êý¾Ý¿âsqlserver2008.Ò»Ö±ÓÃwindowsÑéÖ¤£¬µÇ½£¬²»ÄÜÓÃsqlÑéÖ¤£¬ÔÚsaÉÏÖØÐÂ×¢²áÒ»¸öÓû§µÄ»°£¬µÇ½ʱµÚÒ»±é±¨
Òѳɹ¦Óë·þÎñÆ÷½¨Á¢Á¬½Ó£¬µ«ÊÇÔڵǼ¹ý³ÌÖз¢Éú´íÈ¡¡££¨provider:¹²ÏíÄÚ´æÌṩ³ÌÐò£¬ ......

ÇóSQLÓï¾ä

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

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