Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public class AccessModel{
- public DefaultTableModel getAccessModel() throws IOException {
- Database db = DatabaseBuilder.open(new File("MyFile.accdb"));
- Vector<String> columnNames = new Vector<String>();
- Vector<String> vector = new Vector<String>();
- Vector<Vector<String>> data = new Vector<Vector<String>>();
- StringBuilder output = new StringBuilder();
- Table table = db.getTable("Table1");
- for (Column column : table.getColumns()) { // get the table column names
- output.append(column.getName());
- output.append("n");
- columnNames.add(column.getName());
- }
- for (Column column : table.getColumns()) { // get the column rows and values
- vector.add(column.getRowValue(table.getNextRow()).toString());
- }
- data.add(vector);
- // return the model to Gui
- DefaultTableModel accessModel = new DefaultTableModel(data, columnNames);
- return accessModel;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement