bsproject.java

运动会成绩管理系统

package prapare_manager;

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.ImageIcon;
import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;

import user.quanxian;


public class bsProject 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[50][2]; 
String[] columnNames = {
    "项目", "类型"};
JTable jT1 = new JTable(rowData, columnNames);


JLabel j1=new JLabel("比赛项目: ");
JLabel j2=new JLabel("项目类型: ");
JButton b1=new JButton("添 加");
JButton b2=new JButton("删 除");
JButton b3=new JButton("查 询");
JButton b4=new JButton("刷 新");
JButton b5=new JButton("返 回");

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


public bsProject()

{try{
	  Init();if(new quanxian().get_quanxian()==2){b2.setEnabled(false);b1.setEnabled(false);}
}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);
	
	b4.setBounds(480,170,85,30);
	b4.setFont(new java.awt.Font("Dialog",0,15));
	b4.addActionListener(this);
	cp.add(b4);
	
	b5.setBounds(480,220,85,30);
	b5.setFont(new java.awt.Font("Dialog",0,15));
	b5.addActionListener(this);
	cp.add(b5);
	
	
	j1.setBounds(440,280,80,30);
	j1.setForeground(new Color(255,0,0));
	j1.setFont(new java.awt.Font("Dialog",0,16));
	cp.add(j1,null);
	
	t1.setBounds(520,280,85,30);
	t1.setFont(new java.awt.Font("Dialog",0,14));
	cp.add(t1,null);
	
	j2.setBounds(440,340,80,30);
	j2.setFont(new java.awt.Font("Dialog",0,16));
	j2.setForeground(new Color(255,0,0));
	cp.add(j2,null);
	
	cbx.setBounds(520,340,80,30);
	cbx.setFont(new java.awt.Font("Dialog",0,15));
	cbx.addItem("田赛");
	cbx.addItem("径赛");
    cp.add(cbx,null);
    
	jsp.setBounds(6,0,400,400);
	jsp.getViewport().add(jT1,null);
	cp.add(jsp);
    
	tp.setSize(660,500);
	tp.setText("");
	cp.add(tp,null);



	 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[50][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,"数据库连接出错！");}
     

 	this.setResizable(false);
 	this.setLocationRelativeTo(null);
 	this.setVisible(true);
}


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


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()==b1){
                                    if(t1.getText().equals(""))
                                       { 
                                    	JOptionPane.showMessageDialog(null,"请输入要添加的项目！"); 
                                        rs=ps.executeQuery("select * from 项目表");t1.requestFocus();
                                       } 
        
                                    else
                                       { 
                                    	rs=ps.executeQuery("select * from 项目表 where 项目='"+t1.getText().trim()+"'");
                                        if(rs.next())
       	                                  {  JOptionPane.showMessageDialog(null, "此项目已存在，请重新输入！");
       	                                     t1.setText("");t1.requestFocus();
                                         	 rs=ps.executeQuery("select * from 项目表");
                                           }
                                        else 
                                          {
                                        	int v=JOptionPane.showConfirmDialog(this,"确定添加吗？","用户确认",
                                                  JOptionPane.OK_CANCEL_OPTION );
                                             if(v==JOptionPane.OK_OPTION)
                                             {
                                        	 ps.executeUpdate("Insert Into 项目表 Values('"+
                                        		              t1.getText().trim()+"','"+cbx.getSelectedItem()+"')");  
                                             JOptionPane.showMessageDialog(null,"添加成功!");}
                                             rs=ps.executeQuery("select * from 项目表");t1.setText("");
                                           }
                                       } 
                                 }
              else  if(e.getSource()==b2)
                                {
		
	                                if(t1.getText().equals(""))
	                                 {    JOptionPane.showMessageDialog(null,"请输入要删除的项目!"); 
	                                      rs=ps.executeQuery("select * from 项目表");t1.requestFocus();
	                                 }
	                                else
	                                 {    rs=ps.executeQuery("select * from 项目表 where 项目='"+t1.getText().trim()+"'");
	                                      if(rs.next())
	                                         { int  v=JOptionPane.showConfirmDialog(this,"确定删除吗？","用户确认",
                                                     JOptionPane.OK_CANCEL_OPTION );
                                               if(v==JOptionPane.OK_OPTION)
                                                  {
	    	                                         ps.executeUpdate("delete from 项目表 where 项目='"+t1.getText().trim()+"'");
	    	                                         ps.executeUpdate("delete from 运动员参赛表 where 项目='"+t1.getText().trim()+"'");
	    	                                         ps.executeUpdate("delete from 表一 where 项目='"+t1.getText().trim()+"'");
	    	                                         ps.executeUpdate("delete from 参赛单位表 where 参赛项目='"+t1.getText().trim()+"'");
	    	                                         JOptionPane.showMessageDialog(null, "删除成功！");
                                                  }
                                               rs=ps.executeQuery("select * from 项目表");t1.setText("");t1.requestFocus();
	                                          }
	                                      else 
	                                         {  JOptionPane.showMessageDialog(null,"没有此项目！"); 
	                                            rs=ps.executeQuery("select * from 项目表");
	                                            t1.setText("");t1.requestFocus();
	                                          }

	                                  }
                                 }
               else if(e.getSource()==b3)
                                {
	                                 if(t1.getText().equals("")) 
	                                  {  JOptionPane.showMessageDialog(null,"请输入要查询的项目！"); 
	                                     t1.setText("");t1.requestFocus();
	                                	 rs=ps.executeQuery("select * from 项目表");   }
                                     else  
                                      {  rs=ps.executeQuery("select * from 项目表 where 项目='"+t1.getText().trim()+"'");
                                         if(!rs.next())
                                            {   JOptionPane.showMessageDialog(null,"没有此项目！");t1.setText("");
                                                rs=ps.executeQuery("select * from 项目表");
                                             } 
                                         else{rs=ps.executeQuery("select * from 项目表 where 项目='"+t1.getText().trim()+"'");}
                                       }
                                }
               else { rs=ps.executeQuery("select * from 项目表"); t1.setText("");t1.requestFocus();}                                                         
   
              jT1.setModel(new javax.swing.table.DefaultTableModel());
              Object[][] rowData=new Object[50][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,"数据库连接出错！");}
	
  }	

}