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 returnInfoUpdate extends JFrame {  ResultSet rs;    //定義結果集  private DBManager db =new DBManager();//定義數據庫操作對象  XYLayout xYLayout1 = new XYLayout();  JLabel jLabel8 = new JLabel();  JLabel jLabel4 = new JLabel();  JTextField jTextbookname = new JTextField();  JTextField jTextborrowdate = new JTextField();  JLabel jLabel1 = new JLabel();  JLabel jLabel3 = new JLabel();  JButton jButtonupdate = new JButton();  JLabel jLabel2 = new JLabel();  JButton jButtonexit = new JButton();  JTextField jTextcomment = new JTextField();  JButton jButtondicision = new JButton();  JButton jButtonClear = new JButton();  JTextField jTextstudentname = new JTextField();  JTextField jTextreturndate = new JTextField();  JLabel jLabel5 = new JLabel();  public returnInfoUpdate() {    try {      jbInit();    }    catch(Exception e) {      e.printStackTrace();    }  }  public static void main(String[] args) {    returnInfoUpdate returnInfoUpdate = new returnInfoUpdate();  }  private void jbInit() throws Exception {    jTextstudentname.setFont(new java.awt.Font("Dialog", 0, 16));    jTextstudentname.setText("");    jButtonClear.setFont(new java.awt.Font("Dialog", 0, 16));     jButtonClear.setText("清空");    jButtonClear.addMouseListener(new returnInfoUpdate_jButtonClear_mouseAdapter(this));    jButtondicision.setFont(new java.awt.Font("Dialog", 0, 16));     jButtondicision.setText("確定");    jButtondicision.addMouseListener(new returnInfoUpdate_jButtondicision_mouseAdapter(this));    jTextcomment.setFont(new java.awt.Font("Dialog", 0, 16));    jTextcomment.setText("");    jButtonexit.setFont(new java.awt.Font("Dialog", 0, 16));      jButtonexit.setText("退出");    jButtonexit.addMouseListener(new returnInfoUpdate_jButtonexit_mouseAdapter(this));    jLabel2.setFont(new java.awt.Font("Dialog", 0, 16));    jLabel2.setText("書名");    jButtonupdate.setFont(new java.awt.Font("Dialog", 0, 16));     jButtonupdate.setText("更新");    jButtonupdate.addMouseListener(new returnInfoUpdate_jButtonupdate_mouseAdapter(this));    jLabel3.setFont(new java.awt.Font("Dialog", 0, 16));    jLabel3.setText("借閱日期");    jLabel1.setFont(new java.awt.Font("Dialog", 0, 16));    jLabel1.setRequestFocusEnabled(true);    jLabel1.setText("借閱者姓名");    jTextborrowdate.setFont(new java.awt.Font("Dialog", 0, 16));    jTextborrowdate.setText("");    jTextbookname.setFont(new java.awt.Font("Dialog", 0, 16));    jTextbookname.setText("");    jLabel4.setFont(new java.awt.Font("Dialog", 0, 16));    jLabel4.setText("備注");    jLabel8.setText("輸入借閱者姓名或書名點擊確定，將調出此書相關信息");    jLabel8.setFont(new java.awt.Font("Dialog", 0, 16));    this.getContentPane().setLayout(xYLayout1);    jTextreturndate.setFont(new java.awt.Font("Dialog", 0, 16));    jTextreturndate.setText("");    jLabel5.setFont(new java.awt.Font("Dialog", 0, 16));    jLabel5.setText("還書日期");    xYLayout1.setWidth(478);    xYLayout1.setHeight(368);    this.setTitle("書籍還入信息修改");    this.getContentPane().add(jTextborrowdate, new XYConstraints(201, 161, 153, -1));    this.getContentPane().add(jLabel1, new XYConstraints(74, 60, 88, 33));    this.getContentPane().add(jButtonupdate, new XYConstraints(229, 312, 74, 27));    this.getContentPane().add(jButtonexit, new XYConstraints(303, 312, 75, 28));    this.getContentPane().add(jButtondicision, new XYConstraints(163, 312, -1, 28));    this.getContentPane().add(jButtonClear, new XYConstraints(96, 312, 66, 28));    this.getContentPane().add(jTextstudentname, new XYConstraints(202, 64, 150, 26));    this.getContentPane().add(jTextcomment, new XYConstraints(202, 246, 154, -1));    this.getContentPane().add(jLabel4, new XYConstraints(73, 257, 63, 29));    this.getContentPane().add(jLabel5, new XYConstraints(71, 210, 87, 29));    this.getContentPane().add(jLabel8, new XYConstraints(15, 13, 435, 25));    this.getContentPane().add(jTextbookname, new XYConstraints(201, 112, 154, 23));    this.getContentPane().add(jLabel2, new XYConstraints(73, 106, 89, 35));    this.getContentPane().add(jLabel3, new XYConstraints(70, 162, 87, 29));    this.getContentPane().add(jTextreturndate, new XYConstraints(203, 204, 153, -1));  }  void jButtonexit_mouseClicked(MouseEvent e) {       this.dispose();  }  void jButtonupdate_mouseClicked(MouseEvent e) {    String strSQL ;   strSQL="update BookBorrow set  ";   strSQL= strSQL+" borrowdate='"+jTextborrowdate.getText().trim()+"',";     strSQL= strSQL+" returndate='"+jTextreturndate.getText().trim()+"',";   strSQL= strSQL+" comment='"+jTextcomment.getText().trim()+"'";   strSQL= strSQL+  " where studentname='"+jTextstudentname.getText().trim() +"'";   strSQL= strSQL+" and bookname='"+jTextbookname.getText().trim()+"'";   if(db.executeSql(strSQL))          {JOptionPane.showMessageDialog(null,"成功更新！"); }       else          { JOptionPane.showMessageDialog(null," 更新失敗，請重新操作！");      }  }  void jButtondicision_mouseClicked(MouseEvent e) {    String sql;       //定義變量，用來判斷是否是第一個查詢條件       boolean  isfirst =true;       sql="select * from BookBorrow ";         //如果款型的查詢條件不為空       if (jTextstudentname.getText().trim().length() ==0)          {}          else          {             sql=sql+"  where  studentname='"+jTextstudentname.getText().trim()+"'";             isfirst=false;          }               //如果顏色的查詢條件不為空         if (jTextbookname.getText().trim().length()==0)         {}         else         {    //如果是第一個查詢條件           if (isfirst)           sql=sql+" where bookname='"+jTextbookname.getText().trim() +"'";             //如果是第二個查詢條件           else            sql=sql+" and bookname='"+jTextbookname.getText().trim() +"'";         }       //執行數據庫的查詢操作       rs =db.getResult(sql);        try {               //判斷返回的結果集是否為空，若不為空顯示第一條記錄          if(! rs.equals(null) )          {  rs.first();           jTextstudentname.setText(rs.getString("studentname"));           jTextbookname.setText(rs.getString("bookname"));           jTextborrowdate.setText(rs.getString("borrowdate"));           jTextreturndate.setText(rs.getString("returndate"));           jTextcomment.setText(rs.getString("comment"));          }          else          {   JOptionPane.showMessageDialog(null,"無次紀錄!");              }        }//若出現異常，彈出警告對話框        catch (SQLException ex) { JOptionPane.showMessageDialog(null,"發生錯誤!");        }  }  void jButtonClear_mouseClicked(MouseEvent e) {            jTextstudentname.setText("");            jTextbookname.setText("");            jTextborrowdate.setText("");            jTextreturndate.setText("");            jTextcomment.setText("");  }}class returnInfoUpdate_jButtonexit_mouseAdapter extends java.awt.event.MouseAdapter {  returnInfoUpdate adaptee;  returnInfoUpdate_jButtonexit_mouseAdapter(returnInfoUpdate adaptee) {    this.adaptee = adaptee;  }  public void mouseClicked(MouseEvent e) {    adaptee.jButtonexit_mouseClicked(e);  }}class returnInfoUpdate_jButtonupdate_mouseAdapter extends java.awt.event.MouseAdapter {  returnInfoUpdate adaptee;  returnInfoUpdate_jButtonupdate_mouseAdapter(returnInfoUpdate adaptee) {    this.adaptee = adaptee;  }  public void mouseClicked(MouseEvent e) {    adaptee.jButtonupdate_mouseClicked(e);  }}class returnInfoUpdate_jButtondicision_mouseAdapter extends java.awt.event.MouseAdapter {  returnInfoUpdate adaptee;  returnInfoUpdate_jButtondicision_mouseAdapter(returnInfoUpdate adaptee) {    this.adaptee = adaptee;  }  public void mouseClicked(MouseEvent e) {    adaptee.jButtondicision_mouseClicked(e);  }}class returnInfoUpdate_jButtonClear_mouseAdapter extends java.awt.event.MouseAdapter {  returnInfoUpdate adaptee;  returnInfoUpdate_jButtonClear_mouseAdapter(returnInfoUpdate adaptee) {    this.adaptee = adaptee;  }  public void mouseClicked(MouseEvent e) {    adaptee.jButtonClear_mouseClicked(e);  }}