bookadd.java

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

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 bookNameLabel, pressNameLabel,
      authorLabel, addressLabel,
      pressDateLabel, priceLabel, bookCountLabel, commentLabel;
  JTextField bookNameTextField, pressNameTextField,
      authorTextField, addressTextField,
      pressDateTextField, priceTextField, bookCountTextField, commentTextField;
  Container c;
  JButton clearBtn, addBtn, exitBtn;
  public BookAdd() {
    super("添加书籍信息");
    c = getContentPane();
    c.setLayout(new BorderLayout());
    bookNameLabel = new JLabel("名称", JLabel.CENTER);
    pressNameLabel = new JLabel("出版社", JLabel.CENTER);
    authorLabel = new JLabel("作者", JLabel.CENTER);
    addressLabel = new JLabel("地址", JLabel.CENTER);
    pressDateLabel = new JLabel("出版日期", JLabel.CENTER);
    priceLabel = new JLabel("价格", JLabel.CENTER);
    bookCountLabel = new JLabel("新书数目", JLabel.CENTER);
    commentLabel = new JLabel("备注", JLabel.CENTER);
    bookNameTextField = new JTextField(15);
    pressNameTextField = new JTextField(15);
    authorTextField = new JTextField(15);
    addressTextField = new JTextField(15);
    pressDateTextField = new JTextField(15);
    priceTextField = new JTextField(15);
    bookCountTextField = new JTextField(15);
    commentTextField = new JTextField(15);
    panel1 = new JPanel();
    panel1.setLayout(new GridLayout(8, 2));
    panel1.add(bookNameLabel);
    panel1.add(bookNameTextField);
    panel1.add(pressNameLabel);
    panel1.add(pressNameTextField);
    panel1.add(authorLabel);
    panel1.add(authorTextField);
    panel1.add(addressLabel);
    panel1.add(addressTextField);
    panel1.add(pressDateLabel);
    panel1.add(pressDateTextField);
    panel1.add(priceLabel);
    panel1.add(priceTextField);
    panel1.add(bookCountLabel);
    panel1.add(bookCountTextField);
    panel1.add(commentLabel);
    panel1.add(commentTextField);
    panel2 = new JPanel();
    panel2.setLayout(new GridLayout(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) {
      bookNameTextField.setText("");
      pressNameTextField.setText("");
      authorTextField.setText("");
      addressTextField.setText("");
      pressDateTextField.setText("");
      priceTextField.setText("");
      bookCountTextField.setText("");
      commentTextField.setText("");
    }
    else if (e.getSource() == addBtn) {
      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 {
          String strSQL = "insert into books(bookname,press,author,address,pressDate,price,books_count,com) values('"+
              bookNameTextField.getText().trim() + "','" +
              pressNameTextField.getText().trim() + "','" +
              authorTextField.getText().trim() + "','" +
              addressTextField.getText().trim() + "','" +
              pressDateTextField.getText().trim() + "','" +
              priceTextField.getText().trim() + "','" +
              bookCountTextField.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());
        }
      }

    }
  }
}