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);
 
原文地址:https://www.cnblogs.com/wqk66/p/10850897.html