frame1.java~434~

一点java的学习资料和小程序 有需要的可以看看

        String se = "";
        String s1 = jPasswordField1.getText();
        String s2 = jTextField2.getText();
        int t=Integer.valueOf(s2);
        // boolean r=true;                ///判断是否有该学生

        try {

            ResultSet rs = st.executeQuery(
                    "select sID,sname,sno,password from student where sid="+t +
                    " and password=" + s1);
            rs.next();
            if (rs!= null) {

                sid= rs.getInt("sID");
                name = rs.getString("sname");
                se=rs.getString("sno");
                ss = rs.getString("password");
                jLabel2.setText(""+sid);
               jLabel5.setText(""+se);
                 jLabel21.setText(""+name);}
                 try{
                 ResultSet rr=st.executeQuery("select * from "+name);
                 rr.next();
                 if(rr!=null){
                     redenlu=true;
            jLabel9.setVisible(true);
           jTextField1.setVisible(true);}
         }catch(Exception dd){
                     System.out.println(dd);

       }
     if(redenlu){                                              //判断是否重新登陆
         ResultSet ry=st.executeQuery("select password from admin");
         ry.next();
         String admin=ry.getString("password");
          if( jTextField1.getText().equals(admin))
                cardLayout1.show(contentPane, "jPanel2");
          }
            else{cardLayout1.show(contentPane, "jPanel2");}


        } catch (Exception ee) {
            JOptionPane.showMessageDialog(this, "用户名或考号错误");
            System.out.println(ee);
        }
    }

    public void run() {
       /* int fen=0;
        int miao=60;*/
        try {
            ResultSet dd=st.executeQuery("select 考试时间 from sysdata");
             dd.next();
            fen=dd.getInt("考试时间")-1;
             System.out.print(""+fen);
            while (fen!=0&& miao!=0) {
                if(miao!=0){miao--;}

                if (miao==0) {
                    fen--;
                    miao=60;
                    d=true;
                }

                if (fen ==1&&miao == 0) {
                    JOptionPane.showMessageDialog(jPanel3, "还有１分钟");
                }
                jLabel11.setText("还有" + fen + "分" + miao + "秒");
                Thread.sleep(1000);
            }
            cardLayout1.show(contentPane, "jPanel5");
           } catch (Exception eee) {
            System.out.println(eee);
        }
    }

    public void jButton2_actionPerformed(ActionEvent e) {
        cardLayout1.show(contentPane, "jPanel1");
    }
    public void jianbiao(){
       if(! redenlu){ try{
                 String sql ="create table "+name+"(ID int,content text,A  text,B  text,C text,D text,标准答案  nvarchar(1),考生答案 varchar(3))";
                st.executeQuery(sql);}catch(Exception te){System.out.println(te);}}
}
    public void jButton1_actionPerformed(ActionEvent e) {
         Thread th = new Thread(this);
        jianbiao();

        int j,min,max;
        try{   if(! redenlu){
                ResultSet rs = st.executeQuery("select 选择题数量 from sysdata"); //获得选择题数量
                rs.next();
                // rs=rs.next();
                j = rs.getInt("选择题数量");

                ResultSet rs1 = st.executeQuery(
                        "select min(tid) as min,max(tid) as max from choose"); //获取题号的最大值与最小值
                rs1.next();
                min = rs1.getInt("min");
                max = rs1.getInt("max");
                System.out.println("\n" + min + "" + max);

                System.out.println("" + max + "" + min);

                int i[] = new int[j];
                for (int v = 0; v < j; v++) {

                    i[v] = (int) (Math.random() * (max - min + 1) + min);

                    for (int k = 0; k < v; k++) {

                        if (i[k] == i[v]) {
                            i[v] = (int) (Math.random() * (max - min + 1) + min);
                            k = -1;
                            break;

                        }

                    }

                }

                for (int t = 0; t < j; t++) {

                    try {

                        st.executeQuery("insert into " + name + "(ID,content,A,B,C,D,标准答案) select tID,content,A,B,C,D,answer from choose where tID=" +
                                        i[t]); //}

                    } catch (Exception ey) {
                        System.out.print(ey);
                    }

                }
            }
       database1.closeConnection();

     database1.setConnection(new ConnectionDescriptor("jdbc:odbc:wei", "",
      "dang", false, "sun.jdbc.odbc.JdbcOdbcDriver"));
     database1.openConnection();
      st = database1.createStatement();
      queryDataSet1.setQuery(new  QueryDescriptor(database1,"SELECT "+name+".ID,"+name+".content,"+name+".A,"+name+".B,"+name+".C,"+name+".D FROM sjks.dbo."+name));//, null, true, Load.ALL));
         jdbLabel1.setDataSet(queryDataSet1);
           jdbLabel1.setColumnName("ID");
            jdbTextArea1.setDataSet(queryDataSet1);
            jdbTextArea1.setColumnName("content");
            jdbLabel2.setDataSet(queryDataSet1);
            jdbLabel2.setColumnName("A");
            jdbLabel3.setDataSet(queryDataSet1);
            jdbLabel3.setColumnName("B");
            jdbLabel4.setDataSet(queryDataSet1);
            jdbLabel4.setColumnName("C");
            jdbLabel5.setDataSet(queryDataSet1);
            jdbLabel5.setColumnName("D");


        } catch (Exception rr) {
            System.out.println(rr);
        }
        jLabel20.setText(""+dqth);

        th.start();
        cardLayout1.show(contentPane, "jPanel3");

    }



    public void jRadioButton2_actionPerformed(ActionEvent actionEvent) {
        jButton1.setEnabled(true);

    }

    public void jButton8_actionPerformed(ActionEvent e) {
        int k=0;
            try{ResultSet rr=st.executeQuery("select 选择题分值 from sysdata");
                rr.next();
                k=rr.getInt("选择题分值");
                ResultSet rs6=st.executeQuery("select 标准答案,考生答案 from "+name);
            while(rs6.next()){
                String right=rs6.getString("标准答案");
                String answer=rs6.getString("考生答案");
                if(right.equals(answer)){fenshu=fenshu+k;}
            }

        }catch(Exception dd){System.out.println(dd);}
          jLabel15.setText(""+fenshu);
         try{ st.executeUpdate("update student set score="+fenshu+" where sid="+sid);
         }catch(Exception ff){System.out.println(ff);}
        cardLayout1.show(contentPane, "jPanel5");
    }

    public void jButton9_actionPerformed(ActionEvent e) {
       try{
       st.executeUpdate("drop table "+name);

           database1.closeConnection();
            queryDataSet1.closeStatement();
        System.exit(0);
    }catch(Exception dd){System.out.println(dd);}

    }

    public void jRadioButton3_actionPerformed(ActionEvent e) {
        try {
            System.out.println("2975974876297459856796298756");
            jRadioButton3.setSelected(true);
            jRadioButton4.setSelected(false);
            jRadioButton5.setSelected(false);
            jRadioButton6.setSelected(false);
            String t =jdbLabel1.getText();
            int w = Integer.valueOf(t);

           st.clearBatch();
        st.executeUpdate("update "+name+" set 考生答案='A'  where ID=" + w);
         System.out.println("fsfgfdhgjfgjhlkjja");
        } catch (Exception ce) {
            System.out.println(ce);
        }

    }

    public void jButton5_actionPerformed(ActionEvent e) {

        dqth=1;
        jLabel20.setText(""+dqth);

        String d=jdbLabel1.getText();
        int i=Integer.valueOf(d);
        try{ System.out.println("------------------------------------");

               ResultSet  rs=st.executeQuery("select 考生答案 from "+name+" where id="+i);
                 System.out.println("+kkkkkkkkkkkkkkkkkkkkkkkkkkkk");
            rs.next();
            String ss=rs.getString("考生答案");
            System.out.println("+++++++++++++++++++++++++");//}catch(Exception ll){}
            if(ss.equals("A"))
        {jRadioButton3.setSelected(true);
        jRadioButton4.setSelected(false);
        jRadioButton5.setSelected(false);
        jRadioButton6.setSelected(false);
          }
          else  if(ss.equals("B")){jRadioButton3.setSelected(false);
        jRadioButton4.setSelected(true);
        jRadioButton5.setSelected(false);
        jRadioButton6.setSelected(false);
                   }
    else  if(ss.equals("C")){jRadioButton3.setSelected(false);
        jRadioButton4.setSelected(false);
        jRadioButton5.setSelected(true);
        jRadioButton6.setSelected(false);
                         }
    else  if(ss.equals("D")){jRadioButton3.setSelected(false);
        jRadioButton4.setSelected(false);
        jRadioButton5.setSelected(false);
        jRadioButton6.setSelected(true);
                   }
  /*  else{jRadioButton3.setSelected(false);
            jRadioButton4.setSelected(false);
            jRadioButton5.setSelected(false);
            jRadioButton6.setSelected(false);
}*/

}catch(Exception eer){}
       queryDataSet1.first();

    }

    public void jButton6_actionPerformed(ActionEvent e) {
        ll();
        //queryDataSet1.openDetails();
       String ssi=jLabel20.getText();
       int r=Integer.valueOf(ssi);
        if(r==1){jLabel20.setText(""+r);}

       dqth--;
        if(dqth==0)
       { dqth=1;

       }
        jLabel20.setText(""+dqth);
         queryDataSet1.prior();
        String d=jdbLabel1.getText();
        int i=Integer.valueOf(d);
        //queryDataSet1.next();
        try{ //i=i-1;

            ResultSet  rs=st.executeQuery("select 考生答案 from "+name+" where id="+i);
            rs.next();
           String ss=rs.getString("考生答案");
           System.out.println("==========================");
           if(ss.equals("A"))
           {
       jRadioButton3.setSelected(true);
       jRadioButton4.setSelected(false);
       jRadioButton5.setSelected(false);
       jRadioButton6.setSelected(false);
         }
         else  if(ss.equals("B")){jRadioButton3.setSelected(false);
       jRadioButton4.setSelected(true);
       jRadioButton5.setSelected(false);
       jRadioButton6.setSelected(false);
     }
   else  if(ss.equals("C")){jRadioButton3.setSelected(false);
       jRadioButton4.setSelected(false);
       jRadioButton5.setSelected(true);
       jRadioButton6.setSelected(false);
}
   else  if(ss.equals("D")){jRadioButton3.setSelected(false);
       jRadioButton4.setSelected(false);
       jRadioButton5.setSelected(false);
       jRadioButton6.setSelected(true);
}
   else{jRadioButton3.setSelected(false);
           jRadioButton4.setSelected(false);
           jRadioButton5.setSelected(false);
           jRadioButton6.setSelected(false);
}

}catch(Exception eer){System.out.println(eer);}

//queryDataSet1.prior();

    }
    public void ll(){
        jRadioButton3.setSelected(false);
        jRadioButton4.setSelected(false);
        jRadioButton5.setSelected(false);
        jRadioButton6.setSelected(false);

    }

    public void jButton7_actionPerformed(ActionEvent e) {

        queryDataSet1.next();
        int  k=0;

       ll();
        try{
            ResultSet rt=st.executeQuery("select 选择题数量 from sysdata");
            rt.next();
              k=rt.getInt("选择题数量");
   }catch(Exception ff){}
         //queryDataSet1.next();
        String d=jdbLabel1.getText();
        int i=Integer.valueOf(d);
        //queryDataSet1.prior();
        jRadioButton3.setSelected(false);
        jRadioButton4.setSelected(false);
        jRadioButton5.setSelected(false);
        jRadioButton6.setSelected(false);
        if(dqth==k){jLabel20.setText(""+dqth);}
            else{dqth++;
            jLabel20.setText(""+dqth);
          //queryDataSet1.prior();
      }

        try{ //i=i+1;
            ResultSet  rs=st.executeQuery("select 考生答案 from "+name+" where id="+i);
            rs.next();
            String ss=rs.getString("考生答案");
            System.out.print("kalhkryhkdhiur");
          if(ss.equals("A"))
            {
        jRadioButton3.setSelected(true);
        jRadioButton4.setSelected(false);
        jRadioButton5.setSelected(false);
        jRadioButton6.setSelected(false);
          }
          else  if(ss.equals("B")){jRadioButton3.setSelected(false);
        jRadioButton4.setSelected(true);
        jRadioButton5.setSelected(false);
        jRadioButton6.setSelected(false);
}
    else  if(ss.equals("C")){jRadioButton3.setSelected(false);
        jRadioButton4.setSelected(false);
        jRadioButton5.setSelected(true);
        jRadioButton6.setSelected(false);
}
    else  if(ss.equals("D")){jRadioButton3.setSelected(false);
        jRadioButton4.setSelected(false);
        jRadioButton5.setSelected(false);
        jRadioButton6.setSelected(true);
}
    /*else{jRadioButton3.setSelected(false);
            jRadioButton4.setSelected(false);
            jRadioButton5.setSelected(false);
            jRadioButton6.setSelected(false);
}
*/
}catch(Exception eer){}
/*jRadioButton3.setSelected(false);
            jRadioButton4.setSelected(false);
            jRadioButton5.setSelected(false);
            jRadioButton6.setSelected(false);*/
//queryDataSet1.next();