hi,
I have an illegal start of expression exception at function retnAL()
Can some body help me solving the exception
import java.io.*;
import java.net.*;
import java.sql.*;
import java.util.*;
public class xlsRead{
public static final
String DRIVER_NAME =
"sun.jdbc.odbc.JdbcOdbcDriver";
public static final String DATABASE_URL = "jdbc
dbc:exl";
public static void main(String[] args)
throws ClassNotFoundException, SQLException{
Class.forName(DRIVER_NAME);
Connection con = null;
try {
con = DriverManager.getConnection(DATABASE_URL);
//Connection conn = DriverManager.getConnection("jdbc
dbc
rcl","SMARISETTY","SMARISETTY" );
Statement stmt = con.createStatement();
//Statement statement = conn.createStatement
ResultSet rs = stmt.executeQuery
("select NAME from [bball$]");
ArrayList al = new ArrayList();
while (rs.next()) {
String lname = rs.getString(1);
al.add(lname);
//String fname = rs.getString(2);
//int id = rs.getInt(3);
//System.out.println(lname);
}
public ArrayList retnAL()
{
return (al);
}
rs.close();
stmt.close();
}
finally {
if (con != null)
con.close();
}
}
}