package bookmanager;import javax.swing.*;import com.borland.jbcl.layout.*;import java.awt.*;import java.sql.*;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 borrowHistoryBybookname extends JFrame {  ResultSet rs;    //resultset String sql; private DBManager db =new DBManager();  XYLayout xYLayout1 = new XYLayout();  JLabel jLabel4 = new JLabel();  JLabel jLabel1 = new JLabel();  JLabel jLabel3 = new JLabel();  JTextField jTextbdate = new JTextField();  JButton jButtonnext = new JButton();  JButton jButtonpre = new JButton();  JButton jButtonlast = new JButton();  JButton jButtonupdate = new JButton();  JLabel jLabel2 = new JLabel();  JTextField jTextbname = new JTextField();  JButton jButtonexit = new JButton();  JButton jButtondelete = new JButton();  JButton jButtonsearch = new JButton();  JButton jButtonfirst = new JButton();  JTextField jTextpname = new JTextField();  JTextField jTextrdate = new JTextField();  JTextField jTextcomment = new JTextField();  JLabel jLabel5 = new JLabel();  JPanel jPanel1 = new JPanel();  XYLayout xYLayout2 = new XYLayout();  public borrowHistoryBybookname() {    try {      jbInit();    }    catch(Exception e) {      e.printStackTrace();    }  }  public static void main(String[] args) {    borrowHistoryBybookname borrowHistoryBybookname = new borrowHistoryBybookname();  }  private void jbInit() throws Exception {    jLabel5.setText("還閱日期");    jLabel5.setFont(new java.awt.Font("Dialog", 0, 16));    jTextcomment.setText("");    jTextcomment.setFont(new java.awt.Font("Dialog", 0, 16));    jTextrdate.setText("");    jTextrdate.setFont(new java.awt.Font("Dialog", 0, 16));    jTextpname.setText("");    jTextpname.setFont(new java.awt.Font("Dialog", 0, 16));    jButtonfirst.setText("第一條");    jButtonfirst.addMouseListener(new borrowHistoryBybookname_jButtonfirst_mouseAdapter(this));    jButtonfirst.setFont(new java.awt.Font("Dialog", 0, 16));    jButtonsearch.setText("查詢");    jButtonsearch.addMouseListener(new borrowHistoryBybookname_jButtonsearch_mouseAdapter(this));    jButtonsearch.setFont(new java.awt.Font("Dialog", 0, 16));    jButtondelete.setFont(new java.awt.Font("Dialog", 0, 16));    jButtondelete.setText("刪除");    jButtondelete.addMouseListener(new borrowHistoryBybookname_jButtondelete_mouseAdapter(this));    jButtonexit.setFont(new java.awt.Font("Dialog", 0, 16));    jButtonexit.setText("退出");    jButtonexit.addMouseListener(new borrowHistoryBybookname_jButtonexit_mouseAdapter(this));    jTextbname.setText("");    jTextbname.setFont(new java.awt.Font("Dialog", 0, 16));    jLabel2.setText("書名");    jLabel2.setFont(new java.awt.Font("Dialog", 0, 16));    jButtonupdate.setFont(new java.awt.Font("Dialog", 0, 16));    jButtonupdate.setText("更新");    jButtonupdate.addMouseListener(new borrowHistoryBybookname_jButtonupdate_mouseAdapter(this));    jButtonlast.setText("最后一條");    jButtonlast.addMouseListener(new borrowHistoryBybookname_jButtonlast_mouseAdapter(this));    jButtonlast.setFont(new java.awt.Font("Dialog", 0, 16));    jButtonpre.setFont(new java.awt.Font("Dialog", 0, 16));    jButtonpre.setText("前一條");    jButtonpre.addMouseListener(new borrowHistoryBybookname_jButtonpre_mouseAdapter(this));    jButtonnext.setFont(new java.awt.Font("Dialog", 0, 16));    jButtonnext.setText("后一條");    jButtonnext.addMouseListener(new borrowHistoryBybookname_jButtonnext_mouseAdapter(this));    jTextbdate.setText("");    jTextbdate.setFont(new java.awt.Font("Dialog", 0, 16));    jLabel3.setText("借閱日起");    jLabel3.setFont(new java.awt.Font("Dialog", 0, 16));    jLabel1.setText("借閱者姓名");    jLabel1.setFont(new java.awt.Font("Dialog", 0, 16));    jLabel4.setText("備注");    jLabel4.setFont(new java.awt.Font("Dialog", 0, 16));    this.getContentPane().setLayout(xYLayout1);    xYLayout1.setWidth(631);    xYLayout1.setHeight(377);    jPanel1.setLayout(xYLayout2);    jPanel1.setBorder(BorderFactory.createLineBorder(Color.black));    this.getContentPane().add(jButtonsearch, new XYConstraints(423, 38, 104, 31));    this.getContentPane().add(jLabel2, new XYConstraints(56, 31, 89, 35));    this.getContentPane().add(jTextbname, new XYConstraints(209, 38, 154, 23));    this.getContentPane().add(jPanel1,         new XYConstraints(20, 84, 583, 217));    jPanel1.add(jTextpname, new XYConstraints(180, 14, 116, 26));    jPanel1.add(jLabel1, new XYConstraints(25, 14, 88, 33));    jPanel1.add(jTextbdate, new XYConstraints(181, 57, 137, -1));    jPanel1.add(jLabel3, new XYConstraints(28, 56, 87, 29));    jPanel1.add(jLabel5, new XYConstraints(29, 98, 87, 29));    jPanel1.add(jTextcomment, new XYConstraints(178, 143, 324, -1));    jPanel1.add(jTextrdate, new XYConstraints(180, 98, 137, -1));    jPanel1.add(jLabel4, new XYConstraints(29, 149, 66, 29));    this.getContentPane().add(jButtonnext, new XYConstraints(188, 326, 89, 26));    this.getContentPane().add(jButtonpre, new XYConstraints(105, 325, 82, 26));    this.getContentPane().add(jButtonlast, new XYConstraints(277, 326, 98, 27));    this.getContentPane().add(jButtonupdate, new XYConstraints(376, 327, 84, 27));    this.getContentPane().add(jButtonexit, new XYConstraints(545, 326, 70, 28));    this.getContentPane().add(jButtondelete, new XYConstraints(459, 327, 86, 28));    this.getContentPane().add(jButtonfirst, new XYConstraints(18, 324, 86, 26));      this.setSize(600,480);  }  void showResult(){     try {         jTextpname.setText(rs.getString("studentname") );        jTextbname.setText(rs.getString("bookname") );        jTextbdate.setText(rs.getString("borrowdate") );        jTextrdate.setText(rs.getString("returndate") );        jTextcomment.setText(rs.getString("comment") );         }      catch (SQLException ex) {         }   }  void jButtonsearch_mouseClicked(MouseEvent e) {    sql="select * from BookBorrow ";            // JOptionPane.showMessageDialog(null,jCombocolor.getSelectedItem().toString().trim() );                   if (jTextbname.getText().trim().length() ==0)                   {}                   else                   {                      sql=sql+"  where  bookname='"+jTextbname.getText().trim()+"'";                   }                    rs =db.getResult(sql);                   try {                     if(! rs.equals(null) )                     {  rs.next();                        showResult();                     }                   }                   catch (SQLException ex) {                      JOptionPane.showMessageDialog(null," search failed!");                   }  }  void jButtonfirst_mouseClicked(MouseEvent e) {    try {              rs.first() ;              showResult();           }           catch (SQLException ex) {           }  }  void jButtonpre_mouseClicked(MouseEvent e) {    try {                if(! rs.isFirst() )                {  rs.previous();                   showResult();                }              }              catch (SQLException ex) {              }  }  void jButtonnext_mouseClicked(MouseEvent e) {    try {                if(! rs.isLast())                 {  rs.next();                    showResult();                 }               }                   catch (SQLException ex) {                     }  }  void jButtonlast_mouseClicked(MouseEvent e) {    try {                  rs.last();                   showResult();                }                catch (SQLException ex) {                }  }  void jButtonupdate_mouseClicked(MouseEvent e) {//update      sql="update Books set borrowdate='"+jTextbdate.getText().trim() +"',";      sql=sql+" returndate ='"+jTextrdate.getText().trim() +"',";      sql=sql+" comment ='"+jTextcomment.getText().trim() +"'";      sql=sql+" where studentname='"+jTextpname.getText() +"'";      sql=sql+" and bookname='"+jTextbname.getText() +"'";      if(db.executeSql(sql))          {             JOptionPane.showMessageDialog(null,"successed!");          }     else          {             JOptionPane.showMessageDialog(null,"failed!");          }  }  void jButtondelete_mouseClicked(MouseEvent e) {    sql="delete from Books ";       sql=sql+" where studentname='"+jTextpname.getText() +"'";       sql=sql+" and bookname='"+jTextbname.getText() +"'";                       if(db.executeSql(sql))                        System.out.println(sql+"delete successed!") ;                      else                         System.out.println(sql+"delete failed!!!") ;  }  void jButtonexit_mouseClicked(MouseEvent e) {  dispose();  }}class borrowHistoryBybookname_jButtonsearch_mouseAdapter extends java.awt.event.MouseAdapter {  borrowHistoryBybookname adaptee;  borrowHistoryBybookname_jButtonsearch_mouseAdapter(borrowHistoryBybookname adaptee) {    this.adaptee = adaptee;  }  public void mouseClicked(MouseEvent e) {    adaptee.jButtonsearch_mouseClicked(e);  }}class borrowHistoryBybookname_jButtonfirst_mouseAdapter extends java.awt.event.MouseAdapter {  borrowHistoryBybookname adaptee;  borrowHistoryBybookname_jButtonfirst_mouseAdapter(borrowHistoryBybookname adaptee) {    this.adaptee = adaptee;  }  public void mouseClicked(MouseEvent e) {    adaptee.jButtonfirst_mouseClicked(e);  }}class borrowHistoryBybookname_jButtonpre_mouseAdapter extends java.awt.event.MouseAdapter {  borrowHistoryBybookname adaptee;  borrowHistoryBybookname_jButtonpre_mouseAdapter(borrowHistoryBybookname adaptee) {    this.adaptee = adaptee;  }  public void mouseClicked(MouseEvent e) {    adaptee.jButtonpre_mouseClicked(e);  }}class borrowHistoryBybookname_jButtonnext_mouseAdapter extends java.awt.event.MouseAdapter {  borrowHistoryBybookname adaptee;  borrowHistoryBybookname_jButtonnext_mouseAdapter(borrowHistoryBybookname adaptee) {    this.adaptee = adaptee;  }  public void mouseClicked(MouseEvent e) {    adaptee.jButtonnext_mouseClicked(e);  }}class borrowHistoryBybookname_jButtonlast_mouseAdapter extends java.awt.event.MouseAdapter {  borrowHistoryBybookname adaptee;  borrowHistoryBybookname_jButtonlast_mouseAdapter(borrowHistoryBybookname adaptee) {    this.adaptee = adaptee;  }  public void mouseClicked(MouseEvent e) {    adaptee.jButtonlast_mouseClicked(e);  }}class borrowHistoryBybookname_jButtonupdate_mouseAdapter extends java.awt.event.MouseAdapter {  borrowHistoryBybookname adaptee;  borrowHistoryBybookname_jButtonupdate_mouseAdapter(borrowHistoryBybookname adaptee) {    this.adaptee = adaptee;  }  public void mouseClicked(MouseEvent e) {    adaptee.jButtonupdate_mouseClicked(e);  }}class borrowHistoryBybookname_jButtondelete_mouseAdapter extends java.awt.event.MouseAdapter {  borrowHistoryBybookname adaptee;  borrowHistoryBybookname_jButtondelete_mouseAdapter(borrowHistoryBybookname adaptee) {    this.adaptee = adaptee;  }  public void mouseClicked(MouseEvent e) {    adaptee.jButtondelete_mouseClicked(e);  }}class borrowHistoryBybookname_jButtonexit_mouseAdapter extends java.awt.event.MouseAdapter {  borrowHistoryBybookname adaptee;  borrowHistoryBybookname_jButtonexit_mouseAdapter(borrowHistoryBybookname adaptee) {    this.adaptee = adaptee;  }  public void mouseClicked(MouseEvent e) {    adaptee.jButtonexit_mouseClicked(e);  }}