How to get the number of rows and columns in a resultset in java

How to get the number of rows and columns in a resultset in java

Create a scrollable result set.

conn = getDBConnection(db_conn_string,db_conn_user,db_conn_pass);
ps = conn.prepareStatement(sql,ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY); //to move to last and first
rs = ps.executeQuery();

if(rs.last()){ // to get the row counts
numRows = rs.getRow();
rs.first();
}


ResultSetMetaData rsmd = rs.getMetaData();
int numCols = rsmd.getColumnCount();