java.sql.SQLException: ORA-01722: 无效数字 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1093)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2047)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1940)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2709)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589)
at com.test.db.DBOperator.executeUpdate(DBOperator.java:41)
at com.test.dao.StudentDAO.insertStudent(StudentDAO.java:20)
at com.test.servlet.ServletAction.insert(ServletAction.java:98)
at com.test.servlet.ServletAction.doPost(ServletAction.java:45)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:619)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1093)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2047)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1940)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2709)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589)
at com.test.db.DBOperator.executeUpdate(DBOperator.java:41)
at com.test.dao.StudentDAO.insertStudent(StudentDAO.java:20)
at com.test.servlet.ServletAction.insert(ServletAction.java:98)
at com.test.servlet.ServletAction.doPost(ServletAction.java:45)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:619)
解决方案 »
- springmvc Json Jquery easyui 传值问题
- cas····,会的进来说说,不要百度···
- java FTP 上传问题。 求解。
- 手动装配Spring与Webwork配置的问题研究 高手进(修改spring-xwork-integration.jar方法实现)
- 关于tomcat与apache http server 用mod_jk连接的问题
- TreeSet取值问题?
- 请问大家一个关于网站后台管理的问题
- 讨厌的EJB死锁,谁有好的方法
- 初学j2ee 小问题 白送分
- jboss的JNDI问题啊,搞了我一天时间了.帮帮忙.
- 请问Hibernate JPA 单表一对一双向关联配置
- 100分急求2011年以后的ssh框架项目视频,除OA和CRM项目
例如
String xx="xx";
int y=0;
String sql="insert into a values('"+xx+"',"+yy+")";
System.out.print(sql);
然后将输出的语句贴出来
at com.test.dao.StudentDAO.insertStudent(StudentDAO.java:20)
at com.test.servlet.ServletAction.insert(ServletAction.java:98)
at com.test.servlet.ServletAction.doPost(ServletAction.java:45)把报错的这几个类贴出来把 ,或者你看看你的 sql ,就是类型 和数据库的不一样
* 向数据库新增一条记录的调用方法
*/
public int insertStudent(Student cust) throws SQLException{
String sql = "insert into Student values(?,?,?,?,?)";
Object [] obj = new Object[]{cust.getId(),cust.getName(),cust.getAge(),cust.getSex(),cust.getAddress()};
DBOperator db = new DBOperator();
try {
n = db.executeUpdate(sql, obj);
} catch (SQLException e) {
e.printStackTrace();
}
return n;
}
* 对数据库增,删,改操作的调用方法
*/
public int executeUpdate(String sql,Object[]obj) throws SQLException {
stmt = conn.prepareStatement(sql);
for (int i=0;i<obj.length;i++) {
stmt.setObject(i+1,obj[i]);
}
int ri = stmt.executeUpdate();
return ri;
}
throws ServletException, IOException {
response.setContentType("text/html");
request.setCharacterEncoding("gbk");
response.setCharacterEncoding("gbk");
String type=request.getParameter("type");
if(type.equals("login")){
this.show(request, response);
}
if(type.equals("delete")){
this.delete(request, response);
}
if(type.equals("insert")){
//45行显示出错 this.insert(request, response);
}
if(type.equals("modify")){
this.modify(request, response);
}
if(type.equals("select")){
this.select(request, response);
}
}
关系对应也好 是不是从文本框中的是字符型 要转换成int型啊 因为我的表里有两个int型的
还有你们看一下我的出错那几个类 已经标好了哪一行 出错的 谢谢
public void insert(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
int id = Integer.parseInt(request.getParameter("id"));
String name = request.getParameter("name");
int age = Integer.parseInt(request.getParameter("age"));
String sex = request.getParameter("sex");
String address = request.getParameter("address");
Student stu=new Student();
stu.setId(id);
stu.setName(name);
stu.setAge(age);
stu.setSex(sex);
stu.setAddress(address);
try {
//98行添加出错 s.insertStudent(stu);
} catch (SQLException e) {
e.printStackTrace();
}
response.sendRedirect("ServletAction?type=login");
}
insert into emp1(hiredate) values('02-4月-81')
*
第 1 行出现错误:
ORA-01722: 无效数字
这是怎么回事?