package com.sccp.StudentMS.baseFrame;


import java.awt.BorderLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Vector;

import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.table.AbstractTableModel;
import javax.swing.table.DefaultTableModel;
import com.swtdesigner.SwingResourceManager;

public class StudentMarkTableFrame extends JFrame {

	
	private JTable table;
	private Vector vector;
	DefaultTableModel model;
	private JLabel label ;
	/**
	 * Launch the application
	 * @param args
	 */
	public static void main(String args[]) {
		try {
			StudentMarkTableFrame frame = new StudentMarkTableFrame();
			frame.setVisible(true);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	/**
	 * Create the frame
	 */
	public StudentMarkTableFrame() {
		super();
		setBounds(100, 100, 593, 413);
		setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

		final JPanel panel = new JPanel();
		panel.setLayout(null);
		getContentPane().add(panel, BorderLayout.CENTER);
         
		model=new DefaultTableModel();
		model.addColumn("學號");
		model.addColumn("總分");
		model.addColumn("政治");
		model.addColumn("高數");
		model.addColumn("英語");
		model.addColumn("專業課");

		final JScrollPane scrollPane = new JScrollPane();
		panel.add(scrollPane);
		scrollPane.setBounds(44, 68, 517, 242);
		table = new JTable(model);		 
		table.setColumnSelectionAllowed(true);
		scrollPane.setViewportView(table);
		

		final JButton button = new JButton();
		button.addActionListener(new ActionListener() {
			public void actionPerformed(final ActionEvent e) {
				StudentMarkTableFrame.this.dispose();
			}
		});
		button.setText("退出");
		button.setBounds(429, 343, 80, 23);
		panel.add(button);

	label= new JLabel();
		label.setText("以下為查詢結果：");
		label.setBounds(44, 32, 109, 15);
		panel.add(label);

		final JLabel label_1 = new JLabel();
		label_1.setIcon(SwingResourceManager.getIcon(StudentMarkTableFrame.class, "/images/dd.JPG"));
		label_1.setText(" ");
		label_1.setBounds(0, 0, 585, 391);
		panel.add(label_1);
		//
	}
	public void resultShow(ResultSet rs)
	{
		try {
			while(rs.next())
			{
			 	vector = new Vector(1,1);
			 	vector.add(rs.getString("ID"));
			 	vector.add(rs.getString("Total"));
			 	vector.add(rs.getString("philosophy"));
			 	vector.add(rs.getString("math"));
			 	vector.add(rs.getString("english"));
			 	vector.add(rs.getString("specialty"));
			 	model.addRow(vector);
			 	
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			JOptionPane.showMessageDialog(null,"成績查詢時出錯！");
			e.printStackTrace();
		}
	}
	public void sortFrame(StudentMarkTableFrame smtf)
	{
		smtf.label.setText("以下為排序結果：");
	}

}