all_record.java

运动会成绩管理系统

package record_manager;

import java.sql.*;

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

import java.awt.print.PrinterException;

import java.sql.DriverManager;
import javax.swing.*;
public class all_record 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("返 回");





public all_record()
{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("总成绩册");
	
	b1.setBounds(300,540,85,30);
	b1.setFont(new java.awt.Font("Dialog",0,15));
	b1.addActionListener(this);
	cp.add(b1);
	
	b2.setBounds(530,540,85,30);
	b2.setFont(new java.awt.Font("Dialog",0,15));
	b2.addActionListener(this);
	cp.add(b2);
	
    jsp.setBounds(40,8,720,500);
    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 all_record();}


public void actionPerformed(ActionEvent e) {
	if(e.getSource()==b1){try {
		jT1.print();
	} catch (PrinterException e1) {
		
		e1.printStackTrace();
	}}
	else{this.dispose();}
	
}


}