jh_tools.jad

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

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

package jinghua;

import java.io.*;
import java.sql.*;
import javax.servlet.jsp.JspWriter;

public class JH_Tools
{

    public JH_Tools()
    {
    }

    public static String Replace(String source, String oldString, String newString)
    {
        StringBuffer output = new StringBuffer();
        int lengthOfSource = source.length();
        int lengthOfOld = oldString.length();
        int posStart;
        int i;
        for(posStart = 0; (i = source.indexOf(oldString, posStart)) >= 0; posStart = i + lengthOfOld)
        {
            output.append(source.substring(posStart, i));
            output.append(newString);
        }

        if(posStart < lengthOfSource)
            output.append(source.substring(posStart));
        return output.toString();
    }

    public static String ReplaceFirst(String source, String oldString, String newString)
    {
        StringBuffer output = new StringBuffer();
        int lengthOfSource = source.length();
        int lengthOfOld = oldString.length();
        int posStart = 0;
        int pos;
        if((pos = source.indexOf(oldString, posStart)) >= 0)
        {
            output.append(source.substring(posStart, pos));
            output.append(newString);
            posStart = pos + lengthOfOld;
        }
        if(posStart < lengthOfSource)
            output.append(source.substring(posStart));
        return output.toString();
    }

    public static String codestring(String s)
    {
        String str = s;
        byte b[] = str.getBytes("ISO-8859-1");
        str = new String(b);
        return str;
        Exception e;
        e;
        return str;
    }

    public static void debugmsg(String msg, JspWriter out)
    {
        out.print(msg);
        break MISSING_BLOCK_LABEL_24;
        Exception e;
        e;
        System.out.println(e.toString());
        return;
    }

    public static void goback(JspWriter out)
    {
        out.print("<SCRIPT LANGUAGE=\"javascript\"\n>    history.go(-1);\n</SCRIPT>\n");
        break MISSING_BLOCK_LABEL_25;
        Exception e;
        e;
        System.out.println(e.toString());
        return;
    }

    public static String grade_mntest(Connection con)
    {
        int i;
        StringBuffer sb;
        String sql;
        i = 0;
        sb = new StringBuffer("");
        sql = "SELECT   name,  id,  grade_note FROM  mn_test";
        PreparedStatement pstmt = con.prepareStatement(sql);
        ResultSet rs = pstmt.executeQuery();
        sb.append("<script language =\"JavaScript\">\n");
        sb.append("var gmcount;\n");
        sb.append("gmcount=0;\n");
        sb.append("grade_mntest=new Array();\n");
        while(rs.next()) 
        {
            sb.append("grade_mntest[" + i + "]=new Array(\"" + rs.getString("grade_note") + "\",\"" + rs.getInt("id") + "\",\"" + rs.getString("name") + "\")\n");
            i++;
        }
        sb.append("gmcount=" + i + "\n");
        sb.append("</script>\n");
        break MISSING_BLOCK_LABEL_215;
        SQLException se;
        se;
        System.out.print(se.toString());
        return sb.toString();
    }

    public static String grade_sub(Connection con)
    {
        int i;
        StringBuffer sb;
        String sql;
        i = 0;
        sb = new StringBuffer("");
        sql = "select id,name,gradenote from subject order by gradenote,id";
        PreparedStatement pstmt = con.prepareStatement(sql);
        ResultSet rs = pstmt.executeQuery();
        sb.append("<script language =\"JavaScript\">\n");
        sb.append("var gscount;\n");
        sb.append("gscount=0;\n");
        sb.append("grade_sub=new Array();\n");
        while(rs.next()) 
        {
            sb.append("grade_sub[" + i + "]=new Array(\"" + rs.getString("gradenote") + "\",\"" + rs.getInt("id") + "\",\"" + rs.getString("name") + "\")\n");
            i++;
        }
        sb.append("gscount=" + i + "\n");
        sb.append("</script>\n");
        break MISSING_BLOCK_LABEL_215;
        SQLException se;
        se;
        System.out.print(se.toString());
        return sb.toString();
    }

    public static String readFile(String filename)
    {
        String httpText = null;
        File file = new File(filename);
        FileInputStream fis = new FileInputStream(file);
        byte webxml[] = new byte[fis.available()];
        fis.read(webxml);
        httpText = new String(webxml);
        break MISSING_BLOCK_LABEL_67;
        FileNotFoundException e2;
        e2;
        e2.printStackTrace();
        break MISSING_BLOCK_LABEL_67;
        IOException e;
        e;
        e.printStackTrace();
        System.out.print(httpText);
        return httpText;
    }

