Vfrdtyky

Here is my code: there is one database table field I m retrieving, but I want the second one too.

String query = "select QId, Options from QuestionMaster where SurveyID = '" + s + "'";



Statement stmt = con.createStatement();

ResultSet rs = stmt.executeQuery(query);

ArrayList list = new ArrayList();



while (rs.next())

{

    list.add(rs.getString(1));

}

rs.close();

String contactListNames = (String) list.toArray(new String[list.size()]);

is there any way to do this by 2d arraylist or 2d array

If your ids are unique, you can use a HashMap to store the resultset:

   Map< String, String> hm = new HashMap<String, String>(); 

   while (rs.next()) {

       hm.put(rs.getString(1), rs.getString(2));     

    }



   Set<Map.Entry<String,String>> set = hm.entrySet();    



   for (Map.Entry<String, String> entry : set) { 

       System.out.println(entry.getKey()); 

       System.out.println(entry.getValue()); 

   }

entry.getKey() returns QId and
entry.getValue() returns Options

Basically you create model class that fits to a table.
Each query you do have to return that exact type so you know the entry is correct.
(Won't go further but take a look at how Jpa or else works)

1. you create a class with all attributes (id, option, name...), let
   call this POJO


2. query your fields


3. iterate over each result and
   create your POJO Object


4. add it to the list

there is plenty of other thing you could do here but this is the beginning of a database mapping