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.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) {        String strSQL ;             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);  }}