| 16 | public class Driver { |
| 17 | |
| 18 | static int export(Database db, String tableName, Writer csv) throws IOException{ |
| 19 | Table table = db.getTable(tableName); |
| 20 | String[] buffer = new String[table.getColumnCount()]; |
| 21 | CSVWriter writer = new CSVWriter(new BufferedWriter(csv)); |
| 22 | int rows = 0; |
| 23 | try{ |
| 24 | for(Row row : table){ |
| 25 | int i = 0; |
| 26 | for (Object object : row.values()) { |
| 27 | buffer[i++] = object == null ? null : object.toString(); |
| 28 | } |
| 29 | writer.writeNext(buffer); |
| 30 | rows++; |
| 31 | } |
| 32 | }finally{ |
| 33 | writer.close(); |
| 34 | } |
| 35 | return rows; |
| 36 | } |
| 37 | |
| 38 | static void export(String filename, String tableName) throws IOException{ |
| 39 | Database db = DatabaseBuilder.open(new File(filename)); |