bookadd.java~10~

这是一个图书管理系统

package bookmanager;

import javax.swing.*;
import com.borland.jbcl.layout.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2003</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */

public class bookAdd extends JFrame {
//定义数据库操作对象
 private DBManager db =new DBManager();

  XYLayout xYLayout1 = new XYLayout();
  JLabel jLabel1 = new JLabel();
  JLabel jLabel2 = new JLabel();
  JLabel jLabel3 = new JLabel();
  JLabel jLabel4 = new JLabel();
  JLabel jLabel5 = new JLabel();
  JLabel jLabel6 = new JLabel();
  JLabel jLabel7 = new JLabel();
  JTextField jTextFieldname = new JTextField();
  JTextField jTextFieldpress = new JTextField();
  JTextField jTextFieldauthor = new JTextField();
  JTextField jTextFieldaddress = new JTextField();
  JTextField jTextFieldpressdate = new JTextField();
  JTextField jTextFieldprice = new JTextField();
  JTextField jTextFieldcomment = new JTextField();
  JButton jButtonClear = new JButton();
  JButton jButtonAdd = new JButton();
  JButton jButtonExit = new JButton();

  public bookAdd() {
    try {
      jbInit();
    }
    catch(Exception e) {
      e.printStackTrace();
    }
  }
  public static void main(String[] args) {
    bookAdd bookAdd = new bookAdd();
  }
  private void jbInit() throws Exception {
    jLabel1.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel1.setText("名称");
    this.getContentPane().setLayout(xYLayout1);
    jLabel2.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel2.setText("出版社");
    jLabel3.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel3.setText("作者");
    jLabel4.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel4.setText("地址");
    jLabel5.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel5.setText("出版日期");
    jLabel6.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel6.setText("价格");
    jLabel7.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel7.setText("备注");
    xYLayout1.setWidth(433);
    xYLayout1.setHeight(344);
    jTextFieldname.setFont(new java.awt.Font("Dialog", 0, 16));
    jTextFieldname.setText("");
    jTextFieldpress.setFont(new java.awt.Font("Dialog", 0, 16));
    jTextFieldpress.setText("");
    jTextFieldauthor.setFont(new java.awt.Font("Dialog", 0, 16));
    jTextFieldauthor.setText("");
    jTextFieldaddress.setFont(new java.awt.Font("Dialog", 0, 16));
    jTextFieldaddress.setText("");
    jTextFieldpressdate.setFont(new java.awt.Font("Dialog", 0, 16));
    jTextFieldpressdate.setText("");
    jTextFieldprice.setFont(new java.awt.Font("Dialog", 0, 16));
    jTextFieldprice.setText("");
    jTextFieldcomment.setFont(new java.awt.Font("Dialog", 0, 16));
    jTextFieldcomment.setText("");
    jButtonClear.setFont(new java.awt.Font("Dialog", 0, 16));
    jButtonClear.setText("清空");
    jButtonClear.addMouseListener(new bookAdd_jButtonClear_mouseAdapter(this));
     jButtonAdd.setFont(new java.awt.Font("Dialog", 0, 16));
    jButtonAdd.setText("添加");
     jButtonAdd.addMouseListener(new bookAdd_jButtonAdd_mouseAdapter(this));
    jButtonExit.setFont(new java.awt.Font("Dialog", 0, 16));
    jButtonExit.setText("退出");
     jButtonExit.addMouseListener(new bookAdd_jButtonExit_mouseAdapter(this));
	//将对象添加到相应容器
    this.setTitle("添加书籍信息");
    this.getContentPane().add(jLabel1, new XYConstraints(59, 16, 72, 23));
    this.getContentPane().add(jLabel2,  new XYConstraints(57, 51, 89, 21));
    this.getContentPane().add(jLabel3,   new XYConstraints(56, 87, 57, 21));
    this.getContentPane().add(jLabel4, new XYConstraints(56, 124, 51, 21));
    this.getContentPane().add(jLabel5, new XYConstraints(54, 163, 98, -1));
    this.getContentPane().add(jLabel6, new XYConstraints(56, 201, 62, 26));
    this.getContentPane().add(jLabel7, new XYConstraints(55, 242, 54, 20));
    this.getContentPane().add(jTextFieldname,  new XYConstraints(181, 19, 131, 27));
    this.getContentPane().add(jTextFieldpress,  new XYConstraints(181, 58, 132, 23));
    this.getContentPane().add(jTextFieldauthor,    new XYConstraints(182, 89, 133, 24));
    this.getContentPane().add(jTextFieldaddress,   new XYConstraints(181, 119, 134, 27));
    this.getContentPane().add(jTextFieldpressdate,  new XYConstraints(179, 163, 137, 21));
    this.getContentPane().add(jTextFieldprice,   new XYConstraints(177, 202, 139, 27));
    this.getContentPane().add(jTextFieldcomment,   new XYConstraints(178, 239, 137, 23));
    this.getContentPane().add(jButtonClear,  new XYConstraints(67, 294, 66, 28));
    this.getContentPane().add(jButtonAdd, new XYConstraints(173, 294, -1, 28));
    this.getContentPane().add(jButtonExit, new XYConstraints(293, 294, 66, 27));
  }
//退出本窗口
  void jButtonExit_mouseClicked(MouseEvent e) {
           this.dispose();
  }
  //清空文本框
  void jButtonClear_mouseClicked(MouseEvent e) {
           jTextFieldname.setText("");
            jTextFieldpress.setText("");
             jTextFieldauthor.setText("");
              jTextFieldaddress.setText("");
               jTextFieldpressdate.setText("");
                jTextFieldprice.setText("");
                 jTextFieldcomment.setText("");
  }
//添加一条新记录
  void jButtonAdd_mouseClicked(MouseEvent e) {
	 //校验书名是否为空
	  if(jTextFieldname.getText().trim().equals(""))
	  {JOptionPane.showMessageDialog(null,"书名不许为空！");
	      return;}
	//校验作者是否为空
      if(jTextFieldauthor.getText().trim().equals(""))
	  {JOptionPane.showMessageDialog(null,"作者不许为空！");
	      return;}
	//校验出版社是否为空
      if(jTextFieldpress.getText().trim().equals(""))
	  {JOptionPane.showMessageDialog(null,"出版社不许为空！");
	      return;}
	//校验价格是否为空
	  if(jTextFieldprice.getText().trim().equals(""))
	  {JOptionPane.showMessageDialog(null,"价格不许为空！");
	      return;}

        String strSQL ;
          //生成sql操作语句
			 strSQL="insert into  Books(bookname,press,author,address,pressdate,price,comment) ";
             strSQL=  strSQL+"values('"+jTextFieldname.getText().trim() +"','"+jTextFieldpress.getText().trim()+"',";
             strSQL=  strSQL+" '"+jTextFieldauthor.getText().trim() +"','"+jTextFieldaddress.getText().trim()+"',";
             strSQL=  strSQL+" '"+jTextFieldpressdate.getText().trim() +"','"+jTextFieldprice.getText().trim()+"',";
             strSQL=  strSQL+" '"+jTextFieldcomment.getText().trim() +"')";
          //由数据库操作对象执行数据库操作，并返回操作成功失败的提示信息
	         if(db.executeSql(strSQL))
                    {JOptionPane.showMessageDialog(null,"成功添加！"); }
                 else
                    { JOptionPane.showMessageDialog(null," 添加失败，请重新操作！");      }
  }
class bookAdd_jButtonExit_mouseAdapter extends java.awt.event.MouseAdapter {
  bookAdd adaptee;

