import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.net.*;
import java.sql.*;
import java.lang.*;

public class Add extends JFrame
{
	JPanel contentPane;
	JLabel label1=new JLabel("輸入新的學生資料",JLabel.CENTER);
	JTextField stu_number=new JTextField();
	JTextField name=new JTextField();
	JTextField sex=new JTextField();
	JTextField age=new JTextField();
	JTextField department=new JTextField();
	JTextField classes=new JTextField();
	JTextField pho_number=new JTextField();
	JTextField qinshi=new JTextField();
	JTextField remark=new JTextField();
	JLabel 學號=new JLabel("學號：",JLabel.CENTER);
	JLabel 姓名=new JLabel("姓名：",JLabel.CENTER);
	JLabel 性別=new JLabel("性別：",JLabel.CENTER);
	JLabel 年齡=new JLabel("年齡：",JLabel.CENTER);
	JLabel 系別=new JLabel("系別：",JLabel.CENTER);
	JLabel 班級=new JLabel("班級：",JLabel.CENTER);
	JLabel 電話=new JLabel("電話：",JLabel.CENTER);
	JLabel 寢室=new JLabel("寢室：",JLabel.CENTER);
	JLabel 備注=new JLabel("備注：",JLabel.CENTER);
	JButton button1=new JButton("ADD");
	JButton button2=new JButton("CANCEL");
	int x=0,y=0,w,h;

	public Add()
	{
		final JFrame frame=this;
		contentPane = (JPanel) this.getContentPane();
		contentPane.setLayout(null);
		label1.setFont(new java.awt.Font("Dialog", 1, 20));
		contentPane.add(label1,null);
		contentPane.add(學號,null);
		contentPane.add(stu_number,null);
		contentPane.add(姓名,null);
		contentPane.add(name,null);
		contentPane.add(性別,null);
		contentPane.add(sex,null);
		contentPane.add(年齡,null);
		contentPane.add(age,null);
		contentPane.add(系別,null);
		contentPane.add(department,null);
		contentPane.add(班級,null);
		contentPane.add(classes,null);
		contentPane.add(電話,null);
		contentPane.add(pho_number,null);
		contentPane.add(寢室,null);
		contentPane.add(qinshi,null);
		contentPane.add(備注,null);
		contentPane.add(remark,null);
        contentPane.add(button1,null);
		contentPane.add(button2,null);
		this.setBounds(new Rectangle(150,150,400,350));
		w=this.getSize().width;
		h=this.getSize().height;
		x=w/8;
		y=h/12;
		label1.setBounds(new Rectangle(2*x,0,4*x,2*y));
		學號.setBounds(new Rectangle(0,2*y,2*x,y));
		stu_number.setBounds(new Rectangle(2*x,2*y,3*x,y));

		姓名.setBounds(new Rectangle(0,3*y,2*x,y));
		name.setBounds(new Rectangle(2*x,3*y,2*x,y));

		性別.setBounds(new Rectangle(0,4*y,2*x,y));
		sex.setBounds(new Rectangle(2*x,4*y,x,y));

		年齡.setBounds(new Rectangle(0,5*y,2*x,y));
		age.setBounds(new Rectangle(2*x,5*y,x,y));

		系別.setBounds(new Rectangle(0,6*y,2*x,y));
		department.setBounds(new Rectangle(2*x,6*y,3*x,y));

		班級.setBounds(new Rectangle(0,7*y,2*x,y));
		classes.setBounds(new Rectangle(2*x,7*y,2*x,y));

		電話.setBounds(new Rectangle(0,8*y,2*x,y));
		pho_number.setBounds(new Rectangle(2*x,8*y,3*x,y));

		寢室.setBounds(new Rectangle(0,9*y,2*x,y));
		qinshi.setBounds(new Rectangle(2*x,9*y,2*x,y));

		備注.setBounds(new Rectangle(0,10*y,2*x,y));
		remark.setBounds(new Rectangle(2*x,10*y,5*x,y));

		button1.setBounds(new Rectangle(5*x,2*y,2*x,y));
		button2.setBounds(new Rectangle(5*x,4*y,2*x,y));
		button1.addActionListener(new ActionListener()
		{
			public void actionPerformed(ActionEvent e)
			{
				if(e.getSource()==button1)
		       {
					if(stu_number.getText().equals(""))
				   {
						JOptionPane.showMessageDialog(null,"不能空！","Message",0);
				   }
				   else
				   {
					   try
					   {
						   Addstudent();
					   }
					   catch(SQLException ee)
					   {
					   }
				   }
			   }
			}
		});

		this.setResizable(false);
		this.setTitle("Add");
		this.setDefaultCloseOperation(JFrame.HIDE_ON_CLOSE);
		this.show();
	}
    public void Addstudent() throws SQLException
	{
		String s="'"+stu_number.getText()+"'"+"'"+name.getText()+"'"+"'"+sex.getText()+"'"+"'"+age.getText()+"'"+"'"+department.getText()+"'"+"'"+classes.getText()+"'"+"'"+pho_number.getText()+"'"+"'"+qinshi.getText()+"'"+"'"+remark.getText()+"'";
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		}
		catch(ClassNotFoundException e)
		{
		}
		Connection con=DriverManager.getConnection("jdbc:odbc:asan","","");
		Statement sql=con.createStatement();
		String s1="INSERT INTO student VALUES"+"("+s+")";
		sql.executeUpdate(s1);
		JOptionPane.showMessageDialog(null,"Username or Password Error!","Message",0);
	}

	//public static void main(String args[])
	//{
		//Add add=new Add();
	//}
}