singlegame.java

基于UML的运动会成绩统计系统设计。1.1运动会成绩统计系统包括个人成绩统计

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package sports;
import java.awt.*;
import java.awt.Checkbox.*;
import java.awt.event.* ;
import java.sql.*;
/**
 *
 * 单项成绩统计表
 */
class SingleGame extends Frame implements ActionListener{
    Choice choice;
    TextArea ta;
    Button b1,b2;
    CheckboxGroup cb;
    Checkbox m,wm;
    Connection conn ;
    Statement sm ;
    ResultSet rs1,rs2 ;
   
    SingleGame(){
        setSize(500,500);
        setBackground(Color.pink);
        setLocation(400,250);
        setResizable(false);
        addWindowListener(new WindowAdapter() {
            @Override
            public void windowClosing(WindowEvent we) {
				dispose();
			}}); 
        choice=new Choice();
        ta=new TextArea(100,100);
        choice.add("50m短跑");
        choice.add("100m短跑");
        choice.add("400m中长跑");
        choice.add("1000m长跑");
        choice.add("3000m长跑");
        choice.add("跳高");
        choice.add("跳远");
        choice.add("推铅球");
        choice.add("掷标枪");
        
        b1=new Button("确定");
        b2=new Button("返回");
        cb=new CheckboxGroup();
        m=new Checkbox("男",false,cb);
        wm=new Checkbox("女",false,cb);
        Panel p1=new Panel();
        Panel p2=new Panel(new BorderLayout());
        Panel p3=new Panel();
        add(p1,BorderLayout.NORTH);
        p1.add(choice);
        p1.add(b1);
        add(p2,BorderLayout.CENTER);
        p2.add(p3,BorderLayout.NORTH);
        p3.add(m);
        p3.add(wm);
        p2.add(ta,BorderLayout.CENTER);
        add(b2,BorderLayout.SOUTH);

        b1.addActionListener(this);
        b2.addActionListener(this); 
        setVisible(true);
    }
    public void actionPerformed(ActionEvent e){
        if(e.getSource()==b1){
            ta.setText("查询结果\n");
            String ch=choice.getSelectedItem();
            String se= cb.getSelectedCheckbox().getLabel();
            try {
                Class.forName("com.mysql.jdbc.Driver");
            } catch (java.lang.ClassNotFoundException ee) {
                System.out.println("驱动加载失败,属于系统错误，请与管理员联系！");
            }
            try{
                conn = DriverManager
		          .getConnection("jdbc:mysql://localhost:3306/sports?user=root&password=root");
		sm = conn.createStatement();
            }
            catch (SQLException kk) {
		System.out.println("数据库连接失败，请查看服务器是否开启！");
            }
            try{
                int index1 = 0;
                rs2=sm.executeQuery("select * from totalgame where EVENT='"+ch+"'"+"and SSEX= '"+se+"'");
                ta.append("学号       "+"姓名     "+"性别     "+"学院       "+"年龄     "+"成绩     "+"得分     "+"名次    ");
                while(rs2.next()){
                    index1=1;
                    String SID=rs2.getString(1);
                    String SNAME=rs2.getString(2);
                    String SSEX=rs2.getString(3);
                    String SDEPT=rs2.getString(4);
                    int SAGE=rs2.getInt(5);
                    String RESULT=rs2.getString(7);
                    int SCORE=rs2.getInt(8);
                    String RANKING=rs2.getString(9);                    
                        
                    ta.append(" "+"\n"+SID+"   "+SNAME+"    "+SSEX+"    "+SDEPT+"     "+SAGE+"      "+RESULT+"       "+SCORE+"        "+RANKING+"  ");
                }
        
                            conn.close();
                if(index1==0){
                    ta.append("\n"+"您所要查询的项目成绩统计暂未输入或者此次运动会没有该项目");
                }
                         
            }

            
            catch(SQLException eee){}
        }
        else{
           dispose();
        }
    }}