如何制作分页按钮(下一页、上一页),并从数据库加载按钮的值?

huangapple 未分类评论56阅读模式
标题翻译

How to make paginations buttons (Next, Previous) that load button values from database?

问题

package posresturent;

import com.mysql.jdbc.Connection;
import com.mysql.jdbc.PreparedStatement;
import static java.awt.Component.CENTER_ALIGNMENT;
import java.awt.Dimension;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.DriverManager;
import java.sql.ResultSet;
import javax.swing.AbstractButton;
import javax.swing.ImageIcon;
import javax.swing.JButton;
import javax.swing.SwingConstants;

public class mainPanel extends javax.swing.JPanel {

    private JButton btnCategory;
    final int col = 5;
    final int rows = 2;
    Connection con;
    PreparedStatement pst;
    ResultSet rs;

    public mainPanel() {
        initComponents();
        cat_buttons();
    }

    public void cat_buttons() {
        try {
            Class.forName("com.mysql.jdbc.Driver");
            con = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/shopingmoll", "root", "qwer9900");
            String sl = "SELECT * FROM `item_types` ";
            pst = (PreparedStatement) con.prepareStatement(sl);
            rs = pst.executeQuery();

            rs.absolute(1);
            rs.absolute(5);

            String a1 = rs.getString("name");
            String a2 = rs.getString("id");
            JButton btn = new JButton();

            btn.setText("<html><body> <h3>" + a1 + "</h3><br> <b></body></html> ");
            btn.setVerticalAlignment((int) CENTER_ALIGNMENT);
            btn.applyComponentOrientation(getComponentOrientation());
            btn.setFocusPainted(false);
            btn.setFocusable(false);
            btn.setRequestFocusEnabled(false);
            btn.setMaximumSize(new Dimension(110, 90));
            btn.setPreferredSize(new Dimension(90, 80));
            btn.setMinimumSize(new Dimension(110, 90));

            btn.addActionListener(new ActionListener() {
                public void actionPerformed(ActionEvent e) {
                    System.out.println(a1 + ":" + a2);
                }
            });

            ImageIcon img = new ImageIcon("src/posresturent/cat.jpg");

            btn.setHorizontalAlignment(SwingConstants.CENTER);
            btn.setHorizontalTextPosition(AbstractButton.CENTER);
            btn.setVerticalTextPosition(AbstractButton.BOTTOM);
            cat_panel.add(btn, "center");
            repaint();
            revalidate();
        } catch (Exception e) {
        }
    }

    private void jButton15ActionPerformed(java.awt.event.ActionEvent evt) {                                          
        // TODO add your handling code here:
    }    

    private void jButton14ActionPerformed(java.awt.event.ActionEvent evt) {                                          
        // TODO add your handling code here:
    }
    
    // ... (Other components and methods)
}
英文翻译

I want to make a category JPanel in which I get all buttons values from the database on scroll pane but I want to remove the scroll pane and use pagination two buttons (Next, Previous) that control button values from database next or previous.

Output Image.png

> Image 2 Frome JAva Floreant POS Like this.

Image#02 JAVA Floreant POS.png

Following my code:

    /*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package posresturent;

import com.mysql.jdbc.Connection;
import com.mysql.jdbc.PreparedStatement;
import static java.awt.Component.CENTER_ALIGNMENT;
import java.awt.Dimension;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.DriverManager;
import java.sql.ResultSet;
import javax.swing.AbstractButton;
import javax.swing.ImageIcon;
import javax.swing.JButton;
import javax.swing.JOptionPane;
import javax.swing.JScrollBar;
import javax.swing.SwingConstants;

/**
 *
 * @author ultronhouse11
 */
public class mainPanel extends javax.swing.JPanel {

    /**
     * Creates new form mainPanel
     */
    private JButton btnCategory;
    final int col = 5;
    final int rows = 2;
    Connection con;
    PreparedStatement pst;
    ResultSet rs;

    public mainPanel() {
        initComponents();
       
        cat_buttons();

     

    }

   

    public void cat_buttons() {

        try {

            Class.forName(&quot;com.mysql.jdbc.Driver&quot;);
            con = (Connection) DriverManager.getConnection(&quot;jdbc:mysql://localhost:3306/shopingmoll&quot;, &quot;root&quot;, &quot;qwer9900&quot;);
            String sl = &quot;SELECT * FROM `item_types` &quot;;
            pst = (PreparedStatement) con.prepareStatement(sl);

            rs = pst.executeQuery();

        //     JFlowPanel jPeople = new JFlowPanel();
          
          
     
             //rs.absolute(5);
            // while (rs.next()) {
                
                rs.absolute(1);
                rs.absolute(5);
                
                String a1 = rs.getString(&quot;name&quot;);
                String a2 = rs.getString(&quot;id&quot;);
                JButton btn = new JButton();
              
               
                btn.setText(&quot;&lt;html&gt;&lt;body&gt; &lt;h3&gt;&quot; + a1 + &quot;&lt;/h3&gt;&lt;br&gt; &lt;b&gt;&lt;/body&gt;&lt;/html&gt; &quot;);
                btn.setVerticalAlignment((int) CENTER_ALIGNMENT);
                btn.applyComponentOrientation(getComponentOrientation());
                btn.setFocusPainted(false);
                btn.setFocusable(false);
                btn.setRequestFocusEnabled(false);
                btn.setMaximumSize(new Dimension(110, 90));
                btn.setPreferredSize(new Dimension(90, 80));
                btn.setMinimumSize(new Dimension(110, 90));

                btn.addActionListener(new ActionListener() {
                    public void actionPerformed(ActionEvent e) {
                        System.out.println(a1+&quot;:&quot;+a2);
                    }
                });

                //String a2 = rs.getString(2);
                ImageIcon img = new ImageIcon(&quot;src/posresturent/cat.jpg&quot;);
                // btn.setIcon(img);

                btn.setHorizontalAlignment(SwingConstants.CENTER);
                btn.setHorizontalTextPosition(AbstractButton.CENTER);
                btn.setVerticalTextPosition(AbstractButton.BOTTOM);
                cat_panel.add(btn,&quot;center&quot;);
              
                repaint();
                revalidate();
             //}
          
           
             // cat_sch.getViewport().setView(jPeople);
         
        } catch (Exception e) {
        }

    }

   
     
    /**
     * This method is called from within the constructor to initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is always
     * regenerated by the Form Editor.
     */
    @SuppressWarnings(&quot;unchecked&quot;)
    // &lt;editor-fold defaultstate=&quot;collapsed&quot; desc=&quot;Generated Code&quot;&gt;                          
    private void initComponents() {

        jTabbedPane1 = new javax.swing.JTabbedPane();
        jPanel2 = new javax.swing.JPanel();
        sch = new javax.swing.JScrollPane();
        jPanel9 = new javax.swing.JPanel();
        jPanel11 = new javax.swing.JPanel();
        textFieldRectBackground1 = new org.edisoncor.gui.textField.TextFieldRectBackground();
        jScrollPane1 = new javax.swing.JScrollPane();
        jTable1 = new javax.swing.JTable();
        jLabel1 = new javax.swing.JLabel();
        jLabel2 = new javax.swing.JLabel();
        jTextField1 = new javax.swing.JTextField();
        jTextField2 = new javax.swing.JTextField();
        jTextField3 = new javax.swing.JTextField();
        jLabel3 = new javax.swing.JLabel();
        jPanel10 = new javax.swing.JPanel();
        jButton4 = new javax.swing.JButton();
        jButton5 = new javax.swing.JButton();
        jButton6 = new javax.swing.JButton();
        jButton7 = new javax.swing.JButton();
        jButton8 = new javax.swing.JButton();
        jButton9 = new javax.swing.JButton();
        jButton10 = new javax.swing.JButton();
        cat_panel = new javax.swing.JPanel();
        jPanel5 = new javax.swing.JPanel();
        jButton14 = new javax.swing.JButton();
        jButton15 = new javax.swing.JButton();
        jPanel6 = new javax.swing.JPanel();
        jButton22 = new javax.swing.JButton();
        jButton23 = new javax.swing.JButton();
        jButton24 = new javax.swing.JButton();
        jButton25 = new javax.swing.JButton();
        jButton26 = new javax.swing.JButton();
        jButton27 = new javax.swing.JButton();
        jPanel3 = new javax.swing.JPanel();
        jPanel1 = new javax.swing.JPanel();
        jButton1 = new javax.swing.JButton();
        jButton2 = new javax.swing.JButton();
        jButton3 = new javax.swing.JButton();
        jButton11 = new javax.swing.JButton();
        jButton12 = new javax.swing.JButton();
        jButton13 = new javax.swing.JButton();

        sch.setBorder(javax.swing.BorderFactory.createTitledBorder(null, &quot;Items&quot;, javax.swing.border.TitledBorder.CENTER, javax.swing.border.TitledBorder.DEFAULT_POSITION));

        jPanel11.setLayout(new java.awt.GridLayout(1, 0));

        textFieldRectBackground1.setDescripcion(&quot;Enter Barcode ...&quot;);
        textFieldRectBackground1.setFocusCycleRoot(true);
        jPanel11.add(textFieldRectBackground1);

        jTable1.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null}
            },
            new String [] {
                &quot;#SrNo&quot;, &quot;Product&quot;, &quot;Unit&quot;, &quot;Rate&quot;
            }
        ));
        jTable1.setRowHeight(35);
        jScrollPane1.setViewportView(jTable1);

        jLabel1.setFont(new java.awt.Font(&quot;Arial&quot;, 0, 14)); // NOI18N
        jLabel1.setText(&quot;Total &quot;);

        jLabel2.setFont(new java.awt.Font(&quot;Arial&quot;, 0, 14)); // NOI18N
        jLabel2.setText(&quot;Tax&quot;);

        jTextField1.setFont(new java.awt.Font(&quot;Arial&quot;, 1, 18)); // NOI18N
        jTextField1.setHorizontalAlignment(javax.swing.JTextField.RIGHT);
        jTextField1.setText(&quot;0.00&quot;);

        jTextField2.setFont(new java.awt.Font(&quot;Arial&quot;, 1, 18)); // NOI18N
        jTextField2.setHorizontalAlignment(javax.swing.JTextField.RIGHT);
        jTextField2.setText(&quot;0.00&quot;);

        jTextField3.setFont(new java.awt.Font(&quot;Arial Black&quot;, 1, 45)); // NOI18N
        jTextField3.setForeground(new java.awt.Color(51, 51, 51));
        jTextField3.setHorizontalAlignment(javax.swing.JTextField.CENTER);
        jTextField3.setText(&quot; Rs  0.00&quot;);

        jLabel3.setFont(new java.awt.Font(&quot;Arial&quot;, 0, 14)); // NOI18N
        jLabel3.setText(&quot;&lt;html&gt; Grand &lt;br&gt;&lt;br&gt; Total&quot;);

        javax.swing.GroupLayout jPanel9Layout = new javax.swing.GroupLayout(jPanel9);
        jPanel9.setLayout(jPanel9Layout);
        jPanel9Layout.setHorizontalGroup(
            jPanel9Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(jPanel11, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
            .addGroup(jPanel9Layout.createSequentialGroup()
                .addGroup(jPanel9Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jLabel2)
                    .addComponent(jLabel1)
                    .addComponent(jLabel3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addGap(35, 35, 35)
                .addGroup(jPanel9Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
                    .addComponent(jTextField3, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, 230, Short.MAX_VALUE)
                    .addComponent(jTextField1, javax.swing.GroupLayout.Alignment.TRAILING)
                    .addComponent(jTextField2, javax.swing.GroupLayout.Alignment.TRAILING))
                .addGap(0, 0, Short.MAX_VALUE))
            .addComponent(jScrollPane1, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 309, javax.swing.GroupLayout.PREFERRED_SIZE)
        );
        jPanel9Layout.setVerticalGroup(
            jPanel9Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel9Layout.createSequentialGroup()
                .addComponent(jPanel11, javax.swing.GroupLayout.PREFERRED_SIZE, 33, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(1, 1, 1)
                .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 0, Short.MAX_VALUE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(jPanel9Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel9Layout.createSequentialGroup()
                        .addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(jTextField2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addGap(7, 7, 7))
                    .addGroup(jPanel9Layout.createSequentialGroup()
                        .addComponent(jLabel1)
                        .addGap(18, 18, 18)
                        .addComponent(jLabel2)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)))
                .addGroup(jPanel9Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jLabel3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jTextField3, javax.swing.GroupLayout.PREFERRED_SIZE, 69, javax.swing.GroupLayout.PREFERRED_SIZE)))
        );

        jPanel10.setLayout(new java.awt.GridLayout(7, 0, 0, 3));

        jButton4.setIcon(new javax.swing.ImageIcon(getClass().getResource(&quot;/icons/add_shopping_cart_40px.png&quot;))); // NOI18N
        jPanel10.add(jButton4);

        jButton5.setIcon(new javax.swing.ImageIcon(getClass().getResource(&quot;/icons/up.png&quot;))); // NOI18N
        jPanel10.add(jButton5);

        jButton6.setIcon(new javax.swing.ImageIcon(getClass().getResource(&quot;/icons/minus.png&quot;))); // NOI18N
        jPanel10.add(jButton6);

        jButton7.setIcon(new javax.swing.ImageIcon(getClass().getResource(&quot;/icons/add_user.png&quot;))); // NOI18N
        jPanel10.add(jButton7);

        jButton8.setIcon(new javax.swing.ImageIcon(getClass().getResource(&quot;/icons/delete.png&quot;))); // NOI18N
        jPanel10.add(jButton8);

        jButton9.setIcon(new javax.swing.ImageIcon(getClass().getResource(&quot;/icons/edit_30px.png&quot;))); // NOI18N
        jPanel10.add(jButton9);

        jButton10.setIcon(new javax.swing.ImageIcon(getClass().getResource(&quot;/icons/down.png&quot;))); // NOI18N
        jPanel10.add(jButton10);

        cat_panel.setBorder(javax.swing.BorderFactory.createTitledBorder(null, &quot;Category&quot;, javax.swing.border.TitledBorder.CENTER, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font(&quot;Tahoma&quot;, 0, 11), new java.awt.Color(51, 51, 51))); // NOI18N
        cat_panel.setLayout(new java.awt.GridLayout(0, 1, 3, 5));

        jPanel5.setLayout(new java.awt.GridLayout(1, 2, 2, 0));

        jButton14.setIcon(new javax.swing.ImageIcon(getClass().getResource(&quot;/icons/previous.png&quot;))); // NOI18N
        jButton14.setHorizontalAlignment(javax.swing.SwingConstants.RIGHT);
        jButton14.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton14ActionPerformed(evt);
            }
        });
        jPanel5.add(jButton14);

        jButton15.setIcon(new javax.swing.ImageIcon(getClass().getResource(&quot;/icons/next_32.png&quot;))); // NOI18N
        jButton15.setHorizontalAlignment(javax.swing.SwingConstants.LEFT);
        jButton15.setHorizontalTextPosition(javax.swing.SwingConstants.RIGHT);
        jButton15.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton15ActionPerformed(evt);
            }
        });
        jPanel5.add(jButton15);

        jPanel6.setBorder(javax.swing.BorderFactory.createTitledBorder(null, &quot;Groups&quot;, javax.swing.border.TitledBorder.CENTER, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font(&quot;Tahoma&quot;, 0, 11), new java.awt.Color(51, 51, 51))); // NOI18N
        jPanel6.setLayout(new java.awt.GridLayout(1, 6, 3, 0));

        jButton22.setText(&quot;jButton22&quot;);
        jPanel6.add(jButton22);

        jButton23.setText(&quot;jButton23&quot;);
        jPanel6.add(jButton23);

        jButton24.setText(&quot;jButton23&quot;);
        jPanel6.add(jButton24);

        jButton25.setText(&quot;jButton22&quot;);
        jPanel6.add(jButton25);

        jButton26.setText(&quot;jButton23&quot;);
        jPanel6.add(jButton26);

        jButton27.setText(&quot;jButton22&quot;);
        jPanel6.add(jButton27);

        javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2);
        jPanel2.setLayout(jPanel2Layout);
        jPanel2Layout.setHorizontalGroup(
            jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel2Layout.createSequentialGroup()
                .addComponent(jPanel9, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jPanel10, javax.swing.GroupLayout.PREFERRED_SIZE, 66, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(sch)
                    .addComponent(jPanel6, javax.swing.GroupLayout.DEFAULT_SIZE, 658, Short.MAX_VALUE))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
                    .addComponent(jPanel5, javax.swing.GroupLayout.PREFERRED_SIZE, 124, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(cat_panel, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
                .addGap(2, 2, 2))
        );
        jPanel2Layout.setVerticalGroup(
            jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(jPanel10, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
            .addComponent(jPanel9, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
            .addGroup(jPanel2Layout.createSequentialGroup()
                .addComponent(cat_panel, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jPanel5, javax.swing.GroupLayout.PREFERRED_SIZE, 50, javax.swing.GroupLayout.PREFERRED_SIZE))
            .addGroup(jPanel2Layout.createSequentialGroup()
                .addComponent(jPanel6, javax.swing.GroupLayout.PREFERRED_SIZE, 52, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(0, 0, 0)
                .addComponent(sch))
        );

        jTabbedPane1.addTab(&quot;ADD STOCK&quot;, jPanel2);

        javax.swing.GroupLayout jPanel3Layout = new javax.swing.GroupLayout(jPanel3);
        jPanel3.setLayout(jPanel3Layout);
        jPanel3Layout.setHorizontalGroup(
            jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 1177, Short.MAX_VALUE)
        );
        jPanel3Layout.setVerticalGroup(
            jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 513, Short.MAX_VALUE)
        );

        jTabbedPane1.addTab(&quot;ADD ACCOUNTS&quot;, jPanel3);

        jPanel1.setLayout(new java.awt.GridLayout(1, 6, 4, 0));

        jButton1.setText(&quot;Add New Stocks&quot;);
        jPanel1.add(jButton1);

        jButton2.setText(&quot;Add Category&quot;);
        jPanel1.add(jButton2);

        jButton3.setText(&quot;Modification Stock&quot;);
        jPanel1.add(jButton3);

        jButton11.setText(&quot;Add Groups&quot;);
        jPanel1.add(jButton11);
        jPanel1.add(jButton12);
        jPanel1.add(jButton13);

        javax.swing.GroupLayout layout = new javax.swing.GroupLayout(this);
        this.setLayout(layout);
        layout.setHorizontalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addComponent(jTabbedPane1)
                .addContainerGap())
            .addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, 45, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(1, 1, 1)
                .addComponent(jTabbedPane1))
        );
    }// &lt;/editor-fold&gt;                        

    private void jButton15ActionPerformed(java.awt.event.ActionEvent evt) {                                          
        // TODO add your handling code here:
    }                                         

    private void jButton14ActionPerformed(java.awt.event.ActionEvent evt) {                                          
        // TODO add your handling code here:
    }                                         


    // Variables declaration - do not modify                     
    private javax.swing.JPanel cat_panel;
    private javax.swing.JButton jButton1;
    private javax.swing.JButton jButton10;
    private javax.swing.JButton jButton11;
    private javax.swing.JButton jButton12;
    private javax.swing.JButton jButton13;
    private javax.swing.JButton jButton14;
    private javax.swing.JButton jButton15;
    private javax.swing.JButton jButton2;
    private javax.swing.JButton jButton22;
    private javax.swing.JButton jButton23;
    private javax.swing.JButton jButton24;
    private javax.swing.JButton jButton25;
    private javax.swing.JButton jButton26;
    private javax.swing.JButton jButton27;
    private javax.swing.JButton jButton3;
    private javax.swing.JButton jButton4;
    private javax.swing.JButton jButton5;
    private javax.swing.JButton jButton6;
    private javax.swing.JButton jButton7;
    private javax.swing.JButton jButton8;
    private javax.swing.JButton jButton9;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel2;
    private javax.swing.JLabel jLabel3;
    private javax.swing.JPanel jPanel1;
    private javax.swing.JPanel jPanel10;
    private javax.swing.JPanel jPanel11;
    private javax.swing.JPanel jPanel2;
    private javax.swing.JPanel jPanel3;
    private javax.swing.JPanel jPanel5;
    private javax.swing.JPanel jPanel6;
    private javax.swing.JPanel jPanel9;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JTabbedPane jTabbedPane1;
    private javax.swing.JTable jTable1;
    private javax.swing.JTextField jTextField1;
    private javax.swing.JTextField jTextField2;
    private javax.swing.JTextField jTextField3;
    private javax.swing.JScrollPane sch;
    private org.edisoncor.gui.textField.TextFieldRectBackground textFieldRectBackground1;
    // End of variables declaration                   
}

Next Pagination Button eventAction

private void jButton15ActionPerformed(java.awt.event.ActionEvent evt) {                                          
    // TODO add your handling code here:
}  

Previous Button Pagination event action

  private void jButton14ActionPerformed(java.awt.event.ActionEvent evt) {                                          
        // TODO add your handling code here:
    }   

答案1

得分: 0

Please check the below solution and update it as you required

import com.mysql.jdbc.Connection;
import com.mysql.jdbc.PreparedStatement;
import static java.awt.Component.CENTER_ALIGNMENT;
import java.awt.Dimension;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.DriverManager;
import java.sql.ResultSet;
import javax.swing.AbstractButton;
import javax.swing.ImageIcon;
import javax.swing.JButton;
import javax.swing.JOptionPane;
import javax.swing.JScrollBar;
import javax.swing.SwingConstants;

/**
 *
 * author ultronhouse11
 */
public class mainPanel extends javax.swing.JPanel {

    private JButton btnCategory;
    final int col = 5;
    final int rows = 2;

    private Connection con;
    private int pageIndex = 1;

    public mainPanel() {
        initComponents();
        openConnection();
        loadPage(pageIndex);
    }

    private void openConnection() {
        try {
            Class.forName("com.mysql.jdbc.Driver");
            con = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/shopingmoll", "root", "qwer9900");
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    private void loadPage(int page) {
        this.pageIndex = page;
        try {
            int pageSize = 10;

            String sl = "SELECT * FROM `item_types` LIMIT ? OFFSET ?";
            PreparedStatement pst = (PreparedStatement) con.prepareStatement(sl);
            pst.setInt(1, pageSize);
            pst.setInt(2, pageSize * page);
            ResultSet rs = pst.executeQuery();

            cat_panel.removeAll();

            while (rs.next()) {

                String a1 = rs.getString("name");
                String a2 = rs.getString("id");
                JButton btn = new JButton();

                btn.setText("<html><body> <h3>" + a1 + "</h3><br> <b></body></html> ");
                btn.setVerticalAlignment((int) CENTER_ALIGNMENT);
                btn.applyComponentOrientation(getComponentOrientation());
                btn.setFocusPainted(false);
                btn.setFocusable(false);
                btn.setRequestFocusEnabled(false);
                btn.setMaximumSize(new Dimension(110, 90));
                btn.setPreferredSize(new Dimension(90, 80));
                btn.setMinimumSize(new Dimension(110, 90));

                btn.addActionListener(new ActionListener() {
                    public void actionPerformed(ActionEvent e) {
                        System.out.println(a1 + ":" + a2);
                    }
                });

                ImageIcon img = new ImageIcon("src/posresturent/cat.jpg");
                btn.setHorizontalAlignment(SwingConstants.CENTER);
                btn.setHorizontalTextPosition(AbstractButton.CENTER);
                btn.setVerticalTextPosition(AbstractButton.BOTTOM);
                cat_panel.add(btn, "center");

                cat_panel.repaint();
                cat_panel.revalidate();
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    @SuppressWarnings("unchecked")
    private void initComponents() {
        // Generated Code for UI components
    }

    private void jButton15ActionPerformed(java.awt.event.ActionEvent evt) {
        loadPage(pageIndex + 1);
    }

    private void jButton14ActionPerformed(java.awt.event.ActionEvent evt) {
        loadPage(pageIndex - 1);
    }
}

Please let me know if you need any further assistance!

英文翻译

Please check the bellow solution and update it as you required

import com.mysql.jdbc.Connection;
import com.mysql.jdbc.PreparedStatement;
import static java.awt.Component.CENTER_ALIGNMENT;
import java.awt.Dimension;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.DriverManager;
import java.sql.ResultSet;
import javax.swing.AbstractButton;
import javax.swing.ImageIcon;
import javax.swing.JButton;
import javax.swing.JOptionPane;
import javax.swing.JScrollBar;
import javax.swing.SwingConstants;

/**
 *
 * @author ultronhouse11
 */
public class mainPanel extends javax.swing.JPanel {

    /**
     * Creates new form mainPanel
     */
    private JButton btnCategory;
    final int col = 5;
    final int rows = 2;

    private Connection con;
    private int pageIndex = 1;

    public mainPanel() {
        initComponents();
        // open mysql connectivity 
        openConnection();
        // load first page initialy
        loadPage(pageIndex);
    }

    private void openConnection(){
        try{
            Class.forName(&quot;com.mysql.jdbc.Driver&quot;);
            con = (Connection) DriverManager.getConnection(&quot;jdbc:mysql://localhost:3306/shopingmoll&quot;, &quot;root&quot;, &quot;qwer9900&quot;);
        } catch(Exception e){
            e.printStackTrace();
        }
    }

    private void loadPage(int page) {
        this.pageIndex = page;
        try {
            // Customize page size here
            int pageSize = 10;
          
            String sl = &quot;SELECT * FROM `item_types` LIMIT ? OFFSET ?&quot;;
            PreparedStatement pst = (PreparedStatement) con.prepareStatement(sl);
            pst.setInt(0, pageSize);
            pst.setInt(1, pageSize * page);
            ResultSet rs = pst.executeQuery();
            
            // remove all child elements 
            cat_panel.removeAll();
            
             while (rs.next()) {

                String a1 = rs.getString(&quot;name&quot;);
                String a2 = rs.getString(&quot;id&quot;);
                JButton btn = new JButton();


                btn.setText(&quot;&lt;html&gt;&lt;body&gt; &lt;h3&gt;&quot; + a1 + &quot;&lt;/h3&gt;&lt;br&gt; &lt;b&gt;&lt;/body&gt;&lt;/html&gt; &quot;);
                btn.setVerticalAlignment((int) CENTER_ALIGNMENT);
                btn.applyComponentOrientation(getComponentOrientation());
                btn.setFocusPainted(false);
                btn.setFocusable(false);
                btn.setRequestFocusEnabled(false);
                btn.setMaximumSize(new Dimension(110, 90));
                btn.setPreferredSize(new Dimension(90, 80));
                btn.setMinimumSize(new Dimension(110, 90));

                btn.addActionListener(new ActionListener() {
                    public void actionPerformed(ActionEvent e) {
                        System.out.println(a1+&quot;:&quot;+a2);
                    }
                });

                //String a2 = rs.getString(2);
                ImageIcon img = new ImageIcon(&quot;src/posresturent/cat.jpg&quot;);
                // btn.setIcon(img);

                btn.setHorizontalAlignment(SwingConstants.CENTER);
                btn.setHorizontalTextPosition(AbstractButton.CENTER);
                btn.setVerticalTextPosition(AbstractButton.BOTTOM);
                cat_panel.add(btn,&quot;center&quot;);

                cat_panel.repaint();
                cat_panel.revalidate();
             }
        } catch (Exception e) {
            e.printStackTrace();
        }

    }



    /**
     * This method is called from within the constructor to initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is always
     * regenerated by the Form Editor.
     */
    @SuppressWarnings(&quot;unchecked&quot;)
    // &lt;editor-fold defaultstate=&quot;collapsed&quot; desc=&quot;Generated Code&quot;&gt;                          
    private void initComponents() {

        jTabbedPane1 = new javax.swing.JTabbedPane();
        jPanel2 = new javax.swing.JPanel();
        sch = new javax.swing.JScrollPane();
        jPanel9 = new javax.swing.JPanel();
        jPanel11 = new javax.swing.JPanel();
        textFieldRectBackground1 = new org.edisoncor.gui.textField.TextFieldRectBackground();
        jScrollPane1 = new javax.swing.JScrollPane();
        jTable1 = new javax.swing.JTable();
        jLabel1 = new javax.swing.JLabel();
        jLabel2 = new javax.swing.JLabel();
        jTextField1 = new javax.swing.JTextField();
        jTextField2 = new javax.swing.JTextField();
        jTextField3 = new javax.swing.JTextField();
        jLabel3 = new javax.swing.JLabel();
        jPanel10 = new javax.swing.JPanel();
        jButton4 = new javax.swing.JButton();
        jButton5 = new javax.swing.JButton();
        jButton6 = new javax.swing.JButton();
        jButton7 = new javax.swing.JButton();
        jButton8 = new javax.swing.JButton();
        jButton9 = new javax.swing.JButton();
        jButton10 = new javax.swing.JButton();
        cat_panel = new javax.swing.JPanel();
        jPanel5 = new javax.swing.JPanel();
        jButton14 = new javax.swing.JButton();
        jButton15 = new javax.swing.JButton();
        jPanel6 = new javax.swing.JPanel();
        jButton22 = new javax.swing.JButton();
        jButton23 = new javax.swing.JButton();
        jButton24 = new javax.swing.JButton();
        jButton25 = new javax.swing.JButton();
        jButton26 = new javax.swing.JButton();
        jButton27 = new javax.swing.JButton();
        jPanel3 = new javax.swing.JPanel();
        jPanel1 = new javax.swing.JPanel();
        jButton1 = new javax.swing.JButton();
        jButton2 = new javax.swing.JButton();
        jButton3 = new javax.swing.JButton();
        jButton11 = new javax.swing.JButton();
        jButton12 = new javax.swing.JButton();
        jButton13 = new javax.swing.JButton();

        sch.setBorder(javax.swing.BorderFactory.createTitledBorder(null, &quot;Items&quot;, javax.swing.border.TitledBorder.CENTER, javax.swing.border.TitledBorder.DEFAULT_POSITION));

        jPanel11.setLayout(new java.awt.GridLayout(1, 0));

        textFieldRectBackground1.setDescripcion(&quot;Enter Barcode ...&quot;);
        textFieldRectBackground1.setFocusCycleRoot(true);
        jPanel11.add(textFieldRectBackground1);

        jTable1.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null}
            },
            new String [] {
                &quot;#SrNo&quot;, &quot;Product&quot;, &quot;Unit&quot;, &quot;Rate&quot;
            }
        ));
        jTable1.setRowHeight(35);
        jScrollPane1.setViewportView(jTable1);

        jLabel1.setFont(new java.awt.Font(&quot;Arial&quot;, 0, 14)); // NOI18N
        jLabel1.setText(&quot;Total &quot;);

        jLabel2.setFont(new java.awt.Font(&quot;Arial&quot;, 0, 14)); // NOI18N
        jLabel2.setText(&quot;Tax&quot;);

        jTextField1.setFont(new java.awt.Font(&quot;Arial&quot;, 1, 18)); // NOI18N
        jTextField1.setHorizontalAlignment(javax.swing.JTextField.RIGHT);
        jTextField1.setText(&quot;0.00&quot;);

        jTextField2.setFont(new java.awt.Font(&quot;Arial&quot;, 1, 18)); // NOI18N
        jTextField2.setHorizontalAlignment(javax.swing.JTextField.RIGHT);
        jTextField2.setText(&quot;0.00&quot;);

        jTextField3.setFont(new java.awt.Font(&quot;Arial Black&quot;, 1, 45)); // NOI18N
        jTextField3.setForeground(new java.awt.Color(51, 51, 51));
        jTextField3.setHorizontalAlignment(javax.swing.JTextField.CENTER);
        jTextField3.setText(&quot; Rs  0.00&quot;);

        jLabel3.setFont(new java.awt.Font(&quot;Arial&quot;, 0, 14)); // NOI18N
        jLabel3.setText(&quot;&lt;html&gt; Grand &lt;br&gt;&lt;br&gt; Total&quot;);

        javax.swing.GroupLayout jPanel9Layout = new javax.swing.GroupLayout(jPanel9);
        jPanel9.setLayout(jPanel9Layout);
        jPanel9Layout.setHorizontalGroup(
            jPanel9Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(jPanel11, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
            .addGroup(jPanel9Layout.createSequentialGroup()
                .addGroup(jPanel9Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jLabel2)
                    .addComponent(jLabel1)
                    .addComponent(jLabel3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addGap(35, 35, 35)
                .addGroup(jPanel9Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
                    .addComponent(jTextField3, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, 230, Short.MAX_VALUE)
                    .addComponent(jTextField1, javax.swing.GroupLayout.Alignment.TRAILING)
                    .addComponent(jTextField2, javax.swing.GroupLayout.Alignment.TRAILING))
                .addGap(0, 0, Short.MAX_VALUE))
            .addComponent(jScrollPane1, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 309, javax.swing.GroupLayout.PREFERRED_SIZE)
        );
        jPanel9Layout.setVerticalGroup(
            jPanel9Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel9Layout.createSequentialGroup()
                .addComponent(jPanel11, javax.swing.GroupLayout.PREFERRED_SIZE, 33, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(1, 1, 1)
                .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 0, Short.MAX_VALUE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(jPanel9Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel9Layout.createSequentialGroup()
                        .addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(jTextField2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addGap(7, 7, 7))
                    .addGroup(jPanel9Layout.createSequentialGroup()
                        .addComponent(jLabel1)
                        .addGap(18, 18, 18)
                        .addComponent(jLabel2)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)))
                .addGroup(jPanel9Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jLabel3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jTextField3, javax.swing.GroupLayout.PREFERRED_SIZE, 69, javax.swing.GroupLayout.PREFERRED_SIZE)))
        );

        jPanel10.setLayout(new java.awt.GridLayout(7, 0, 0, 3));

        jButton4.setIcon(new javax.swing.ImageIcon(getClass().getResource(&quot;/icons/add_shopping_cart_40px.png&quot;))); // NOI18N
        jPanel10.add(jButton4);

        jButton5.setIcon(new javax.swing.ImageIcon(getClass().getResource(&quot;/icons/up.png&quot;))); // NOI18N
        jPanel10.add(jButton5);

        jButton6.setIcon(new javax.swing.ImageIcon(getClass().getResource(&quot;/icons/minus.png&quot;))); // NOI18N
        jPanel10.add(jButton6);

        jButton7.setIcon(new javax.swing.ImageIcon(getClass().getResource(&quot;/icons/add_user.png&quot;))); // NOI18N
        jPanel10.add(jButton7);

        jButton8.setIcon(new javax.swing.ImageIcon(getClass().getResource(&quot;/icons/delete.png&quot;))); // NOI18N
        jPanel10.add(jButton8);

        jButton9.setIcon(new javax.swing.ImageIcon(getClass().getResource(&quot;/icons/edit_30px.png&quot;))); // NOI18N
        jPanel10.add(jButton9);

        jButton10.setIcon(new javax.swing.ImageIcon(getClass().getResource(&quot;/icons/down.png&quot;))); // NOI18N
        jPanel10.add(jButton10);

        cat_panel.setBorder(javax.swing.BorderFactory.createTitledBorder(null, &quot;Category&quot;, javax.swing.border.TitledBorder.CENTER, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font(&quot;Tahoma&quot;, 0, 11), new java.awt.Color(51, 51, 51))); // NOI18N
        cat_panel.setLayout(new java.awt.GridLayout(0, 1, 3, 5));

        jPanel5.setLayout(new java.awt.GridLayout(1, 2, 2, 0));

        jButton14.setIcon(new javax.swing.ImageIcon(getClass().getResource(&quot;/icons/previous.png&quot;))); // NOI18N
        jButton14.setHorizontalAlignment(javax.swing.SwingConstants.RIGHT);
        jButton14.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton14ActionPerformed(evt);
            }
        });
        jPanel5.add(jButton14);

