默认先在目录下生成common.mdb文件
/**
* Project Name:MonitoringPlatform-commons-util* File Name:MdbUtils.java
* Package Name:com.monitoring.common.util
* Date:2017年4月20日上午10:40:50
* Copyright (c) 2017, chenzhou1025@126.com All Rights Reserved.
*
*/
package com.monitoring.common.util;
import java.io.File;
import java.sql.Types;
import java.util.Map;
import org.apache.commons.io.Charsets;
import com.healthmarketscience.jackcess.ColumnBuilder;
import com.healthmarketscience.jackcess.Database;
import com.healthmarketscience.jackcess.Database.FileFormat;
import com.healthmarketscience.jackcess.Table;
import com.healthmarketscience.jackcess.TableBuilder;
/**
* ClassName:MdbUtils <br/>
* Function: ADD FUNCTION. <br/>
* Reason: ADD REASON. <br/>
* Date: 2017年4月20日 上午10:40:50 <br/>
* @author wpengfei
* @version
* @since JDK 1.6
* @see
*/
public class MdbUtils {
public static void operator() throws Exception {
File mdbFile = new File("E:\\hospital\\trunk\\MonitoringPlatform-commons-util\\src\\main\\java\\com\\monitoring\\common\\util\\common.mdb");
if (mdbFile.exists()) {
Database dbin = Database.open(mdbFile);
Table table = dbin.getTable("InfoTable");
/*for (Map<String, Object> map : table) { //打印原先该文件中的数据
System.out.println(map);
} */
}
Database db = Database.create(FileFormat.V2000, mdbFile, true,
Charsets.UTF_16LE, null);
Table newTable = new TableBuilder("InfoTable")
.addColumn(
new ColumnBuilder("名称").setSQLType(Types.VARCHAR)
.toColumn())
.addColumn(
new ColumnBuilder("年龄112").setSQLType(Types.VARCHAR)
.toColumn()).toTable(db);
newTable.addRow("2鹏23", "123423");
System.out.println(true
);
}
public static void main(String[] args) throws Exception {
operator();
}
}
maven依赖
- <dependency>
- <groupId>org.hsqldb</groupId>
- <artifactId>hsqldb</artifactId>
- <version>2.2.8</version>
- <type>jar</type>
- <optional>false</optional>
- </dependency>
- <dependency>
- <groupId>com.healthmarketscience.jackcess</groupId>
- <artifactId>jackcess</artifactId>
- <version>1.2.14.2</version>
- <type>jar</type>
- <optional>false</optional>
- </dependency>