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,再执行删除操作,才能操作成功。
最后
以上就是尊敬心情最近收集整理的关于java.sql.SQLException: 索引中丢失 IN 或 OUT 参数:: 1的全部内容,更多相关java.sql.SQLException:内容请搜索靠谱客的其他文章。
发表评论 取消回复