Control the loop of resultset.next( );

[Hewa Naimanage Sumedha Amalka]

Hai, guys
I am using the ODBC database (Excel Sheet) and i wanna get the records from it. My code is scucess but there is a problem in resultset.next() method.

The thing is it retrieving all the data including the none data fields, so finally it became a never ending loop.

pls help me to get the data rang's records

Statement stmnt = connexl.createStatement();
String query = "SELECT * FROM [IJTS$]";
stmnt.execute(query);
ResultSet rsxl = stmnt.getResultSet();

while(rsxl.next()) {
String excelname = rsxl.getString(1);
String excelcate = rsxl.getString(2);
System.out.print(rsxl.getString(1));
System.out.println(" "+rsxl.getString(2));
}
Thanks

[Prabhu Venkatachalam]

    
 
while(rsxl.next()) {
String excelname = rsxl.getString(1);
String excelcate = rsxl.getString(2);
[B]if((rsxl.getString(1) != null) || "".equals()rsxl.getString(1)) {
   break;
}[/B]
System.out.print(rsxl.getString(1));
System.out.println(" "+rsxl.getString(2));
}

Try this. It should work.