Main.java Source code

Introduction

Here is the source code for Main.java

Source

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class Main {

    public static void main(String[] args) throws Exception {
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        Connection conn = DriverManager
                .getConnection("jdbc:odbc:Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};"
                        + "Dbq=C://Book1.xlsx;");

        PreparedStatement s = conn.prepareStatement("SELECT * FROM [Sheet1$] WHERE [MetricMonth] = ?");
        s.setString(1, "Jul-2013");
        s.execute();
        ResultSet rs = s.getResultSet();
        if (rs != null) {
            while (rs.next()) {
                System.out.println(rs.getInt("All"));
            }
        }
        s.close();

        conn.close();
    }

}