import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
public class AddForm implements ActionListener 
{
	JDialog dialog;
	JTextField tF1=new JTextField();
	JTextField tF2=new JTextField();
	JTextField tF3=new JTextField();
	JTextField tF4=new JTextField();
	JTextField tF5=new JTextField();
	JTextField tF6=new JTextField();
	public AddForm (JFrame f)
	{
		dialog=new JDialog(f,"學生信息添加系統",true);
		Container dialogPan=dialog.getContentPane();
		dialogPan.setLayout(new GridLayout(7,2));
		
		dialogPan.add(new JLabel("學號：",SwingConstants.CENTER));
		dialogPan.add(tF1);
		
		dialogPan.add(new JLabel("姓名：",SwingConstants.CENTER));
		dialogPan.add(tF2);
		
		dialogPan.add(new JLabel("班級：",SwingConstants.CENTER));
		dialogPan.add(tF3);
		
		dialogPan.add(new JLabel("英語：",SwingConstants.CENTER));
		dialogPan.add(tF4);
		
		dialogPan.add(new JLabel("Java：",SwingConstants.CENTER));
		dialogPan.add(tF5);
		
		dialogPan.add(new JLabel("高數：",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 text1=tF1.getText();
		String text2=tF2.getText();
		String text3=tF3.getText();
		String text4=tF4.getText();
		String text5=tF5.getText();
		String text6=tF6.getText();
		int single=0;
		
		if(cmd.equals("保存"))
		{
			if(text1.equals("")||text2.equals("")||text3.equals("")||text4.equals("")||text5.equals("")||text6.equals(""))
			{
				JOptionPane.showMessageDialog(dialog,"添加項不能為空！");
			}
			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(text1.equals(rs.getString(1)))
					{
						JOptionPane.showMessageDialog(dialog,"該學生紀錄已經存在！");
						tF1.setText("");
						tF2.setText("");
						tF3.setText("");
						tF4.setText("");
						tF5.setText("");
						tF6.setText("");
						single=1;
						break;
					}
				}
				
				if(single==1)
				{
					return;
				}
				float English=Float.parseFloat(tF4.getText());
	
				float Java=Float.parseFloat(tF5.getText());
				float Maths=Float.parseFloat(tF6.getText());
				if(English<0||English>100||Java<0||Java>100||Maths<0||Maths>100)
				{
					JOptionPane.showMessageDialog(dialog,"成績輸入有誤，請重新輸入！");
					if(English<0||English>100)
						tF4.setText("");
					if(Java<0||Java>100)
						tF5.setText("");
					if(Maths<0||Maths>100)
						tF6.setText("");
					return;
				}
				
				String SQLOrder="INSERT INTO student VALUES('"+text1+"','"+text2+"','"+text3+"','"+text4+"','"+text5+"','"+text6+"')";
				
				stmt.executeUpdate(SQLOrder);
				stmt.close();
				con.close();
				JOptionPane.showMessageDialog(dialog,"添加成功！");
				dialog.dispose();
				}catch(Exception ex){}
			}
		}
		else if(cmd.equals("取消"))
		{
			dialog.dispose();
		}
		
	}
}