mysql 存储过程的结果集怎么用

Question

如题所述

Answer 1

[java] view plain copy
con = Mytest.getConn(); //获取连接
String sql = "{call test()}";
cs = con.prepareCall(sql);
boolean hadResults = cs.execute();
int i=0;
while (hadResults) {
System.out.println(++i);
ResultSet rs = cs.getResultSet();
while (rs != null && rs.next()) {