t_errorpad.java

在线考试系统

package jinghua;

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

public class T_errorpad
{

    public T_errorpad()
    {
    }

    public static int addErrorCount(Connection con, String ids)
    {
        String sql;
        int valid;
        sql = "update errorpad set errorcount=errorcount+1 where id in (" + ids + ")";
        valid = 1;
        Statement stmt = con.createStatement();
        stmt.executeUpdate(sql);
        con.commit();
        stmt.close();
        break MISSING_BLOCK_LABEL_149;
        SQLException se;
        se;
        valid = -1;
        System.out.println("Add errorcount error sql=" + sql);
        System.out.println(se.toString());
        break MISSING_BLOCK_LABEL_149;
        Exception e;
        e;
        valid = -1;
        System.out.println("Add errorcount error sql=" + sql);
        System.out.println(e.toString());
        return valid;
    }

    public static int decErrorCount(Connection con, String ids)
    {
        String sql;
        int valid;
        sql = "update errorpad set errorcount=errorcount-1 where id in (" + ids + ")";
        valid = 1;
        Statement stmt = con.createStatement();
        stmt.executeUpdate(sql);
        con.commit();
        stmt.close();
        break MISSING_BLOCK_LABEL_149;
        SQLException se;
        se;
        valid = -1;
        System.out.println("Add errorcount error sql=" + sql);
        System.out.println(se.toString());
        break MISSING_BLOCK_LABEL_149;
        Exception e;
        e;
        valid = -1;
        System.out.println("Add errorcount error sql=" + sql);
        System.out.println(e.toString());
        return valid;
    }
}