3

I have java program doing that : fetching data from database and append them into JTable.

when I add data into database, I cant refresh JTable to view the new data and I should to close program and run it again.

how can I refresh/reload the program to view data

mKorbel
  • 109,525
  • 20
  • 134
  • 319
user1625324
  • 93
  • 1
  • 1
  • 7

2 Answers2

2

Ok, I will just give you a quick solution:

package stack;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.swing.JTable;
import javax.swing.table.DefaultTableModel;


public class Test {
    JTable table = new JTable();

    public void selectFrom(){
        Connection conn = null;
        Statement st = null;
        ResultSet rs = null;
        DefaultTableModel model=(DefaultTableModel)table.getModel();
        int rc= model.getRowCount();
        for(int i = 0;i<rc;i++){
            model.removeRow(0);
        }
        try{
            Class.forName("org.postgresql.Driver");
            conn = DriverManager.getConnection("jdbc:postgresql://localhost:5432/mydb","postgres","123");
            st = conn.createStatement();
            rs = st.executeQuery("select * from mytable");
            while(rs.next()){
                //Populate table
            }
        }catch(Exception e){
            e.printStackTrace();
        }finally{
            try {
                rs.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
            try {
                st.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
            try {
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }

    private void insertInto(){
        Connection conn = null;
        PreparedStatement pst = null;
            try{
                Class.forName("org.postgresql.Driver");
                conn = DriverManager.getConnection("jdbc:postgresql://localhost:5432/mydb","postgres","123");
                pst = conn.prepareStatement("INSERT INTO mytable(id,first_column) VALUES(?,?)");
                //Insert into table using pst
                pst.execute();

                selectFrom();
            }catch(Exception e){
                e.printStackTrace();
            }finally{
                try {
                    conn.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
                try {
                    pst.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
        }
    }
}
Branislav Lazic
  • 14,388
  • 8
  • 60
  • 85
  • Well sorry Mr. Thompson, english isn't my native language. – Branislav Lazic Sep 01 '12 at 01:23
  • No peoblem in insertion rows into database or JTable, but when I insert a new row into database it does not appear directly into JTable , I have to close program and run it again. – user1625324 Sep 01 '12 at 02:00
  • Thats because you have to call selectFrom(); (or whatever you call it) again. Pay attention on my insertInto(); method, you will spot that I called selectFrom(); method inside of it...to fetch data again. – Branislav Lazic Sep 01 '12 at 02:05
  • no need to loop for removing all rows - setRowCount(0) is the api you didn't find :-) – kleopatra Sep 01 '12 at 07:08
  • consider to edit your answer to show the correct method to use :-) – kleopatra Sep 01 '12 at 14:32
2

If using DefaultTableModel see the addRow methods. Else simply create a new model and call JTable.setModel(TableModel).

Andrew Thompson
  • 168,117
  • 40
  • 217
  • 433