public int getRsCountForSQL(String sql) {
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try {
conn = SqlServerConn.getConn();
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
if (rs.next()) {
this.rscount = rs.getInt("num"); // num为SQL语句中指定，select count(id) num from.....
} else {
this.rscount = 0;
}
} catch (Exception ex) {
ex.printStackTrace();
this.rscount = 0;
} finally {
SqlServerConn.ConnClose(conn, stmt, rs);
}
return this.rscount;
}
/** 传入SQL语句获取总记录数 */
public int getRsCountForRs(String sql) {
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try {
conn = SqlServerConn.getConn();
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery(sql);
if (rs.next()) {
rs.last();
this.rscount = rs.getRow();
} else {
this.rscount = 0;
}
} catch (Exception ex) {
ex.printStackTrace();
this.rscount = 0;
} finally {
SqlServerConn.ConnClose(conn, stmt, rs);
}
return this.rscount;
}