personalgame.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.*;

/**
 *
 * 个人成绩统计表
 */
public class PersonalGame extends Frame implements ActionListener{
    TextField t;
    TextArea ta;
    Button b1,b2;
    Connection conn ;
    Statement sm ;
    ResultSet rs1,rs2 ;
   
    PersonalGame(){
        setSize(400,350);
        setBackground(Color.pink);
        setLocation(400,250);
        setResizable(false);
        setLayout(new FlowLayout());
        addWindowListener(new WindowAdapter() {
            @Override
            public void windowClosing(WindowEvent we) {
				dispose();
			}}); 
        t=new TextField(10);
        ta=new TextArea(12,50);
        Label l=new Label("请输入您要查询的参赛者编号");
        t=new TextField(10);
        b1=new Button("确定");
        b2=new Button("返回");
        add(l);
        add(t);
        add(b1);
        add(b2);
        add(ta); 
        b1.addActionListener(this);
        b2.addActionListener(this);
        setVisible(true);

    }
    public void actionPerformed(ActionEvent e){
        if(e.getSource()==b1){
             String t1=t.getText();
            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 SID='"+t1+"'");
                ta.setText("您所查询的结果是");
                ta.append("\n");
                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();
        }
        
    }}