java之java.sql.SQLException: ResultSet is from UPDATE. No Data.

问题解释:java调用存储过程的时候,查询结果不能通过ResultSet来查询,需要通过CallableStatement来查询,

  比如:

ResultSet rs =  callableStatement.executeQuery();
            while(rs.next()){
                int empno = rs.getInt(1);
                String empname = rs.getString(2);
                System.out.println(empno);
                System.out.println(empname);
            }


//这种查询方式错误,报java.sql.SQLException: ResultSet is from UPDATE. No Data.


应该通过下面的方式:
  int empno = callableStatement.getInt(1);
  String empname = callableStatement.getString(2);
  System.out.println(empno);
  System.out.println(empname);
 

 

posted @ 2019-05-12 01:34  bitbetter  阅读(6756)  评论(0编辑  收藏  举报