import?java.awt.*;
import?javax.swing.*;
import?java.awt.event.*;
import?java.sql.*;
public?class?admin?extends?Jframe{
????int?WIDTH=768;
????int?HEIGHT=522;
????private?JTextField?studentID;//查詢學(xué)生信息
????private?JTextField?student_name;
????private?JComboBox?student_sex;
????private?JTextField?student_age;
????private?JComboBox?student_college;
????private?JTextArea?student_display;
????private?JTextField?s_number;
????
????private?JTextField?cstudentID;//修改學(xué)生信息
????private?JTextField?cstudent_name;
????private?JComboBox?cstudent_sex;
????private?JTextField?cstudent_age;
????private?JComboBox?cstudent_college;
????
????private?JTextField?teacherID;
????private?JTextField?teacher_name;
????private?JComboBox?teacher_sex;
????private?JTextField?teacher_age;
????private?JComboBox?teacher_college;
????private?JTextField?teacher_salary;
????private?JTextArea?teacher_display;
????private?JTextField?t_number;
????
????private?JTextField?cteacherID;
????private?JTextField?cteacher_name;
????private?JComboBox?cteacher_sex;
????private?JTextField?cteacher_age;
????private?JComboBox?cteacher_college;
????private?JTextField?cteacher_salary;
	
????private?JTextField?course_number;
????private?JTextField?course_name;
????private?JTextField?course_pre_number;
????private?JTextField?course_credit;
????private?JTextArea?course_display;
????private?JTextField?c_number;
????private?JTextField?course_teacher;
????
????
????private?JTextField?change_course_number;
????private?JTextField?change_course_name;
????private?JTextField?change_course_pre_number;
????private?JTextField?change_course_credit;
????//private?JTextField?change_course_teacher;
????private?JTextField?add_course_number;
????private?JTextField?add_course_teacher;
????
????String?driverName?=?“sun.jdbc.odbc.JdbcOdbcDriver“;?//?加載JDBC驅(qū)動(dòng)
	String?dbURL?=?“jdbc:odbc:stu“;?//?連接服務(wù)器和數(shù)據(jù)庫(kù)sample
	String?userName?=?“sa“;?//?默認(rèn)用戶名
	String?userPwd?=?“weier“;?//?密碼
	java.sql.Connection?connection;
	static?java.sql.Statement?s;
	ResultSet?result=null;
	admin（）{
		super（）;
		
		try?{
			Class.forName（driverName）;
			connection?=?DriverManager.getConnection（dbURL?userName?userPwd）;
			System.out.println（“Connection?Successful!“）;?//?如果連接成功		
			s?=?connection.createStatement（）;
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
		}
		JTabbedPane?operatePane=new?JTabbedPane（JTabbedPane.LEFT）;
		
		
		JPanel?studentPane=new?JPanel（）;//管理學(xué)生信息
		operatePane.add（“管理學(xué)生信息“studentPane）;
		
		JPanel?stu=new?JPanel（）;
		studentPane.add（stu）;
		JTabbedPane?studentChoice=new?JTabbedPane（JTabbedPane.TOP）;
		
		JPanel?studentSelect=new?JPanel（）;
		studentChoice.add（“查詢信息“studentSelect）;
		
		JPanel?messageInput=new?JPanel（）;
		messageInput.setLayout（new?BoxLayout（messageInputBoxLayout.Y_AXIS））;
		
?????	JLabel?a=new?JLabel（“輸入查詢條件??????????????????????????????????????????????????????????????????????????????????????“）;
		messageInput.add（a）;

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件????????383??2009-05-09?20:25??student\.project

?????文件????????226??2009-05-09?20:25??student\.classpath

?????文件??????13512??2009-07-12?10:10??student\log.java

?????文件??????14529??2008-05-02?20:34??student\picture\bear.jpg

?????文件?????768054??2009-05-21?11:50??student\picture\a.jpg

?????文件??????55355??2009-05-21?00:35??student\admin.java

?????文件????????288??2009-05-11?22:41??student\WindowDestroyer.java

?????文件??????16664??2009-05-21?00:25??student\student.java

?????文件??????23915??2009-05-21?00:48??student\teacher.java

?????文件???????1463??2009-05-20?20:48??student\welcome.java

?????文件????????570??2009-11-06?22:19??student\welcome$Listener.class

?????文件???????2360??2009-11-06?22:19??student\welcome.class

?????文件???????7673??2009-11-06?22:19??student\teacher$teacherListener.class

?????文件??????14232??2009-11-06?22:19??student\teacher.class

?????文件??????10926??2009-11-06?22:19??student\student.class

?????文件???????5948??2009-11-06?22:19??student\student$studentListener.class

?????文件???????7481??2009-11-06?22:19??student\log.class

?????文件???????6714??2009-11-06?22:19??student\log$regit.class

?????文件??????22392??2009-11-06?22:19??student\admin.class

?????文件???????9042??2009-11-06?22:19??student\admin$courseListener.class

?????文件???????7613??2009-11-06?22:19??student\admin$teacherListener.class

?????文件???????7035??2009-11-06?22:19??student\admin$studentListener.class

?????文件????????694??2009-11-06?22:19??student\WindowDestroyer.class

?????目錄??????????0??2009-05-09?20:31??student\picture

?????目錄??????????0??2009-05-09?20:25??student

-----------?---------??----------?-----??----

???????????????997069????????????????????25