modifywin.java

界面不错的东西

/***********************************
*程序文件名：ModifyWin.java
*功能：实现修改密码的功能，用户修改密码
***********************************/
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import javax.swing.*;

 class ModifyWin extends JFrame implements ActionListener
 {
   JTextField con_acco;
   JPasswordField original_pwd,new_pwd,new_pwd_confirm; //为密码设置掩码
   JButton modifybtn,cancelbtn;
   Connection Con=null;
   Statement Stmt=null;
   ModifyWin()
   {
     super("光大银行储户修改密码");
     this.setBounds(250,250,450,300);
     this.setVisible(true);
     Container con=getContentPane();
     con.setLayout(new FlowLayout());
     con.add(new Label("光大银行储户更改密码:"));

     JPanel p2=new JPanel();
     p2.setLayout(new GridLayout(5,2));
     p2.add(new Label("要修改密码的用户帐号:")); //用户帐号唯一标示一个储户，一个用户可办理多个帐号
     con_acco=new JTextField(15);
     p2.add(con_acco);
     
     p2.add(new Label("用户原密码:"));
     original_pwd=new JPasswordField(15); //new PasswordField 
     p2.add(original_pwd);
     
     p2.add(new Label("用户新密码:"));
     new_pwd=new JPasswordField(15);
     p2.add(new_pwd);
     
     p2.add(new Label("新密码确认:"));
     new_pwd_confirm=new JPasswordField(15);
     p2.add(new_pwd_confirm);
      
     //范了严重错误：两个按钮没有实例化就添加到了面板上！!!
     modifybtn=new JButton("确认修改");
     cancelbtn=new JButton("取消修改");
      
     p2.add(modifybtn);
     p2.add(cancelbtn);
     //con.add(p,"CENTER");
     modifybtn.addActionListener(this);
     cancelbtn.addActionListener(this);
     this.validate();
     con.add(p2,"CENTER");
 }
  public void actionPerformed(ActionEvent e)
  {
    if(e.getSource()==modifybtn)
      {
        if(con_acco.getText().equals(""))
          {
           JOptionPane.showMessageDialog(this,"请输入用户的帐号!","警告",JOptionPane.WARNING_MESSAGE);
           }
        else if(original_pwd.getText().equals("")||new_pwd.getText().equals("")||new_pwd_confirm.getText().equals(""))
           //三个密码都不允许为空
         {
          JOptionPane.showMessageDialog(this,"请输入完整的原始密码以及新密码!","警告",JOptionPane.WARNING_MESSAGE);
          if(!new_pwd.getText().equals(new_pwd_confirm.getText()))
             JOptionPane.showMessageDialog(this,"你输入的新密码和确认密码不一致!","警告",JOptionPane.WARNING_MESSAGE);
          }
        else
          {
            try{ Modify_pwd();}
            catch(SQLException ee){System.out.println("SQLException"+ee.getMessage());}
           }
       }
   else if(e.getSource()==cancelbtn)
     {
       dispose();
     }
   }

 //实现储户密码的修改
   public void Modify_pwd() throws SQLException
    {
      String _con_acco,_new_pwd,_original_pwd;
      _con_acco=con_acco.getText().trim();
      _new_pwd=new_pwd.getText().trim();
      _original_pwd=original_pwd.getText().trim(); 
      try{
          Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
         } 
      catch(ClassNotFoundException e){System.out.println("DBClassNotFoundException:"+e.getMessage());}
     
      try{ Con=DriverManager.getConnection("jdbc:odbc:Bankdb","","");
      Stmt=Con.createStatement();
      ResultSet rs=Stmt.executeQuery("select * from consumer where con_acco='"+_con_acco+"'"+"and con_pwd='"+_original_pwd+"'");          
      boolean boo=false;
      if((boo=rs.next())==true)  //查到该用户，否则该用户不存在，提示出错信息。
        {//查到的数据为有效数据的前一行
         String temp="UPDATE consumer SET con_pwd='"+_new_pwd+"'"+"WHERE con_acco='"+_con_acco+"'";
         Stmt.executeUpdate(temp);
         JOptionPane.showMessageDialog(this,"密码修改成功!","恭喜",JOptionPane.WARNING_MESSAGE);
         dispose();
        }
      else
        {
        JOptionPane.showMessageDialog(this,"你输入的用户不存在!或密码错误,请查证!","警告",JOptionPane.WARNING_MESSAGE);
        }
    Con.close();
      }catch(SQLException e_6){System.out.println("SQLException:"+e_6.getMessage());}
 }
}