//package?myprojects.main;
import?java.sql.*;?
import?javax.swing.*;?
import?java.awt.*;?
import?java.awt.event.*;?
import?java.util.*;?

public?class?Inquest?extends?JDialog?
{
	private?Connection?queryconnection;?
???	private?Statement?querystatement;?
???	private?ResultSet?queryresultSet;?
???	private?ResultSetmetaData?rsmetaData;
??
????//GUI變量定義
	private?Jframe?parent;?
	private?JPanel?labelPanel?tablePanel;//定義兩塊面板對(duì)象
	//labelPanel用來放標(biāo)簽，fieldsPanel用來放文本區(qū)
	private?String?labels;
	private?JTable?commoditytable;?
	private?JButton?submitQuery;?????
	private?JButton?cancelQuery;?????
????????????JTextField?文字輸入欄;
	String?窗口標(biāo)題query;
	
	public?Inquest（int?select）?
????{??submitQuery?=?new?JButton（?“查??詢“?）;
????/*----------------------------select=1為查詢已經(jīng)選上的課程---------------------------*/
????????if（select==1）
????????{
????????	labels=new?String（“請(qǐng)輸入課程號(hào)“）;
????????	窗口標(biāo)題=?new?String（“已選課程查詢窗口“）;
????????	query?=new?String（“SELECT?成績(jī)表.課程號(hào)課程名學(xué)時(shí)學(xué)分學(xué)期教師分?jǐn)?shù)?FROM?課程信息表成績(jī)表?WHERE?課程信息表.課程號(hào)=成績(jī)表.課程號(hào)“）;
????????	query?=?query+“?AND?學(xué)號(hào)=‘“+Loginframe.userNameTextField.getText（）+“‘“;
????????}
???/*----------------------------select=2為選課申請(qǐng)---------------------------*/
????????else?if（select==2）
????????{
????????	labels=new?String（“請(qǐng)輸入課程號(hào)“）;
????????	窗口標(biāo)題=?new?String（“選課申請(qǐng)窗口“）;
????????	submitQuery.setText（“申請(qǐng)“）;
????????	query?=new?String（“SELECT?*?FROM?課程信息表“）;
???????	}
??/*----------------------------select=3成績(jī)查詢---------------------------*/
????????else?if（select==3）
????????{
????????	labels=new?String（“請(qǐng)輸入課程號(hào)“）;
????????	窗口標(biāo)題=?new?String（“成績(jī)查詢窗口“）;
????????	query?=new?String（“SELECT?成績(jī)表.課程號(hào)課程名學(xué)分學(xué)期教師分?jǐn)?shù)??FROM?成績(jī)表課程信息表?WHERE?成績(jī)表.課程號(hào)=課程信息表.課程號(hào)“）;
????????	query=query+“?AND?學(xué)號(hào)=‘“+Loginframe.userNameTextField.getText（）+“‘“;
????????}
??/*----------------------------select=4選課名單（教師查詢）---------------------------*/
????????else?if（select==4）
????????{
????????	labels=new?String（“請(qǐng)輸入課程號(hào)“）;
????????	窗口標(biāo)題=?new?String（“選課名單查詢窗口“）;
????????	query?=new?String（“SELECT?成績(jī)表.學(xué)號(hào)姓名成績(jī)表.課程號(hào)課程名??“
????????	?????+“?FROM?學(xué)生基本信息表成績(jī)表課程信息表教師表?“
????????	?????+“?WHERE?成績(jī)表.學(xué)號(hào)=學(xué)生基本信息表.學(xué)號(hào)?“
????????	?????+“?AND??成績(jī)表.課程號(hào)=課程信息表.課程號(hào)?“）;
????????	query=query+“?AND?登陸帳號(hào)=‘“+Loginframe.userNameTextField.getText（）
????????	?????+“‘?AND?課程信息表.教師=教師表.教師?“;
????????}
??/*-----------------------------------------------------------------------*/
????????pack（）;
????????submitQuery.setPreferredSize（new?Dimension（120?25））;
????????submitQuery.addActionListener（new?ActionLis（select））;
????????cancelQuery?=?new?JButton（?“返??回“?）;
????????cancelQuery.setPreferredSize（new?Dimension（120?25））;
????	cancelQuery.addActionListener（?
?????????new?ActionListener（）?
?????????{?
????????????public?void?actionPerformed（?ActionEvent?e?）?
????????????{?
???????????????	setVisible（false）;
???????????????	dispose（）;
????????????}?
?????????}???
????????）;?
????????
????????Box?box?=?Box.createHorizontalBox（）;
????????文字輸

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

?????文件???????1945??2005-10-18?00:51??readme.txt

?????文件???????1051??2004-12-24?22:36??SQL生成數(shù)據(jù)表.txt

?????文件????????516??2005-01-21?23:21??classes\InquestCourse$1.class

?????文件????????555??2005-01-21?23:21??classes\InquestCourse$2.class

?????文件???????5731??2005-01-21?23:21??classes\InquestCourse.class

?????文件?????????74??2005-01-21?23:46??classes\readme.txt

?????文件?????????10??2005-01-21?23:46??classes\Run.bat

?????文件????????468??2005-05-13?21:55??classes\Loginframe$1.class

?????文件????????705??2005-05-13?21:55??classes\Loginframe$2.class

?????文件????????953??2005-05-13?21:55??classes\Loginframe$3.class

?????文件????????542??2005-05-13?21:55??classes\Loginframe$4.class

?????文件????????491??2005-05-13?21:55??classes\Loginframe$5.class

?????文件???????6297??2005-05-13?21:55??classes\Loginframe.class

?????文件????????339??2005-05-13?21:55??classes\Main.class

?????文件????????476??2005-05-13?21:55??classes\Managerframe$1.class

?????文件???????8200??2005-05-13?21:55??classes\Managerframe.class

?????文件???????5157??2005-05-13?21:55??classes\ModifyPassword.class

?????文件???????6582??2005-05-13?21:55??classes\Stat.class

?????文件???????7350??2005-05-13?21:55??classes\Student.class

?????文件????????476??2005-05-13?21:55??classes\Studentframe$1.class

?????文件???????4791??2005-05-13?21:55??classes\Studentframe.class

?????文件????????476??2005-05-13?21:55??classes\Teacherframe$1.class

?????文件???????4939??2005-05-13?21:55??classes\Teacherframe.class

?????文件????????515??2005-05-13?21:55??classes\Inquest$1.class

?????文件???????1908??2005-05-13?21:55??classes\Inquest$ActionLis.class

?????文件???????7672??2005-05-13?21:55??classes\Inquest.class

?????文件??????17599??2005-05-13?21:55??classes\Insert.class

?????目錄??????????0??2005-01-21?23:44??classes

?????文件????1048576??2005-01-21?23:03??DATA\學(xué)生選課管理系統(tǒng)_Data.MDF

?????文件????1048576??2005-01-21?23:03??DATA\學(xué)生選課管理系統(tǒng)_Log.LDF

............此處省略16個(gè)文件信息