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 userUpdate extends JFrame { //定義結果集  ResultSet rs;   //定義數據庫操作對象  private DBManager db =new DBManager();  XYLayout xYLayout1 = new XYLayout();  JButton jButtonCancel = new JButton();  JLabel jLabel2 = new JLabel();  JButton jButtonOK = new JButton();  JPasswordField jPasswordold = new JPasswordField();  JLabel jLabel1 = new JLabel();  JTextField jTextFieldusername = new JTextField();  JPasswordField jPasswordnew = new JPasswordField();  JLabel jLabel3 = new JLabel();  public userUpdate() {    try {      jbInit();    }    catch(Exception e) {      e.printStackTrace();    }  }  public static void main(String[] args) {    userUpdate userUpdate = new userUpdate();  }  private void jbInit() throws Exception {    jTextFieldusername.setText("");    jTextFieldusername.setFont(new java.awt.Font("Dialog", 0, 16));    jLabel1.setText("用戶名");    jLabel1.setFont(new java.awt.Font("Dialog", 0, 16));    jPasswordold.setText("");    jButtonOK.setText("更新");    jButtonOK.addMouseListener(new userUpdate_jButtonOK_mouseAdapter(this));    jButtonOK.setFont(new java.awt.Font("Dialog", 0, 16));    jLabel2.setText("原密碼");    jLabel2.setFont(new java.awt.Font("Dialog", 0, 16));     jButtonCancel.setText("取消");    jButtonCancel.addMouseListener(new userUpdate_jButtonCancel_mouseAdapter(this));    jButtonCancel.setFont(new java.awt.Font("Dialog", 0, 16));    this.getContentPane().setLayout(xYLayout1);    xYLayout1.setWidth(400);    xYLayout1.setHeight(296);    jLabel3.setFont(new java.awt.Font("Dialog", 0, 16));    jLabel3.setText("新密碼");    jPasswordnew.setFont(new java.awt.Font("Dialog", 0, 16));    jPasswordnew.setText("");    this.getContentPane().add(jTextFieldusername,  new XYConstraints(216, 35, 111, 38));    this.getContentPane().add(jLabel2, new XYConstraints(66, 102, 80, 34));    this.getContentPane().add(jPasswordold, new XYConstraints(217, 98, 111, 35));    this.getContentPane().add(jLabel1, new XYConstraints(65, 36, 99, 34));    this.getContentPane().add(jPasswordnew,  new XYConstraints(216, 151, 114, 31));    this.getContentPane().add(jLabel3,  new XYConstraints(69, 160, 62, 30));    this.getContentPane().add(jButtonOK, new XYConstraints(89, 234, 91, 31));    this.getContentPane().add(jButtonCancel, new XYConstraints(207, 235, 94, 30));  }  void jButtonCancel_mouseClicked(MouseEvent e) {             this.dispose();  }  void jButtonOK_mouseClicked(MouseEvent e) {       String strSQL ;	    //校驗用戶名是否為空		 if(jTextFieldusername.GetText().Trim().eques(""))	       {JOptionPane.showMessageDialog(null,"用戶名不許為空！");	        return;}        //檢驗用戶兩次輸入的密碼是否一致   		 if(!jPasswordold.getText().trim().equals(jPasswordnew.getText().trim()))            {JOptionPane.showMessageDialog(null,"兩次輸入的密碼不一致！");             return;             }			//檢驗用戶名是否存在           strSQL="select * from user where username='"+jTextFieldusername.getText().trim() +"' and password='"+jPasswordold.getText().trim()+"'";                  rs=db.getResult(strSQL) ;           //若不存在提醒用戶從新輸入           if(rs is null )             {JOptionPane.showMessageDialog(null,"用戶名不存在，或原密碼不正確！");                      }            //若存在，執行更新操作           else             {              //生成更新sql語句                 strSQL="update user set password='"+jPasswordnew.getText().trim()+"' where username='"+jTextFieldusername.getText().trim() +"'";                //由數據庫操作對象執行數據庫操作，并返回操作成功失敗的提示信息				 if(db.executeSql(strSQL))                    {JOptionPane.showMessageDialog(null,"成功更新！"); }                 else                    { JOptionPane.showMessageDialog(null," 更新失敗，請重新操作！");      }                            }  }}class userUpdate_jButtonCancel_mouseAdapter extends java.awt.event.MouseAdapter {  userUpdate adaptee;  userUpdate_jButtonCancel_mouseAdapter(userUpdate adaptee) {    this.adaptee = adaptee;  }  public void mouseClicked(MouseEvent e) {    adaptee.jButtonCancel_mouseClicked(e);  }}class userUpdate_jButtonOK_mouseAdapter extends java.awt.event.MouseAdapter {  userUpdate adaptee;  userUpdate_jButtonOK_mouseAdapter(userUpdate adaptee) {    this.adaptee = adaptee;  }  public void mouseClicked(MouseEvent e) {    adaptee.jButtonOK_mouseClicked(e);  }}