//錄入，查詢，修改學(xué)生信息
import javax.swing.*;
import javax.swing.event.*;
import java.awt.*;
import java.awt.event.*;
import java.io.*;
import java.sql.*;
public class student_manage1 extends JFrame implements ActionListener
{
	JTextField sno;
	JTextField sname;
	JTextField ssystem;
	JTextField sage;
	JTextField sclass;
	Label sno1;
	Label sname1;
	Label ssystem1;
	Label sage1;
	Label sclass1;
	JButton a_enter1;
	JButton a_enter2;
	JButton a_enter3;
	JButton b1;
	public student_manage1()
	{
    	super("管理員管理學(xué)生");	
    	sno=new JTextField(20);
		sname=new JTextField(20);
		ssystem=new JTextField(20);
		sage=new JTextField(20);
		sclass=new JTextField(20);
		sno1=new Label("    學(xué)號(hào)    ");
		sname1=new Label("     姓名    ");
	 	ssystem1=new Label("   所在系   ");
	 	sage1=new Label("    年齡    ");
	  	sclass1=new Label("    班級    ");
	 	a_enter1=new JButton("錄入");
	 	a_enter2=new JButton("查詢");
	 	a_enter3=new JButton("修改");
	 	b1=new JButton("返回");
		a_enter1.addActionListener(this);
		a_enter2.addActionListener(this);
		a_enter3.addActionListener(this);
		b1.addActionListener(this);
		JPanel pane=new JPanel();//定義主面板
		pane.setLayout(new FlowLayout());
		pane.add(sno1); 
		pane.add(sno); 
		pane.add(sname1); 
		pane.add(sname);
		pane.add(ssystem1);
		pane.add(ssystem);
		pane.add(sage1);
		pane.add(sage);
		pane.add(sclass1);
		pane.add(sclass);
		pane.add(a_enter1);
		pane.add(a_enter2);
		pane.add(a_enter3);
		pane.add(b1);
		this.add(pane);
	}
	public void actionPerformed(ActionEvent e)
	{
		if(e.getSource()==a_enter1)
		{
			if(!sno.getText().trim().equals("2005211"))
			{
				String s1=sno.getText();
				String s2=sname.getText();
				String s3=ssystem.getText();
				String s4=sage.getText();
				String s5=sclass.getText();
				String url1="jdbc:odbc:agang";
				try{
					Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");  //驅(qū)動(dòng)程序名稱_JDBC/ODBC橋接驅(qū)動(dòng)程序
				}catch(java.lang.ClassNotFoundException e1){}
				try{
				Connection con=DriverManager.getConnection(url1,"",null);//建立連接
				Statement stmt=con.createStatement();
				String sql="INSERT INTO student VALUES('"+s1+"','"+s2+"','"+s3+"','"+s4+"','"+s5+"')";
			  	stmt.executeUpdate(sql); 
			  	stmt.close();
		      	con.close();
				}catch(SQLException e2){System.out.print(e2);}
				new myDialog4();
			}
			else
			{
				new myDialog3();
			}
		}
		else if(e.getSource()==a_enter2){
		
			String url1="jdbc:odbc:agang";
		 	String sql="select * FROM student";
			try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");  //驅(qū)動(dòng)程序名稱_JDBC/ODBC橋接驅(qū)動(dòng)程序
			}catch(java.lang.ClassNotFoundException e4){}
			try{
			Connection con=DriverManager.getConnection(url1,"",null);//建立連接
			Statement stmt=con.createStatement();
		  	ResultSet rs=stmt.executeQuery(sql);
		  	int i=0;
		  	while(rs.next())
		  	{ 
			  String t1=rs.getString("sno");
			  String t2=rs.getString("sname");
			  String t3=rs.getString("ssystem");
			  String t4=rs.getString("sage");
			  String t5=rs.getString("sclass");
			  System.out.println(t1);
			  while(t1.trim().equals(sno.getText()))
			  {
			  	i++;
			  	sname.setText(t2);
			  	ssystem.setText(t3);
			  	sage.setText(t4);
			  	sclass.setText(t5);
			  	break;
			  }
		  	} 
		  	if(i==0)
		  	{
		  		new myDialog8();
		  		sname.setText("");
			  	ssystem.setText("");
			  	sage.setText("");
			  	sclass.setText("");
		  	}
		  stmt.close();
	      con.close();
		}catch(SQLException e5){}
		}
	
		
		else if(e.getSource()==a_enter3){
			int a=0;
				String url1="jdbc:odbc:agang";
			 	String sql5="update student set sname='"+sname.getText()+"' where sno='"+sno.getText()+"'";
			 	String sql6="update student set ssystem='"+ssystem.getText()+"' where sno='"+sno.getText()+"'";
			 	String sql7="update student set sage='"+sage.getText()+"' where sno='"+sno.getText()+"'";
			 	String sql8="update student set sclass='"+sclass.getText()+"' where sno='"+sno.getText()+"'";
				try{
					Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");  //驅(qū)動(dòng)程序名稱_JDBC/ODBC橋接驅(qū)動(dòng)程序
				}catch(java.lang.ClassNotFoundException e1){}
				try{
				Connection con=DriverManager.getConnection(url1,"",null);//建立連接
				Statement stmt=con.createStatement();
			  	stmt.executeUpdate(sql5); 
			  	stmt.executeUpdate(sql6);
			  	stmt.executeUpdate(sql7); 
			  	stmt.executeUpdate(sql8);  
			  	stmt.close();
		      	con.close();
				}catch(SQLException e8){System.out.println(e8.getMessage());}	
				new	myDialog7();
		}
		
		else{
			dispose();
		student_system x1=new student_system();
		x1.setVisible(true);
		x1.setLocation(300,300);
		x1.setSize(600,600);
		}
	}
	public static void main(String args[])
	{
		student_manage1 x=new student_manage1();
		x.setVisible(true);
		x.setLocation(300,300);
		x.setSize(350,500);
	}
}