可用jdbc方式连接EXCEL。实现增、删、改、查。
例：查询
package gzx.test;
import
java.sql
.*;
public class dbexcel {
/**
* 连接池对象
*/
private static String ExcelDataSource = “driver={Microsoft Excel Driver (*.xls)};DBQ=c:/test.xls”;
/**
* 返回Excel数据连接的实例
*
* @throws java.lang.Exception
* @return Connection
*/
public synchronized static Connection GetConnectionInstance() throws Exception {
Connection lcon = null;
try {
String url = “jdbc:odbc:” + ExcelDataSource;
Class.forName(“sun.jdbc.odbc.JdbcOdbcDriver”);
lcon = DriverManager.getConnection(url, “”, “”);
} catch (Exception e) {
System.out.println(“EXCEL数据源连接失败。”+e.getMessage());
}
return lcon;
}
/**
* 将Excel 数据批量入库
*
*/
public static boolean ExcelVolumeToDB() throws Exception
{
//读取Excel 数据
String esql = “select 姓名,性别 from [Sheet1$A1:B5]”;
System.out.println(“查询数据: ” + esql);
Connection ExcelCon = GetConnectionInstance();
try
{
Statement ExcelStmt= ExcelCon.createStatement();
ResultSet ExcelRes = ExcelStmt.executeQuery(esql);
while(ExcelRes.next()){
System.out.println(“姓名: ” + ExcelRes.getString(“姓名”) + “、性别: ” + ExcelRes.getString(“性别”));
}
ExcelRes.close();
ExcelStmt.close();
ExcelCon.close();
return true;
} catch (Exception ex) {
ex.printStackTrace();
return false;
}
}
public static void main(String[] args) throws Exception {
ExcelVolumeToDB();
}
}
