ÇóÒ»¸ö¼òµ¥µÄjspÐÞ¸ÄsqlÊý¾ÝµÄÀý×Ó - Java / Web ¿ª·¢
ÎÒÓõÄÊÇ£º
Connection conn= DriverManager.getConnection(url,user,password);
String sql="updata zhuqiuling set xuanze1=? where name='zhuqiuling'";
PreparedStatement pstmt=conn.prepareStatement(sql);
pstmt.clearParameters();
pstmt.setString(1,choice);
pstmt.executeUpdata();
¿ÉÊÇÒ»Ö±µ÷ÊÔ²»³öÀ´
СµÜÊdzõѧÕß Ï£Íû´ó¼Ò°ï°ïÎÒ
ÏÈлл´ó¼ÒÁË
ÌáʾµÄ´íÎóÊÇ£º
org.apache.jasper.JasperException: An exception occurred processing JSP page /shiti/xuanze1.jsp at line 30
27: PreparedStatement pstmt=conn.prepareStatement(sql);
28: pstmt.clearParameters();
29: pstmt.setString(1,choice);
30: pstmt.execute();
31:
javax.servlet.ServletException: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]µÚ 1 ÐÐ: 'updata' ¸½½üÓÐÓï·¨´íÎó¡£
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:855)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:784)
org.apache.jsp.shiti.xuanze1_jsp._jspService(xuanze1_jsp.java:104)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:384)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
o
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......
¸÷·´óÏÀ¸ø¸ö˼·£¬²»ÊÇÔÚÏßµÄÄÇÖÖ£¬¾ÍÊÇÒ»¸ö×öÆÕͨµÄÓ¦ÓóÌÐò¡£
´Ê¿âÔõôÉú³ÉÄØ£¿
²»»á¡£
ÒýÓÃ
´Ê¿âÔõôÉú³ÉÄØ£¿
ÕÒ±¾×Öµä
ÒýÓÃ
´Ê¿âÔõôÉú³ÉÄØ£¿
Êý¾Ý¿â ºÇºÇ
ÓÃmap ¼üÖµ¶ÔÓ¦
Èç¹ûÓÃÊý¾Ý¿ ......
×Ö¶Î1,×Ö¶Î2.....×Ö¶ÎN,Status,ParentID
1,Name1....test1,1,99
1,Name1....test1,3,99
1,Name2....test2,1,101
1,Name2....test2,3,101
1,Name3....test3,2,101
1,Name1....test1,4,101
ÏëÒªµÄ½á¹ûÊÇ:
1,Na ......
org.apache.jasper.JasperException: Unable to compile class for JSP:
An error occurred at line: 52 in the jsp file: /vip_info.jsp
ÕË cannot be resolved
49: <table border="1& ......