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

红薯
 红薯
发布于 2010年08月03日
收藏 1

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

本站文章除注明转载外,均为本站原创或编译。欢迎任何形式的转载,但请务必注明出处,尊重他人劳动共创开源社区。
转载请注明:文章转载自 开源中国社区 [http://www.oschina.net]
本文标题:Jackcess 1.2.1 发布,Access数据库读写库
加载中
返回顶部
顶部