java.sql.SQLException: 索引中丢失 IN 或 OUT 参数:: 1

最新推荐文章于 2022-10-23 11:31:03 发布

heidoutwenty

最新推荐文章于 2022-10-23 11:31:03 发布

阅读量1.1k

点赞数

CC 4.0 BY-SA版权

文章标签： Java SQL Oracle JDBC DAO

本文链接：https://blog.youkuaiyun.com/heidoutwenty/article/details/83847159

java.sql.SQLException: 索引中丢失 IN 或 OUT 参数:: 1

代码如下：
public static void deleteEmpInfo(int empno){
StringBuffer sqlStr = new StringBuffer("delete from emp where empno = ? ");
try{
conn = DBconn.getConn();
pstmt = conn.prepareStatement(sqlStr.toString());
int t = pstmt.executeUpdate();
if(t != 0){
System.out.println("删除成功！");
}else{
System.out.println("删除失败！");
}
}catch(Exception e){
e.printStackTrace();
}
}

调试出现如下错误：
[color=red]java.sql.SQLException: 索引中丢失 IN 或 OUT 参数:: 1
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:199)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:263)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:271)
at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1738)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3382)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3468)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350)
at com.ibm.project.dao.GetEmpInfo.deleteEmpInfo(GetEmpInfo.java:96)
at com.ibm.project.dao.GetEmpInfo.main(GetEmpInfo.java:108)[/color]

[color=red]解决方法[/color]：在pstmt = conn.prepareStatement(sqlStr.toString());和
int t = pstmt.executeUpdate();之间需加一条语句pstmt.setInt(1,empno);

调用deleteEmpInfo(8005)方法时，将实参传给形参。执行pstmt.setInt(1,empno)语句时，也就是说必须先将索引1处的值设置为empno即8005，再执行删除操作，才能操作成功。