IS there any function to get entire row

[Arun Maalik]

Hey Ranchar i would like to know one thing that to get the result of a particuar columns we use the function like getString(),getInt() so that we can get particular columns from result set. Is there any function so that we can get entire complite one row at a time from ResultSet .

Regard

Arun

[Muhammad Saifuddin]

Originally posted by Arun Maalik:
Is there any function so that we can get entire complite one row at a time from ResultSet .

didn't get what you trying to do.. ?

[Arun Maalik]

well now see i have written a code like below

 
     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
     Connection con=DriverManager.getConnection("jdbc:odbc:MyDataSource");
     Statement stmt=con.createStatement();
     ResultSet rs=stmt.executeQuery("select * from authors");
     rs.next();
     rs.getString(1);
 

Now suppose authors table has 3 columns now i want to see contents of these 3 columns on output console at same time then i have to use 3 time rs.getString() (if all 3 columns contane string data ) like

rs.getString(1);
rs.getString(2);
rs.getString(3);

Now i want to know that is there any function so that i can get complite 3 columns that is complite row at a time without using columns function like rs.getString()

[Muhammad Saifuddin]

I think your first place to be find you answer in ResultSet Java Doc.