Lab 12 Hints and Tips

Part 1

• In Step 7a, be sure to load the JDBC driver into memory before connecting:

  Class.forName("org.hsqldb.jdbcDriver");
           

• In Step 7b, your code might look like:

  Statement st = conn.createStatement();
  
  ResultSet rs = st.executeQuery("select * from lifepolicy");
          

• In Step 7c, here's some code to help you get started:

  while (rs.next())
  {
    System.out.println("Policy number: " + rs.getInt("policyNum"));
    . . .
  }