statprojectinfo.java

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

package com.statManage;

import com.MainFrame;
import com.component.MyFrame;
import java.awt.Dimension;
import java.awt.Rectangle;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.print.PrinterException;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Vector;
import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JScrollPane;
import javax.swing.JTable;

/**
 * @author  Laiger
 */
public class StatProjectInfo extends MyFrame implements ActionListener{

	private JLabel jLabel = null;
	private JComboBox jComboBox1 = null;
	private JScrollPane jScrollPane = null;
	private JTable jTable = null;
	private JButton print = null;

	/**
	 * This method initializes 
	 * 
	 */
	public StatProjectInfo(MainFrame m) {
		super(m);
		initialize();
	}
	public StatProjectInfo() {
		super();
		initialize();
	}
	/**
	 * This method initializes this
	 * 
	 */
	private void initialize() {
        jLabel = new JLabel();
        jLabel.setBounds(new Rectangle(57, 38, 61, 26));
        jLabel.setText("选择项目");
        this.setSize(new Dimension(602, 289));
        this.setTitle("项目成绩信息统计");
        this.add(jLabel, null);
        this.add(getJComboBox1(), null);
        this.add(getJScrollPane(), null);
        this.add(getPrint(), null);
			
	}

	/**
	 * This method initializes jComboBox1	
	 * @return  javax.swing.JComboBox
	 * @uml.property  name="jComboBox1"
	 */
	private JComboBox getJComboBox1() {
		if (jComboBox1 == null) {
			jComboBox1 = new JComboBox();
			jComboBox1.setBounds(new Rectangle(165, 35, 156, 33));
			
			ResultSet rs=db.executeQuery("select * from project");
			try {
				while(rs.next()){
					jComboBox1.addItem(rs.getString("id"));
				}
			} catch (SQLException e) {
				
				e.printStackTrace();
			}
		}
		jComboBox1.setSelectedIndex(-1);
		jComboBox1.addActionListener(this);
		return jComboBox1;
	}

	/**
	 * 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(14, 92, 575, 146));
			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();
		}
		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(258, 249, 122, 29));
			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;
	}

	@Override
	public void actionPerformed(ActionEvent arg0) {
		if(jComboBox1.getSelectedIndex()<0){
			JOptionPane.showMessageDialog(this,"请先选择一个项目！");
			return;
		}
		Vector row=new Vector();
		Vector col=new Vector();
		col.add("学生编号");col.add("姓名");col.add("学院");col.add("性别");col.add("成绩");col.add("得分");
		String proID=jComboBox1.getSelectedItem().toString().trim();
		
		String sql="select a.id,a.name,a.academe,a.sex,b.achievement,b.score ";
		sql+="from athlete a,achievement b ";
		sql+=" where b.projectid='"+proID+"' and b.athleteid=a.id order by score desc";
          
		ResultSet rs=db.executeQuery(sql);
		
		try {
			while(rs.next()){
				Vector v=new Vector();
				v.add(rs.getString("id"));
				v.add(rs.getString("name"));
				v.add(rs.getString("academe"));
				v.add(rs.getString("sex"));
				v.add(rs.getString("achievement"));
				v.add(rs.getString("score"));
				row.add(v);	
			}
			
		} catch (SQLException e) {
		
			e.printStackTrace();
		}
		jTable=new JTable(row,col);
		jScrollPane.setViewportView(jTable);
		 
		
		
		
	}

}  //  @jve:decl-index=0:visual-constraint="185,10"