  bookAdd_jButtonExit_mouseAdapter(bookAdd adaptee) {
    this.adaptee = adaptee;
  }
  public void mouseClicked(MouseEvent e) {
    adaptee.jButtonExit_mouseClicked(e);
  }
}

class bookAdd_jButtonClear_mouseAdapter extends java.awt.event.MouseAdapter {
  bookAdd adaptee;

  bookAdd_jButtonClear_mouseAdapter(bookAdd adaptee) {
    this.adaptee = adaptee;
  }
  public void mouseClicked(MouseEvent e) {
    adaptee.jButtonClear_mouseClicked(e);
  }
}

class bookAdd_jButtonAdd_mouseAdapter extends java.awt.event.MouseAdapter {
  bookAdd adaptee;

  bookAdd_jButtonAdd_mouseAdapter(bookAdd adaptee) {
    this.adaptee = adaptee;
  }
  public void mouseClicked(MouseEvent e) {
    adaptee.jButtonAdd_mouseClicked(e);
  }
}}

class bookAdd_jButtonClear_mouseAdapter extends java.awt.event.MouseAdapter {
  bookAdd adaptee;

  bookAdd_jButtonClear_mouseAdapter(bookAdd adaptee) {
    this.adaptee = adaptee;
  }
  public void mouseClicked(MouseEvent e) {
    adaptee.jButtonClear_mouseClicked(e);
  }
}

class bookAdd_jButtonExit_mouseAdapter extends java.awt.event.MouseAdapter {
  bookAdd adaptee;

  bookAdd_jButtonExit_mouseAdapter(bookAdd adaptee) {
    this.adaptee = adaptee;
  }
  public void mouseClicked(MouseEvent e) {
    adaptee.jButtonExit_mouseClicked(e);
  }
}

class bookAdd_jButtonAdd_mouseAdapter extends java.awt.event.MouseAdapter {
  bookAdd adaptee;

  bookAdd_jButtonAdd_mouseAdapter(bookAdd adaptee) {
    this.adaptee = adaptee;
  }
  public void mouseClicked(MouseEvent e) {
    adaptee.jButtonAdd_mouseClicked(e);
  }
}