📄 bookframe.java
字号:
jDesktopPane.add(getJRadioButton1(), null);
jDesktopPane.add(jLabel2, null);
jDesktopPane.add(jLabel3, null);
jDesktopPane.add(getJButton4(), null);
jDesktopPane.add(getJButton9(), null);
jDesktopPane.add(getJTextField(), null);
jDesktopPane.add(getJButton10(), null);
buttonGroup = new ButtonGroup();
buttonGroup.add(jRadioButton);
buttonGroup.add(jRadioButton1);
}
return jDesktopPane;
}
/**
* This method initializes jDesktopPane1
*
* @return javax.swing.JDesktopPane
*/
private JDesktopPane getJDesktopPane1() {
if (jDesktopPane1 == null) {
jDesktopPane1 = new JDesktopPane();
jDesktopPane1.setBounds(new Rectangle(1, 329, 151, 327));
jDesktopPane1.add(getJButton5(), null);
jDesktopPane1.add(getJButton6(), null);
jDesktopPane1.add(getJButton7(), null);
jDesktopPane1.add(getJButton8(), null);
}
return jDesktopPane1;
}
/**
* This method initializes jDesktopPane2
*
* @return javax.swing.JDesktopPane
*/
private JDesktopPane getJDesktopPane2() {
if (jDesktopPane2 == null) {
jLabel16 = new JLabel();
jLabel16.setBounds(new Rectangle(417, 454, 149, 36));
jLabel16.setText("");
jLabel16.addMouseListener(new java.awt.event.MouseAdapter() {
public void mouseClicked(java.awt.event.MouseEvent e) {
if(jLabel16.getText()==null) return;
BookDataDialog bookDataDialog = new BookDataDialog(null,connection,loadId,idList[5]);
bookDataDialog.show();
//System.out.println("mouseClicked()"); // TODO Auto-generated Event stub mouseClicked()
}
public void mouseExited(java.awt.event.MouseEvent e) {
jLabel16.setForeground(Color.black);
//System.out.println("mouseExited()"); // TODO Auto-generated Event stub mouseExited()
}
public void mouseEntered(java.awt.event.MouseEvent e) {
jLabel16.setForeground(Color.red);
//System.out.println("mouseEntered()"); // TODO Auto-generated Event stub mouseEntered()
}
});
jLabel15 = new JLabel();
jLabel15.setBounds(new Rectangle(224, 454, 158, 37));
jLabel15.setText("");
jLabel15.addMouseListener(new java.awt.event.MouseAdapter() {
public void mouseClicked(java.awt.event.MouseEvent e) {
if(jLabel15.getText()==null) return;
BookDataDialog bookDataDialog = new BookDataDialog(null,connection,loadId,idList[4]);
bookDataDialog.show();
//System.out.println("mouseClicked()"); // TODO Auto-generated Event stub mouseClicked()
}
public void mouseExited(java.awt.event.MouseEvent e) {
jLabel15.setForeground(Color.black);
//System.out.println("mouseExited()"); // TODO Auto-generated Event stub mouseExited()
}
public void mouseEntered(java.awt.event.MouseEvent e) {
jLabel15.setForeground(Color.red);
//System.out.println("mouseEntered()"); // TODO Auto-generated Event stub mouseEntered()
}
});
jLabel14 = new JLabel();
jLabel14.setBounds(new Rectangle(27, 454, 154, 37));
jLabel14.setText("");
jLabel14.addMouseListener(new java.awt.event.MouseAdapter() {
public void mouseClicked(java.awt.event.MouseEvent e) {
if(jLabel14.getText()==null) return;
BookDataDialog bookDataDialog = new BookDataDialog(null,connection,loadId,idList[3]);
bookDataDialog.show();
//System.out.println("mouseClicked()"); // TODO Auto-generated Event stub mouseClicked()
}
public void mouseExited(java.awt.event.MouseEvent e) {
jLabel14.setForeground(Color.black);
//System.out.println("mouseExited()"); // TODO Auto-generated Event stub mouseExited()
}
public void mouseEntered(java.awt.event.MouseEvent e) {
jLabel14.setForeground(Color.red);
//System.out.println("mouseEntered()"); // TODO Auto-generated Event stub mouseEntered()
}
});
jLabel9 = new JLabel();
jLabel9.setBounds(new Rectangle(418, 207, 153, 37));
jLabel9.setText("");
jLabel9.addMouseListener(new java.awt.event.MouseAdapter() {
public void mouseClicked(java.awt.event.MouseEvent e) {
if(jLabel9.getText()==null) return;
BookDataDialog bookDataDialog = new BookDataDialog(null,connection,loadId,idList[2]);
bookDataDialog.show();
//System.out.println("mouseClicked()"); // TODO Auto-generated Event stub mouseClicked()
}
public void mouseExited(java.awt.event.MouseEvent e) {
jLabel9.setForeground(Color.black);
//System.out.println("mouseExited()"); // TODO Auto-generated Event stub mouseExited()
}
public void mouseEntered(java.awt.event.MouseEvent e) {
jLabel9.setForeground(Color.red);
//System.out.println("mouseEntered()"); // TODO Auto-generated Event stub mouseEntered()
}
});
jLabel8 = new JLabel();
jLabel8.setBounds(new Rectangle(224, 209, 154, 35));
jLabel8.setText("");
jLabel8.addMouseListener(new java.awt.event.MouseAdapter() {
public void mouseClicked(java.awt.event.MouseEvent e) {
if(jLabel8.getText()==null) return;
BookDataDialog bookDataDialog = new BookDataDialog(null,connection,loadId,idList[1]);
bookDataDialog.show();
//System.out.println("mouseClicked()"); // TODO Auto-generated Event stub mouseClicked()
}
public void mouseExited(java.awt.event.MouseEvent e) {
jLabel8.setForeground(Color.black);
//System.out.println("mouseExited()"); // TODO Auto-generated Event stub mouseExited()
}
public void mouseEntered(java.awt.event.MouseEvent e) {
jLabel8.setForeground(Color.red);
//System.out.println("mouseEntered()"); // TODO Auto-generated Event stub mouseEntered()
}
});
jLabel7 = new JLabel();
jLabel7.setBounds(new Rectangle(28, 207, 155, 37));
jLabel7.setText("");
jLabel7.addMouseListener(new java.awt.event.MouseAdapter() {
public void mouseClicked(java.awt.event.MouseEvent e) {
if(jLabel7.getText()==null) return;
BookDataDialog bookDataDialog = new BookDataDialog(null,connection,loadId,idList[0]);
bookDataDialog.show();
//System.out.println("mouseClicked()"); // TODO Auto-generated Event stub mouseClicked()
}
public void mouseExited(java.awt.event.MouseEvent e) {
jLabel7.setForeground(Color.black);
//System.out.println("mouseExited()"); // TODO Auto-generated Event stub mouseExited()
}
public void mouseEntered(java.awt.event.MouseEvent e) {
jLabel7.setForeground(Color.red);
//System.out.println("mouseEntered()"); // TODO Auto-generated Event stub mouseEntered()
}
});
jDesktopPane2 = new JDesktopPane();
jDesktopPane2.setLayout(null);
jDesktopPane2.setBounds(new Rectangle(174, 124, 610, 535));
jDesktopPane2.add(jLabel7, null);
jDesktopPane2.add(jLabel8, null);
jDesktopPane2.add(jLabel9, null);
jDesktopPane2.add(getJButton(), null);
jDesktopPane2.add(getJButton1(), null);
jDesktopPane2.add(jLabel14, null);
jDesktopPane2.add(jLabel15, null);
jDesktopPane2.add(jLabel16, null);
jDesktopPane2.add(getJScrollPane(), null);
jDesktopPane2.add(getJScrollPane1(), null);
jDesktopPane2.add(getJScrollPane2(), null);
jDesktopPane2.add(getJScrollPane3(), null);
jDesktopPane2.add(getJScrollPane4(), null);
jDesktopPane2.add(getJScrollPane5(), null);
}
return jDesktopPane2;
}
/**
* This method initializes jButton
*
* @return javax.swing.JButton
*/
private JButton getJButton() {
if (jButton == null) {
jButton = new JButton();
jButton.setBounds(new Rectangle(293, 501, 75, 18));
jButton.setText("下一页");
jButton.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
try{
if(resultSet.isLast()||resultSet.isAfterLast()) return;
}catch(Exception sqlE){
sqlE.printStackTrace();
}
try{
//jComboBox1.setSelectedIndex(jComboBox1.getSelectedIndex()+1);
for(int i=0;i<6;i++){
if(resultSet.next()){
String id = resultSet.getString("id");
String name = resultSet.getString("name");
String text = "<html>"
+"编号:"+id
+"<br>"
+"书名:"+name
+"</html>";
jLabelTextCollect[i].setText(text);
jLabelCollect[i].setIcon(new ImageIcon(resultSet.getBytes("cover")));
idList[i] = id;
}else{
jLabelTextCollect[i].setText(null);
jLabelCollect[i].setIcon(null);
resultSet.previous();
idList[i] = null;
}
}
}catch(Exception sqlE){
sqlE.printStackTrace();
}
//System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
}
});
}
return jButton;
}
/**
* This method initializes jButton1
*
* @return javax.swing.JButton
*/
private JButton getJButton1() {
if (jButton1 == null) {
jButton1 = new JButton();
jButton1.setBounds(new Rectangle(193, 501, 75, 18));
jButton1.setText("上一页");
jButton1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
try{
if(resultSet.isBeforeFirst()) return;
int curRow = resultSet.getRow();
//int m = curRow - curRow % 6;
//System.out.println(curRow);
for(int i=0;i<curRow % 6 + 12;i++){
resultSet.previous();
}
for(int i=0;i<6;i++){
if(resultSet.next()){
String id = resultSet.getString("id");
String name = resultSet.getString("name");
String text = "<html>"
+"编号:"+id
+"<br>"
+"书名:"+name
+"</html>";
jLabelTextCollect[i].setText(text);
jLabelCollect[i].setIcon(new ImageIcon(resultSet.getBytes("cover")));
idList[i] = id;
}
}
}catch(Exception sqlE){
sqlE.printStackTrace();
}
//System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
}
});
}
return jButton1;
}
/**
* This method initializes jButton4
*
* @return javax.swing.JButton
*/
private JButton getJButton4() {
if (jButton4 == null) {
jButton4 = new JButton();
jButton4.setBounds(new Rectangle(322, 7, 118, 24));
jButton4.setText("图书浏览");
jButton4.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
try{
String query = "select * from Book";
resultSet = statement.executeQuery(query);
resultSet.last();
int count = resultSet.getRow();
resultSet.first();
resultSet.previous();
for(int i=0;i<6;i++){
if(resultSet.next()){
String id = resultSet.getString("id");
String name = resultSet.getString("name");
String text = "<html>"
+"编号:"+id
+"<br>"
+"书名:"+name
+"</html>";
jLabelTextCollect[i].setText(text);
jLabelCollect[i].setIcon(new ImageIcon(resultSet.getBytes("cover")));
idList[i] = id;
}else{
jLabelTextCollect[i].setText(null);
jLabelCollect[i].setIcon(null);
}
}
}catch(Exception sqlE){
sqlE.printStackTrace();
}
//System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
}
});
}
return jButton4;
}
/**
* This method initializes jButton5
*
* @return javax.swing.JButton
*/
private JButton getJButton5() {
if (jButton5 == null) {
jButton5 = new JButton();
jButton5.setBounds(new Rectangle(16, 65, 120, 30));
jButton5.setText("修改个人密码");
jButton5.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
String oldPassword = JOptionPane.showInputDialog("请输入原密码:");
//String oldPassword = new ReaderUpdateDialog(null,"请输入原密码:").getPassword();
if(oldPassword == null) return;
//System.out.println(oldPassword.length());
if(oldPassword.length()==0){
JOptionPane.showMessageDialog(null, "密码不能为空", "ERROR", JOptionPane.ERROR_MESSAGE);
return;
}
//Statement statement = connection.createStatement();
//String password2 = jPasswordField.getText();
try{
String query = "select * from Reader where id = "
+ "'" + loadId + "'"
+ "and password = "
+ "'" + oldPassword + "'";
ResultSet resultSet = statement.executeQuery(query);
if(!resultSet.next()){
JOptionPane.showMessageDialog(null, "密码错误!!", "ERROR", JOptionPane.ERROR_MESSAGE);
return;
}
}catch(Exception sqlE){
sqlE.printStackTrace();
}
String newPassword = JOptionPane.showInputDialog("请输入新密码:");
if(newPassword == null) return;
if(newPassword.length()==0){
JOptionPane.showMessageDialog(null, "密码不能为空", "ERROR", JOptionPane.ERROR_MESSAGE);
return;
}
String newPassword2 = JOptionPane.showInputDialog("请再输一遍:");
if(newPassword2 == null) return;
if(newPassword2.equals(newPassword)==false){
JOptionPane.showMessageDialog(null, "两次密码输入不同", "ERROR", JOptionPane.ERROR_MESSAGE);
return;
}
try{
String query = "update Reader "+
"set password = "+ "'" +newPassword + "'" +
" where id = " + "'" + loadId + "'"
;
statement.executeUpdate(query);
JOptionPane.showMessageDialog(null, "密码修改成功","成功",JOptionPane.INFORMATION_MESSAGE);
//System.out.println(query);
}catch(Exception sqlE){
sqlE.printStackTrace();
}
//System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -