eth_no.java

运动会成绩管理系统

package prapare_manager;

import java.sql.*;
import java.awt.TextField;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;

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

public class eth_no 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[20][2]; 
String[] columnNames = {
    "学院", "编号范围"};
JTable jT1 = new JTable(rowData, columnNames);


JButton b3=new JButton("查 询");
JButton b4=new JButton("刷 新");
JButton b5=new JButton("返 回");

JComboBox cbx=new JComboBox();
TextField t1=new TextField(20);


public eth_no()

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

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

	this.setTitle("运动员编号范围");

	b3.setBounds(365,30,85,30);
	b3.setFont(new java.awt.Font("Dialog",0,15));
	b3.addActionListener(this);
	cp.add(b3);
	
	b4.setBounds(365,80,85,30);
	b4.setFont(new java.awt.Font("Dialog",0,15));
	b4.addActionListener(this);
	cp.add(b4);
	
	b5.setBounds(365,130,85,30);
	b5.setFont(new java.awt.Font("Dialog",0,15));
	b5.addActionListener(this);
	cp.add(b5);
	
	
	cbx.setBounds(340,180,130,30);
	cbx.setFont(new java.awt.Font("Dialog",0,15));
	try
	{
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		Connection con=DriverManager.getConnection("jdbc:odbc:yundonghui","sa","123");
		Statement ps=con.createStatement();
		ResultSet rs1=null;
		rs1=ps.executeQuery("select * from 学院名称表");
	    while(rs1.next()){cbx.addItem(rs1.getString(1));}

	}
	catch(Exception err){err.printStackTrace();JOptionPane.showMessageDialog(null,"数据库连接出错！");}

    cp.add(cbx,null);
    
	jsp.setBounds(6,0,300,262);
	jsp.getViewport().add(jT1,null);
	cp.add(jsp);
    
	tp.setSize(500,320);
	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[20][2]; 
    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);
      i++;
    }
     }catch(Exception err){err.printStackTrace();JOptionPane.showMessageDialog(null,"数据库连接出错！");}
}


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


public void actionPerformed(ActionEvent e)
{
	if(e.getSource()==b5) {this.dispose();}
    else
	  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;
  
       if(e.getSource()==b3) {                    
                                    rs=ps.executeQuery("select * from 运动员编号范围 where 学院='"+cbx.getSelectedItem()+"'");
                                         
                               }
               else {   rs=ps.executeQuery("select * from 运动员编号范围 ");}                                                         

              jT1.setModel(new javax.swing.table.DefaultTableModel());
              Object[][] rowData=new Object[20][2]; 
              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);
                i++;
              }
            }
       catch (Exception err){err.printStackTrace();JOptionPane.showMessageDialog(null,"数据库连接出错！");}
	
  }	

}