borrowbook.java

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

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 borrowedBookStudentNoLabel,borrowedBookStudentNameLabel,borrowedBookStudentTypeLabel, 
         borrowedBookNoLabel,borrowedBookNameLabel,
      borrowedDateLabel,borrowedMustReturnLabel, is_returnedLabel,borrowedComLabel;
  JTextField borrowedBookStudentNoTextField,borrowedBookStudentNameTextField,borrowedBookStudentTypeTextField,
      borrowedBookNoTextField,borrowedBookNameTextField, borrowedDateTextField,
      borrowedMustReturnTextField, is_returnedTextField,borrowedComTextField;
  JButton clearBtn, yesBtn, cancelBtn;
  JComboBox bookNameComboBox = new JComboBox();
  public BorrowBook() {
    super("书籍出借");
    c = getContentPane();
    c.setLayout(new BorderLayout());
    borrowedBookStudentNoLabel = new JLabel("借阅学号", JLabel.CENTER);
   borrowedBookStudentNameLabel=new JLabel("借阅者名字", JLabel.CENTER);
   borrowedBookStudentTypeLabel=new JLabel("类型", JLabel.CENTER);
   borrowedBookNoLabel=new JLabel("书号", JLabel.CENTER);
   borrowedBookNameLabel = new JLabel("书名", JLabel.CENTER);
   borrowedDateLabel = new JLabel("借书日期", JLabel.CENTER);
   borrowedMustReturnLabel = new JLabel("应还书日期", JLabel.CENTER);
   is_returnedLabel = new JLabel("是否已还书", JLabel.CENTER);
   borrowedComLabel = new JLabel("备注", JLabel.CENTER);
    borrowedBookStudentNoTextField = new JTextField(15);
    borrowedBookStudentNameTextField= new JTextField(15);
    borrowedBookStudentTypeTextField= new JTextField(15);
    borrowedBookNoTextField = new JTextField(15);
    borrowedBookNameTextField= new JTextField(15);
    borrowedDateTextField= new JTextField(15);
    borrowedMustReturnTextField= new JTextField(15);
    is_returnedTextField= new JTextField(15);
    borrowedComTextField= 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(9, 2));
    panel1.add(borrowedBookStudentNoLabel);
    panel1.add(borrowedBookStudentNoTextField);
    panel1.add(borrowedBookStudentNameLabel);
    panel1.add(borrowedBookStudentNameTextField);
    panel1.add(borrowedBookStudentTypeLabel);
    panel1.add(borrowedBookStudentTypeTextField);
    panel1.add(borrowedBookNoLabel);
    panel1.add(borrowedBookNoTextField);
    panel1.add(borrowedBookNameLabel);
    panel1.add(bookNameComboBox);
    panel1.add(borrowedDateLabel);
    panel1.add(borrowedDateTextField);
    panel1.add(borrowedMustReturnLabel);
    panel1.add(borrowedMustReturnTextField);
    panel1.add(is_returnedLabel);
    panel1.add(is_returnedTextField);
    panel1.add(borrowedComLabel);
    panel1.add(borrowedComTextField);
    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) {//清空
      borrowedBookStudentNoTextField.setText("");
      borrowedBookStudentNameTextField.setText("");
      borrowedBookStudentTypeTextField.setText("");
      borrowedBookNoTextField.setText("");
      borrowedBookNameTextField.setText("");
      borrowedDateTextField.setText("");
      borrowedMustReturnTextField.setText("");
      is_returnedTextField.setText("");
      borrowedComTextField.setText("");

    }
    else if (e.getSource() == yesBtn) {//确定借书
      if (borrowedBookStudentNoTextField.getText().trim().equals("")) {
        JOptionPane.showMessageDialog(null, "请输入借阅者的学号。。。");
      }
      else if (bookNameComboBox.getSelectedItem().equals("")) {
        JOptionPane.showMessageDialog(null, "对不起，现在书库里没有书，\n你现在不能借书!");
      }
      else {
        try {
          String strSQL = "insert into bookBrowse(StudentNo,StudentName,Type,Bookno,BookName,Borrowdate,MustReturndate,Is_Returned,Com) values('" +
              borrowedBookStudentNoTextField.getText().trim() + "','" +
              borrowedBookStudentNameTextField.getText().trim() + "','" +
              borrowedBookStudentTypeTextField.getText().trim() + "','" +
              borrowedBookNoTextField.getText().trim() + "','" +
              bookNameComboBox.getSelectedItem() + "','" +
              borrowedDateTextField.getText().trim() + "','" +
              borrowedMustReturnTextField.getText().trim() + "','" +
              is_returnedTextField.getText().trim() + "','" +
              borrowedComTextField.getText().trim() + "')";
          if (db.updateSql(strSQL)>0) {
            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());
        }
      }
    }

  }
}