JSP报错: java.sql.SQLException: ORA-01722: 无效数字
String id=request.getParameter("id");
if(id==null){
out.print("<script>alert('没有找到您要查看的记录');window.close();</script>");
}
sql="select * from scott.main,scott.teacher,scott.type where
main.idofteacher=teacher.teacherid and main.idoftype=type.typeid and main.mainid='"+id+"'";
rs=stmt.executeQuery(sql);
if(!rs.next()){
out.print("<script>alert('没有找到您要查看的记录');window.close();</script>");
}
运行时 报错:java.sql.SQLException: ORA-01722: 无效数字
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1451)
oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:943)
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2126)
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2331)
oracle.jdbc.driver.OracleStatement.doScrollStmtExecuteQuery(OracleStatement.java:6280)
oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:640)
org.apache.jsp.detail_jsp._jspService(org.apache.jsp.detail_jsp:94)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
我想请问下这是什么原因 我的代码有问题吗?
我的表里面 关于ID的字段 我都用的 NUMBER型~~~
有高手帮忙解决下 谢谢了~~~