Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.sql.Statement;
- public class Main {
- public static Connection getConnection() throws Exception {
- String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
- String url = "jdbc:odbc:excelDB";
- String username = "yourName";
- String password = "yourPass";
- Class.forName(driver);
- return DriverManager.getConnection(url, username, password);
- }
- public static void main(String args[]) throws Exception {
- Connection conn = null;
- Statement stmt = null;
- ResultSet rs = null;
- conn = getConnection();
- stmt = conn.createStatement();
- String excelQuery = "select * from [Sheet1$]";
- rs = stmt.executeQuery(excelQuery);
- while (rs.next()) {
- System.out.println(rs.getString("FirstName") + " " + rs.getString("LastName"));
- }
- rs.close();
- stmt.close();
- conn.close();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement