有 Java 编程相关的问题?

你可以在下面搜索框中键入要查询的问题!

使用jtable和数据库在javaswing中进行分页

我是java新手,正在使用数据库开发Jtable。我用数据库中的数据填充jtable,现在我需要使用分页,我不知道如何在我的代码中实现这一点,我使用DbUtils填充jtable,每个想法都是可以的,但问题是我不知道如何使用分页,提前感谢您分享信息和帮助

public class FenetrePers extends JFrame  {
    private JTextField rechNomField;
    private JTextField rechPrenField;
    private JTextField rechemailField;
    private JTextField rechtelephField;
    private JButton btnNewButton_2;
    AjoutPers ajpers;
    
    
    Connection cnx =null;
    PreparedStatement prepared=null;
    ResultSet resultat=null;
    private JScrollPane scrollPane;
    private JTable table;
    private JButton editButton;
    private JButton deleteButton;
    
    public FenetrePers() {
        cnx=ConnectionSql.ConnexionDB();
        
        this.setExtendedState(this.MAXIMIZED_BOTH);
        
        setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
        getContentPane().setLayout(null);
        
        
        
        JLabel lblNewLabel = new JLabel("       Gestion du personnel");
        lblNewLabel.setFont(new Font("Tahoma", Font.BOLD, 14));
        lblNewLabel.setForeground(Color.BLACK);
        lblNewLabel.setBounds(10, 23, 181, 21);
        getContentPane().add(lblNewLabel);
        
        rechNomField = new JTextField();
        rechNomField.setBounds(27, 84, 175, 32);
        getContentPane().add(rechNomField);
        rechNomField.setColumns(10);
        
        rechPrenField = new JTextField();
        rechPrenField.setBounds(298, 84, 163, 32);
        getContentPane().add(rechPrenField);
        rechPrenField.setColumns(10);
        
        rechemailField = new JTextField();
        rechemailField.setBounds(587, 84, 163, 32);
        getContentPane().add(rechemailField);
        rechemailField.setColumns(10);
        
        rechtelephField = new JTextField();
        rechtelephField.setBounds(844, 84, 157, 32);
        getContentPane().add(rechtelephField);
        rechtelephField.setColumns(10);
        
        JButton FindButton = new JButton("find");
        FindButton.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent arg0) {
                
                try {
                    UpdateTableSearch();
                } catch (SQLException e) {
                    // TODO Auto-generated catch block
                    e.printStackTrace();
                }
                
            }
        });
        FindButton.setBounds(1034, 89, 66, 27);
        getContentPane().add(FindButton);
        
        JButton btnNewButton_1 = new JButton("reset");
        btnNewButton_1.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent arg0) {
                
                String nomS=rechNomField.getText().toString();  
                String prenomS=rechPrenField.getText().toString();  
                String emailS=rechemailField.getText().toString();  
                String telephS=rechtelephField.getText().toString();
                if(!nomS.equals("")|| !prenomS.equals("")|| !emailS.equals("")||!telephS.equals("")) {
                rechNomField.setText("");
                rechPrenField.setText("");
                rechemailField.setText("");
                rechtelephField.setText("");
                UpdateTable();
                
                
            }}
        });
        btnNewButton_1.setBounds(1110, 89, 66, 27);
        getContentPane().add(btnNewButton_1);
        
        btnNewButton_2 = new JButton("Ajouter personnel");
        btnNewButton_2.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                
             ajpers =   new AjoutPers(FenetrePers.this);
            UpdateTable();
            
            }
        });
        btnNewButton_2.setBounds(1034, 24, 142, 32);
        getContentPane().add(btnNewButton_2);
        
        scrollPane = new JScrollPane();
        scrollPane.setBounds(27, 150, 985, 308);
        getContentPane().add(scrollPane);
        
        table = new JTable();
        table.addMouseListener(new MouseAdapter() {
            @Override
            public void mouseClicked(MouseEvent arg0) {
                
            
            }
        });
        scrollPane.setViewportView(table);

共 (0) 个答案