sturankstat.java

学生成绩管理系统,可以修改

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
import javax.swing.table.*;
import java.util.Vector;
public class StuRankStat extends JFrame implements ActionListener {
	DataBaseManager db = new DataBaseManager();
	ResultSet rs;
	Container c;
	JPanel panel1, panel2;
	JLabel StuNuLabel;
	JTextField StuNuTextField;
	JButton SearchBtn, ExitBtn;
	JTable table = null;
	DefaultTableModel defaultModel = null;
public StuRankStat() {
		super("统计名次");
		c = getContentPane();
		c.setLayout(new BorderLayout());
		StuNuLabel = new JLabel("学号   ", JLabel.CENTER);
		StuNuTextField = new JTextField(15);
		SearchBtn = new JButton("统计");
		ExitBtn = new JButton("退出");
		SearchBtn.addActionListener(this);
		ExitBtn.addActionListener(this);
		Box box1 = Box.createHorizontalBox();
		box1.add(StuNuLabel);
		box1.add(StuNuTextField);
		box1.add(SearchBtn);
		Box box2 = Box.createHorizontalBox();
		box2.add(ExitBtn);
		Box boxH = Box.createVerticalBox();
		boxH.add(box1);
		boxH.add(box2);
		boxH.add(Box.createVerticalGlue());
		panel1 = new JPanel();
		panel1.add(boxH);
		panel2 = new JPanel();
		String[] name = { "学号","总分" ,"名次"};
		String[][] data = new String[0][0];
		defaultModel = new DefaultTableModel(data, name);
		table = new JTable(defaultModel);
		table.setPreferredScrollableViewportSize(new Dimension(400, 180));
		JScrollPane s = new JScrollPane(table);
		panel2.add(s);
		c.add(panel1, BorderLayout.NORTH);
		c.add(panel2, BorderLayout.SOUTH);
	}
public void actionPerformed(ActionEvent e) {
      		if (e.getSource() == ExitBtn) {
      			this.dispose();
      		} else if (e.getSource() == SearchBtn) {
      			String strSQL = "select 学号,sum(成绩) as 总分,rank() over(order by sum(成绩) desc) as 名次 from cj group by 学号";		 
      			try {
      				// 首先要删除table中的数据：
      				int rowCount = defaultModel.getRowCount() - 1;// 取得table中的数据行；
      				int j = rowCount;
      				for (int i = 0; i <= rowCount; i++) {
      					defaultModel.removeRow(j);// 删除rowCount行的数据；
      					defaultModel.setRowCount(j);// 重新设置行数；
      					j = j - 1;
      				}
      				rs = db.getResult(strSQL); 
      				while (rs.next()) {
      					Vector data=new Vector();
      					data.addElement(rs.getString(1));
      					data.addElement(rs.getString(2));
      					data.addElement(rs.getString(3));
      					defaultModel.addRow(data);
      				}
      				table.revalidate();
      			} catch (SQLException sqle) {
      				System.out.println(sqle.toString());
      			} catch (Exception ex) {
      				System.out.println(ex.toString());
      			}
      		}
      	}
}