Wie bekomme ich ein ArrayList in die JTable?
Hier mein Code/Methode
Hier mein Code/Methode
Java:
DataTable() throws SQLException { // Konstruktor
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
ImageIcon img = new ImageIcon("TaskIcon.png");
Image icon = Toolkit.getDefaultToolkit().getImage("TaskIcon.png");
//JFrame.setIconImage(icon);
//JFrame.setIconImage(img.getImage());
// String[] titel = {"Datum", "Erledigt", "Aufgabe","Wiederholung","Prio"};
String[] titel = {"Datum", "Erledigt", "Aufgabe","Wiederholung","Prio","Zeit"};
// String [][] inhalt = { {"Beatles","Help","Test","x","1"},
// {"Beatwatt","Is That All", "Test","x","2"} };
ArrayList<TaskData> list = DatabaseConnect.taskArrayList();
JTable table = new JTable(inhalt, titel);
add(new JScrollPane(table)); // ohne JScrollPane keine Titel!
table.setFont(new Font("Verdana", Font.PLAIN, 14));
setSize(400, 300);
setVisible(true);
}
Java:
public static ArrayList<TaskData> taskArrayList() throws SQLException {
Connection conn = null;
Statement stmt = null;
String url = "jdbc:sqlite:C:\\Privat\\sqlite\\SQLiteStudio\\DataTasks.db";
try {
conn = DriverManager.getConnection(url);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
stmt = conn.createStatement();
//ResultSet rs = stmt.executeQuery("SELECT * FROM TablDataTask;");
ResultSet rs = stmt.executeQuery("SELECT ID, TaskDate, TaskData " +
" FROM TablDataTask " +
" WHERE TaskDate=(SELECT Max([TaskDate]) FROM TablDataTask)");
System.out.println("ID\t Task\t ");
ArrayList<TaskData> taskDataList = new ArrayList<TaskData>();
while ( rs.next() ) {
TaskData taskDataObj = new TaskData();
taskDataObj.setId(rs.getInt("ID"));
taskDataObj.setDate(rs.getString("TaskDate"));
taskDataObj.setTask(rs.getString("TaskData"));
taskDataList.add(taskDataObj);
Integer id = rs.getInt("ID");
String taskDate = rs.getString("TaskDate");
String taskData = rs.getString("TaskData");
System.out.println(id+" \t "+taskDate +" \t "+taskData);
}
rs.close();
return taskDataList;
}