[MS-SQL] RowCount 가져오기
SQL = al_mstDAO_sub.mst_APPR_GROUP(as_REQ_NOs);
try {
PreparedStatement pstmt = conn.prepareStatement( SQL
, ResultSet.TYPE_SCROLL_INSENSITIVE
, ResultSet.CONCUR_READ_ONLY);
rs = pstmt.executeQuery();
/* RowCount 가져오기 */
iTemp = rs.getRow();
rs.last();
iRowCount = rs.getRow();
rs.beforeFirst();
iTemp = rs.getRow();
try {
PreparedStatement pstmt = conn.prepareStatement( SQL
, ResultSet.TYPE_SCROLL_INSENSITIVE
, ResultSet.CONCUR_READ_ONLY);
rs = pstmt.executeQuery();
/* RowCount 가져오기 */
iTemp = rs.getRow();
rs.last();
iRowCount = rs.getRow();
rs.beforeFirst();
iTemp = rs.getRow();