title: Adding database column to JComboBox
body: <p>I've searched around for the answer to this, but to no avail. When I compile this, it just returns the last row of my table in the database and not a list of the entire column as I expect. I believe the problem is from here.. If only I can make it list everything in that column, I'd be grateful for your help.</p>
  
  <pre><code>String query = "SELECT contact_id, first_name, last_name FROM my_contacts";
  ResultSet rs = statement.executeQuery(query);
  
  while (rs.next())
  {
      System.out.println(rs.getInt(1) + " " + rs.getString(2) + " " + rs.getString(3));
      String name = rs.getString(2) + " " + rs.getString(3);
          names = new JComboBox();
          names.addItem(rs.getString("first_name"));
  }//end while
  </code></pre>