package com.sccp.StudentMS.baseFrame;

import java.awt.BorderLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.util.Vector;
import javax.swing.JOptionPane;

import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
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;
import java.sql.ResultSet;
import java.sql.SQLException;
public class MarkSortTableFrame extends JFrame {

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

	/**
	 * Create the frame
	 */
	public MarkSortTableFrame() {
		super();
		setBounds(100, 100, 591, 518);
		setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

		final JPanel panel = new JPanel();
		panel.setLayout(null);
		getContentPane().add(panel, BorderLayout.CENTER);
         
		model=new DefaultTableModel();
		model.addColumn("學(xué)號(hào)");
		model.addColumn("總分");
		model.addColumn("政治");
		model.addColumn("高數(shù)");
		model.addColumn("英語");
		model.addColumn("專業(yè)課");

		final JScrollPane scrollPane = new JScrollPane();
		panel.add(scrollPane);
		scrollPane.setBounds(44, 68, 513, 281);
		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) {
				MarkSortTableFrame.this.dispose();
			}
		});
		button.setText("退出");
		button.setBounds(456, 408, 80, 23);
		panel.add(button);

		final JLabel label = new JLabel();
		label.setText("以下為排序結(jié)果：");
		label.setBounds(44, 32, 109, 15);
		panel.add(label);

		final JLabel label_1 = new JLabel();
		label_1.setText(" ");
		label_1.setBounds(0, 0, 600, 419);
		panel.add(label_1);

		final JLabel label_2 = new JLabel();
		label_2.setIcon(SwingResourceManager.getIcon(MarkSortTableFrame.class, "/images/2942.gif"));
		label_2.setText(" ");
		label_2.setBounds(10, 355, 128, 128);
		panel.add(label_2);

		final JLabel label_3 = new JLabel();
		label_3.setIcon(SwingResourceManager.getIcon(MarkSortTableFrame.class, "/images/ff.JPG"));
		label_3.setText(" ");
		label_3.setBounds(0, 0, 583, 525);
		panel.add(label_3);
		//
	}
	public void showTableMarkInfo(ResultSet rs)
	{
		try{
			while(rs.next())
			{   vector=new Vector(1,1);
				vector.add(rs.getString(1));
			    vector.add(rs.getString(3));
			    vector.add(rs.getString(4));
			    vector.add(rs.getString(5));
			    vector.add(rs.getString(6));
			    vector.add(rs.getString(7));
			    model.addRow(vector);
			    }
			    	
		}catch(Exception e)
		{
			System.out.println("顯示table信息時(shí)出錯(cuò)！");
			e.printStackTrace();
		}
		
	}

}