问题描述
首先有两个页面insert.jsp和insert-success.jsp， 在insert.jsp里面连接数据库dbs，把表stu中的数据输出，然后添加一条记录，添加之后，跳转到insert_success.jsp 输出添加之后的stu里的所有记录。表结构如下：insert.jsp源码<%@ page language="java" import="java.util.*" pageEncoding="GBK"%><%@ page import="java.sql.*"%><html><head><title>Insert Record Test...</title></head><body><p><font color=green>data inserting test........</font></p><hr color="brown"><form action="insert_success.jsp" method="post"><table ><tr><td>input StuID</td><td><input type=text name="no"></td></tr><tr><td>input StuName</td> <td><input type=text name="name"></td></tr><tr><td>input ChineseScore</td> <td><input type=text name="chiscore"></td></tr><tr><td>input MathScore</td><td><input type=text name="mathscore"></td></tr><tr><td>input EngScore</td><td><input type=text name="engscore"></td></tr></table><br><input type="submit" value="click to add record"/></form><hr color="brown"><br><p> <font color=green>添加之前的数据记录：</font></p><%try{Class.forName("oracle.jdbc.driver.OracleDriver");}catch (ClassNotFoundException e){}String ConStr = "jdbc:oracle:thin:@" ;String ServerName = "localhost";String url =ConStr+ServerName+":1521:dbs";String SqlQuery = "SELECT * FROM stu";Connection con = DriverManager.getConnection(url,"soo","qq");Statement sql=con.createStatement();ResultSet rs = sql.executeQuery(SqlQuery);out.print("<table >");out.print("<TH>学号");out.print("<TH>姓名");out.print("<TH>语文");out.print("<TH>数学");out.print("<TH>英语");while (rs.next()){out.print("<tr>");out.print("<td>"+rs.getInt("no")+"</td>");out.print("<td>"+rs.getString("name")+"</td>");out.print("<td>"+rs.getInt("chinese")+"</td>");out.print("<td>"+rs.getInt("math")+"</td>");out.print("<td>"+rs.getInt("english")+"</td>");out.print("</tr>");}out.print("</table>");rs.close();sql.close();con.close();%></body></html> insert_success.jsp源码<%@ page language="java" import="java.util.*" pageEncoding="gbk"%><%@ page import="java.sql.*" %><html><head><title>New Records!</title></head><body><br><%try {Class.forName("oracle.jdbc.driver.OracleDriver");}catch (ClassNotFoundException e){}String name = request.getParameter("name");String no=request.getParameter("no");String chiscore = request.getParameter("chiscore");String mathscore = request.getParameter("mathscore");String engscore = request.getParameter("engscore");out.print("<table border>");out.print("<TH>StuID");out.print("<TH>StuName");out.print("<TH>ChineseScore");out.print("<TH>MathScore");out.print("<TH>EnglishScore");String ConStr = "jdbc:oracle:thin:@";String ServerName = "localhost";String url = ConStr+ServerName+":1521:dbs";Connection con = DriverManager.getConnection(url,"soo","qq");Statement sql = con.createStatement();String SQLQuery = "INSERT INTO stu VALUES("+no+",'"+name+"',"+chiscore+","+mathscore+","+engscore+")";out.print(SQLQuery);ResultSet rs = sql.executeQuery(SQLQuery);while(rs.next()){out.print("<tr>");out.print("<td>"+rs.getInt("no")+"</td>");out.print("<td>"+rs.getString("name")+"</td>");out.print("<td>"+rs.getInt("chinese")+"</td>");out.print("<td>"+rs.getInt("math")+"</td>");out.print("<td>"+rs.getInt("english")+"</td>");out.print("</tr>");}out.print("</table>");rs.close();con.close();sql.close();%></body></html>insert.jsp点击 click to add record之后出现如下错误：HTTP Status 500 - --------------------------------------------------------------------------------type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: An exception occurred processing JSP page /insert_success.jsp at line 3835: ResultSet rs = sql.executeQuery(SQLQuery);36: while(rs.next()){37: out.print("<tr>");38: out.print("<td>"+rs.getInt("no")+"</td>");39: out.print("<td>"+rs.getString("name")+"</td>");40: out.print("<td>"+rs.getInt("chinese")+"</td>");41: out.print("<td>"+rs.getInt("math")+"</td>");Stacktrace:org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:510)org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:401)org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)javax.servlet.http.HttpServlet.service(HttpServlet.java:717)root cause javax.servlet.ServletException: java.sql.SQLException: ORA-00900: 无效 SQL 语句org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:862)org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)org.apache.jsp.insert_005fsuccess_jsp._jspService(insert_005fsuccess_jsp.java:113)org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)javax.servlet.http.HttpServlet.service(HttpServlet.java:717)org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)javax.servlet.http.HttpServlet.service(HttpServlet.java:717)root cause java.sql.SQLException: ORA-00900: 无效 SQL 语句oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:283)oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:278)oracle.jdbc.driver.T4C8Odscrarr.receive(T4C8Odscrarr.java:214)oracle.jdbc.driver.T4CStatement.doDescribe(T4CStatement.java:723)oracle.jdbc.driver.OracleStatement.getColumnIndex(OracleStatement.java:3276)oracle.jdbc.driver.OracleResultSetImpl.findColumn(OracleResultSetImpl.java:1914)oracle.jdbc.driver.OracleResultSet.getInt(OracleResultSet.java:1563)org.apache.jsp.insert_005fsuccess_jsp._jspService(insert_005fsuccess_jsp.java:92)org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)javax.servlet.http.HttpServlet.service(HttpServlet.java:717)org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)javax.servlet.http.HttpServlet.service(HttpServlet.java:717)note The full stack trace of the root cause is available in the Apache Tomcat/6.0.29 logs.--------------------------------------------------------------------------------Apache Tomcat/6.0.29实在不知道哪里错了。。希望路过的大家帮忙看下。 问题补充：首先有两个页面insert.jsp和insert-success.jsp， 在insert.jsp里面连接数据库dbs，把表stu中的数据输出，然后添加一条记录，添加之后，跳转到insert_success.jsp 输出添加之后的stu里的所有记录。表结构如下：insert.jsp源码<%@ page language="java" import="java.util.*" pageEncoding="GBK"%><%@ page import="java.sql.*"%><html><head><title>Insert Record Test...</title></head><body><p><font color=green>data inserting test........</font></p><hr color="brown"><form action="insert_success.jsp" method="post"><table ><tr><td>input StuID</td><td><input type=text name="no"></td></tr><tr><td>input StuName</td> <td><input type=text name="name"></td></tr><tr><td>input ChineseScore</td> <td><input type=text name="chiscore"></td></tr><tr><td>input MathScore</td><td><input type=text name="mathscore"></td></tr><tr><td>input EngScore</td><td><input type=text name="engscore"></td></tr></table><br><input type="submit" value="click to add record"/></form><hr color="brown"><br><p> <font color=green>添加之前的数据记录：</font></p><%try{Class.forName("oracle.jdbc.driver.OracleDriver");}catch (ClassNotFoundException e){}String ConStr = "jdbc:oracle:thin:@" ;String ServerName = "localhost";String url =ConStr+ServerName+":1521:dbs";String SqlQuery = "SELECT * FROM stu";Connection con = DriverManager.getConnection(url,"soo","qq");Statement sql=con.createStatement();ResultSet rs = sql.executeQuery(SqlQuery);out.print("<table >");out.print("<TH>学号");out.print("<TH>姓名");out.print("<TH>语文");out.print("<TH>数学");out.print("<TH>英语");while (rs.next()){out.print("<tr>");out.print("<td>"+rs.getInt("no")+"</td>");out.print("<td>"+rs.getString("name")+"</td>");out.print("<td>"+rs.getInt("chinese")+"</td>");out.print("<td>"+rs.getInt("math")+"</td>");out.print("<td>"+rs.getInt("english")+"</td>");out.print("</tr>");}out.print("</table>");rs.close();sql.close();con.close();%></body></html> insert_success.jsp源码<%@ page language="java" import="java.util.*" pageEncoding="gbk"%><%@ page import="java.sql.*" %><html><head><title>New Records!</title></head><body><br><%try {Class.forName("oracle.jdbc.driver.OracleDriver");}catch (ClassNotFoundException e){}String name = request.getParameter("name");String no=request.getParameter("no");String chiscore = request.getParameter("chiscore");String mathscore = request.getParameter("mathscore");String engscore = request.getParameter("engscore");out.print("<table border>");out.print("<TH>StuID");out.print("<TH>StuName");out.print("<TH>ChineseScore");out.print("<TH>MathScore");out.print("<TH>EnglishScore");String ConStr = "jdbc:oracle:thin:@";String ServerName = "localhost";String url = ConStr+ServerName+":1521:dbs";Connection con = DriverManager.getConnection(url,"soo","qq");Statement sql = con.createStatement();String SQLQuery = "INSERT INTO stu VALUES("+no+",'"+name+"',"+chiscore+","+mathscore+","+engscore+")";out.print(SQLQuery);ResultSet rs = sql.executeQuery(SQLQuery);while(rs.next()){out.print("<tr>");out.print("<td>"+rs.getInt("no")+"</td>");out.print("<td>"+rs.getString("name")+"</td>");out.print("<td>"+rs.getInt("chinese")+"</td>");out.print("<td>"+rs.getInt("math")+"</td>");out.print("<td>"+rs.getInt("english")+"</td>");out.print("</tr>");}out.print("</table>");rs.close();con.close();sql.close();%></body></html>insert.jsp点击 click to add record之后出现如下错误：HTTP Status 500 - --------------------------------------------------------------------------------type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: An exception occurred processing JSP page /insert_success.jsp at line 3835: ResultSet rs = sql.executeQuery(SQLQuery);36: while(rs.next()){37: out.print("<tr>");38: out.print("<td>"+rs.getInt("no")+"</td>");39: out.print("<td>"+rs.getString("name")+"</td>");40: out.print("<td>"+rs.getInt("chinese")+"</td>");41: out.print("<td>"+rs.getInt("math")+"</td>");Stacktrace:org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:510)org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:401)org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)javax.servlet.http.HttpServlet.service(HttpServlet.java:717)root cause javax.servlet.ServletException: java.sql.SQLException: ORA-00900: 无效 SQL 语句org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:862)org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)org.apache.jsp.insert_005fsuccess_jsp._jspService(insert_005fsuccess_jsp.java:113)org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)javax.servlet.http.HttpServlet.service(HttpServlet.java:717)org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)javax.servlet.http.HttpServlet.service(HttpServlet.java:717)root cause java.sql.SQLException: ORA-00900: 无效 SQL 语句oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:283)oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:278)oracle.jdbc.driver.T4C8Odscrarr.receive(T4C8Odscrarr.java:214)oracle.jdbc.driver.T4CStatement.doDescribe(T4CStatement.java:723)oracle.jdbc.driver.OracleStatement.getColumnIndex(OracleStatement.java:3276)oracle.jdbc.driver.OracleResultSetImpl.findColumn(OracleResultSetImpl.java:1914)oracle.jdbc.driver.OracleResultSet.getInt(OracleResultSet.java:1563)org.apache.jsp.insert_005fsuccess_jsp._jspService(insert_005fsuccess_jsp.java:92)org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)javax.servlet.http.HttpServlet.service(HttpServlet.java:717)org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)javax.servlet.http.HttpServlet.service(HttpServlet.java:717)note The full stack trace of the root cause is available in the Apache Tomcat/6.0.29 logs.--------------------------------------------------------------------------------Apache Tomcat/6.0.29实在不知道哪里错了。。希望路过的大家帮忙看下。
解决方案
修改如下，供参考：String SQLQuery = "INSERT INTO stu VALUES("+no+",'"+name+"',"+chiscore+","+mathscore+","+engscore+")"; // 先更新sql.executeUpdate(SQLQuery);// 再查询SqlQuery = "SELECT * FROM stu";ResultSet rs = sql.executeQuery(SQLQuery); while(rs.next()){ out.print("<tr>"); out.print("<td>"+rs.getInt("no")+"</td>"); out.print("<td>"+rs.getString("name")+"</td>"); out.print("<td>"+rs.getInt("chinese")+"</td>"); out.print("<td>"+rs.getInt("math")+"</td>"); out.print("<td>"+rs.getInt("english")+"</td>"); out.print("</tr>"); }
解决方案二：
String SQLQuery = "INSERT INTO stu VALUES("+no+",'"+name+"',"+chiscore+","+mathscore+","+engscore+")"; out.print(SQLQuery); ResultSet rs = sql.executeQuery(SQLQuery); 这是一条UPdate语句，不应该用executeQuery,应该用executeUpdate