I need help using xlsjdbc

S

sahm

Hi evey one
I'm using xlsjdbc to read xls file but it would not work whit me and
no error massage is showing can any one help me please
this is my code

/////////////////////////////////////
try
{
Class.forName("org.aarboard.jdbc.xls.XlsDriver");
Connection con =
DriverManager.getConnection("jdbc:aarboard:xls:E://Data");
Statement stat = con.createStatement();
ResultSet result = stat.executeQuery("select * from
Adresse");
int i = 0;
while (result.next())
{
jTable1.setValueAt(result.getString("First Name"), i,
0);
jTable1.setValueAt(result.getString("Secand Name"), i,
1);
jTable1.setValueAt(result.getString("Famliy Name"), i,
2);

i++;
}

result.close();
stat.close();
con.close();
\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\
please show me where is my error

Best
Salim
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,769
Messages
2,569,582
Members
45,066
Latest member
VytoKetoReviews

Latest Threads

Top