        jButton15.setIcon(new javax.swing.ImageIcon(getClass().getResource(&quot;/icons/next_32.png&quot;))); // NOI18N
        jButton15.setHorizontalAlignment(javax.swing.SwingConstants.LEFT);
        jButton15.setHorizontalTextPosition(javax.swing.SwingConstants.RIGHT);
        jButton15.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton15ActionPerformed(evt);
            }
        });
        jPanel5.add(jButton15);

        jPanel6.setBorder(javax.swing.BorderFactory.createTitledBorder(null, &quot;Groups&quot;, javax.swing.border.TitledBorder.CENTER, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font(&quot;Tahoma&quot;, 0, 11), new java.awt.Color(51, 51, 51))); // NOI18N
        jPanel6.setLayout(new java.awt.GridLayout(1, 6, 3, 0));

        jButton22.setText(&quot;jButton22&quot;);
        jPanel6.add(jButton22);

        jButton23.setText(&quot;jButton23&quot;);
        jPanel6.add(jButton23);

        jButton24.setText(&quot;jButton23&quot;);
        jPanel6.add(jButton24);

        jButton25.setText(&quot;jButton22&quot;);
        jPanel6.add(jButton25);

        jButton26.setText(&quot;jButton23&quot;);
        jPanel6.add(jButton26);

        jButton27.setText(&quot;jButton22&quot;);
        jPanel6.add(jButton27);

        javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2);
        jPanel2.setLayout(jPanel2Layout);
        jPanel2Layout.setHorizontalGroup(
            jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel2Layout.createSequentialGroup()
                .addComponent(jPanel9, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jPanel10, javax.swing.GroupLayout.PREFERRED_SIZE, 66, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(sch)
                    .addComponent(jPanel6, javax.swing.GroupLayout.DEFAULT_SIZE, 658, Short.MAX_VALUE))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
                    .addComponent(jPanel5, javax.swing.GroupLayout.PREFERRED_SIZE, 124, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(cat_panel, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
                .addGap(2, 2, 2))
        );
        jPanel2Layout.setVerticalGroup(
            jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(jPanel10, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
            .addComponent(jPanel9, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
            .addGroup(jPanel2Layout.createSequentialGroup()
                .addComponent(cat_panel, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jPanel5, javax.swing.GroupLayout.PREFERRED_SIZE, 50, javax.swing.GroupLayout.PREFERRED_SIZE))
            .addGroup(jPanel2Layout.createSequentialGroup()
                .addComponent(jPanel6, javax.swing.GroupLayout.PREFERRED_SIZE, 52, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(0, 0, 0)
                .addComponent(sch))
        );

        jTabbedPane1.addTab(&quot;ADD STOCK&quot;, jPanel2);

        javax.swing.GroupLayout jPanel3Layout = new javax.swing.GroupLayout(jPanel3);
        jPanel3.setLayout(jPanel3Layout);
        jPanel3Layout.setHorizontalGroup(
            jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 1177, Short.MAX_VALUE)
        );
        jPanel3Layout.setVerticalGroup(
            jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 513, Short.MAX_VALUE)
        );

        jTabbedPane1.addTab(&quot;ADD ACCOUNTS&quot;, jPanel3);

        jPanel1.setLayout(new java.awt.GridLayout(1, 6, 4, 0));

        jButton1.setText(&quot;Add New Stocks&quot;);
        jPanel1.add(jButton1);

        jButton2.setText(&quot;Add Category&quot;);
        jPanel1.add(jButton2);

        jButton3.setText(&quot;Modification Stock&quot;);
        jPanel1.add(jButton3);

        jButton11.setText(&quot;Add Groups&quot;);
        jPanel1.add(jButton11);
        jPanel1.add(jButton12);
        jPanel1.add(jButton13);

        javax.swing.GroupLayout layout = new javax.swing.GroupLayout(this);
        this.setLayout(layout);
        layout.setHorizontalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addComponent(jTabbedPane1)
                .addContainerGap())
            .addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, 45, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(1, 1, 1)
                .addComponent(jTabbedPane1))
        );
    }// &lt;/editor-fold&gt;                        

    private void jButton15ActionPerformed(java.awt.event.ActionEvent evt) {                                          
        // next button
        loadPage(pageIndex+1);
    }                                         

    private void jButton14ActionPerformed(java.awt.event.ActionEvent evt) {                                          
        // previous button
        loadPage(pageIndex-1);
    }                                         


    // Variables declaration - do not modify                     
    private javax.swing.JPanel cat_panel;
    private javax.swing.JButton jButton1;
    private javax.swing.JButton jButton10;
    private javax.swing.JButton jButton11;
    private javax.swing.JButton jButton12;
    private javax.swing.JButton jButton13;
    private javax.swing.JButton jButton14;
    private javax.swing.JButton jButton15;
    private javax.swing.JButton jButton2;
    private javax.swing.JButton jButton22;
    private javax.swing.JButton jButton23;
    private javax.swing.JButton jButton24;
    private javax.swing.JButton jButton25;
    private javax.swing.JButton jButton26;
    private javax.swing.JButton jButton27;
    private javax.swing.JButton jButton3;
    private javax.swing.JButton jButton4;
    private javax.swing.JButton jButton5;
    private javax.swing.JButton jButton6;
    private javax.swing.JButton jButton7;
    private javax.swing.JButton jButton8;
    private javax.swing.JButton jButton9;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel2;
    private javax.swing.JLabel jLabel3;
    private javax.swing.JPanel jPanel1;
    private javax.swing.JPanel jPanel10;
    private javax.swing.JPanel jPanel11;
    private javax.swing.JPanel jPanel2;
    private javax.swing.JPanel jPanel3;
    private javax.swing.JPanel jPanel5;
    private javax.swing.JPanel jPanel6;
    private javax.swing.JPanel jPanel9;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JTabbedPane jTabbedPane1;
    private javax.swing.JTable jTable1;
    private javax.swing.JTextField jTextField1;
    private javax.swing.JTextField jTextField2;
    private javax.swing.JTextField jTextField3;
    private javax.swing.JScrollPane sch;
    private org.edisoncor.gui.textField.TextFieldRectBackground textFieldRectBackground1;
    // End of variables declaration                   
}

> Previous Button Event Code when press button console error

  loadPage(pageIndex + 1);
        System.out.println(String.valueOf(pageIndex - 1));

>
Previous Button after press console error.

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near &#39;-4&#39; at line 1
0
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	at 
	at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2348)
	at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
	at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
	at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
	at java.awt.Component.processMouseEvent(Component.java:6539)
	at javax.swing.JComponent.processMouseEvent(JComponent.java:3324)
	at java.awt.Component.processEvent(Component.java:6304)
	at java.awt.Container.processEvent(Container.java:2239)
	at java.awt.Component.dispatchEventImpl(Component.java:4889)
	at java.awt.Container.dispatchEventImpl(Container.java:2297)
	at java.awt.Component.dispatchEvent(Component.java:4711)
	at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4904)
	at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4535)
	at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4476)
	at java.awt.Container.dispatchEventImpl(Container.java:2283)
	at java.awt.Window.dispatchEventImpl(Window.java:2746)
	at java.awt.Component.dispatchEvent(Component.java:4711)
	at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:760)
	at java.awt.EventQueue.access$500(EventQueue.java:97)
	at java.awt.EventQueue$3.run(EventQueue.java:709)
	at java.awt.EventQueue$3.run(EventQueue.java:703)
	at java.security.AccessController.doPrivileged(Native Method)
	at 

huangapple
  • 本文由 发表于 2020年3月16日 15:10:20
  • 转载请务必保留本文链接:https://java.coder-hub.com/60701664.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定