jdbc-query(new PreparedStatementCreator(),new PreparedStatementSetter(),new ResultSetExtractor<Objec

public List queryPreparedStatementSetter(){
    final String insertSql = "select *from  users where id =?";  
        final List result = new ArrayList();  
       jdbcTemplate.query(new PreparedStatementCreator(){


@Override
public PreparedStatement createPreparedStatement(Connection conn)
throws SQLException {
// TODO Auto-generated method stub
return conn.prepareStatement(insertSql);
}
       
        }, new PreparedStatementSetter(){


@Override
public void setValues(PreparedStatement prs) throws SQLException {
//prs.setInt(1, "1"); 
prs.setLong(1, 1);

}
       
        }, new ResultSetExtractor<Object>(){


@Override
public Object extractData(ResultSet rs) throws SQLException,
DataAccessException {
Map row = new HashMap();  
         row.put(rs.getInt("id"), rs.getString("name")); 
         System.out.println(rs.getInt("id"));
         return row;
}
       
        });
       
        return result;
       }

    程序报错

Exception in thread "main" org.springframework.dao.TransientDataAccessResourceException: PreparedStatementCallback; SQL []; Before start of result set; nested exception is java.sql.SQLException: Before start of result set
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:106)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:605)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:639)
at com.yzl.dao.mysql.TestServiceDaoJdbcTemplateImpl.queryPreparedStatementSetter(TestServiceDaoJdbcTemplateImpl.java:144)
at com.yzl.TestDataSourse.main(TestDataSourse.java:26)
Caused by: java.sql.SQLException: Before start of result set
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:998)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:937)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:872)
at com.mysql.jdbc.ResultSetImpl.checkRowPos(ResultSetImpl.java:787)
at com.mysql.jdbc.ResultSetImpl.getInt(ResultSetImpl.java:2460)
at com.mysql.jdbc.ResultSetImpl.getInt(ResultSetImpl.java:2571)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:275)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:275)
at com.yzl.dao.mysql.TestServiceDaoJdbcTemplateImpl$9.extractData(TestServiceDaoJdbcTemplateImpl.java:168)
at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:651)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:589)
... 3 more

http://blog.sina.com.cn/s/blog_6a98783b0100o3ut.html

java.sql.SQLException: Before start of result set

  (2010-12-21 13:47:23)

标签：  it

分类： [计算机]异常

    异常信息：java.sql.SQLException: Before start of result set

 

    是个 SQL 异常 引起异常的原因是因为 rs.getString("name"); 前要加rs.next();

    这是因为rs.next()是指游标每次像下移动一行 在关闭 ResultSet 之前都是继续有效的 当第一次rs.next()的时候 游标位置在表的最上方 也就是说处于一个空的位置 但是如果没有rs.next() 游标的位置为空 所以rs.getString("name") 不知道是哪个位置

    例：

        for(int i=0;i<size;rs.next()){

            rs.getString("name");

        }

        或许有朋友会说 这样也要抛该异常 是的 我今天也是遇到这个问题了 有朋友会问 for里已经有rs.next()了啊 为什么还会抛异常？ 后来我想了想 是因为for循环最后一个条件是在运行了以后才会执行

    就像：

        for(int i=0;i<size;i++){

            //这样是先运行了for里面的循环体 i 才开始加加

        }

public List queryPreparedStatementSetter(){
    final String insertSql = "select *from  users where id =?";  
        final List result = new ArrayList();  
       jdbcTemplate.query(new PreparedStatementCreator(){


@Override
public PreparedStatement createPreparedStatement(Connection conn)
throws SQLException {
// TODO Auto-generated method stub
return conn.prepareStatement(insertSql);
}
       
        }, new PreparedStatementSetter(){


@Override
public void setValues(PreparedStatement prs) throws SQLException {
//prs.setInt(1, "1"); 
prs.setLong(1, 1);

}
       
        }, new ResultSetExtractor<Object>(){


@Override
public Object extractData(ResultSet rs) throws SQLException,
DataAccessException {
List list=new ArrayList();
while(rs.next()){
Map row = new HashMap();  
         row.put(rs.getInt("id"), rs.getString("name")); 
         System.out.println(rs.getInt("id"));
         list.add(row);
         //return row;
}
return list;
}
       
        });
       
        return result;
       }