Processing the Result Set

After executing a query statement, you need to process the returned result set.

1. Use the while loop and next() method to traverse the result set row by row.

   while (rs.next()) {
       // Obtain values by column index.
       int c_customer_sk = rs.getInt(1);       // Obtain int data in the first column.
       String c_customer_name = rs.getString(2);      // Obtain string data in the second column.
       System.out.println("c_customer_sk: " + c_customer_sk + ", c_customer_name: " + c_customer_name);
   }

2. Call the close() method to close resources.

   1 2	rs.close(); // Close the ResultSet object. stmts.close(); // Close the Statement object.