borrowbook.java~8~

图书馆管理系统 运用简单的Java语言与SQLSERVER2000数据库 开发的一个图书管理系统

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

public class BorrowBook
    extends JFrame
    implements ActionListener {
  DataBaseManager db = new DataBaseManager();
  ResultSet rs;
  JPanel panel1, panel2;
  Container c;
  JLabel BorrowedBookStudentLabel, BorrowedBookNameLabel,
      BorrowedDateLabel, BorrowedCommentLabel;
  JTextField BorrowedBookStudentTextField,
      BorrowedDateTextField, BorrowedCommentTextField;
  JButton ClearBtn, YesBtn, CancelBtn;
  JComboBox bookNameComboBox = new JComboBox();
  public BorrowBook() {
    super("书籍出借");
    c = getContentPane();
    c.setLayout(new BorderLayout());
    BorrowedBookStudentLabel = new JLabel("借阅者姓名", JLabel.CENTER);
    BorrowedBookNameLabel = new JLabel("书名", JLabel.CENTER);
    BorrowedDateLabel = new JLabel("日期", JLabel.CENTER);
    BorrowedCommentLabel = new JLabel("备注", JLabel.CENTER);
    BorrowedBookStudentTextField = new JTextField(15);
    BorrowedDateTextField = new JTextField(15);
    BorrowedCommentTextField = new JTextField(15);
    try {
      String strSQL =
          "select bookName from books where books_count>borrowed_count";
      rs = db.getResult(strSQL);
      while (rs.next()) {
        bookNameComboBox.addItem(rs.getString(1).trim());
      }
    }
    catch (SQLException sqle) {
      System.out.println(sqle.toString());
    }
    catch (Exception ex) {
      System.out.println(ex.toString());
    }
    panel1 = new JPanel();
    panel1.setLayout(new GridLayout(4, 2));
    panel1.add(BorrowedBookStudentLabel);
    panel1.add(BorrowedBookStudentTextField);
    panel1.add(BorrowedBookNameLabel);
    panel1.add(bookNameComboBox);
    panel1.add(BorrowedDateLabel);
    panel1.add(BorrowedDateTextField);
    panel1.add(BorrowedCommentLabel);
    panel1.add(BorrowedCommentTextField);
    c.add(panel1, BorderLayout.CENTER);
    panel2 = new JPanel();
    panel2.setLayout(new GridLayout(1, 3));
    ClearBtn = new JButton("清空");
    YesBtn = new JButton("确定");
    CancelBtn = new JButton("取消");
    ClearBtn.addActionListener(this);
    YesBtn.addActionListener(this);
    CancelBtn.addActionListener(this);
    panel2.add(ClearBtn);
    panel2.add(YesBtn);
    panel2.add(CancelBtn);
    c.add(panel2, BorderLayout.SOUTH);

  }

  public void actionPerformed(ActionEvent e) {
    if (e.getSource() == CancelBtn) {
      this.dispose();
    }
    else if (e.getSource() == ClearBtn) {
      BorrowedBookStudentTextField.setText("");
      BorrowedDateTextField.setText("");
      BorrowedCommentTextField.setText("");

    }
    else if (e.getSource() == YesBtn) {
      if (BorrowedBookStudentTextField.getText().trim().equals("")) {
        JOptionPane.showMessageDialog(null, "请输入借阅者的姓名。。。");
      }
      else if (bookNameComboBox.getSelectedItem().equals("")) {
        JOptionPane.showMessageDialog(null, "对不起，现在书库里没有书，\n你现在不能借书!");
      }
      else {
        try {
          String strSQL = "insert into bookBrowse(studentname,bookname,borrowdate,returndate,com) values('" +
              BorrowedBookStudentTextField.getText().trim() + "','" +
              bookNameComboBox.getSelectedItem() + "','" +
              BorrowedDateTextField.getText().trim() + "','','" +
              BorrowedCommentTextField.getText().trim() + "')";
          if (db.updateSql(strSQL)) {
            JOptionPane.showMessageDialog(null, "借阅完成！");
            strSQL =
                "update books set borrowed_count=borrowed_count+1 where bookname='" +
                bookNameComboBox.getSelectedItem() + "'";
            db.updateSql(strSQL);
            db.closeConnection();
            this.dispose();
          }
          else {
            JOptionPane.showMessageDialog(null, "借阅失败！");
            db.closeConnection();
            this.dispose();
          }
        }
        catch (Exception ex) {
          System.out.println(ex.toString());
        }
      }
    }

  }
}