package bookmanager;import javax.swing.*;import java.awt.*;import com.borland.jbcl.layout.*;import java.awt.event.*;/** * <p>Title: </p> * <p>Description: </p> * <p>Copyright: Copyright (c) 2003</p> * <p>Company: </p> * @author not attributable * @version 1.0 */public class bookIn extends JFrame {   private DBManager db =new DBManager();      //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();  JButton jbtnClear = new JButton();  JButton jbtnAdd = new JButton();  JButton jbtnExit = new JButton();  JTextField jTextbookname = new JTextField();  JTextField jTextpress = new JTextField();  JLabel jLabel17 = new JLabel();  JTextField jTextcomment = new JTextField();  JTextField jTextaddress = new JTextField();  JTextField jTextdate = new JTextField();  JTextField jTextprice = new JTextField();  JTextField jTextauthor = new JTextField();  public bookIn() {    try {      jbInit();    }    catch(Exception e) {      e.printStackTrace();    }  }  public static void main(String[] args) {    bookIn bookIn = new bookIn();  }  private void jbInit() throws Exception {    jTextpress.setFont(new java.awt.Font("Dialog", 0, 16));    jTextpress.setText("");    jTextbookname.setFont(new java.awt.Font("Dialog", 0, 16));    jTextbookname.setText("");    jbtnExit.setFont(new java.awt.Font("Dialog", 0, 16));    jbtnExit.setText("退出");    jbtnExit.addMouseListener(new bookIn_jbtnExit_mouseAdapter(this));    jbtnAdd.setFont(new java.awt.Font("Dialog", 0, 16));    jbtnAdd.setText("添加");    jbtnAdd.addMouseListener(new bookIn_jbtnAdd_mouseAdapter(this));    jbtnClear.setFont(new java.awt.Font("Dialog", 0, 16));    jbtnClear.setText("清空");    jbtnClear.addMouseListener(new bookIn_jbtnClear_mouseAdapter(this));    jLabel6.setFont(new java.awt.Font("Dialog", 0, 16));    jLabel6.setText("價格");    jLabel5.setFont(new java.awt.Font("Dialog", 0, 16));    jLabel5.setVerifyInputWhenFocusTarget(true);    jLabel5.setText("出版日期");    jLabel4.setFont(new java.awt.Font("Dialog", 0, 16));    jLabel4.setText("地址");    jLabel3.setFont(new java.awt.Font("Dialog", 0, 16));    jLabel3.setText("作者");    jLabel2.setFont(new java.awt.Font("Dialog", 0, 16));    jLabel2.setText("出版社");    jLabel1.setFont(new java.awt.Font("Dialog", 0, 16));    jLabel1.setText("書名");    this.getContentPane().setLayout(xYLayout1);    this.setFont(new java.awt.Font("DialogInput", 0, 16));    xYLayout1.setWidth(544);    xYLayout1.setHeight(336);    jLabel17.setFont(new java.awt.Font("Dialog", 0, 16));    jLabel17.setText("備注");    jTextcomment.setText("");    jTextauthor.setText("");    jTextprice.setText("");    jTextdate.setText("");    jTextaddress.setText("");    this.getContentPane().add(jLabel1,  new XYConstraints(33, 27, 107, 27));    this.getContentPane().add(jLabel4,    new XYConstraints(226, 36, 65, 27));    this.getContentPane().add(jLabel6,   new XYConstraints(227, 125, 55, 27));    this.getContentPane().add(jLabel2,  new XYConstraints(30, 78, 81, -1));    this.getContentPane().add(jTextbookname,  new XYConstraints(130, 40, 85, 19));    this.getContentPane().add(jTextpress,   new XYConstraints(132, 80, 81, 23));    this.getContentPane().add(jbtnClear, new XYConstraints(79, 269, 85, 26));    this.getContentPane().add(jbtnAdd, new XYConstraints(204, 267, 91, 30));    this.getContentPane().add(jbtnExit, new XYConstraints(337, 266, 87, 30));    this.getContentPane().add(jTextaddress,  new XYConstraints(305, 41, 116, 28));    this.getContentPane().add(jTextdate,   new XYConstraints(306, 84, 119, 27));    this.getContentPane().add(jTextprice,   new XYConstraints(306, 128, 122, 28));    this.getContentPane().add(jTextauthor,     new XYConstraints(132, 129, 84, 27));    this.getContentPane().add(jLabel5, new XYConstraints(227, 81, 69, 32));    this.getContentPane().add(jTextcomment, new XYConstraints(132, 189, 324, 28));    this.getContentPane().add(jLabel3, new XYConstraints(32, 124, 60, 43));    this.getContentPane().add(jLabel17, new XYConstraints(36, 188, 69, 32));  }  void jbtnExit_mouseClicked(MouseEvent e) {              dispose();  }  void jbtnClear_mouseClicked(MouseEvent e) {        jTextcomment.setText("");        jTextauthor.setText("");        jTextprice.setText("");        jTextdate.setText("");        jTextaddress.setText("");        jTextpress.setText("");        jTextbookname.setText("");  }  void jbtnAdd_mouseClicked(MouseEvent e) {    String sql;          sql="insert into Books(bookname,press,author,address,pressdate,price,comment)values(  ";            sql=sql+"'"+jTextbookname.getText() +"',";              sql=sql+"'"+jTextpress.getText() +"',";                sql=sql+"'"+jTextauthor.getText()+"',";//date                 sql=sql+"'"+jTextaddress.getText() +"',";                   sql=sql+"'"+jTextdate.getText() +"',";                     sql=sql+"'"+jTextprice.getText() +"',";                       sql=sql+"'"+jTextcomment.getText() +"'";          sql=sql+")";         if(db.executeSql(sql)){               JOptionPane.showMessageDialog(null,"Add successed!");             }            else            {              JOptionPane.showMessageDialog(null,"Add failed!");            }  }}class bookIn_jbtnExit_mouseAdapter extends java.awt.event.MouseAdapter {  bookIn adaptee;  bookIn_jbtnExit_mouseAdapter(bookIn adaptee) {    this.adaptee = adaptee;  }  public void mouseClicked(MouseEvent e) {    adaptee.jbtnExit_mouseClicked(e);  }}class bookIn_jbtnClear_mouseAdapter extends java.awt.event.MouseAdapter {  bookIn adaptee;  bookIn_jbtnClear_mouseAdapter(bookIn adaptee) {    this.adaptee = adaptee;  }  public void mouseClicked(MouseEvent e) {    adaptee.jbtnClear_mouseClicked(e);  }}class bookIn_jbtnAdd_mouseAdapter extends java.awt.event.MouseAdapter {  bookIn adaptee;  bookIn_jbtnAdd_mouseAdapter(bookIn adaptee) {    this.adaptee = adaptee;  }  public void mouseClicked(MouseEvent e) {    adaptee.jbtnAdd_mouseClicked(e);  }}