Jackcess 是一个Java 类库,用来读写微软的Access 数据库。
显示表格内容的源码:
| 1 | System.out.println(Database.open(new File("my.mdb")).getTable("MyTable").display()); |
创建表并写入数据:
| 01 | Database db = Database.create(new File("new.mdb")); |
| 02 | Table newTable = new TableBuilder("NewTable") |
| 03 | .addColumn(new ColumnBuilder("a") |
| 04 | .setSQLType(Types.INTEGER) |
| 05 | .toColumn()) |
| 06 | .addColumn(new ColumnBuilder("b") |
| 07 | .setSQLType(Types.VARCHAR) |
| 08 | .toColumn()) |
| 09 | .toTable(db); |
| 10 | newTable.addRow(1, "foo"); |
