资讯评论 - Jackcess 1.2.1 发布，Access数据库读写库 - OSCHINA

Jackcess 1.2.1 发布，Access数据库读写库

Jackcess 是一个Java 类库，用来读写微软的Access 数据库。

显示表格内容的源码：

System.out.println(Database.open(new File("my.mdb")).getTable("MyTable").display());

创建表并写入数据：

Database db = Database.create(new File("new.mdb"));
Table newTable = new TableBuilder("NewTable")
  .addColumn(new ColumnBuilder("a")
             .setSQLType(Types.INTEGER)
             .toColumn())
  .addColumn(new ColumnBuilder("b")
             .setSQLType(Types.VARCHAR)
             .toColumn())
  .toTable(db);
newTable.addRow(1, "foo");

该版本改进内容：

1. Support was added for reading Access 97 (jet format 3) databases.
2. ExportUtil and associated utilities were added for exporting tables to flat files.
3. Some minor fixes were included....
4. Some places where table/columns names were not being handled case-insensitively were fixed.
5. Database.escapeIdentifier was made public.
6. Methods were added to TableBuilder and ColumnBuilder to optionally escape names.
7. Support was added for overriding the charset and timezone used when reading or writing a database

Jackcess 1.2.1 发布，Access数据库读写库

暂无更多评论