java excel odbc,java读取excel表格中的内容(1.手动配置ODBC数据源 2.不手动配置)

java读取excel表格中的内容(1.手动配置ODBC数据源2.不手动配置)一，不手动配置数据源

例程如下

view plaincopy to clipboardprint?

01.import java.sql.*;

02.public class Odbc

03.{

04. public static void main(String args[]) throws ClassNotFoundException, SQLException{

05. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

06. String dburl="driver={Microsoft Excel Driver (*.xls)};DBQ=f:\\banji\\cekong08.xls";//

07. Connection conn=DriverManager.getConnection("jdbc:odbc:"+dburl);

08. Statement stmt=conn.createStatement();

09. ResultSet rs=stmt.executeQuery("select * from [sheet1$]");

10. while(rs.next())

11. {

12. System.out.println(rs.getString("姓名"));

13.

14. }

15. stmt.close();

16. conn.close();

17. }

18.}

import java.sql.*;

public class Odbc

{

public static void main(String args[]) throws ClassNotFoundException, SQLException{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

String dburl="driver={Microsoft Excel Driver (*.xls)};DBQ=f:\\banji\\cekong08.xls";//

Connection

conn=DriverManager.getConnection("jdbc:odbc:"+dburl); Statement stmt=conn.createStatement();

ResultSet rs=stmt.executeQuery("select * from [sheet1$]"); while(rs.next())

{

System.out.println(rs.getString("姓名"));

}