import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
public class ModifyForm implements ActionListener 
{
	JDialog dialog;
	JTextField tF2=new JTextField();
	JTextField tF3=new JTextField();
	JTextField tF4=new JTextField();
	JTextField tF5=new JTextField();
	JTextField tF6=new JTextField();
	String text;
	public ModifyForm (JFrame f)
	{
		text=JOptionPane.showInputDialog("請(qǐng)輸入要修改學(xué)生的學(xué)號(hào)");
		dialog=new JDialog(f,"學(xué)生信息修改系統(tǒng)",true);
		Container dialogPan=dialog.getContentPane();
		dialogPan.setLayout(new GridLayout(6,2));
		
		dialogPan.add(new JLabel("姓名：",SwingConstants.CENTER));
		dialogPan.add(tF2);
		
		dialogPan.add(new JLabel("班級(jí)：",SwingConstants.CENTER));
		dialogPan.add(tF3);
		
		dialogPan.add(new JLabel("英語(yǔ)：",SwingConstants.CENTER));
		dialogPan.add(tF4);
		
		dialogPan.add(new JLabel("Java：",SwingConstants.CENTER));
		dialogPan.add(tF5);
		
		dialogPan.add(new JLabel("高數(shù)：",SwingConstants.CENTER));
		dialogPan.add(tF6);
		
		JButton b1=new JButton("提交");
		dialogPan.add(b1);
		JButton b2=new JButton("取消");
		dialogPan.add(b2);
		b1.addActionListener(this);
		b2.addActionListener(this);
		
		dialog.setBounds(450, 300, 300, 160);
		dialog.setVisible(true);
	}
	public void actionPerformed(ActionEvent e)
	{
		String cmd=e.getActionCommand();
		
		String text2=tF2.getText();
		String text3=tF3.getText();
		String text4=tF4.getText();
		String text5=tF5.getText();
		String text6=tF6.getText();
		
		if(cmd.equals("提交"))
		{
			if(text2.equals("")||text3.equals("")||text4.equals("")||text5.equals("")||text6.equals(""))
			{
				JOptionPane.showMessageDialog(dialog,"修改項(xiàng)不能為空！");
			}
			else
			{
				try
				{
				Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
				Connection con=
				DriverManager.getConnection("jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=student");
				Statement stmt=con.createStatement();
				ResultSet rs=stmt.executeQuery("Select * From student");
				while(rs.next())
				{
					if(text.equals(rs.getString(1)))
					{
						float English=Float.parseFloat(text4);
						float Java=Float.parseFloat(text5);
						float Maths=Float.parseFloat(text6);
						if(English<0||English>100||Java<0||Java>100||Maths<0||Maths>100)
						{
							JOptionPane.showMessageDialog(dialog,"成績(jī)輸入有誤，請(qǐng)重新輸入！");
							if(English<0||English>100)
								tF4.setText("");
							if(Java<0||Java>100)
								tF5.setText("");
							if(Maths<0||Maths>100)
								tF6.setText("");
							return;
						}
						stmt.executeUpdate("update student set student.Name0 ='"+text2+"',student.Grade0='"+text3+"',student.English='"+text4+"',student.Java='"+text5+"',student.Maths='"+text6+"' where student.Number0='"+text+"'");
						break;
					}
				}
				stmt.close();
				con.close();
				JOptionPane.showMessageDialog(dialog,"修改成功！");
				dialog.dispose();
				}catch(Exception ex){
					System.out.println(ex.getMessage());
				}
			}
		}
		else if(cmd.equals("取消"))
		{
			dialog.dispose();
		}
		
	}
}