t_question.jad

在线考试软件。 在线考试软件详细设计说明书：说明在线测试这一模块各部分的功能和结构

// Decompiled by DJ v3.2.2.67 Copyright 2002 Atanas Neshkov  Date: 2005-6-15 22:11:18
// Home Page : http://members.fortunecity.com/neshkov/dj.html  - Check often for new version!
// Decompiler options: packimports(3) 
// Source File Name:   T_Question.java

package jinghua;

import java.io.PrintStream;
import java.sql.*;

public class T_Question
{

    public T_Question(Connection con)
    {
        this.con = con;
    }

    public T_Question()
    {
    }

    public static int addCorrectCount(Connection con, long id)
    {
        String sql;
        int UsedCount;
        sql = null;
        UsedCount = 1;
        sql = " update question set CorrectCount=CorrectCount+1 WHERE  (ID = " + id + ")";
        Statement stmt = con.createStatement();
        stmt.executeUpdate(sql);
        con.commit();
        stmt.close();
        break MISSING_BLOCK_LABEL_154;
        SQLException se;
        se;
        UsedCount = -1;
        System.out.println("Add Correctcount error sql=" + sql);
        System.out.println(se.toString());
        break MISSING_BLOCK_LABEL_154;
        Exception e;
        e;
        UsedCount = -1;
        System.out.println("Add correctcount error sql=" + sql);
        System.out.println(e.toString());
        return UsedCount;
    }

    public static int addUsedCount(Connection con, long id)
    {
        String sql;
        int UsedCount;
        sql = null;
        UsedCount = 1;
        sql = " update question set UsedCount=UsedCount+1 WHERE  (ID = " + id + ")";
        Statement stmt = con.createStatement();
        stmt.executeUpdate(sql);
        con.commit();
        stmt.close();
        break MISSING_BLOCK_LABEL_154;
        SQLException se;
        se;
        UsedCount = -1;
        System.out.println("Add usedcount error sql=" + sql);
        System.out.println(se.toString());
        break MISSING_BLOCK_LABEL_154;
        Exception e;
        e;
        UsedCount = -1;
        System.out.println("Add usedcount error sql=" + sql);
        System.out.println(e.toString());
        return UsedCount;
    }

    public static int getCorrectCount(Connection con, long id)
    {
        String sql;
        int UsedCount;
        sql = null;
        UsedCount = -1;
        sql = " SELECT   `question`.`CorrectCount` FROM  `question` WHERE  (`question`.`ID` = " + id + ")";
        Statement stmt = con.createStatement();
        ResultSet rs = stmt.executeQuery(sql);
        if(rs.next())
            UsedCount = rs.getInt("CorrectCount");
        rs.close();
        stmt.close();
        break MISSING_BLOCK_LABEL_178;
        SQLException se;
        se;
        UsedCount = -1;
        System.out.println("Query usedcount error sql=" + sql);
        System.out.println(se.toString());
        break MISSING_BLOCK_LABEL_178;
        Exception e;
        e;
        UsedCount = -1;
        System.out.println("Query usedcount error sql=" + sql);
        System.out.println(e.toString());
        return UsedCount;
    }

    public static String getCorrectRate(Connection con, long id)
    {
        String hard;
        String sql;
        float rate;
        hard = "#";
        sql = null;
        rate = -1F;
        sql = " SELECT   (`question`.`CorrectCount`/`question`.`UsedCount`) as rate FROM  `question` WHERE  (`question`.`ID` = " + id + ")";
        Statement stmt = con.createStatement();
        ResultSet rs = stmt.executeQuery(sql);
        if(rs.next())
            rate = rs.getFloat("rate");
        rs.close();
        stmt.close();
        break MISSING_BLOCK_LABEL_189;
        SQLException se;
        se;
        rate = -1F;
        System.out.println("Query rate error sql=" + sql);
        System.out.println(se.toString());
        break MISSING_BLOCK_LABEL_189;
        Exception e;
        e;
        rate = -1F;
        System.out.println("Query rate error sql=" + sql);
        System.out.println(e.toString());
        if(rate >= 0.0F)
        {
            if((double)rate <= 0.20000000000000001D)
                hard = "A";
            else
            if((double)rate <= 0.40000000000000002D)
                hard = "B";
            else
            if((double)rate <= 0.59999999999999998D)
                hard = "C";
            else
            if((double)rate <= 0.80000000000000004D)
                hard = "D";
            else
                hard = "E";
        }
        return hard;
    }

    public static int getUsedCount(Connection con, long id)
    {
        String sql;
        int UsedCount;
        sql = null;
        UsedCount = -1;
        sql = " SELECT   `question`.`UsedCount` FROM  `question` WHERE  (`question`.`ID` = " + id + ")";
        Statement stmt = con.createStatement();
        ResultSet rs = stmt.executeQuery(sql);
        if(rs.next())
            UsedCount = rs.getInt("UsedCount");
        rs.close();
        stmt.close();
        break MISSING_BLOCK_LABEL_178;
        SQLException se;
        se;
        UsedCount = -1;
        System.out.println("Query usedcount error sql=" + sql);
        System.out.println(se.toString());
        break MISSING_BLOCK_LABEL_178;
        Exception e;
        e;
        UsedCount = -1;
        System.out.println("Query usedcount error sql=" + sql);
        System.out.println(e.toString());
        return UsedCount;
    }

    Connection con;
}