Advertisement
Guest User

Untitled

a guest
Nov 27th, 2014
166
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.92 KB | None | 0 0
  1. public class AccessModel{
  2.  
  3. public DefaultTableModel getAccessModel() throws IOException {
  4. Database db = DatabaseBuilder.open(new File("MyFile.accdb"));
  5.  
  6. Vector<String> columnNames = new Vector<String>();
  7. Vector<String> vector = new Vector<String>();
  8. Vector<Vector<String>> data = new Vector<Vector<String>>();
  9.  
  10. StringBuilder output = new StringBuilder();
  11.  
  12. Table table = db.getTable("Table1");
  13.  
  14. for (Column column : table.getColumns()) { // get the table column names
  15. output.append(column.getName());
  16. output.append("n");
  17. columnNames.add(column.getName());
  18. }
  19. for (Column column : table.getColumns()) { // get the column rows and values
  20. vector.add(column.getRowValue(table.getNextRow()).toString());
  21. }
  22. data.add(vector);
  23.  
  24. // return the model to Gui
  25. DefaultTableModel accessModel = new DefaultTableModel(data, columnNames);
  26. return accessModel;
  27. }
  28. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement