//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;//定義兩塊面板對象
	//labelPanel用來放標簽，fieldsPanel用來放文本區
	private?String?labels;
	private?JTable?commoditytable;?
	private?JButton?submitQuery;?????
	private?JButton?cancelQuery;?????
????????????JTextField?文字輸入欄;
	String?窗口標題query;
	
	public?Inquest（int?select）?
????{??submitQuery?=?new?JButton（?“查??詢“?）;
????/*----------------------------select=1為查詢已經選上的課程---------------------------*/
????????if（select==1）
????????{
????????	labels=new?String（“請輸入課程號“）;
????????	窗口標題=?new?String（“已選課程查詢窗口“）;
????????	query?=new?String（“SELECT?成績表.課程號課程名學時學分學期教師分數?FROM?課程信息表成績表?WHERE?課程信息表.課程號=成績表.課程號“）;
????????	query?=?query+“?AND?學號=‘“+Loginframe.userNameTextField.getText（）+“‘“;
????????}
???/*----------------------------select=2為選課申請---------------------------*/
????????else?if（select==2）
????????{
????????	labels=new?String（“請輸入課程號“）;
????????	窗口標題=?new?String（“選課申請窗口“）;
????????	submitQuery.setText（“申請“）;
????????	query?=new?String（“SELECT?*?FROM?課程信息表“）;
???????	}
??/*----------------------------select=3成績查詢---------------------------*/
????????else?if（select==3）
????????{
????????	labels=new?String（“請輸入課程號“）;
????????	窗口標題=?new?String（“成績查詢窗口“）;
????????	query?=new?String（“SELECT?成績表.課程號課程名學分學期教師分數??FROM?成績表課程信息表?WHERE?成績表.課程號=課程信息表.課程號“）;
????????	query=query+“?AND?學號=‘“+Loginframe.userNameTextField.getText（）+“‘“;
????????}
??/*----------------------------select=4選課名單（教師查詢）---------------------------*/
????????else?if（select==4）
????????{
????????	labels=new?String（“請輸入課程號“）;
????????	窗口標題=?new?String（“選課名單查詢窗口“）;
????????	query?=new?String（“SELECT?成績表.學號姓名成績表.課程號課程名??“
????????	?????+“?FROM?學生基本信息表成績表課程信息表教師表?“
????????	?????+“?WHERE?成績表.學號=學生基本信息表.學號?“
????????	?????+“?AND??成績表.課程號=課程信息表.課程號?“）;
????????	query=query+“?AND?登陸帳號=‘“+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（）;
????????文字輸

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

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

?????文件???????1051??2004-12-24?22:36??SQL生成數據表.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\學生選課管理系統_Data.MDF

?????文件????1048576??2005-01-21?23:03??DATA\學生選課管理系統_Log.LDF

............此處省略16個文件信息