//學生修改自己的密碼
import javax.swing.*;
import javax.swing.event.*;
import java.awt.*;
import java.awt.event.*;
import java.io.*;
import java.sql.*;
public class student_look2 extends JFrame implements ActionListener
{
	JTextField password2;
	JTextField password3;
	JTextField sno;
	JTextField pname;
	Label password22;
	Label password33;
	Label gcourse1;
	Label sno1;
	Label pname1;
	JButton a_enter1;
	JButton b1;
	public student_look2()
	{
    	super("學生密碼修改系統");	
		password2=new JTextField(20);
		password3=new JTextField(20);
		sno=new JTextField(20);
		pname=new JTextField(20);
		sno1=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(sno1); 
		pane.add(sno); 
		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 s2=pname.getText();
			 	String sql="update password set ppassword='"+password2.getText()+"' where sno='"+sno.getText()+"'";
			 	String sql2="update password set pname='"+pname.getText()+"' where sno='"+sno.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){}	
				new	myDialog7();
			}
			else
			{
				new myDialog6();
			}
		}	
	
		else{
			dispose();
			student_look x1=new student_look();
			x1.setVisible(true);
			x1.setLocation(300,300);
			x1.setSize(600,600);
		}
	}
	public static void main(String args[])
	{
		student_look2 x=new student_look2();
		x.setVisible(true);
		x.setLocation(300,300);
		x.setSize(350,500);
	}
}