javaµ÷Óô洢¹ý³ÌÎÞ·¨È¡µÃ·µ»Ø²ÎÊý

»·¾³£ºÊý¾Ý¿âsql server2005£¬jdk1.6 £¬myeclipse£¬Çý¶¯jdts1.2.2
Ö´ÐÐÒÔÏ´úÂ룬±¨´í£º
String querySQL = "{?=call p_sys_manager_csReport(?,?,?,?,?)}";
cstmt = conn.prepareCall(querySQL);
cstmt.registerOutParameter(1, java.sql.Types.INTEGER);
cstmt.setInt(2, modType);
cstmt.setInt(3, dptId);
cstmt.setInt(4, eplId);
cstmt.registerOutParameter(5, java.sql.Types.VARCHAR);
cstmt.registerOutParameter(6, java.sql.Types.VARCHAR);
rs = cstmt.executeQuery();
if (rs != null) {
if (rs.next()) {
companyTotal = rs.getInt("companyTotal");
}
}
String temp = null;
temp = cstmt.getString(5);//´ËÐб¨´í

±¨´íÐÅϢΪ£º
java.sql.SQLException: Output parameters have not yet been processed. Call getMoreResults().
    at net.sourceforge.jtds.jdbc.ParamInfo.getOutValue(ParamInfo.java:159)
    at net.sourceforge.jtds.jdbc.JtdsCallableStatement.getOutputValue(JtdsCallableStatement.java:116)
    at net.sourceforge.jtds.jdbc.JtdsCallableStatement.getString(JtdsCallableStatement.java:310)
±¨´íÐÅϢ˵µÃºÜÃ÷°×£¬¾ÍÊÇÊä³ö½á¹û²ÎÊýδ´¦Àí£¬±ØÐëµ÷ÓÃgetMoreResults()·½·¨ÒÔÅжÏÊÇ·ñ»¹Óнá¹û¼¯¡£
È»ºóÐ޸ĴúÂ룬ÎÊÌâ½â¾ö£º
String querySQL = "{?=call p_sys_manager_csReport(?,?,?,?,?)}";
cstmt = conn.prepareCall(querySQL);
cstmt.registerOutParameter(1, java.sql.Types.INTEGER);
cstmt.setInt(2, modType);
cstmt.setInt(3, dptId);
cstmt.setInt(4, eplId);
cstmt.registerOutParameter(5, java.sql.Types.VARCHAR);
cstmt.registerOutParameter(6, java.sql.Types.VARCHAR);
rs = cstmt.executeQuery();
if (rs != null) {
if(rs.next()) {
companyTotal = rs.getInt("companyTotal");
}
}
String temp = null;
/*
*¼Ç¼¼¯»ñÈ¡µ½ºó,°Ñrs¼Ç¼¼¯Ñ­»·È¡³öºó»òÕßµ÷ÓÃcstmt.getMoreResults()·½·¨ºó,sqlserver²Å»á´¦Àíoutput·µ»ØÖµ
*/
if (!cstmt.getMoreResults()) {//´ËÐÐÅжÏÊÇ·ñ»¹Óиü¶àµÄ½á¹û¼¯,Èç¹ûûÓÐ,½ÓÏÂÀ´»á´¦Àíoutput·µ»Ø²ÎÊýÁË
temp = cstmt.getString(5);//´ËÐв»ÔÙ±¨´í
}

ÆäÖиÄΪÒÔÏ´úÂëÒ²²»±¨´í£º
if (rs != null) {