http://www.brentozar.com/archive/2009/09/whats-on-my-bookshelf/
PreparedStatement pstmt = con.prepareStatement( "SELECT fname, lname, crimes, convictions, laddress, photo " + "FROM FBI_most_wanted WHERE state=?"); pstmt.setString(1, "NC"); ResultSet rs = pstmt.executeQuery (); // Display all rows while (rs.next()) { // Retrieve information and display the contents } rs.close();