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

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

    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)

    at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1681)

    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3280)

    at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3329)

 

因：

1.有的sql语句可能全角与半角出现的：java.sql.SQLException无效的列索引,

StringBuilder sql = new StringBuilder().append("select * from emp where uname=? and upass=? and state=? and a=?");

2.设置参数的时候同一位置多次设置

而我今天在开发一个Struts项目时出的是Oracle的一个错误如下:

StringBuilder sql = new StringBuilder().append("select * from emp where uname=? and upass=?");

   //2.PreparedStatement对象指令

   ps = conn.prepareStatement(sql.toString());   

   //3.设置参数   

   ps.setObject(1, dto.get("uname").toString());

   ps.setObject(1, dto.get("upass").toString());   

   //4.执行判断   

   rs = ps.executeQuery();

3.设置参数的时候参数位置出了错