Show Database data with a Table(Java)

1. Open your last NetBeans project
2. Add a Table
3. Add a button and name it as 'show data'

4. Right click on Libaries and add rs2xml.jar file


5. You can download it by following link
rs2xml.jar
6. Import following librarie

        import net.proteanit.sql.DbUtils;
        

7. Double click on button and add following codes

            try{
        String sql="select * from EMPDATA";
        pst=conn.prepareStatement(sql);
        rs=pst.executeQuery();
        jTable1.setModel(DbUtils.resultSetToTableModel(rs));
        }
        catch(Exception e){
        JOptionPane.showMessageDialog(null, e.getMessage());
        }
        finally{
            try{
                rs.close();
                pst.close();
                
            }
            catch(Exception e){}}
        

Important

• If you want to update your table in many time you can make a method for it. As a example if you update a data in your table you can call that method ontime.
• If you make a method named updateTable(), you can use it as "updateTable();" anyware in your programm(only in this frame).
• You can add this method in your main class(after initComponents();)your data will show as soon as your programm opening.