Select Particular Column values in sql without know the column name

[prakasham selamban]

I want to get particular column values in sql table.For example if table has 10 columns i want to select the values of 4 to 10 column values. Here i dont know the column names because all columns are generated at a run time. i need help as soon as possible. I have searched in lot but i could not find the sql query.

[Charbel Keyrouz]

After you execute your query and in the rs.next loop do the following:

 
while(rs.next())
{
   String col4 = rs.getString(4);
   String col5 = rs.getString(5);
   String col6 = rs.getString(6);
   String col7 = rs.getString(7);
   String col8 = rs.getString(8);
   String col9 = rs.getString(9);
   String col10 = rs.getString(10);
}

   

Instead of calling the fieldname you can get the value by index of the column.

[fred rosenberger]

There also should be a way to query for the column names in your code. It would depend on what api you are using to connect/run against the DB.

[prakasham selamban]

Thanks for your reply.

I want the sql query to select records

[Charbel Keyrouz]

If you want the column names you can get them as follows:

  rs.getMetaData().getColumnName(1);