java 导出mdb文件_Java程序生成一个Access文件

package access;

import java.io.File;

import java.io.IOException;

import java.sql.SQLException;

import java.sql.Types;

import org.junit.Test;

import com.healthmarketscience.jackcess.ColumnBuilder;

import com.healthmarketscience.jackcess.Database;

import com.healthmarketscience.jackcess.DatabaseBuilder;

import com.healthmarketscience.jackcess.Table;

import com.healthmarketscience.jackcess.TableBuilder;

public class AccessUtil {

public static void main(String[] args) throws IOException {

//这里同样支持mdb和accdb

Database db = DatabaseBuilder.create(Database.FileFormat.V2000, new File("d:\\new.mdb"));

Table newTable;

try {

//刚才是创建文件，这里是在文件里创建表，字段名，字段类型

newTable = new TableBuilder("Archives")

.addColumn(new ColumnBuilder("档