<%@page contentType="text/html; charset=GBK"%><%@page import="bookstore.*"%><%@page import="java.sql.*"%><jsp:useBean id="ses_userBean" scope="session" class="bookstore.User"/><html><head><title>修改</title></head><body bgcolor="#ffffff"><center><h2>将修改后的用户信息存到数据库</h2></center><%int id=0;try{id=Integer.parseInt(request.getParameter("id").toString());}catch(Exception e){out.println("链接错误");out.close();}String userid=request.getParameter("userid");String name=request.getParameter("name");String email=request.getParameter("email");if(userid==null||name==null||email==null||userid.equals("")||name.equals("")||email.equals("")){out.println("填写不完整，<a href='javascript:history.back();'>请返回</a>");out.close();}%><%Connection conn = DBConnection1.getConnection();if(conn==null){%>对不起，现在数据库忙，请稍后再试<%}%><%Statement stmt = conn.createStatement();int value=stmt.executeUpdate("update FF_DST_CITY set CITY_NAME='"+userid+"', CITY_HBLID='"+name+"', CITY_DISTID='"+email+"', where OBJECTID="+id);if(value>0){out.println("修改成功！<a href=welcome.jsp>请返回</a>");}else{out.println("修改失败！<a href=modify1.jsp>请返回</a>");}stmt.close();%></body></html>错误信息HTTP Status 500 ---------------------------------------------------------------------------------type Exception reportmessagedescription The server encountered an internal error () that prevented it from fulfilling this request.exceptionjavax.servlet.ServletException: ORA-01747: ?????.?.???.??????org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)org.apache.jsp.modify2_jsp._jspService(modify2_jsp.java:115)org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)javax.servlet.http.HttpServlet.service(HttpServlet.java:802)org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
參考答案:sql语句无效
CITY_DISTID='"+email+"',
多了一个,号(逗号)
(你应当先到查询工具中先检查一下sql的准确性.)
