//管理員修改自己的密碼
import javax.swing.*;
import javax.swing.event.*;
import java.awt.*;
import java.awt.event.*;
import java.io.*;
import java.sql.*;
public class change_admini extends JFrame implements ActionListener
{
	JTextField anumber;
	JTextField password2;
	JTextField password3;
	JTextField sno;
	JTextField pname;
	Label anumber1;
	Label password22;
	Label password33;
	Label gcourse1;
	Label sno1;
	Label pname1;
	JButton a_enter1;
	JButton b1;
	public change_admini()
	{
    	super("管理員密碼修改系統(tǒng)");
    	anumber=new JTextField(20);	
		password2=new JTextField(20);
		password3=new JTextField(20);
		pname=new JTextField(20);
		anumber1=new Label("         編號   ");
		pname1=new Label("     用戶名   ");
	 	password22=new Label("修改的密碼");
	 	password33=new Label("確定的密碼");
	 	a_enter1=new JButton("修改");
	 	b1=new JButton("返回");
		a_enter1.addActionListener(this);
		b1.addActionListener(this);
		setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); //設定關閉窗體時退出程
		JPanel pane=new JPanel();//定義主面板
		pane.setLayout(new FlowLayout());
		pane.add(anumber1);
		pane.add(anumber);
		pane.add(pname1);
		pane.add(pname);  
		pane.add(password22);
		pane.add(password2);
		pane.add(password33); 
		pane.add(password3); 
		pane.add(a_enter1);
		pane.add(b1);
		this.add(pane);
	}
	public void actionPerformed(ActionEvent e)
	{
		if(e.getSource()==a_enter1)
		{
			if(password2.getText().trim().equals(password3.getText()))
			{
				String url1="jdbc:odbc:agang";
				String s1=pname.getText();
				String sql="update administrator set aname='"+s1+"' where ano='"+anumber.getText()+"'";
				String sql2="update administrator set apassword='"+password2.getText()+"' where ano='"+anumber.getText()+"'";
				try{
					Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");  //驅動程序名稱_JDBC/ODBC橋接驅動程序
				}catch(java.lang.ClassNotFoundException e1){}
				try{
				Connection con=DriverManager.getConnection(url1,"",null);//建立連接
				Statement stmt=con.createStatement();
				stmt.executeUpdate(sql); 
				stmt.executeUpdate(sql2);  
				stmt.close();
			    con.close();
				}catch(SQLException e2){System.out.println(e2.getMessage());}	
				new	myDialog7();	
			}
			else
			{
				new myDialog6();
			}
		}	
	
	
		else{
			dispose();
			system_manage x1=new system_manage();
			x1.setVisible(true);
			x1.setLocation(300,300);
			x1.setSize(600,600);
		}
	}
	public static void main(String args[])
	{
		change_admini x=new change_admini();
		x.setVisible(true);
		x.setLocation(300,300);
		x.setSize(350,500);
	}
}