ÇóÒ»¸ö¼òµ¥µÄ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,2,3£¬4,5,6Áù¸öÊý×ÖÅÅÐò£¬ÓÃjava³ÌÐò¼ÆËã³öÅÅÐòµÄÖÖÀà¡£
ÒªÇó£ºÒ»£¬ÒÔ4¿ªÍ·
¶þ£¬2,3²»ÄÜÏàÁÚ
Èý£¬²»ÄÜÒÔ5¿ªÍ·
Ï£Íû´ó¼ÒÄܼ´ ......
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& ......
ÔÚJSPÒ³ÃæÓÐÒ»¸ö<input type="hidden" name="index" value="0">/>¿Ø¼þ
µ±ÎÒÓÃÏÂÃæµÄJavaScriptº¯Êý¸Ä±äÆävalueµÄÖµµÄʱºò Èç¹ûÂú×ãÌõ¼þ£¨¼´i>=3µÄʱºò£©ÎªÊ²Ã´valueµÄ ......
ÇëÎʸ÷λ¸ç¸ç½ã½ã£¬ÈçºÎÔËÓÃÏֳɵÄÄ£°åÀ´ÖÆ×÷ƯÁÁµÄJSPÍøÒ³Ñ½,»ØÕßÓзÖ!
×Ô¼º¶¥Ï£¬×ÜÓиßÊÖ°É,ÆÚ´ýÖÐ......
Èç¹ûÖ±½ÓÒýÓýøÈ¥
¿ÉÒÔÖ±½ÓÓÃjspµÄÖ¸ÁҲ¿ÉÒÔÓÃfreemarkÒýÓ㬼ǵøø·Ö
лл¸÷λÁË£¬¿´À´Î ......