xueyuan_result_find.java

运动会成绩管理系统

package record_find;

import java.sql.*;

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

import java.sql.DriverManager;
import javax.swing.*;
public class xueyuan_result_find 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[200][10]; 
String[] columnNames = {
    "编号","姓名", "性别","项目","学院","类别","成绩","名次","日期","纪录"};
JTable jT1 = new JTable(rowData, columnNames);



JButton b1=new JButton("查 询");
JButton b2=new JButton("刷 新");
JButton b3=new JButton("返 回");

JLabel j1=new JLabel("学院:");

JComboBox jb=new JComboBox();



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


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

	this.setTitle("学院成绩查询");
	
	j1.setBounds(40,440,120,30);
	j1.setFont(new java.awt.Font("Dialog",0,20));
    j1.setForeground(new Color(255,0,0));
	cp.add(j1);
	
	jb.setBounds(120,440,140,30);
	jb.setFont(new java.awt.Font("Dialog",0,10));
    try{
    	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    	Connection con=DriverManager.getConnection("jdbc:odbc:yundonghui","sa","123");
    	Statement ps=con.createStatement();
    	ResultSet rs=null;
    	rs=ps.executeQuery("select * from 学院名称表");
    	while(rs.next()){jb.addItem(rs.getString(1));}	
    }catch (Exception err){err.printStackTrace();JOptionPane.showMessageDialog(null, "数据库连接出错!");}
    jb.setEditable(false);
	cp.add(jb);
	


	
	b1.setBounds(300,440,85,30);
	b1.setFont(new java.awt.Font("Dialog",0,15));
	b1.addActionListener(this);
	cp.add(b1);
	
	b2.setBounds(415,440,85,30);
	b2.setFont(new java.awt.Font("Dialog",0,15));
	b2.addActionListener(this);
	cp.add(b2);
	
	b3.setBounds(530,440,85,30);
	b3.setFont(new java.awt.Font("Dialog",0,15));
	b3.addActionListener(this);
	cp.add(b3);
	
    jsp.setBounds(40,8,720,400);
    jsp.add(jT1);
    cp.add(jsp);
      
    tp.setSize(800,600);
    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 表一");   
     
	
        jT1.setModel(new javax.swing.table.DefaultTableModel());
        Object[][] rowData=new Object[200][10]; 
        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);
          rowData[i][3] = rs.getString(4);
          rowData[i][4] = rs.getString(5);
          rowData[i][5] = rs.getString(6);
          rowData[i][6] = rs.getString(7);
          rowData[i][7] = rs.getString(8);
          rowData[i][8] = rs.getString(9);
          rowData[i][9] = rs.getString(10);
          i++;
         } 
     }catch(Exception err){err.printStackTrace();JOptionPane.showMessageDialog(null,"数据库连接出错！");}
     
}


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


public void actionPerformed(ActionEvent e) 
{   
	if(e.getSource()==b3) { this.dispose();}
	else
	try {

    	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        Connection con=DriverManager.getConnection("jdbc:odbc:yundonghui","sa","123");
        Statement ps=con.createStatement();
        ResultSet rs=null;

        if(e.getSource()==b2)
        {
        	rs=ps.executeQuery("select * from 表一");
            jb.setSelectedItem("计算机学院");
         }
        
        else{


   
        rs=ps.executeQuery("select * from 表一 where 学院='"+jb.getSelectedItem().toString()+"'");
         if(!rs.next()){JOptionPane.showMessageDialog(null, "没有记录！");jb.setSelectedItem("计算机学院");rs=ps.executeQuery("select * from 表一");}
        else{rs=ps.executeQuery("select * from 表一 where 学院='"+jb.getSelectedItem().toString()+"'");}
         
         }

       jT1.setModel(new javax.swing.table.DefaultTableModel());
        Object[][] rowData=new Object[200][10]; 
          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);
         rowData[i][3] = rs.getString(4);
         rowData[i][4] = rs.getString(5);
         rowData[i][5] = rs.getString(6);
         rowData[i][6] = rs.getString(7);
         rowData[i][7] = rs.getString(8);
         rowData[i][8] = rs.getString(9);
         rowData[i][9] = rs.getString(10);
         i++;
        }
    
        
      }
	
	
	catch (Exception err) {err.printStackTrace(); JOptionPane.showMessageDialog(null, "数据库连接出错！");	}
	
		

	

	
}



}