query = "SELECT COUNT
FROM cms_users";
stmt.execute(query);
rs = stmt.getResultSet();
if (rs.next()) {
int count = rs.getInt(1);
System.out.println("count = " + count);
}
query = "SELECT USR_ID, USR_EMAIL, USR_GLOB_SUB FROM cms_users ORDER BY usr_id";
rs = stmt.executeQuery(query);
// rs = stmt.getResultSet();
while (rs.next()) {
double usrId = rs.getDouble(1);
String usrEmail = new String(rs.getString(2));
int usrGlobSub = rs.getInt(3);
System.out.println("usrId = " + usrId + " usrEmail = " + usrEmail + " usrGlobSub = " + usrGlobSub);
}
rs.close();
stmt.close();
con.close();