tj_result.java

运动会成绩管理系统

package record_manager;

import java.sql.*;



import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;

import java.sql.DriverManager;
import javax.swing.*;




public class tj_result extends JFrame implements ActionListener 

{


	private static final long serialVersionUID = -7700451926035976789L;
JPanel cp;
JScrollPane jsp = new JScrollPane();

ImageIcon icon=new ImageIcon("picture/12.jpg");
JLabel tp=new JLabel(icon,JLabel.CENTER);

Object[][] rowData=new Object[30][3]; 
String[] columnNames = { "学院", "总成绩","名次"};
   
JTable jT1 = new JTable(rowData, columnNames);

JButton b1=new JButton("统 计");
JButton b2=new JButton("排 名");
JButton b3=new JButton("返 回");




public tj_result()

{try{
	  Init();
}catch(Exception err){err.printStackTrace();}}

public void Init() throws Exception{
     cp=(JPanel)this.getContentPane();
	cp.setLayout(null);
	
	this.setSize(660,440);

	this.setTitle("学院总成绩统计");

	
	b1.setBounds(480,20,85,30);
	b1.setFont(new java.awt.Font("Dialog",0,15));
	b1.addActionListener(this);
	cp.add(b1);
	
	b2.setBounds(480,70,85,30);
	b2.setFont(new java.awt.Font("Dialog",0,15));
	b2.addActionListener(this);
	cp.add(b2);
	
	
	b3.setBounds(480,120,85,30);
	b3.setFont(new java.awt.Font("Dialog",0,15));
	b3.addActionListener(this);
	cp.add(b3);
	
	
	
	
	
	
    
	jsp.setBounds(6,0,400,400);
	jsp.getViewport().add(jT1,null);
	cp.add(jsp);
    
	tp.setSize(660,500);
	tp.setText("");
	cp.add(tp,null);



	this.setResizable(false);
	this.setLocationRelativeTo(null);
	this.setVisible(true);
	 try
     {
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        java.sql.Connection con=DriverManager.getConnection("jdbc:odbc:yundonghui","sa","123");
        Statement ps=con.createStatement();	
        ResultSet rs = null;
        rs=ps.executeQuery("select * from 学院成绩表 order by 总成绩 desc");   
     
    jT1.setModel(new javax.swing.table.DefaultTableModel());
    
   
    
    Object[][] rowData=new Object[30][3]; 
    String[] columnNames = { "学院", "总成绩","名次"};                 
    JTable jT1=new JTable(rowData, columnNames);   //创建新的JTable对象
    jsp.getViewport().add(jT1,null); //加载JTable对象

    int i=0; 
    while(rs.next())
    {
      rowData[i][0] = rs.getString(1);
      rowData[i][1] = rs.getString(2);
      rowData[i][2] = rs.getString(3);
      i++;
    }
     }catch(Exception err){err.printStackTrace();JOptionPane.showMessageDialog(null,"数据库连接出错！");}
}


public static void main(String args[])
{new tj_result();}


public void actionPerformed(ActionEvent e)
{
	if(e.getSource()==b3) {this.dispose();}
    else
	  try
          {
	         Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
             java.sql.Connection con=DriverManager.getConnection("jdbc:odbc:yundonghui","sa","123");
             Statement ps1=con.createStatement();
             Statement ps=con.createStatement();
             ResultSet rs=null;
             ResultSet rs1 = null;
             ResultSet rs2 = null;
            if(e.getSource()==b1)
            {
             String []ss=new String[30];
             int j=0; 
             rs1=ps.executeQuery("select * from 学院成绩表");
              while(rs1.next())
              {   ss[j]=rs1.getString(1);j++;}
              
              
              
              for(int k=0;k<j;k++)
                {
            	  int sum=0;
                 rs2=ps1.executeQuery("select * from 表一 where 学院='"+ss[k]+"'");
                 
            	 while(rs2.next())
            	{   int num=rs2.getInt(8);
            		 if(num==1){sum=sum+11;} 
            		 if(num==2){sum=sum+7;} 
            		 if(num==3){sum=sum+5;} 
            		
                }
            	ps.executeUpdate("update 学院成绩表 set 总成绩='"+sum+"' where 学院='"+ss[k]+"'");
                 
                }
            	  
              JOptionPane.showMessageDialog(null,"统计成功!");
                                                                                
                
                }
            
           
            	else
                {   int mc=1;
            		int j=0;String []ss1=new String[30];
                    rs1=ps.executeQuery("select * from 学院成绩表 order by 总成绩 desc");
                     while(rs1.next())
                     {   ss1[j]=rs1.getString(1);
                   	    j++;
                     }   
            	   for(int i=0;i<j;i++)
            	   { ps.executeUpdate("update 学院成绩表 set 名次='"+mc+"' where 学院='"+ss1[i]+"'");mc++;}
                }
            
            rs=ps.executeQuery("select * from 学院成绩表 order by 总成绩 desc");      
         
              jT1.setModel(new javax.swing.table.DefaultTableModel());
              Object[][] rowData=new Object[30][3]; 
              String[] columnNames = { "学院", "总成绩","名次"};                  
              JTable jT1=new JTable(rowData, columnNames);   //创建新的JTable对象
              jsp.getViewport().add(jT1,null); //加载JTable对象

              int i=0; 
              while(rs.next())
              {
    	        rowData[i][0] = rs.getString(1);
                rowData[i][1] = rs.getString(2);
                rowData[i][2] = rs.getString(3);
                i++;
              }
    
	
            }
       catch (Exception err){err.printStackTrace();JOptionPane.showMessageDialog(null,"数据库连接出错！");}
	
  }	

}