vststd.jad

公务员管理系统,本系统的使用可以将工作的部分流程使用计算机的办公自动化处理

        throws SQLException
    {
        Vector vector = new Vector();
        Vector vector1 = new Vector();
        try
        {
            Vector vector3 = getVectorBySelect(s);
            Vector vector2 = (Vector)vector3.get(2);
            for(int i = 0; i < vector2.size(); i++)
                if(vector2.get(i) == null)
                    vector.addElement("");
                else
                    vector.addElement((String)vector2.get(i));

        }
        catch(Exception exception)
        {
            System.out.println("\u6267\u884CSQL\u8BED\u53E5\u65F6\u51FA\u9519\uFF1A" + exception.getMessage());
        }
        return vector;
    }

    public String popListWithSelect(String s, String s1)
    {
        String s2 = "";
        String s4 = "";
        String s6 = "";
        try
        {
            for(ResultSet resultset = getResultBySelect(s); resultset.next();)
            {
                String s3 = resultset.getString(1);
                String s5 = resultset.getString(2);
                if(s3.equals(s1))
                    s6 = s6 + "<option value='" + s3 + "' selected>" + s5 + "</option>";
                else
                    s6 = s6 + "<option value='" + s3 + "'>" + s5 + "</option>";
            }

        }
        catch(Exception exception)
        {
            System.out.println("\u6267\u884CSQL\u8BED\u53E5\u65F6\u51FA\u9519\uFF1A" + exception.getMessage());
        }
        finally
        {
            close();
        }
        return s6;
    }

    public String popRadioWithSelect(String s, String s1, String s2, int i)
    {
        String s3 = "";
        String s5 = "";
        String s7 = ">";
        String s9 = "";
        String s10 = "<table width='100%' border='0' cellspacing='0' cellpadding='0'><tbody><tr>";
        int j = 0;
        try
        {
            for(ResultSet resultset = getResultBySelect(s); resultset.next();)
            {
                String s4 = resultset.getString(1);
                String s6 = resultset.getString(2);
                if(s4 == null)
                    s4 = "";
                if(s6 == null)
                    s6 = "";
                String s8;
                if(s4.equals(s1))
                    s8 = "checked>";
                else
                    s8 = ">";
                s10 = s10 + "<td height='20' width='20'><input type='radio' name='" + s2 + "' value='" + s4 + "'" + s8;
                s10 = s10 + "</td><td>" + s6 + "</td>";
                s8 = ">";
                if(++j == i)
                {
                    s10 = s10 + "</tr><tr>";
                    j = 0;
                }
            }

            s10 = s10 + "</tr></tbody></table>";
        }
        catch(Exception exception)
        {
            System.out.println("\u6267\u884CSQL\u8BED\u53E5\u65F6\u51FA\u9519\uFF1A" + exception.getMessage());
        }
        finally
        {
            close();
        }
        return s10;
    }

    public String popCheckboxWithCode(String s, String s1, String s2, int i)
    {
        String s3 = "";
        String s5 = "";
        String s7 = "<table width='100%' border='0' cellspacing='0' cellpadding='0'><tbody><tr>";
        String s8 = ">";
        int j = 0;
        try
        {
            Vector vector = columnValues(s1);
            for(ResultSet resultset = getResultBySelect(s); resultset.next();)
            {
                String s4 = resultset.getString(1);
                String s6 = resultset.getString(2);
                if(s4 == null)
                    s4 = "";
                if(s6 == null)
                    s6 = "";
                for(int k = 0; k < vector.size(); k++)
                    if(vector.get(k).equals(s4))
                        s8 = " checked>";

                s7 = s7 + "<td  width='25%'><input type='checkbox' name='" + s2 + "' value='" + s4 + "'" + s8 + s6 + "</td>";
                s8 = ">";
                if(++j == 4)
                {
                    s7 = s7 + "</tr><tr>";
                    j = 0;
                }
            }

            s7 = s7 + "</tr></tbody></table>";
        }
        catch(Exception exception)
        {
            System.out.println("\u6267\u884CSQL\u8BED\u53E5\u65F6\u51FA\u9519\uFF1A" + exception.getMessage());
        }
        finally
        {
            close();
        }
        return s7;
    }

    public String fixString(String s)
    {
        int i = 0;
        if(s == null)
            return "";
        char c;
        StringBuffer stringbuffer;
        for(stringbuffer = new StringBuffer(s); i < stringbuffer.length();)
            if((c = stringbuffer.charAt(i)) == '"')
            {
                stringbuffer.replace(i, i + 1, "&#34;");
                i += 5;
            } else
            if(c == '&')
            {
                stringbuffer.replace(i, i + 1, "&amp;");
                i += 5;
            } else
            if(c == '<')
            {
                stringbuffer.replace(i, i + 1, "&lt;");
                i += 4;
            } else
            if(c == '>')
            {
                stringbuffer.replace(i, i + 1, "&gt;");
                i += 4;
            } else
            if(c == '\'')
            {
                stringbuffer.replace(i, i + 1, "''");
                i += 2;
            } else
            {
                i++;
            }

        return stringbuffer.toString();
    }

    public String fixEnter(String s)
    {
        String s1 = "";
        s = s.replace(' ', '\032');
        for(StringTokenizer stringtokenizer = new StringTokenizer(s, "\n"); stringtokenizer.hasMoreTokens();)
            s1 = s1 + stringtokenizer.nextToken() + "<br>";

        return s1;
    }

    public String showMsg(String s)
    {
        String s1 = "<script language='javascript'>alert('";
        s1 = s1 + s;
        s1 = s1 + "');</script>";
        return s1;
    }

    public String showMsgback(String s, String s1)
    {
        String s2 = s1;
        if(s2.equals(""))
            s2 = "-1";
        String s3 = "<script language='javascript'>alert('";
        s3 = s3 + s;
        s3 = s3 + "');window.history.go(" + s2 + ")</script>";
        s3 = s3 + "<a href='javascript:window.history.go(" + s2 + ")'>";
        s3 = s3 + s;
        s3 = s3 + "</a>";
        return s3;
    }

    public String getStringByValues(HttpServletRequest httpservletrequest, String s)
    {
        String s1 = "";
        String s2 = httpservletrequest.getParameter(s);
        if(s2 != null)
        {
            String as[] = httpservletrequest.getParameterValues(s);
            for(int i = 0; i < as.length; i++)
                s1 = s1 + as[i] + "$";

            s1 = s1.substring(0, s1.length() - 1);
        } else
        {
            s1 = "";
        }
        return s1;
    }

    public Vector columnValues(String s)
        throws SQLException
    {
        Vector vector = new Vector();
        try
        {
            String s1 = s;
            String s2;
            for(s1 = s1 + "$"; s1.indexOf("$") > 0; vector.addElement(s2))
            {
                s2 = s1.substring(0, s1.indexOf("$"));
                s1 = s1.substring(s1.indexOf("$") + 1, s1.length());
            }

        }
        catch(Exception exception)
        {
            return vector;
        }
        return vector;
    }

    public String getValue(HttpServletRequest httpservletrequest, String s)
    {
        String s1 = httpservletrequest.getParameter(s);
        if(s1 == null)
            s1 = "";
        return s1;
    }

    DataSource ds;
    Context ctx;
    Connection con;
    ResultSet rs;
    Statement stmt;
    String jndiname;
}