/*
* Author : Bok, Jong Soon
* When : July 20, 2011
* Objective : Connect to Microsoft Excel File via JDBC
* Environment : Microsoft Windows XP Service Pack 3, JDK 1.6.0_26, Editplus 3.x
*/
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class JdbcExcel {
	public static void main(String[] args) {
		String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
		String url = "jdbc:odbc:mydata";
		Connection conn = null;
		Statement stmt = null;
		ResultSet rs = null;
		try {
			Class.forName(driver);
            conn = DriverManager.getConnection(url);
            stmt = conn.createStatement();
			String sql = "SELECT * FROM [data$]";
            rs = stmt.executeQuery(sql);
            while(rs.next()){
				String name = rs.getString(1);
				int su = rs.getInt(2);
				int buy = rs.getInt(3);
				int sale = rs.getInt(4);
				int fee = rs.getInt(5);
				System.out.printf("%s, %d, %d, %d, %d\n", name, su, buy, sale, fee);
			}
        }catch(Exception ex){
            System.err.println("Exception: " + ex.getMessage());
        }finally{
			try{
				if(rs != null) rs.close();
				if(stmt != null) stmt.close();
				if(conn != null) conn.close();
			}catch(SQLException ex){}
		}
    }
}