title: I need the method to return all values from the select query
body: <p>My project requires me to retrieve data from a mySQL database. The method is contained in a class that contains dozens of other database access methods for my java program. The plan is to call this methods from any other class that requires the data from the database. The problem is in java you can only return one data type and yet I need to get back all data from the tuple obtained. </p>
  
  <p>What is the best way to get my method to return (in another class that calls this method) all the data from my query?</p>
  
  <p>Here's the code snippet: </p>
  
  <pre><code>// SELECT QUERIES 
  public void select_H_Customer_Table(int get_intCustomerID) { 
    int intCustomerID = get_intCustomerID; 
    sql = "SELECT intCustomerID, vachCustomerTitle, vachCustomerFirstName, vachCustomerSurnames, dteCustomerDOB, vachCustomerAddressStreet, vachCustomerAddressTown, vachCustomerAddressCounty, vachCustomerAddressPostalCode, intCustomerHomePhone, intCustomerWorkPhone, intCustomerMobilePhone, vachCustomerEmail FROM h_customers " + "WHERE" + " intCustomerID=?"; 
     try {
       st.setInt(1, intCustomerID); 
       rs = st.executeQuery(); 
       while (rs.next()){ 
         int rs_intCustomerID = rs.getInt("intCustomerID"); 
         String rs_vachCustomerTitle = rs.getString("vachCustomerTitle");            
         String rs_vachCustomerFirstName = rs.getString("vachCustomerFirstName"); 
         String rs_vachCustomerSurnames = rs.getString("vachCustomerSurnames"); 
         String rs_dteCustomerDOB = rs.getString("dteCustomerDOB"); 
         String rs_vachCustomerAddressStreet = rs.getString("vachCustomerAddressStreet"); 
         String rs_vachCustomerAddressTown = rs.getString("vachCustomerAddressTown"); 
         String rs_vachCustomerAddressCounty = rs.getString("vachCustomerAddressCounty"); 
         String rs_vachCustomerAddressPostalCode = rs.getString("vachCustomerAddressPostalCode"); 
         int rs_intCustomerHomePhone = rs.getInt("intCustomerHomePhone"); 
         int rs_intCustomerWorkPhone = rs.getInt("intCustomerWorkPhone"); 
         int rs_intCustomerMobilePhone = rs.getInt("intCustomerMobilePhone");
         String rs_txtCustomerEmail = rs.getString("txtCustomerEmail"); 
      } 
    } catch (SQLException e) { 
      // TODO Auto-generated catch block e.printStackTrace(); 
    } 
   }
  </code></pre>