    public static String selgrade_sub(Connection con)
    {
        int i;
        StringBuffer sb;
        String sql;
        i = 0;
        sb = new StringBuffer("");
        sql = "select id,name,gradenote from subject order by gradenote,id";
        PreparedStatement pstmt = con.prepareStatement(sql);
        ResultSet rs = pstmt.executeQuery();
        sb.append("<script language =\"JavaScript\">\n");
        sb.append("var gscount;\n");
        sb.append("gscount=0;\n");
        sb.append("grade_sub=new Array();\n");
        while(rs.next()) 
        {
            sb.append("grade_sub[" + i + "]=new Array(\"" + rs.getString("gradenote") + "\",\"" + rs.getInt("id") + "\",\"" + rs.getString("name") + "\")\n");
            i++;
        }
        sb.append("gscount=" + i + "\n");
        sb.append("function changegs(locationid)\n");
        sb.append("{\n");
        sb.append("document.myform.selsubject.length =1;\n");
        sb.append("var locationid=locationid;\n");
        sb.append("var i;\n");
        sb.append("for (i=0;i < gscount; i++)\n");
        sb.append("{\n");
        sb.append("if (grade_sub[i][0] == locationid)\n");
        sb.append("{\n");
        sb.append("document.myform.selsubject.options[document.myform.selsubject.length] = new Option(grade_sub[i][2], grade_sub[i][1]);\n");
        sb.append("}\n}\n}\n");
        sb.append("</script>\n");
        break MISSING_BLOCK_LABEL_292;
        SQLException se;
        se;
        System.out.print(se.toString());
        return sb.toString();
    }

    public static void showGradeOption(Connection con, JspWriter out)
    {
        String sql;
        Statement stmt = null;
        ResultSet rs = null;
        sql = "select * from grade order by id";
        Statement stmt = con.createStatement();
        ResultSet rs;
        for(rs = stmt.executeQuery(sql); rs.next(); out.print("<OPTION value=\"" + rs.getString("note") + "\">" + rs.getString("Name") + "</OPTION>"));
        rs.close();
        stmt.close();
        break MISSING_BLOCK_LABEL_146;
        SQLException se;
        se;
        out.print(se);
        break MISSING_BLOCK_LABEL_121;
        Exception e;
        e;
        break MISSING_BLOCK_LABEL_146;
        Exception se;
        se;
        out.print(se);
        break MISSING_BLOCK_LABEL_142;
        Exception e1;
        e1;
        return;
    }

    public static void showJS(String msg, JspWriter out)
    {
        out.print("<SCRIPT LANGUAGE=\"javascript\"\n>" + msg + ";\n" + "</SCRIPT>\n");
        break MISSING_BLOCK_LABEL_52;
        Exception e;
        e;
        System.out.println(e.toString());
        return;
    }

    public static void showOption(String sql, Connection con, JspWriter out)
    {
        Statement stmt = null;
        ResultSet rs = null;
        Statement stmt = con.createStatement();
        ResultSet rs;
        for(rs = stmt.executeQuery(sql); rs.next(); out.print("<OPTION value=" + rs.getInt("ID") + ">" + rs.getString("Name") + "</OPTION>"));
        rs.close();
        stmt.close();
        break MISSING_BLOCK_LABEL_147;
        SQLException se;
        se;
        out.print(se);
        break MISSING_BLOCK_LABEL_122;
        Exception e;
        e;
        break MISSING_BLOCK_LABEL_147;
        Exception se;
        se;
        out.print(se);
        break MISSING_BLOCK_LABEL_143;
        Exception e1;
        e1;
        return;
    }

    public static void showalert(String msg, JspWriter out)
    {
        out.print("<SCRIPT LANGUAGE=\"javascript\"\n>    alert(\"" + msg + "\");\n" + "</SCRIPT>\n");
        break MISSING_BLOCK_LABEL_52;
        Exception e;
        e;
        System.out.println(e.toString());
        return;
    }

    public static String sub_know(Connection con)
    {
        int i;
        StringBuffer sb;
        String sql;
        i = 0;
        sb = new StringBuffer("");
        sql = "select id,name,gradenote,subid from knowpoint order by gradenote,subid,id";
        PreparedStatement pstmt = con.prepareStatement(sql);
        ResultSet rs = pstmt.executeQuery();
        sb.append("<script language =\"JavaScript\">\n");
        sb.append("var gscount;\n");
        sb.append("gscount=0;\n");
        sb.append("grade_sub_know=new Array();\n");
        while(rs.next()) 
        {
            sb.append("grade_sub_know[" + i + "]=new Array(\"" + rs.getString("gradenote") + "\",\"" + rs.getInt("subid") + "\",\"" + rs.getInt("id") + "\",\"" + rs.getString("name") + "\")\n");
            i++;
        }
        sb.append("gskcount=" + i + "\n");
        sb.append("</script>\n");
        break MISSING_BLOCK_LABEL_232;
        SQLException se;
        se;
        System.out.print(se.toString());
        return sb.toString();
    }

    public static String toHtml(String str)
    {
        String html = str;
        html = Replace(html, "&", "&amp;");
        html = Replace(html, "<", "&lt;");
        html = Replace(html, ">", "&gt;");
        html = Replace(html, "\r\n", "\n");
        html = Replace(html, "\n", "<br>\n");
        html = Replace(html, "\t", "    ");
        html = Replace(html, "  ", "  ");
        return html;
    }

    public static String toSql(String sqlstr)
    {
        String strsql = sqlstr;
        strsql = Replace(strsql, "'", "''");
        return strsql;
    }
}