pj_eth.java

运动会成绩管理系统

            "编号","姓名","性别","参赛项目","学院"};
        JTable jT1 = new JTable(rowData, columnNames);
        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);
          i++;
         }      
        
        jt1.setText((String)rowData[0][0]);
        jt2.setText((String)rowData[0][1]);
        cbx3.setSelectedItem(rowData[0][2]);        
        cbx2.setSelectedItem(rowData[0][3]);
        cbx1.setSelectedItem(rowData[0][4]);
     }catch (Exception err){err.printStackTrace();JOptionPane.showMessageDialog(null,"数据库连接出错！");}
     
}


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

public void itemStateChanged(ItemEvent e)
{JCheckBox cbx=(JCheckBox) e.getItem();
if(cbx.getText()=="学  院"){if(e.getStateChange()==ItemEvent.SELECTED) i1=1;else i1=0;}
if(cbx.getText()=="项  目"){if(e.getStateChange()==ItemEvent.SELECTED) i2=1;else i2=0;}
}

public void actionPerformed(ActionEvent e)
{  
	

	if(e.getSource()==b6){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;
           ResultSet rs0=null;
           ResultSet rs2=null;
          if(e.getSource()==b1)
                 {
        	       rs=ps.executeQuery("select * from 运动员参赛表 where 编号='"+jt1.getText().trim()+"' and 项目='"+cbx2.getSelectedItem()+"'");
                   if(rs.next()){JOptionPane.showMessageDialog(null,"此项目记录已存在！");}
                   else
                   {
      	             rs0=ps.executeQuery("select * from 运动员参赛表 where 编号='"+jt1.getText().trim()+"'");
    	             String ss=new String();
    	             if(rs0.next())
    	               { ss=rs0.getString(2);}
    	             if(!ss.equals(jt2.getText())&&!ss.equals(""))
    	            	{JOptionPane.showMessageDialog(null, "姓名与编号不一致！\n编号："+jt1.getText()+"    姓名:"+ss);} 
    	             else{
                                int num1=0,num2=0,num3=0;String s1=new String();String s2=new String();
    			                 String s3=new String();String s4=new String();
    			                 num1=Integer.valueOf(jt1.getText().trim());
    				             rs2=ps.executeQuery("select * from 运动员编号范围 where 学院='"+cbx1.getSelectedItem().toString()+"'");

    			                 if(rs2.next())
    			                           { 
                                              s1=rs2.getString(1);
                                              s2=rs2.getString(2);
                                              s3=rs2.getString(3);
                                              s4=rs2.getString(4);            
    			                            }
    			                  num2=Integer.valueOf(s3);num3=Integer.valueOf(s4);
    			                  if(num1<num2||num1>num3){JOptionPane.showMessageDialog(null, "编号与学院不一致"+"\n"+s1+"的编号范围是："+s2);}
    			                 else{        
                	                    int v=JOptionPane.showConfirmDialog(this,"确认添加吗？","添加确认",JOptionPane.OK_CANCEL_OPTION);
                	                    if(jt1.getText().equals("")){JOptionPane.showMessageDialog(null,"请输入运动员编号！");jt1.requestFocus();}
                	                    else if(jt2.getText().equals("")){JOptionPane.showMessageDialog(null,"请输入运动员姓名！");jt2.requestFocus();} 
                	                    else if(v==JOptionPane.OK_OPTION)
                	                    {
                	    
                                       ps.executeUpdate("Insert Into 运动员参赛表 Values('"+jt1.getText().trim()+"','"+jt2.getText().trim()+"'" +
                         		      "  ,'"+cbx3.getSelectedItem().toString()+"','"+cbx2.getSelectedItem().toString()+"','"+cbx1.getSelectedItem().toString()+"')");
                         		
                        		        JOptionPane.showMessageDialog(null,"添加成功!");
                                        }     
                                      }
                     
                          }
         
                   }
                   rs=ps.executeQuery("select * from 运动员参赛表");  
                   }
    	            	  
    	            	  
    	     else if(e.getSource()==b2)
                 {  
        	  
        	  if(jt1.getText().equals("")){JOptionPane.showMessageDialog(null,"请输入运动员编号！");jt1.requestFocus();}
        	             
                 else
                 {   
        	             int v=JOptionPane.showConfirmDialog(this,"确定删除吗？","删除确认",JOptionPane.OK_CANCEL_OPTION);
        	             if(v==JOptionPane.OK_OPTION)
        	              {    rs=ps.executeQuery("select * from 运动员参赛表 where 编号='"+jt1.getText().trim()+"'"); 
        	                   if(rs.next()){ps.executeUpdate("delete from 运动员参赛表 where 编号='"+jt1.getText().trim()+"'");
        	                   ps.executeUpdate("delete from 表一 where 编号='"+jt1.getText().trim()+"'");
        	                   JOptionPane.showMessageDialog(null,"删除成功！");}
        	                   else{JOptionPane.showMessageDialog(null,"没有此记录！" );}
        	               }       
        	    	    rs=ps.executeQuery("select * from 最高记录");
        	    	  
                  }
                   }
        
          
          else if(e.getSource()==b3)
                   {
    	              if(i1==1&&i2==0)
    	                 {
    	                     rs=ps.executeQuery("select * from 运动员参赛表 where 学院='"+
                              cbx1.getSelectedItem()+"'"); 
    	                     if(rs.next()){rs=ps.executeQuery("select * from 运动员参赛表 where 学院='"+
    	                              cbx1.getSelectedItem()+"'"); }
    	                     else{JOptionPane.showMessageDialog(null,"没有此记录！" );
    	                     rs=ps.executeQuery("select * from 运动员参赛表");}
    	                   
    	                  } 
    	              else if(i1==0&&i2==1)
    	                  {
    	    	             rs=ps.executeQuery("select * from 运动员参赛表 where 项目='"+
                             cbx2.getSelectedItem()+"'");
    	                     if(rs.next())
    	                     { 
    	                    	 rs=ps.executeQuery("select * from 运动员参赛表 where 项目='"+
    	                         cbx2.getSelectedItem()+"'");
        		             }
	                        else{JOptionPane.showMessageDialog(null,"没有此记录！" );rs=ps.executeQuery("select * from 运动员参赛表");}     
    	    	 
    	                   }
    	              else if(i1==1&&i2==1)
    	                   {
    	                      rs=ps.executeQuery("select * from 运动员参赛表 where 学院='"+
            		          cbx1.getSelectedItem()+"'and 项目='"+cbx2.getSelectedItem()+"'");
                              if(rs.next())
                              {
                            	 rs=ps.executeQuery("select * from 运动员参赛表 where 学院='"+
                    		     cbx1.getSelectedItem()+"'and 项目='"+cbx2.getSelectedItem()+"'");
		                       }
                              else{JOptionPane.showMessageDialog(null,"没有此记录！" );rs=ps.executeQuery("select * from 运动员参赛表");}

    	                    }
    	              else
    	                   {
    	            	     
    	            	      if(jt1.getText().equals("")){JOptionPane.showMessageDialog(null, "请输入运动员编号!");jt1.requestFocus();
    	            	      rs=ps.executeQuery("select * from 运动员参赛表");}
    	            	      else{rs=ps.executeQuery("select * from 运动员参赛表 where 编号='"+jt1.getText().trim()+"' ");
    	            	         if(rs.next()){rs=ps.executeQuery("select * from 运动员参赛表 where 编号='"+jt1.getText().trim()+"'");}
    	            	         else{JOptionPane.showMessageDialog(null,"没有此记录！" );rs=ps.executeQuery("select * from 运动员参赛表");} 
    	            	          }
    	                   }
   
    	    
                   }
          
          
          else {rs=ps.executeQuery("select * from 运动员参赛表");}      
         
          jT1.setModel(new javax.swing.table.DefaultTableModel());
          Object[][] rowData=new Object[100][5]; 
          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);
             i++;
            }
      
           jt1.setText((String)rowData[0][0]);
           jt2.setText((String)rowData[0][1]);
           cbx3.setSelectedItem(rowData[0][2]);        
           cbx2.setSelectedItem(rowData[0][3]);
           cbx1.setSelectedItem(rowData[0][4]);
          
          }catch(Exception err){err.printStackTrace();JOptionPane.showMessageDialog(null,"数据库连接错误！");}   	

 }


	
}