vststd.jad

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

// Decompiled by DJ v2.9.9.60 Copyright 2000 Atanas Neshkov  Date: 2003-9-8 9:32:41
// Home Page : http://members.fortunecity.com/neshkov/dj.html  - Check often for new version!
// Decompiler options: packimports(3) 
// Source File Name:   vststd.java

package com.vstsoft.std;

import java.io.PrintStream;
import java.io.UnsupportedEncodingException;
import java.sql.*;
import java.util.StringTokenizer;
import java.util.Vector;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.servlet.ServletRequest;
import javax.servlet.http.HttpServletRequest;
import javax.sql.DataSource;

public class vststd
{

    public vststd(String s)
    {
        ds = null;
        ctx = null;
        con = null;
        rs = null;
        stmt = null;
        jndiname = "";
        jndiname = s;
    }

    public int getResultByUpdate(String s)
        throws SQLException
    {
        int i = 0;
        try
        {
            ctx = new InitialContext();
            ds = (DataSource)ctx.lookup(jndiname);
            try
            {
                con = ds.getConnection();
                con.setAutoCommit(true);
                stmt = con.createStatement();
            }
            catch(SQLException sqlexception)
            {
                System.out.println("\u521B\u5EFA\u6570\u636E\u5E93\u8FDE\u63A5\u65F6\u51FA\u9519\uFF1A" + sqlexception.getMessage());
            }
            s = new String(s.getBytes("ISO8859_1"));
            i = stmt.executeUpdate(s);
        }
        catch(Exception exception)
        {
            System.out.println("\u6267\u884CSQL\u8BED\u53E5\u65F6\u51FA\u9519\uFF1A" + exception.getMessage());
        }
        finally
        {
            try
            {
                stmt.close();
                con.close();
            }
            catch(SQLException sqlexception1)
            {
                System.out.println("\u5173\u95ED\u8FDE\u63A5\u65F6\u51FA\u9519\uFF1A" + sqlexception1.getMessage());
            }
        }
        return i;
    }

    public ResultSet getResultBySelect(String s)
        throws SQLException
    {
        try
        {
            ctx = new InitialContext();
            ds = (DataSource)ctx.lookup(jndiname);
            try
            {
                con = ds.getConnection();
                con.setAutoCommit(true);
                stmt = con.createStatement();
            }
            catch(SQLException sqlexception)
            {
                System.out.println("\u521B\u5EFA\u6570\u636E\u5E93\u8FDE\u63A5\u65F6\u51FA\u9519\uFF1A" + sqlexception.getMessage());
            }
            s = new String(s.getBytes("ISO8859_1"));
            rs = stmt.executeQuery(s);
        }
        catch(Exception exception)
        {
            System.out.println("\u6267\u884CSQL\u8BED\u53E5\u65F6\u51FA\u9519\uFF1A" + exception.getMessage());
        }
        return rs;
    }

    public void close()
    {
        try
        {
            rs.close();
            stmt.close();
            con.close();
        }
        catch(Exception exception)
        {
            System.out.println("\u5173\u95ED\u8FDE\u63A5\u65F6\u51FA\u9519: " + exception.getMessage());
        }
    }

    public Vector Sort(ResultSet resultset)
    {
        int i = 0;
        boolean flag = false;
        Vector vector = new Vector();
        ResultSetMetaData resultsetmetadata = null;
        try
        {
            i = resultset.getMetaData().getColumnCount();
            resultsetmetadata = resultset.getMetaData();
        }
        catch(Exception exception)
        {
            System.out.println("\u8FD4\u56DE\u6570\u636E\u5E93\u4FE1\u606F\u63A5\u53E3\u65F6\u51FA\u9519: " + exception.getMessage());
        }
        try
        {
            Vector vector1 = new Vector();
            for(int k = 1; k <= i; k++)
                vector1.addElement(resultsetmetadata.getColumnLabel(k));

            vector.addElement(vector1);
            Vector vector2 = new Vector();
            for(int l = 1; l <= i; l++)
                vector2.addElement(resultsetmetadata.getColumnTypeName(l));

            vector.addElement(vector2);
            Vector vector3;
            for(; resultset.next(); vector.addElement(vector3))
            {
                vector3 = new Vector();
                for(int i1 = 1; i1 <= i; i1++)
                {
                    String s = (String)vector2.get(i1 - 1);
                    if(s.equals("VARCHAR2"))
                        vector3.addElement(resultset.getString(i1));
                    else
                    if(s.equals("NUMBER"))
                        vector3.addElement(resultset.getString(i1));
                    else
                    if(s.equals("DATE"))
                        vector3.addElement(resultset.getDate(i1));
                }

            }

            int j = vector.size() - 2;
            vector.remove(1);
            vector.add(1, "" + j);
        }
        catch(Exception exception1)
        {
            System.out.println("\u8F6C\u6362\u7ED3\u679C\u96C6\u65F6\u51FA\u9519: " + exception1.getMessage());
        }
        return vector;
    }

    public Vector getVectorBySelect(String s)
        throws SQLException
    {
        Vector vector = new Vector();
        Object obj = null;
        try
        {
            s = new String(s.getBytes("ISO8859_1"));
            ResultSet resultset = getResultBySelect(s);
            vector = Sort(resultset);
        }
        catch(Exception exception)
        {
            System.out.println("\u8FD4\u56DEVector\u65F6\u51FA\u9519: " + exception.getMessage());
        }
        finally
        {
            close();
        }
        return vector;
    }

    public int getRecNumBySelect(String s)
        throws SQLException, UnsupportedEncodingException
    {
        int i = 0;
        try
        {
            ctx = new InitialContext();
            ds = (DataSource)ctx.lookup(jndiname);
            try
            {
                con = ds.getConnection();
                con.setAutoCommit(true);
                stmt = con.createStatement();
            }
            catch(SQLException sqlexception)
            {
                System.out.println("\u521B\u5EFA\u6570\u636E\u5E93\u8FDE\u63A5\u65F6\u51FA\u9519\uFF1A" + sqlexception.getMessage());
            }
            s = new String(s.getBytes("ISO8859_1"));
            s = s.substring(s.indexOf("from") + 4);
            s = "select count(1) from " + s;
            rs = stmt.executeQuery(s);
            if(rs.next())
                i = rs.getInt(1);
            else
                i = 0;
        }
        catch(Exception exception)
        {
            System.out.println("\u6267\u884CSQL\u8BED\u53E5\u65F6\u51FA\u9519\uFF1A" + exception.getMessage());
        }
        finally
        {
            try
            {
                rs.close();
                stmt.close();
                con.close();
            }
            catch(SQLException sqlexception1)
            {
                System.out.println("\u5173\u95ED\u8FDE\u63A5\u65F6\u51FA\u9519\uFF1A" + sqlexception1.getMessage());
            }
        }
        return i;
    }

    public String getColValue(String s)
        throws SQLException
    {
        String s1 = "";
        try
        {
            ResultSet resultset = getResultBySelect(s);
            if(resultset.next())
            {
                s1 = resultset.getString(1);
                if(s1 == null)
                    s1 = "";
            } else
            {
                s1 = "";
            }
        }
        catch(Exception exception)
        {
            System.out.println("\u6267\u884CSQL\u8BED\u53E5\u65F6\u51FA\u9519\uFF1A" + exception.getMessage());
        }
        finally
        {
            close();
        }
        return s1;
    }

    public Vector getColValues(String s)