returnbook.java

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

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

public class ReturnBook
    extends JFrame
    implements ActionListener {
  DataBaseManager db = new DataBaseManager();
  ResultSet rs;
  JPanel panel1, panel2;
  Container c;
  JLabel returnedBookStudentNoLabel,returnLabel,
         returnedBookNameLabel,returnedDateLabel, returnedComLabel;
  JTextField returnedBookStudentNoTextField,returnTextField,
             returnedBookNameTextField,returnedDateTextField,returnedComTextField;
  JButton clearBtn, yesBtn, cancelBtn;
  JComboBox bookNameComboBox = new JComboBox();//下拉框
  public ReturnBook() {
    super("书籍归还");
    c = getContentPane();
    c.setLayout(new BorderLayout());
    returnedBookStudentNoLabel = new JLabel("还书者学号", JLabel.CENTER);
    //returnedBookStudentNameLabel = new JLabel("还书者姓名", JLabel.CENTER);
    //returnedBookStudentTypeLabel = new JLabel("还书者类型", JLabel.CENTER);
    //returnedBookNoLabel = new JLabel("书号", JLabel.CENTER);
    returnedBookNameLabel = new JLabel("书名", JLabel.CENTER);
    returnedDateLabel = new JLabel("日期", JLabel.CENTER);
    returnLabel = new JLabel("是否已还", JLabel.CENTER);
    returnedComLabel = new JLabel("备注", JLabel.CENTER);
    returnedBookStudentNoTextField = new JTextField(15);
    //returnedBookStudentNameTextField = new JTextField(15);
    //returnedBookStudentTypeTextField = new JTextField(15);
    //returnedBookNoTextField=new JTextField(15);
    returnedBookNameTextField=new JTextField(15);
    returnedDateTextField = new JTextField(15);
    returnTextField = new JTextField(15);
    returnedComTextField = new JTextField(15);
    try {
      String s = "";
      String strSQL = "select bookName from bookBrowse where is_returned='否'";
      rs = db.getResult(strSQL);
      while (rs.next()) {
        bookNameComboBox.addItem(rs.getString(1));
      }
    }
    catch (SQLException sqle) {
      System.out.println(sqle.toString());
    }
    catch (Exception ex) {
      System.out.println(ex.toString());
    }
    panel1 = new JPanel();
    panel1.setLayout(new GridLayout(5, 2));
    panel1.add(returnedBookStudentNoLabel);
    panel1.add(returnedBookStudentNoTextField);
    //panel1.add(returnedBookStudentNameLabel);
    //panel1.add(returnedBookStudentNameTextField);
    //panel1.add(returnedBookStudentTypeLabel);
    //panel1.add(returnedBookStudentTypeTextField);
    //panel1.add(returnedBookNoLabel);
    //panel1.add(returnedBookNoTextField);
    panel1.add(returnedBookNameLabel);
    panel1.add(bookNameComboBox);
    panel1.add(returnedDateLabel);
    panel1.add(returnedDateTextField);
    panel1.add(returnLabel);
    panel1.add(returnTextField);
    panel1.add(returnedComLabel);
    panel1.add(returnedComTextField);
    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) {//清空重写
      returnedBookStudentNoTextField.setText("");
     // returnedBookStudentNameTextField.setText("");
      //returnedBookStudentTypeTextField.setText("");
      returnedBookNameTextField.setText("");
      returnedDateTextField.setText("");
      returnTextField.setText("");
      returnedComTextField.setText("");

    }
    else if (e.getSource() == yesBtn) {//确定还书
      if (returnedBookStudentNoTextField.getText().trim().equals("")) {
        JOptionPane.showMessageDialog(null, "请输入还书者的学号。。。");
      }
      else if (bookNameComboBox.getSelectedItem().equals("")) {//返回当前所选项
        JOptionPane.showMessageDialog(null, "图书馆没有出借过书！");
      }
      else {
        try {
          String strSQL = "update bookBrowse set returnDate='" +
              returnedDateTextField.getText().trim() + "',com='" +
              returnedComTextField.getText().trim() +
              "',is_returned='是' where Studentno='" +
              returnedBookStudentNoTextField.getText().trim() + "'and BookName='" +
              bookNameComboBox.getSelectedItem() + "'";
          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());
        }
      }
    }
  }
}