//过程单独执行过,没问题。可以返回输出参数public sun.jdbc.rowset.CachedRowSet queryInvestssSeason() throws Exception {
Connection conn = DBManager.getConnection();
CallableStatement stmt = null;
ResultSet rslist = null;
try {
stmt =conn.prepareCall("{call SP_STAT_INVESTSSINFO_SEASON(?,?,?)}",
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
stmt.setInt(1, book_code.intValue());
stmt.setInt(2, start_date.intValue());
stmt.registerOutParameter(3, Types.VARCHAR);
rslist = stmt.executeQuery();
status=stmt.getString(3); //注:错误信息--输出参数未被定义
rowset1 = new sun.jdbc.rowset.CachedRowSet();
rowset1.close();
rowset1.populate(rslist);
} finally {
if (rslist != null)
rslist.close();
if (stmt != null)
stmt.close();
if (conn != null)
conn.close();
}
return rowset1;
}
Connection conn = DBManager.getConnection();
CallableStatement stmt = null;
ResultSet rslist = null;
try {
stmt =conn.prepareCall("{call SP_STAT_INVESTSSINFO_SEASON(?,?,?)}",
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
stmt.setInt(1, book_code.intValue());
stmt.setInt(2, start_date.intValue());
stmt.registerOutParameter(3, Types.VARCHAR);
rslist = stmt.executeQuery();
status=stmt.getString(3); //注:错误信息--输出参数未被定义
rowset1 = new sun.jdbc.rowset.CachedRowSet();
rowset1.close();
rowset1.populate(rslist);
} finally {
if (rslist != null)
rslist.close();
if (stmt != null)
stmt.close();
if (conn != null)
conn.close();
}
return rowset1;
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货