Main.java Source code

Introduction

Here is the source code for Main.java

Source

import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;

public class Main {
    public static void main(String[] argv) throws Exception {
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

        ResultSet rs = DriverManager.getConnection("jdbc:odbc:employee_xls").createStatement()
                .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++) {
                String columnValue = rs.getString(i);
                System.out.println(columnValue);
            }
        }
        rs.close();
    }
}