statgroupinfo.java

这是一个用java语言开发的运动员成绩统计系统

package com.statManage;

import com.MainFrame;
import com.component.MyFrame;
import java.awt.Color;
import java.awt.Dimension;
import java.awt.Font;
import java.awt.Rectangle;
import java.awt.print.PrinterException;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Vector;
import javax.swing.JButton;
import javax.swing.JLabel;
import javax.swing.JScrollPane;
import javax.swing.JTable;

/**
 * @author  Laiger
 */
public class StatGroupInfo extends MyFrame {

	private JLabel jLabel = null;
	private JScrollPane jScrollPane = null;
	private JTable jTable = null;
	private JButton print = null;
	public Vector totalScore=new Vector();

	/**
	 * This method initializes 
	 * 
	 */
	public StatGroupInfo(MainFrame m) {
		super(m);
		initialize();
	}
	public StatGroupInfo() {
		super();
		initialize();
	}
	/**
	 * This method initializes this
	 * 
	 */
	private void initialize() {
        jLabel = new JLabel();
        jLabel.setBounds(new Rectangle(189, 29, 281, 39));
        jLabel.setText("各团队成绩统计信息");
        jLabel.setFont(new Font("黑体",Font.BOLD,27));
        jLabel.setForeground(Color.blue);
        
        this.setSize(new Dimension(663, 310));
        this.setTitle("团队信息统计");
        this.add(jLabel, null);
        this.add(getJScrollPane(), null);
        this.add(getPrint(), null);
			
	}

	/**
	 * This method initializes jScrollPane	
	 * @return  javax.swing.JScrollPane
	 * @uml.property  name="jScrollPane"
	 */
	private JScrollPane getJScrollPane() {
		if (jScrollPane == null) {
			jScrollPane = new JScrollPane();
			jScrollPane.setBounds(new Rectangle(16, 81, 638, 173));
			jScrollPane.setViewportView(getJTable());
		}
		return jScrollPane;
	}

	/**
	 * This method initializes jTable	
	 * @return  javax.swing.JTable
	 * @uml.property  name="jTable"
	 */
	private JTable getJTable() {
		if (jTable == null) {
			jTable = new JTable();
			this.updateTable();
		}
		return jTable;
	}

	/**
	 * This method initializes print	
	 * @return  javax.swing.JButton
	 * @uml.property  name="print"
	 */
	private JButton getPrint() {
		if (print == null) {
			print = new JButton();
			print.setBounds(new Rectangle(283, 270, 92, 27));
			print.setText("打印");
			print.addActionListener(new java.awt.event.ActionListener() {
				public void actionPerformed(java.awt.event.ActionEvent e) {
					try {
						jTable.print();
					} catch (PrinterException e1) {
						
						e1.printStackTrace();
					}
				}
			});
		}
		return print;
	}

	public void updateTable(){
		Vector row=new Vector();
		Vector col=new Vector();
		col.add("团队号");col.add("团队名");col.add("负责人");col.add("电话");col.add("人数");col.add("总分");
		
		
	String sql="select g.groupid,g.name,g.principal,g.phone,";
	   sql+="g.athleteAmount,sum(a.score) as s ";
	   sql+="from groupinfo g,achievement a,groupathlete ga ";  
	   sql+="where ga.groupid=g.groupid and ga.athlete=a.athleteid group by g.groupid order by s desc";
		System.out.println(sql);
		
		ResultSet rs=db.executeQuery(sql);
		
		try {
			while(rs.next()){
				Vector v=new Vector();
				v.add(rs.getString("groupid"));
				v.add(rs.getString("name"));
				v.add(rs.getString("principal"));
				v.add(rs.getString("phone"));
				v.add(rs.getString("athleteAmount"));
				v.add(rs.getString("s"));
				
				row.add(v);
				
			}
			
		} catch (SQLException e) {
		
			e.printStackTrace();
		}
		jTable=new JTable(row,col);
		jScrollPane.setViewportView(jTable);	
	}
}