Reading data form Excel using Jdbc (example)

[Java Tip]

Presented below is an example of reading data from Excel worksheet using Jdbc.

Code:

public class EmployeeReader{
  public static void main(String[] args){
    Connection connection = null;
    try{
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      Connection con = DriverManager.getConnection( "jdbc:odbc:employee_xls" );
      Statement st = con.createStatement();
      ResultSet rs = st.executeQuery( "Select * from [Sheet1$]" );

      ResultSetMetaData rsmd = rs.getMetaData();
      int numberOfColumns = rsmd.getColumnCount();
                
      System.out.println ( "No of cols "+numberOfColumns  );              

      while (rs.next()) {
          for (int i = 1; i <= numberOfColumns; i++) {
            if (i > 1) System.out.print(", ");
            String columnValue = rs.getString(i);
            System.out.print(columnValue);
            }
            System.out.println(""); 
          }
      rs.close();  
      st.close();
      } 
    catch(Exception ex) {
      System.err.print("Exception: ");
      System.err.println(ex.getMessage());
      }
    finally {
      con.close();
      }
    }
 }