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

2025-04-03 18:02:46
推荐回答(1个)
回答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()) {