queryathleteinfo.java

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

package com.query;

import com.DBManager.MyDB;
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.JScrollPane;
import javax.swing.JTable;

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

	private JLabel jLabel1 = null;
	private JComboBox jComboBox1 = null;
	private JButton check = null;
	private JScrollPane jScrollPane = null;
	private JTable jTable = null;
	private JButton b2 = null;
	private JButton print = null;
	/**
	 * This method initializes 
	 * 
	 */
	public QueryAthleteInfo(MainFrame m) {
		super(m);
		initialize();
	}
	public QueryAthleteInfo() {
		super();
		initialize();
	}
	/**
	 * This method initializes this
	 * 
	 */
	private void initialize() {
        jLabel1 = new JLabel();
        jLabel1.setBounds(new Rectangle(19, 39, 77, 26));
        jLabel1.setText("运动员编号");
        this.setSize(new Dimension(611, 244));
        this.setTitle("查询运动员成绩");
        this.add(jLabel1, null);
        this.add(getJComboBox1(), null);
        this.add(getCheck(), null);
        this.add(getJScrollPane(), null);
        this.add(getB2(), 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(118, 40, 141, 26));
			
			ResultSet rs=db.executeQuery("select * from athlete");
			try {
				while(rs.next()){
					jComboBox1.addItem(rs.getString("id").trim());
				}
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			jComboBox1.setSelectedIndex(-1);
			jComboBox1.addActionListener(this);
		}
		return jComboBox1;
	}

	/**
	 * @return  the check
	 * @uml.property  name="check"
	 */
	private JButton getCheck() {
		if (check == null) {
			check = new JButton();
			check.setBounds(new Rectangle(377, 36, 103, 34));
			check.setText("查询成绩");
			check.addActionListener(this);
			check.setVisible(false);
			
		}
		return check;
	}

	@Override
	public void actionPerformed(ActionEvent e) {
		if(e.getSource()==jComboBox1){
			if(jComboBox1.getSelectedIndex()>-1)
				check.setVisible(true);
			    b2.setVisible(true);
			    
		}
		else if(e.getSource()==check){
			  check.setVisible(false);
			  b2.setVisible(true);
			  this.updateTable1("select * from achievement where athleteID="+jComboBox1.getSelectedItem().toString().trim()+"");
		}
		else if(e.getSource()==b2){
			 b2.setVisible(false);
			 check.setVisible(true);
			 this.updateTable2();
		}
		
	}
	public void updateTable1(String sql){
		ResultSet rs=db.executeQuery(sql);
		try {
			Vector row,col;
			row=new Vector();
			col=new Vector();
			col.add("项目编号");col.add("项目名称");col.add("成绩");col.add("得分");
			MyDB d=new MyDB();
			d.connectDB();
			while(rs.next()){
				Vector v=new Vector();
				String proID=rs.getString("projectID");
				v.add(proID);
				v.add(d.getString("select * from project where id='"+proID+"'", "name"));
				v.add(rs.getFloat("achievement"));
				v.add(rs.getInt("score"));
				row.add(v);
			}
			d.close();
			jTable=new JTable(row,col);
			jScrollPane.setViewportView(jTable);
		} catch (SQLException e) {
			
			e.printStackTrace();
		}
	}
	public void updateTable2(){

		ResultSet rs=db.executeQuery("select * from athlete where id="+jComboBox1.getSelectedItem().toString().trim()+"");
		try {
			Vector row,col;
			row=new Vector();
			col=new Vector();
			col.add("学生编号");col.add("姓名");col.add("学院");col.add("性别");
			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"));
				row.add(v);
			}
			jTable=new JTable(row,col);
			jScrollPane.setViewportView(jTable);
		} catch (SQLException e) {
			
			e.printStackTrace();
		}
	
	}
	/**
	 * @return  the jScrollPane
	 * @uml.property  name="jScrollPane"
	 */
	private JScrollPane getJScrollPane() {
		if (jScrollPane == null) {
			jScrollPane = new JScrollPane();
			jScrollPane.setBounds(new Rectangle(14, 88, 562, 104));
			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("select * from achievement");
		}
		return jTable;
	}

	/**
	 * This method initializes b2	
	 * @return  javax.swing.JButton
	 * @uml.property  name="b2"
	 */
	private JButton getB2() {
		if (b2 == null) {
			b2 = new JButton();
			b2.setBounds(new Rectangle(276, 35, 86, 35));
			b2.setText("基本信息");
			b2.setVisible(false);
		    b2.addActionListener(this);
		}
		return b2;
	}

	/**
	 * 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(361, 204, 97, 30));
			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;
	}

}  //  @jve:decl-index=0:visual-constraint="156,9"