package denglu;
import java.awt.Graphics;
import java.awt.Image;
import java.awt.MediaTracker;
import java.awt.TextField;
import java.awt.Toolkit;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JPasswordField;
import javax.swing.SwingUtilities;
import javax.swing.UIManager;
import denglu.jiemian;
public class Change extends JPanel {
    private JButton ok,close;
    private JPasswordField t1,t2,t3;
    private Image bg;
    private JFrame jf;
    private JLabel l1,l2,l3,l4;
   // TextField Number;
    String old_psw,new_psw1,new_psw2,n1;
 	Connection con;
	Statement sql;
	ResultSet rs;	
    public Change() {
        initOther();
        initWindow();      
    }
     void initWindow(){		
        this.setLayout(null);      
        ok=new JButton("確定");
        ok.addActionListener(new ActionListener(){
        	public void actionPerformed(ActionEvent e) {
        		
        		String a=Login1.userName.getText().toString().trim();
        		String regex="\\w{1,}";
        		old_psw = t1.getText().toString().trim();
				new_psw1 = t2.getText().toString().trim();
				new_psw2 = t3.getText().toString().trim();
				try {
					Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
				}
				catch(ClassNotFoundException eve){
					System.out.println(""+eve);
				}
				try{
					con=DriverManager.getConnection("jdbc:microsoft:sqlserver://202.115.80.180:2433;DatabaseName=JY06;user=jy06;password=jy06;");
					sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
					rs=sql.executeQuery("select * from UserMessage where username='"+a+"'");
					while(rs.next()){
						n1=rs.getString(3);	
					}
					con.close();
				}
				catch(SQLException eve){
					System.out.println(eve);
				}
				if(old_psw.matches(regex)||new_psw1.matches(regex)||new_psw2.matches(regex)){
					if(n1.equals(old_psw)){
						if(new_psw1.length()<6||new_psw2.length()<6){
							JOptionPane.showMessageDialog(Change.this,"請(qǐng)輸入六位以上新密碼!","錯(cuò)誤!",JOptionPane.ERROR_MESSAGE);					
							t2.setText(null);
						}
						else if(!new_psw1.equals(new_psw2)){
							JOptionPane.showMessageDialog(Change.this,"兩次輸入的新密碼不一致!","錯(cuò)誤!",JOptionPane.ERROR_MESSAGE);							
							t3.setText(null);
						}
						else {
							int rs;
								try{
									con=DriverManager.getConnection("jdbc:microsoft:sqlserver://202.115.80.180:2433;DatabaseName=JY06;user=jy06;password=jy06;");
									sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
									rs=sql.executeUpdate("update UserMessage set pwsd = '"+new_psw1+"' where username = '"+a+"'");
									con.close();
									new Changejilu();
									JOptionPane.showMessageDialog(Change.this,"密碼更改成功!","提示！",JOptionPane.INFORMATION_MESSAGE);
									new jiemian();
									jf.dispose();
								}
								catch(SQLException eve){
								System.out.println("修改失敗!");
								}
							}
						}
					else {JOptionPane.showMessageDialog(Change.this,"請(qǐng)輸入正確的密碼!","錯(cuò)誤!",JOptionPane.ERROR_MESSAGE);
						t1.setText(null);
					}
	        	}
				else{
					JOptionPane.showMessageDialog(Change.this,"您輸入了非法字符!","警告!",JOptionPane.WARNING_MESSAGE);
				}
			}
				
        });
        close=new JButton("返回");
        close.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e){
				new jiemian();
				jf.dispose();
			}
		});
        t1=new JPasswordField(10);
        t2=new JPasswordField(10);
        t3=new JPasswordField(10);      
        l1=new JLabel("請(qǐng)輸入舊密碼:");
        l2=new JLabel("請(qǐng)輸入新密碼:");
        l3=new JLabel("請(qǐng)?jiān)俅屋斎胄旅艽a:");
        l4=new JLabel("密碼修改");
        l1.setBounds(170,150,200,30);
        l2.setBounds(170,220,200,30);
        l3.setBounds(170,290,200,30);
        l4.setBounds(320,50,200,30);
        t1.setBounds(270,150,170,30);
        t2.setBounds(270,220,170,30);
        t3.setBounds(270,290,170,30);
        ok.setBounds(600,450,83,31);
        close.setBounds(10,450,83,31);
        this.add(l1);
        this.add(l2);
        this.add(l3);
        this.add(l4);
        this.add(t1);
        this.add(t2);
        this.add(t3);        
        this.add(ok);
        this.add(close);
        try{
            UIManager.setLookAndFeel(UIManager.getSystemLookAndFeelClassName());
            SwingUtilities.updateComponentTreeUI(this);
        } catch(Exception exe){
            exe.printStackTrace();
        }
        jf=new JFrame("");
        jf.getContentPane().add(this,null);
        jf.setSize(700,500);
        jf.setUndecorated(true);
        jf.setLocationRelativeTo(null);
        jf.setResizable(false);
        jf.setVisible(true);
        jf.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);        
    }  
    private void initOther(){
        bg=Toolkit.getDefaultToolkit().createImage(this.getClass().getResource("login/bj3.jpg"));      
        MediaTracker mt=new MediaTracker(this);
        mt.addImage(bg,0);
        try{
            mt.waitForAll();
        } catch(Exception exe){
            exe.printStackTrace();
        }
    }
    protected void paintComponent(Graphics g){
        super.paintComponent(g);
        g.drawImage(bg,0,0,this);
    }
    public static void main(String[] args){
        new Change();
    }
}
class Changejilu{
	String getlogintime;
	
	public  Changejilu ()
	{
		getlogintime=jilu.gettime;
		Connection con;
		Statement stmt;
		ResultSet rs;
		String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; 
		String dbURL = "jdbc:sqlserver://202.115.80.180:2433;DatabaseName=JY06;user=jy06;password=jy06;";
		String sql ="update AceessNoteTable set ChangePwd=1 where ActionDate='"+getlogintime+"'";
		try{
			try
			{
				Class.forName(driverName);
			}catch(ClassNotFoundException ex){
				System.out.println("this is error!");
			}
			con = DriverManager.getConnection(dbURL); 
			stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
			rs = stmt.executeQuery(sql);			
		}
		catch(SQLException ex)
		{
			System.out.println("this is SQL error!");
		}
	}
}