bookmodify.java

采用java+sql实现图书管理系统

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;

public class BookModify
    extends JFrame
    implements ActionListener {
  DataBaseManager db = new DataBaseManager();
  ResultSet rs;
  JPanel panel1, panel2, panel3;
  JLabel TipLabel = new JLabel("输入书名点确定，将调出此书相关信息");
  JLabel booknoLabel,bookNameLabel, bookTypeLabel,pressNameLabel,
      authorLabel,pressDateLabel,priceLabel,InDateLabel,bookCountLabel,borrowed_countLabel, commentLabel;
  JTextField booknoTextField,bookNameTextField, bookTypeTextField,pressNameTextField,
      authorTextField,pressDateTextField,priceTextField,InDateTextField,bookCountTextField,borrowed_countTextField,commentTextField;
  Container c;
  JButton clearBtn, yesBtn, updateBtn, exitBtn;
  public BookModify() {
    super("修改书籍信息");
    c = getContentPane();
    c.setLayout(new BorderLayout());
    panel3 = new JPanel();
    panel3.add(TipLabel);
    c.add(panel3, BorderLayout.NORTH);
    bookNameLabel = new JLabel("书籍名称", JLabel.CENTER);//显示名称
    booknoLabel = new JLabel("书籍编号", JLabel.CENTER);
    bookTypeLabel = new JLabel("书籍类别", JLabel.CENTER);
    pressNameLabel = new JLabel("出版社", JLabel.CENTER);
    authorLabel = new JLabel("作者", JLabel.CENTER);
    pressDateLabel = new JLabel("出版日期", JLabel.CENTER);
    priceLabel = new JLabel("价格", JLabel.CENTER);
    InDateLabel = new JLabel("登记日期", JLabel.CENTER);
    bookCountLabel = new JLabel("数目", JLabel.CENTER);
    borrowed_countLabel = new JLabel("已借数目", JLabel.CENTER);
    commentLabel = new JLabel("备注", JLabel.CENTER);
    bookNameTextField = new JTextField(15);//文本框的宽度可以容纳15个字符
    booknoTextField = new JTextField(15);
    bookTypeTextField = new JTextField(15);
    pressNameTextField = new JTextField(15);
    authorTextField = new JTextField(15);
    pressDateTextField = new JTextField(15);
    priceTextField = new JTextField(15);
    InDateTextField = new JTextField(30);
    bookCountTextField = new JTextField(15);
    borrowed_countTextField = new JTextField(15);
    commentTextField = new JTextField(15);
    panel1 = new JPanel();
    panel1.setLayout(new GridLayout(11, 2));//使用方格式页面设置来布局，10行2列
    panel1.add(bookNameLabel);
    panel1.add(bookNameTextField);
    panel1.add(booknoLabel);
    panel1.add(booknoTextField);
    panel1.add(bookTypeLabel);
    panel1.add(bookTypeTextField); 
    panel1.add(pressNameLabel);
    panel1.add(pressNameTextField);
    panel1.add(authorLabel);
    panel1.add(authorTextField);
    panel1.add(pressDateLabel);
    panel1.add(pressDateTextField);
    panel1.add(priceLabel);
    panel1.add(priceTextField);
    panel1.add(InDateLabel);
    panel1.add(InDateTextField);
    panel1.add(bookCountLabel);
    panel1.add(bookCountTextField);
    panel1.add(borrowed_countLabel);
    panel1.add(borrowed_countTextField);
    panel1.add(commentLabel);
    panel1.add(commentTextField);
    panel2 = new JPanel();
    panel2.setLayout(new GridLayout(1, 4));
    clearBtn = new JButton("清空");
    yesBtn = new JButton("确定");
    updateBtn = new JButton("更新");
    exitBtn = new JButton("退出");
    panel2.add(clearBtn);
    panel2.add(yesBtn);
    panel2.add(updateBtn);
    panel2.add(exitBtn);
    clearBtn.addActionListener(this);
    yesBtn.addActionListener(this);
    updateBtn.addActionListener(this);
    exitBtn.addActionListener(this);
    updateBtn.addActionListener(this);
    c.add(panel1, BorderLayout.CENTER);
    c.add(panel2, BorderLayout.SOUTH);
  }

  public void actionPerformed(ActionEvent e) {
    if (e.getSource() == exitBtn) {//退出
      this.dispose();
    }
    else if (e.getSource() == clearBtn) {//清空按钮将所有文本框中的内容清空
      bookNameTextField.setText("");//设置文本框为空
      booknoTextField.setText("");
      bookTypeTextField.setText("");
      pressNameTextField.setText("");
      authorTextField.setText("");
      pressDateTextField.setText("");
      priceTextField.setText("");
      InDateTextField.setText("");
      bookCountTextField.setText("");
      borrowed_countTextField.setText("");
      commentTextField.setText("");
    }
    else if (e.getSource() == yesBtn) {//确定按钮将图书信息读出

      try {
        String strSQL = "select * from books where bookName='" +
            bookNameTextField.getText().trim() + "'";
        if (bookNameTextField.getText().trim().equals("")) {
          JOptionPane.showMessageDialog(null, "请输入书名：<*v*>");
        }
        else if (!db.getResult(strSQL).first()) {
          JOptionPane.showMessageDialog(null, "此书没有在书库中...");
        }
        else {
          rs = db.getResult(strSQL);
          rs.first();
          booknoTextField.setText(rs.getString(2).trim());
          bookTypeTextField.setText(rs.getString(3).trim());
          pressNameTextField.setText(rs.getString(4).trim());
          authorTextField.setText(rs.getString(5).trim());
          pressDateTextField.setText(rs.getString(6).trim());
          priceTextField.setText(rs.getString(7).trim());
          InDateTextField.setText(rs.getString(8).trim());
          bookCountTextField.setText(rs.getString(9).trim());
          borrowed_countTextField.setText(rs.getString(10).trim());
          commentTextField.setText(rs.getString(11).trim());
          updateBtn.setEnabled(true);
        }
      }
      catch (NullPointerException upe) {//空指针
        System.out.println(upe.toString());
      }
      catch (SQLException sqle) {//数据库连接不成功
        System.out.println(sqle.toString());
      }
      catch (Exception ex) {
        System.out.println(ex.toString());
      }
    }
    else if (e.getSource() == updateBtn) {//更新
      try {
        String strSQL = "update books set BookName='" +
            bookNameTextField.getText().trim() + "',BookType='" +
            bookTypeTextField.getText().trim() + "',Press='" +
            pressNameTextField.getText().trim() + "',Author='" +
            authorTextField.getText().trim() + "',PressDate='" +
            pressDateTextField.getText().trim() + "',Price='" +
            priceTextField.getText().trim() + "',InDate='" +
             InDateTextField.getText().trim() + "',books_count='" +
            bookCountTextField.getText().trim() + "',borrowed_count='" +
             borrowed_countTextField.getText().trim() + "',Com='" +
            commentTextField.getText().trim() + "'where Bookno='"+
            booknoTextField.getText().trim() +"'"; 
        if (db.updateSql(strSQL)>0) {
          JOptionPane.showMessageDialog(null, "更新书籍信息成功！");
          db.closeConnection();
          this.dispose();
        }
        else {
          JOptionPane.showMessageDialog(null, "更新书籍信息失败！");
          db.closeConnection();
          this.dispose();
        }
      }
      catch (Exception ex) {
        System.out.println(ex.toString());
      }
    }
  }
}