zsh_root
2024-01-02 046905340273e5996ba0d4fce2df52b236d960e3
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
package Method;
import java.awt.Color;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.Box;
import javax.swing.JPanel;
 
import ColorAndFont.buttonTitle;
import PbuliClass.JButtonModel;
import PbuliClass.JlableModel;
 
/**±¾ÀàÓÃÓÚÑ¡ÔñÒ³Âë*/
public class PageSelect {
    JPanel mb=null;
    JButtonModel firstPageButton=null;
    JButtonModel latePageButton=null;
    JButtonModel nextPageButton=null;
    JButtonModel lastPageButton=null;
    String a;
    String serch;
    int k;
    int maxPageNumber;
    static int currentPageNumber = 1;//µ±Ç°Ò³Ãæ
    int allrows;//Êý¾Ý×ÜÌõÊý
    JPanel south=null;
    JlableModel nowpage;//µ±Ç°Ò³Âë
    String hang;//ÿҳÏÔʾµÄÐÐÊý
    String data_name;//Êý¾Ý¿âµÄÃû³Æ
    
    public String getHang() {
        return hang;
    }
    public String getSerch() {
        return serch;
    }
 
    public void setHang(String hang) {
        this.hang = hang;
    }
 
    public String getData_name() {
        return data_name;
    }
 
    public void setData_name(String data_name) {
        this.data_name = data_name;
    }
 
 
    public int getAllrows() {
        return allrows;
    }
 
    public void setAllrows(int allrows) {
        this.allrows = allrows;
    }
 
    public JPanel get_page_mb() {
            mb=new JPanel();
            mb.setBackground(Color.WHITE);//ÉèÖÃÃæ°å±³¾°Îª°×É«
            Box topicBox = Box.createHorizontalBox();// ´´½¨Ò»¸öˮƽÏäÈÝÆ÷
            topicBox.add(getFirstPageButton());
            topicBox.add(Box.createHorizontalStrut(15));// Ìí¼ÓÒ»¸ö3ÏñËØ¿íµÄˮƽ֧Öù
            topicBox.add(getLatePageButton());
            topicBox.add(Box.createHorizontalStrut(15));// Ìí¼ÓÒ»¸ö5ÏñËØ¿íµÄˮƽ֧Öù
            topicBox.add(getNextPageButton());
            topicBox.add(Box.createHorizontalStrut(15));// Ìí¼ÓÒ»¸ö5ÏñËØ¿íµÄˮƽ֧Öù            
            topicBox.add(getLastPageButton());
            nowpage= new JlableModel("µÚ"+currentPageNumber+"Ò³"); 
            topicBox.add(Box.createHorizontalStrut(25));// Ìí¼ÓÒ»¸ö15ÏñËØ¿íµÄˮƽ֧Öù            
            topicBox.add(nowpage);
            mb.add(topicBox );
        return mb;
    }
    
    public JButtonModel getFirstPageButton() {
        if(firstPageButton==null) {
            firstPageButton=new JButtonModel(buttonTitle.getHome());
            firstPageButton.setEnabled(false);
            firstPageButton.addActionListener(new ActionListener() {
                public void actionPerformed(ActionEvent e) {
                    currentPageNumber=1;
                    nowpage.setText("µÚ"+currentPageNumber+"Ò³");
                    lastPageButton.setEnabled(true);
                    nextPageButton.setEnabled(true);
                    k=Integer.parseInt(getHang());
                    serch="select * from "+getData_name() +" limit 0,"+k;
                    currentPageNumber = 1;
                    firstPageButton.setEnabled(false);
                    latePageButton.setEnabled(false);    
                }
            });
        }
        return firstPageButton;
    }
 
    public JButtonModel getLatePageButton() {
        if(latePageButton==null) {
            latePageButton=new JButtonModel(buttonTitle.getPrevious());            
            latePageButton.addActionListener(new ActionListener() {
                public void actionPerformed(ActionEvent e) {                    
                    lastPageButton.setEnabled(true);
                    latePageButton.setEnabled(true);
                    --currentPageNumber;
                    nowpage.setText("µÚ"+currentPageNumber+"Ò³");
                    if(currentPageNumber==1) {
                        latePageButton.setEnabled(false);
                        firstPageButton.setEnabled(false);
                    }
                    if(currentPageNumber>=1) {
                        k=Integer.parseInt(getHang());
                        a=String.valueOf(currentPageNumber*k-k);
                        serch="select * from "+getData_name() +" limit "+a+","+k;
                        nextPageButton.setEnabled(true);
                    }
                }
            });
        }
        return latePageButton;
    }
 
    public JButtonModel getNextPageButton() {
        if(nextPageButton==null) {
            nextPageButton=new JButtonModel(buttonTitle.getNext());
            nextPageButton.addActionListener(new ActionListener() {
                public void actionPerformed(ActionEvent e) {
                    ++currentPageNumber;
                    nowpage.setText("µÚ"+currentPageNumber+"Ò³");
                    k=Integer.parseInt(getHang());
                    a=String.valueOf(currentPageNumber*k-k);
                    serch="select * from  "+getData_name() +"  limit "+a+","+k;
                    if(currentPageNumber!=1) {
                        firstPageButton.setEnabled(true);
                        latePageButton.setEnabled(true);
                    }
                    if (currentPageNumber == maxPageNumber) {
                        nextPageButton.setEnabled(false);
                        lastPageButton.setEnabled(false);
                    }
 
 
                }
            });
        }
        return nextPageButton;
    }
 
    public JButtonModel getLastPageButton() {
        if(lastPageButton==null) {
            lastPageButton=new JButtonModel(buttonTitle.getLast());
            lastPageButton.addActionListener(new ActionListener() {
                public void actionPerformed(ActionEvent e) {
                    nextPageButton.setEnabled(false);
                    lastPageButton.setEnabled(false);
                    k=Integer.parseInt(getHang()); 
                    a=String.valueOf(getMaxPageNumber()*k-k);
                    serch="select * from  "+getData_name() +"  limit "+a+","+k;
                    latePageButton.setEnabled(true);
                    firstPageButton.setEnabled(true);
                    currentPageNumber=getMaxPageNumber();
                    nowpage.setText("µÚ"+currentPageNumber+"Ò³");
 
                }
            });
 
        }
        return lastPageButton;
    }
 
    public int getMaxPageNumber() {
        double k=Integer.parseInt(getHang());
        double j=getAllrows()/k;
        return maxPageNumber=(int) Math.ceil(j);
        //Math.ceil() º¯Êý·µ»Ø´óÓÚ»òµÈÓÚÒ»¸ö¸ø¶¨Êý×ÖµÄ×îСÕûÊý
    }
    
 
}