java - executeUpdate()之后如何从CallableStatment检索ResultSet

This question already has an answer here:

Null resultsets when calling Sybase stored procedure through JDBC

（1个答案）


4年前关闭。




我正在用Java执行存储过程。过程之一返回多行。

int haveResults = Param.callableStatement.executeUpdate();
System.out.println(haveResults);
if (haveResults > 0) {
    System.out.println("I have results"); //This statement is printed
    ResultSet rs = Param.callableStatement.getResultSet();
    while (rs.next()) { //This is where I am getting error:NullPointerException
        //If I comment 'while(rs.next())' then code is giving output but then it can't handle multiple rows
        itr1 = listOutParam.iterator();
        while (itr1.hasNext()) {
            Object obj = null;
            obj = ParameterGetter.getParameter(itr1.next().toString(), counter1);
            list.add(obj);
            counter1++;
        }
        System.out.println(list.toString());
        list1.add(list);
        counter1 = counter2;
    }
}
}

我尝试使用execute（），但是如果返回false值，则表明该过程未成功执行。

最佳答案

如果要从ResultSet检索CallableStatement，则需要使用execute()而不是executeUpdate()

if (Param.callableStatement.execute()) {
     ResultSet rs = Param.callableStatement.getResultSet();
     ...
}