bookadd.java

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

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

public class BookAdd
    extends JFrame
    implements ActionListener {
  DataBaseManager db = new DataBaseManager();
  ResultSet rs;
  JPanel panel1, panel2;//声明两个轻量级容器
  JLabel booknoLabel,bookNameLabel, bookTypeLabel,pressNameLabel,//用于短文本字符串或图像或二者的显示区
      authorLabel, pressDateLabel, priceLabel,InDateLabel,bookCountLabel,borrowed_countLabel,commentLabel;
  JTextField booknoTextField,bookNameTextField, bookTypeTextField,pressNameTextField,//JTextField允许编辑单行文本
      authorTextField,pressDateTextField, priceTextField,InDateTextField, bookCountTextField, borrowed_countTextField,commentTextField;
  Container c;
  JButton clearBtn, addBtn, exitBtn;//配置按钮
  public BookAdd() {
    super("添加书籍信息");
    c = getContentPane();//获得当前的容器
    c.setLayout(new BorderLayout());//使用边界页面设置来布局
    booknoLabel = new JLabel("书籍编号", JLabel.CENTER);
    bookNameLabel = 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);
    booknoTextField = new JTextField(15);
    bookNameTextField = new JTextField(15);//文本框的宽度可以容纳15个字符
    bookTypeTextField = new JTextField(15);
    pressNameTextField = new JTextField(15);
    authorTextField = new JTextField(15);
    pressDateTextField = new JTextField(15);
    priceTextField = new JTextField(15);
    InDateTextField = new JTextField(15);
    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(booknoLabel);
    panel1.add(booknoTextField);
    panel1.add(bookNameLabel);
    panel1.add(bookNameTextField);
    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, 3));//1行3列
    clearBtn = new JButton("清空");
    clearBtn.addActionListener(this);
    addBtn = new JButton("添加");
    addBtn.addActionListener(this);
    exitBtn = new JButton("退出");
    exitBtn.addActionListener(this);
    panel2.add(clearBtn);//添加按钮到面板
    panel2.add(addBtn);
    panel2.add(exitBtn);
    c.add(panel1, BorderLayout.CENTER);//中间位置
    c.add(panel2, BorderLayout.SOUTH);//南边位置

  }

//事件发生的处理操作
  public void actionPerformed(ActionEvent e) {
    if (e.getSource() == exitBtn) {
      db.closeConnection();
      this.dispose();//关闭窗体并释放该窗体的占用的部分资源
    }
    else if (e.getSource() == clearBtn) {//Button为ActionEvent的事件源
    	booknoTextField.setText("");
      bookNameTextField.setText("");//设置文本框为空
      bookTypeTextField.setText("");
      pressNameTextField.setText("");
      authorTextField.setText("");
      pressDateTextField.setText("");
      InDateTextField.setText("");
      priceTextField.setText("");
      bookCountTextField.setText("");
      borrowed_countTextField.setText("");
      commentTextField.setText("");
    }
    else if (e.getSource() == addBtn) {//获得按钮的信息
    	if (booknoTextField.getText().trim().equals("")) {
        JOptionPane.showMessageDialog(null, "书籍编号不能为空！");
      }
      else if (bookNameTextField.getText().trim().equals("")) {
        JOptionPane.showMessageDialog(null, "书名不能为空！");
      }
      else if (pressNameTextField.getText().trim().equals("")) {
        JOptionPane.showMessageDialog(null, "出版社不能为空！");
      }
      else if (authorTextField.getText().trim().equals("")) {
        JOptionPane.showMessageDialog(null, "作者不能为空！");
      }
      else if (bookCountTextField.getText().trim().equals("")) {
        JOptionPane.showMessageDialog(null, "数目不能为空！");
      }
      else {
        try {//strSQL为传入的查询的sql语
          String strSQL = "insert into books(Bookno,BookName,BookType,Press,Author,PressDate,Price,InDate,books_count,borrowed_count,Com) values('"+
              booknoTextField.getText().trim() + "','" +
              bookNameTextField.getText().trim() + "','" +
             bookTypeTextField.getText().trim() + "','" +
              pressNameTextField.getText().trim() + "','" +
              authorTextField.getText().trim() + "','" +
              pressDateTextField.getText().trim() + "','" +
              priceTextField.getText().trim() + "','" +
              InDateTextField.getText().trim() + "','" +
              bookCountTextField.getText().trim() + "','" +
              borrowed_countTextField.getText().trim() + "','" +
              commentTextField.getText().trim() + "')";
          if (db.updateSql(strSQL)>0) {//执行了对数据库的操作
            JOptionPane.showMessageDialog(null, "添加书籍成功！");//显示一个消息对话框
            this.dispose();
          }
          else {
            JOptionPane.showMessageDialog(null, "添加书籍失败！");
            this.dispose();
          }
          db.closeConnection();//断开数据库的连接
        }
        catch (Exception ex) {
          System.out.println(ex.toString());
        }
      }

    }
  }
}