How do I populate my database in jtable and adding properly?

See more:

Java

netbeans

Finally I success the populate a data in jtable. But no refresh when I was add new data. Could you help me ? Thanks..

final void FillList() throws ClassNotFoundException {
       try {
           Class.forName("org.sqlite.JDBC");
           Connection con = DriverManager.getConnection("jdbc:sqlite:lib/mydb.db");

           String[] tableColumnsName = {"name", "city","date"};
           DefaultTableModel aModel = (DefaultTableModel) tablo.getModel();
           aModel.setColumnIdentifiers(tableColumnsName);

           Statement stmt = con.createStatement();
           ResultSet rs = stmt.executeQuery("select name,city,date from mytable");

           java.sql.ResultSetMetaData rsmd = rs.getMetaData();
           int colNo = rsmd.getColumnCount();
           while (rs.next()) {
               Object[] objects = new Object[colNo];
               for (int i = 0; i < colNo; i++) {
                   objects[i] = rs.getObject(i + 1);
               }
               aModel.addRow(objects);
           }
           tablo.setModel(aModel);
           con.close();
           stmt.close();
           rs.close();

       } catch (ClassNotFoundException ex) {
           Logger.getLogger(buny.class.getName()).log(Level.SEVERE, null, ex);
       } catch (SQLException ex) {
           Logger.getLogger(buny.class.getName()).log(Level.SEVERE, null, ex);
       }
   }

And another problem, this code is work but I don't see new data in table same time.(I see new data when I was restart my app) And ide show this error msg :
SEVERE: null
java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (Connection is closed)
at org.sqlite.core.DB.newSQLException(DB.java:890)
at org.sqlite.core.CoreStatement.internalClose(CoreStatement.java:109)
at org.sqlite.jdbc3.JDBC3Statement.close(JDBC3Statement.java:35)

private void addActionPerformed(java.awt.event.ActionEvent evt) {

       try {
           Class.forName("org.sqlite.JDBC");
           Connection con = DriverManager.getConnection("jdbc:sqlite:lib/mydb.db");
           Statement stmt = con.createStatement();
           String Query = "insert into mytable (name,city,date) values ('" +name.getText() + "','" + city.getText() + "','" + date.getText() + "')";

           stmt.executeQuery(Query);
           stmt.close();
           con.close();
           FillList();

           JOptionPane.showMessageDialog(null, "OK..");
       } catch (ClassNotFoundException ex) {
           Logger.getLogger(buny.class.getName()).log(Level.SEVERE, null, ex);
       } catch (SQLException ex) {
           Logger.getLogger(buny.class.getName()).log(Level.SEVERE, null, ex);
       }

   }