org.apache.jasper.JasperException: An exception occurred processing JSP page /project/add.jsp at line 36
33:
34: String sql = "insert into emp values("+ Integer.parseInt(empno)+","+"'"+ename+"'"+","+"'"+ename+"'"+","+Integer.parseInt(mgr)+","+"'"+job+"'"+","+d+","+Integer.parseInt(sal) +","+Integer.parseInt(comm)+","+Integer.parseInt(deptno) +")";
35: pstmt = conn.prepareStatement(sql);//将预编译的sql语句存储在pstmt对象中
36: int i= pstmt.executeUpdate();
37: sql = "select * from emp";
38: pstmt = conn.prepareStatement(sql);
39: rs = pstmt.executeQuery();
javax.servlet.ServletException: java.sql.SQLException: 索引中丢失 IN 或 OUT 参数:: 1
改了 又换了一种错误 int i= pstmt.executeUpdate();这一行出错
javax.servlet.ServletException: java.sql.SQLException: ORA-01722: 无效数字
非数字字符转化为数字时报的错,楼主看一下那个Integer.parseInt的参数是不是有无法转化成数字的变量,然后你试一下把d编程d.toString()
全部插入了 字段数量完整 那个d是date类型的
java.text.SimpleDateFormat sim=new SimpleDateFormat("yyyy-MM-dd");
java.util.Date d=sim.parse(hiredate);