MYSQL存储过程如何返回一个resultSet

[javasgt]

java 执行MYSQL存储过程如何返回一个resultSet

[ssqtjffcu]

ResultSet rs = null;
String sql = "select name,id from sort";
Connection conn = db.getConn();
Statement state = db.createState(conn);
rs = db.getResult(state, sql);
return rs;

[jackson416]

cstmt = DBConn.prepareCall("{call USP_getPo('" + Pa + )}",java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);
ResultSet RS = cstmt.executeQuery();
while(RS.next() && !RS.isAfterLast())
{

[kkwulei]

一般多行查询时用到 executeQuery() 方法 他的 返回值就是一个set