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 borrowHistoryall 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 jButtonupdate = new JButton();  JButton jButtonlast = new JButton();  JLabel jLabel2 = new JLabel();  JButton jButtonexit = new JButton();  JTextField jTextbname = new JTextField();  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();  public borrowHistoryall() {    try {      jbInit();    }    catch(Exception e) {      e.printStackTrace();    }  }  public static void main(String[] args) {    borrowHistoryall borrowHistoryall = new borrowHistoryall();  }  private void jbInit() throws Exception {    jLabel5.setFont(new java.awt.Font("Dialog", 0, 16));    jLabel5.setText("還閱日期");    jTextcomment.setFont(new java.awt.Font("Dialog", 0, 16));    jTextcomment.setText("");    jTextrdate.setFont(new java.awt.Font("Dialog", 0, 16));    jTextrdate.setText("");    jTextpname.setFont(new java.awt.Font("Dialog", 0, 16));    jTextpname.setText("");    jButtonfirst.setFont(new java.awt.Font("Dialog", 0, 16));    jButtonfirst.setText("第一條");     jButtonfirst.addMouseListener(new borrowHistoryall_jButtonfirst_mouseAdapter(this));    jButtonsearch.setFont(new java.awt.Font("Dialog", 0, 16));    jButtonsearch.setText("查詢");    jButtonsearch.addMouseListener(new borrowHistoryall_jButtonsearch_mouseAdapter(this));    jButtondelete.setText("刪除");    jButtondelete.addMouseListener(new borrowHistoryall_jButtondelete_mouseAdapter(this));    jButtondelete.setFont(new java.awt.Font("Dialog", 0, 16));    jTextbname.setFont(new java.awt.Font("Dialog", 0, 16));    jTextbname.setText("");    jButtonexit.setText("退出");    jButtonexit.addMouseListener(new borrowHistoryall_jButtonexit_mouseAdapter(this));    jButtonexit.setFont(new java.awt.Font("Dialog", 0, 16));    jLabel2.setFont(new java.awt.Font("Dialog", 0, 16));    jLabel2.setText("書(shū)名");    jButtonlast.setFont(new java.awt.Font("Dialog", 0, 16));    jButtonlast.setText("最后一條");    jButtonlast.addMouseListener(new borrowHistoryall_jButtonlast_mouseAdapter(this));    jButtonupdate.setText("更新");    jButtonupdate.addMouseListener(new borrowHistoryall_jButtonupdate_mouseAdapter(this));    jButtonupdate.setFont(new java.awt.Font("Dialog", 0, 16));    jButtonpre.setText("前一條");    jButtonpre.addMouseListener(new borrowHistoryall_jButtonpre_mouseAdapter(this));    jButtonpre.setFont(new java.awt.Font("Dialog", 0, 16));    jButtonnext.setText("后一條");     jButtonnext.addMouseListener(new borrowHistoryall_jButtonnext_mouseAdapter(this));    jButtonnext.setFont(new java.awt.Font("Dialog", 0, 16));    jTextbdate.setFont(new java.awt.Font("Dialog", 0, 16));    jTextbdate.setText("");    jLabel3.setFont(new java.awt.Font("Dialog", 0, 16));    jLabel3.setText("借閱日起");    jLabel1.setFont(new java.awt.Font("Dialog", 0, 16));    jLabel1.setText("借閱者姓名");    jLabel4.setFont(new java.awt.Font("Dialog", 0, 16));    jLabel4.setText("備注");    this.getContentPane().setLayout(xYLayout1);    xYLayout1.setWidth(662);    xYLayout1.setHeight(351);    this.getContentPane().add(jTextpname, new XYConstraints(226, 39, 116, 26));    this.getContentPane().add(jLabel4, new XYConstraints(72, 242, 66, 29));    this.getContentPane().add(jLabel1, new XYConstraints(75, 31, 88, 33));    this.getContentPane().add(jLabel3, new XYConstraints(74, 135, 87, 29));    this.getContentPane().add(jTextbdate, new XYConstraints(227, 136, 137, -1));    this.getContentPane().add(jButtonnext, new XYConstraints(193, 300, 89, 26));    this.getContentPane().add(jButtonpre, new XYConstraints(110, 299, 82, 26));    this.getContentPane().add(jButtonupdate, new XYConstraints(381, 301, 84, 27));    this.getContentPane().add(jButtonlast, new XYConstraints(282, 300, 98, 27));    this.getContentPane().add(jLabel2, new XYConstraints(76, 78, 89, 35));    this.getContentPane().add(jButtonexit, new XYConstraints(550, 300, 70, 28));    this.getContentPane().add(jTextbname, new XYConstraints(227, 93, 154, 23));    this.getContentPane().add(jButtondelete, new XYConstraints(464, 301, 86, 28));    this.getContentPane().add(jButtonsearch, new XYConstraints(443, 35, 104, 31));    this.getContentPane().add(jButtonfirst, new XYConstraints(23, 298, 86, 26));    this.getContentPane().add(jTextrdate, new XYConstraints(228, 182, 137, -1));    this.getContentPane().add(jTextcomment, new XYConstraints(226, 235, 324, -1));    this.getContentPane().add(jLabel5, new XYConstraints(71, 183, 87, 29));  }  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() );                   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 borrowHistoryall_jButtonsearch_mouseAdapter extends java.awt.event.MouseAdapter {  borrowHistoryall adaptee;  borrowHistoryall_jButtonsearch_mouseAdapter(borrowHistoryall adaptee) {    this.adaptee = adaptee;  }  public void mouseClicked(MouseEvent e) {    adaptee.jButtonsearch_mouseClicked(e);  }}class borrowHistoryall_jButtonfirst_mouseAdapter extends java.awt.event.MouseAdapter {  borrowHistoryall adaptee;  borrowHistoryall_jButtonfirst_mouseAdapter(borrowHistoryall adaptee) {    this.adaptee = adaptee;  }  public void mouseClicked(MouseEvent e) {    adaptee.jButtonfirst_mouseClicked(e);  }}class borrowHistoryall_jButtonpre_mouseAdapter extends java.awt.event.MouseAdapter {  borrowHistoryall adaptee;  borrowHistoryall_jButtonpre_mouseAdapter(borrowHistoryall adaptee) {    this.adaptee = adaptee;  }  public void mouseClicked(MouseEvent e) {    adaptee.jButtonpre_mouseClicked(e);  }}class borrowHistoryall_jButtonnext_mouseAdapter extends java.awt.event.MouseAdapter {  borrowHistoryall adaptee;  borrowHistoryall_jButtonnext_mouseAdapter(borrowHistoryall adaptee) {    this.adaptee = adaptee;  }  public void mouseClicked(MouseEvent e) {    adaptee.jButtonnext_mouseClicked(e);  }}class borrowHistoryall_jButtonlast_mouseAdapter extends java.awt.event.MouseAdapter {  borrowHistoryall adaptee;  borrowHistoryall_jButtonlast_mouseAdapter(borrowHistoryall adaptee) {    this.adaptee = adaptee;  }  public void mouseClicked(MouseEvent e) {    adaptee.jButtonlast_mouseClicked(e);  }}class borrowHistoryall_jButtonupdate_mouseAdapter extends java.awt.event.MouseAdapter {  borrowHistoryall adaptee;  borrowHistoryall_jButtonupdate_mouseAdapter(borrowHistoryall adaptee) {    this.adaptee = adaptee;  }  public void mouseClicked(MouseEvent e) {    adaptee.jButtonupdate_mouseClicked(e);  }}class borrowHistoryall_jButtondelete_mouseAdapter extends java.awt.event.MouseAdapter {  borrowHistoryall adaptee;  borrowHistoryall_jButtondelete_mouseAdapter(borrowHistoryall adaptee) {    this.adaptee = adaptee;  }  public void mouseClicked(MouseEvent e) {    adaptee.jButtondelete_mouseClicked(e);  }}class borrowHistoryall_jButtonexit_mouseAdapter extends java.awt.event.MouseAdapter {  borrowHistoryall adaptee;  borrowHistoryall_jButtonexit_mouseAdapter(borrowHistoryall adaptee) {    this.adaptee = adaptee;  }  public void mouseClicked(MouseEvent e) {    adaptee.jButtonexit_mouseClicked(e);  }}