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.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 StudentInfoTableFrame extends JFrame {

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

	/**
	 * Create the frame
	 */
	public StudentInfoTableFrame() {
		super();
		setResizable(false);
		setBounds(100, 100, 605, 451);
		setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

		final JPanel panel = new JPanel();
		panel.setLayout(null);
		getContentPane().add(panel, BorderLayout.CENTER);
         
		model=new DefaultTableModel();
		model.addColumn("學(xué)號");
		model.addColumn("姓名");
		model.addColumn("性別");
		model.addColumn("民族");
		model.addColumn("班級");
		model.addColumn("出生日期");
		model.addColumn("籍貫");

		final JScrollPane scrollPane = new JScrollPane();
		panel.add(scrollPane);
		scrollPane.setBounds(26, 76, 563, 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) {
				StudentInfoTableFrame.this.dispose();
			}
		});
		button.setText("退出");
		button.setBounds(491, 342, 80, 23);
		panel.add(button);

		final JLabel label = new JLabel();
		panel.add(label);
		label.setText("以下為查詢結(jié)果：");
		label.setBounds(26, 39, 109, 15);

		final JLabel label_1 = new JLabel();
		panel.add(label_1);
		label_1.setIcon(SwingResourceManager.getIcon(StudentInfoTableFrame.class, "/images/ee.jpg"));
		label_1.setText(" ");
		label_1.setBounds(0, 0, 600, 419);
		//
	}
	public void showTableStudentInfo(ResultSet rs)
	{
		try {
			 
			while(rs.next())
			{
				vector=new Vector(1,1);
				vector.add(rs.getString("ID"));
				vector.add(rs.getString("Name"));
				vector.add(rs.getString("Sex"));
				vector.add(rs.getString("Ethnic"));
				vector.add(rs.getString("Class"));
				vector.add(rs.getString("Birth"));
				vector.add(rs.getString("Home"));
				model.addRow(vector);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		
	}

}