/*
* 创建日期 2008-12-9
*/
package excelAsDB;
import java.sql.Connection;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
/**
* @author 李怀北
*
* Discription：Excel 作为数据库
*
*/
public class ReadExcel {
/**
* @param args
*/
public static void main(String[] args) {
ReadExcel obj = new ReadExcel();
obj.ReadExcelJdbc();
obj.ReadExcelOdbc();
}
/**
* ODBC 连接Excel
*/
public void ReadExcelOdbc(){
Connection c = null;
Statement stmnt = null;
ResultSet rs = null;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
c = DriverManager.getConnection("jdbc:odbc:db", "", "");
stmnt = c.createStatement();
String query = "SELECT * FROM [Sheet1$] where a='a1' ";
rs = stmnt.executeQuery(query);
System.out.println("查得匹配'测试'的test1的记录为:");
while (rs.next()) {
System.out.println(rs.getString("a"));
System.out.println(rs.getString("b"));
System.out.println(rs.getString("c"));
System.out.println(rs.getString("d"));
System.out.println(rs.getString("e"));
}
} catch (Exception e) {
System.err.println(e);
} finally {
try {
rs.close();
stmnt.close();
c.close();
} catch (Exception e) {
System.err.println(e);
}
}
}
/**
* JDBC 连接Excel
*/
public void ReadExcelJdbc(){
ResultSet rs = null;
Connection con = null;
Statement stm = null;
try {
String driver = "com.hxtt.sql.excel.ExcelDriver";
Driver d = (Driver) Class.forName(driver).newInstance();
String protocol = "jdbc:excel:/";
String database = "C:/File/DB.xls";
String url = protocol + database;
con = DriverManager.getConnection(url);
stm = con.createStatement();
String sql = "select * from Sheet1 ";
rs = stm.executeQuery(sql);
int i = 1;
while (rs.next()) {
System.out.println("第 "+i+" 行第 1 列是：" + rs.getString(1));
i++;
}
con.close();
} catch (Exception e) {
e.printStackTrace();
}finally{
try {
rs.close();
stm.close();
con.close();
} catch (SQLException e1) {
e1.printStackTrace();
}
}
}
}
JDBC_EXCEL.rar （19个子文件） 
excel 
Excel_JDBC30.jar 964KB excemple 
ReadExcel.java 3KB
history.html 4KB transaction.html 6KB META-INF MANIFEST.MF 71B document.html 8KB sqlsyntax.html 32KB statement.html 8KB installation.html 13KB function.html 44KB faq.html 34KB openapi.html 16KB start.html 7KB components.html 3KB advanced.html 30KB download.html 2KB introduction.html 3KB index.html 2KB resultset.html 7KB
评论0