import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.util.*;
import java.sql.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.table.*;
import java.sql.ResultSet;
import java.io.*; 
    //修改密碼窗體
  ////////////////////////////////////////////////////////////////////////////////////////
  /////////////////////////////////////////////////////////////////////////////////////////   
 class gaimima extends JFrame implements ActionListener
{
  JLabel lbe1=new JLabel("修改密碼");
  //JPanel p=new JPanel();
  JButton b1,b2;
  JLabel lbe2,lbe3,lbe4,lbe5;
  JPasswordField pas1,pas2,pas3;
  JTextField tf;
  
  	Connection con;
    Statement stmt;
    ResultSet rs;
  public gaimima()
  {
          setTitle("修改密碼");
          setLayout(null);
          Font f=new Font("宋體",Font.PLAIN,12);
          lbe2=new JLabel("用  戶  名:");
          lbe2.setFont(f);
          lbe3=new JLabel("輸入舊密碼:");
          lbe3.setFont(f);
          lbe4=new JLabel("輸入新密碼:");
          lbe4.setFont(f);
          lbe5=new JLabel("確定新密碼:");
          lbe5.setFont(f);
          tf=new JTextField();
          pas1=new JPasswordField();
          pas2=new JPasswordField();
          pas3=new JPasswordField();
          b1=new JButton("確定");
          b1.setFont(f);
          b2=new JButton("清空");
          b2.setFont(f);
         
          getContentPane().add(lbe2);
          lbe2.setBounds(20,10,90,25);
          getContentPane().add(tf);
          tf.setBounds(100,10,120,25);
          getContentPane().add(lbe3);
          lbe3.setBounds(20,45,90,25);
          getContentPane().add(pas1);
          pas1.setBounds(100,45,120,25);
          getContentPane().add(lbe4);
          lbe4.setBounds(20,80,80,25);
          getContentPane().add(pas2);
          pas2.setBounds(100,80,120,25);
          getContentPane().add(lbe5);
          lbe5.setBounds(20,115,80,25);
          getContentPane().add(pas3);
          pas3.setBounds(100,115,120,25);
          getContentPane().add(b1);
          b1.setBorder(BorderFactory.createRaisedBevelBorder());
          b1.setBounds(100,160,55,20);
          b1.addActionListener(this);
          getContentPane().add(b2);
          b2.setBorder(BorderFactory.createRaisedBevelBorder());
          b2.setBounds(160,160,55,20);
          b2.addActionListener(this);
         
    setBounds(350, 300, 260, 230);
    
    setVisible(true);
    //setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
  }
  public void actionPerformed(ActionEvent e){
        try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        con=DriverManager.getConnection("jdbc:odbc:user");
        stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE) ; 
        }
        catch (Exception ex) {
    	System.out.println(ex.getMessage());
         
        }
        if(e.getSource()==b1){
        String name=tf.getText();
        	if(tf.getText().equals("")){new JOptionPane().showMessageDialog(null,"請(qǐng)輸入用戶名！");}
        String sqlw="select * from user1 where user='"+ name +"'";
        try{rs=stmt.executeQuery(sqlw);}
        catch (Exception eb) {
    	System.out.println(eb.getMessage());
         
        }
         		   try{
         		   
         		  
         		   	    rs.next();
	         			String ps1=pas1.getText();
	         			String password=rs.getString("passward");
	         			if(ps1.equals(password)){
	         				if(pas2.getText().equals(pas3.getText())){
	         					String supdate="update user1 set passward='"+ pas3.getText()+"' where user='"+ name +"'";
	         					stmt.executeUpdate(supdate);
	         					new JOptionPane().showMessageDialog(null,"密碼更改成功！");
	         					}
	         				else{
	         					new JOptionPane().showMessageDialog(null,"兩次密碼不同！");
	         					}
	         				}
	         			else{
	         				new JOptionPane().showMessageDialog(null,"舊密碼不正確！");
	         				}
	         		  }
	         catch(Exception el){
	         	 	System.out.println(el.getMessage());
	         	 	}
	         		}
	         if(e.getSource()==b2){         		
	            pas1.setText("");
         		pas2.setText("");
         		pas3.setText("");
	         	
	         	}
	       }
}////