表格实时更新问题

代码如下，想实现的功能是增加用户，或者删除用户，，下面的显示框会实时更新，不需要重进界面才会刷新出刚才增加或删除之后的内容，我尝试过把显示内容那部分定义成一个方法，但好像也不是很好，而且麻烦，
import java.awt.*;
import java.awt.event.*;
import *;
import *;
import java.sql.*;
import java.util.*;

import javax.swing.*;

import javax.swing.*;
import javax.swing.table.DefaultTableModel;

public class Conn {
    public void Myframe(){
    JFrame qj=new JFrame("QQ2017");
    qj.setLayout(null);
    qj.setBounds(0,0,200,500);
    Container con=qj.getContentPane();
    qj.setVisible(true);
   
   
    JButton user=new JButton("管理用户");
    user.setBounds(30,60,100,21);
    user.setForeground(Color.red);
    con.add(user);
    user.setVisible(true);
    user.addActionListener(new ActionListener() {
        public void actionPerformed(ActionEvent e){
            
            JFrame zjadmin=new JFrame("用户");
            zjadmin.setLayout(null);
            zjadmin.setBounds(0,0,300,300);
            zjadmin.setVisible(true);
            Container con1=zjadmin.getContentPane();
            
            //用户框内的面板显示
         Connection con;
             ResultSet res;
             DefaultTableModel model=new DefaultTableModel();//创建一个表格模型
            model.setColumnIdentifiers(new Object[]{"账号","密码",});//创建表头
            try {
                Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
                System.out.println("驱动加载成功");
                con=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=ADM","sa","sa");
                System.out.println("数据库连接成功");
                String sql="select * from USERINTO";
                 PreparedStatement stmt=con.prepareStatement(sql);
                res=stmt.executeQuery();
   
                while(res.next()){
                    String id=res.getString("userid");
                    String password=res.getString("password");
                    model.addRow(new Object[]{id,password});
                    
                }
               
                final JTable table=new JTable(model);
                JScrollPane scrollPanne=new JScrollPane(table);
                scrollPanne.setBounds(0,80,300,200);
                con1.add(scrollPanne);
                scrollPanne.setVisible(true);
               
                JButton addadminer=new JButton("增加用户");
                addadminer.setBounds(10,10,100,21);
                con1.add(addadminer);
                addadminer.setVisible(true);

                addadminer.addActionListener(new ActionListener(){
                    public void actionPerformed(ActionEvent e){
                    
                    JFrame zjadmin=new JFrame("增加用户");
                    zjadmin.setBounds(0,0,300,200);
                    Container con1=zjadmin.getContentPane();
                    zjadmin.setVisible(true);
                    
                    final JLabel zh=new JLabel("账号");
                    zh.setBounds(0, 20, 100, 21);
                    con1.add(zh);
                    
                    final JTextField zhangh=new JTextField();
                    zhangh.setBounds(30,20,100,20);   
                    zhangh.setBackground(Color.yellow);
                    con1.add(zhangh);
                    zhangh.setVisible(true);
                    
                    final JLabel zcjl=new JLabel("密码");
                    zcjl.setBounds(0, 40, 100, 21);
                    con1.add(zcjl);
                    
                    final JTextField zcmima=new JTextField("",20);
                    zcmima.setBounds(30,40,100,20);   
                    zcmima.setBackground(Color.yellow);
                    con1.add(zcmima);
                    zcmima.setVisible(true);
                    
                    final JButton zcau=new JButton("注册");
                    zcau.setBounds(40,70,60,20);
                    con1.add(zcau);
                    zcau.setVisible(true);
                    
                    final JLabel zcview=new JLabel();                                   
                    zcview.setBounds(150, 70, 100,21);
                    con1.add(zcview);
                    
                    zcau.addActionListener(new ActionListener(){
                        public void actionPerformed(ActionEvent e){
                             Connection con;
                            try {
                                Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
                                //System.out.println("驱动加载成功");
                                con=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=ADM","sa","sa");
                                //System.out.println("数据库连接成功");
                                String sql="insert into USERINTO (userid,password) values (?,?)";
                             PreparedStatement stmt=con.prepareStatement(sql);//执行sql语句
                                stmt.setString(1, zhangh.getText());
                                stmt.setString(2, zcmima.getText());
                                stmt.executeUpdate();  
                                zcview.setText("注册成功");
                                con.close();
                            System.out.println("添加成功");
                            } catch (Exception e1) {
                                // TODO Auto-generated catch block
                                e1.printStackTrace();
                            }
                                
                        }
                    });
                  
                    }
            });
               
                JButton deleteadmin=new JButton("删除用户");
                deleteadmin.setBounds(120,10,100,21);
                con1.add(deleteadmin);
                deleteadmin.setVisible(true);
                deleteadmin.addActionListener(new ActionListener(){
                        public void actionPerformed(ActionEvent e){
                            int rowcount=table.getSelectedRow();
                            System.out.print(rowcount);
                            System.out.print(table.getValueAt(rowcount,0 ));
                             Connection con;
                        try {
                            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
                            //System.out.println("驱动加载成功");
                            con=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=ADM","sa","sa");
                            //System.out.println("数据库连接成功");
                            String sql="delete  from USERINTO "+"where userid=?";
                             PreparedStatement stmt=con.prepareStatement(sql);//执行sql语句
                             stmt.setString(1, (String) table.getValueAt(rowcount,0 ));
                             stmt.executeUpdate();
                            System.out.println("删除成功");
                        } catch (Exception e1) {
                            // TODO Auto-generated catch block
                            e1.printStackTrace();
                        }
                        }
                });
               
               
                res.close();
                con.close();
            } catch (Exception e1) {
                // TODO Auto-generated catch block
                e1.printStackTrace();
            }
            
            
            //addadminer.setForeground(Color.red);
            
            
            
            
        
        
        
        }
   
    });
   
    }
   
   public static void main(String args[]){
       Conn main=new Conn();
        main.Myframe();
   
    }
   
}

谢啦，我想到了一个简单的办法了，，修改表格模型里的内容就可以实现，比如model.removeRow(rowcount);只要添加这个进去就可以了