eth_result_find.java

运动会成绩管理系统

package record_find;

import java.sql.*;

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

import java.sql.DriverManager;
import javax.swing.*;
public class eth_result_find extends JFrame implements ActionListener

{
	private static final long serialVersionUID = -7700451926035976789L;
JPanel cp;
int i1=0,i2=0;//复选框选择记录
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);




JComboBox cbx1=new JComboBox();
JComboBox cbx2=new JComboBox();

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

JLabel j1=new JLabel("编 号:");
JLabel j2=new JLabel("姓 名:");
JLabel j3=new JLabel("项 目:");
JLabel j4=new JLabel("成 绩:");
JLabel j5=new JLabel("名 次:");

TextField t1=new TextField(20);
TextField t2=new TextField(20);
TextField t3=new TextField(20);
TextField t4=new TextField(20);
TextField t5=new TextField(20);



public eth_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(100,440,60,30);
	j1.setFont(new java.awt.Font("Dialog",0,20));
    j1.setForeground(new Color(255,0,0));
	cp.add(j1);
	
	t1.setBounds(160,440,110,20);
	t1.setFont(new java.awt.Font("Dialog",2,15));
	cp.add(t1);
	
	j2.setBounds(310,440,60,30);
	j2.setFont(new java.awt.Font("Dialog",0,20));
    j2.setForeground(new Color(255,0,0));
	cp.add(j2);
	
	t2.setBounds(370,440,110,20);
	t2.setFont(new java.awt.Font("Dialog",2,15));
	cp.add(t2);
	
	j3.setBounds(100,480,60,30);
	j3.setFont(new java.awt.Font("Dialog",0,20));
    j3.setForeground(new Color(255,0,0));
	cp.add(j3);
	
	t3.setBounds(160,480,110,20);
	t3.setFont(new java.awt.Font("Dialog",2,15));
	t3.setEnabled(false);
	cp.add(t3);
	
	j4.setBounds(310,480,60,30);
	j4.setFont(new java.awt.Font("Dialog",0,20));
    j4.setForeground(new Color(255,0,0));
	cp.add(j4);
	
	t4.setBounds(370,480,110,20);
	t4.setFont(new java.awt.Font("Dialog",2,15));
	t4.setEnabled(false);
	cp.add(t4);
	
	j5.setBounds(520,480,60,30);
	j5.setFont(new java.awt.Font("Dialog",0,20));
    j5.setForeground(new Color(255,0,0));
	cp.add(j5);
	
	t5.setBounds(580,480,110,20);
	t5.setFont(new java.awt.Font("Dialog",2,15));
	t5.setEnabled(false);
	cp.add(t5);
	
	
	b1.setBounds(160,540,85,30);
	b1.setFont(new java.awt.Font("Dialog",0,15));
	b1.addActionListener(this);
	cp.add(b1);
	
	b2.setBounds(370,540,85,30);
	b2.setFont(new java.awt.Font("Dialog",0,15));
	b2.addActionListener(this);
	cp.add(b2);
	
	b3.setBounds(580,540,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 eth_result_find();}


public void actionPerformed(ActionEvent e) 
{    int j=1;
	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 表一");
            t1.setText("");t2.setText("");t3.setText("");t4.setText("");t5.setText("");
         }
        
        else{

        if(t1.getText().equals("")&&t2.getText().equals(""))
            {
              JOptionPane.showMessageDialog(null, "请输入要查询的运动员姓名或者编号！");
                 rs=ps.executeQuery("select * from 表一");
             }

        else if (!t1.getText().equals("")&& t2.getText().equals(""))
        {
        	 rs=ps.executeQuery("select * from 表一 where 运动员编号='"+t1.getText().trim()+"'");
            if(!rs.next()){JOptionPane.showMessageDialog(null, "没有此记录！"); rs=ps.executeQuery("select * from 表一");t1.setText("");}
            else{rs=ps.executeQuery("select * from 表一 where 运动员编号='"+t1.getText().trim()+"'");j=0;}
          }

        else if (t1.getText().equals("")&& !t2.getText().equals(""))
        {rs=ps.executeQuery("select * from 表一 where 姓名='"+t2.getText().trim()+"'");
        if(!rs.next()){JOptionPane.showMessageDialog(null, "没有此记录！"); rs=ps.executeQuery("select * from 表一");t2.setText("");}
        else{rs=ps.executeQuery("select * from 表一 where 姓名='"+t2.getText().trim()+"'");j=0;}
         }


        else
        {rs=ps.executeQuery("select * from 表一 where 姓名='"+t2.getText().trim()+"'and 运动员编号='"+t1.getText().trim()+"'");
         if(!rs.next()){JOptionPane.showMessageDialog(null, "没有此记录！");t1.setText("");t2.setText("");rs=ps.executeQuery("select * from 表一");}
        else{rs=ps.executeQuery("select * from 表一 where 姓名='"+t2.getText().trim()+"'and 运动员编号='"+t1.getText().trim()+"'");j=0;}
         }
        }

       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++;
        }
       
       if(j==0){
           t1.setText((String) rowData[0][0]);
           t2.setText((String) rowData[0][1]);
           t3.setText((String) rowData[0][3]);
           t4.setText((String) rowData[0][6]);
           t5.setText((String) rowData[0][7]);
           }
       
        
      }
	
	
	catch (Exception err) {err.printStackTrace(); JOptionPane.showMessageDialog(null, "数据库连接出错！");	}
	
		

	

	
}



}