marksorttableframe.java

学生信息管理系统

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("学号");
		model.addColumn("总分");
		model.addColumn("政治");
		model.addColumn("高数");
		model.addColumn("英语");
		model.addColumn("专业课");

		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("以下为排序结果：");
		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信息时出错！");
			e.printStackTrace();
		}
		
	}

}