package Cstudent;

import java.awt.*;
import java.sql.*;
import javax.swing.*;
import javax.swing.table.*;
import java.util.*;
import java.awt.event.*;
import java.net.*;

/**
 * 顯示成績查詢模塊查詢結果的類
 */
public class ResultGrade extends JFrame {
	JLabel jLabel1 = new JLabel();
	JButton jBExit = new JButton();
	JScrollPane jScrollPane1 ;
	JTable jTabStuInfo;

	String sNum;
	String[] colName = {"學號","姓名","課程號","課程名稱","成績"};
	String[][] colValue;
	
	public ResultGrade(String sNum) {
		this.setTitle("成績查詢結果");
		
		Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
		this.setLocation( (int) (screenSize.width - 400) / 2 ,
						(int) (screenSize.height - 300) / 2 + 45);

		this.sNum = sNum;
		csBean rGrade = new csBean();
		try {
			colValue = rGrade.csAllSearch(sNum,5);	
			if(colValue == null){
				JOptionPane.showMessageDialog(null, "沒有符合條件的記錄"); 
				this.dispose();
			}
			else{
				jTabStuInfo = new JTable(colValue,colName);
				jScrollPane1 = new JScrollPane(jTabStuInfo);
				this.getContentPane().add(jScrollPane1,BorderLayout.CENTER);
				this.pack();
				this.setVisible(true);
			}
		}
		catch(Exception e) {
		}
	}

	
}