statpersonstatusservlet.java

JSP物业管理系统 一份比较完整的物业管理系统源码。 对于初学者可以有一定的借鉴。

// Decompiled by Jad v1.5.7g. Copyright 2000 Pavel Kouznetsov.
// Jad home page: http://www.geocities.com/SiliconValley/Bridge/8617/jad.html
// Decompiler options: packimports(3) fieldsfirst ansi 
// Source File Name:   StatPersonStatusServlet.java

package personaladmin.statistic;

import common.*;
import java.io.*;
import java.util.Vector;
import javax.servlet.*;
import javax.servlet.http.*;

// Referenced classes of package personaladmin.statistic:
//            StatPersonStatusDBBean

public class StatPersonStatusServlet extends ParentServlet
{

    public StatPersonStatusServlet()
    {
    }

    public void performTask(HttpServletRequest httpservletrequest, HttpServletResponse httpservletresponse)
    {
        try
        {
            StatPersonStatusDBBean statpersonstatusdbbean = new StatPersonStatusDBBean();
            ParseInputStringBean parseinputstringbean = new ParseInputStringBean();
            DateTimeBean datetimebean = new DateTimeBean();
            String s = httpservletrequest.getParameter("inputString");
            Vector vector = parseinputstringbean.parseCommonFormatIS(s);
            Vector vector1 = (Vector)getServletContext().getAttribute("Para");
            statpersonstatusdbbean.setUserID((String)vector1.elementAt(0));
            statpersonstatusdbbean.setPassword((String)vector1.elementAt(1));
            statpersonstatusdbbean.setURL((String)vector1.elementAt(2));
            statpersonstatusdbbean.setDriver((String)vector1.elementAt(3));
            statpersonstatusdbbean.setDataSourceName((String)vector1.elementAt(4));
            String s1 = "1";
            statpersonstatusdbbean.setPage(1);
            s1 = "1";
            try
            {
                statpersonstatusdbbean.initialize();
            }
            catch(Exception exception1)
            {
                throw exception1;
            }
            statpersonstatusdbbean.setPageLength(5);
            statpersonstatusdbbean.setDelFlag("0");
            statpersonstatusdbbean.setTableName("personnelinfo");
            statpersonstatusdbbean.setSelectSQL01("SELECT  NUMBER,PERSNUMB, PERSNAME, PERSGENDER,PICTURENAME, NATION, BORNDATE, ADDRESS, EDULEVEL, TECHNICA,MARRIAGE,SKILL,LIKE,IDENTIRYCODE,PHONE,SCHOOL1,STARTDATE1,ENDDATE1,SPECIALTY1,SCHOOL2,STARTDATE2,ENDDATE2,SPECIALTY2,SCHOOL3,STARTDATE3,ENDDATE3,SPECIALTY3,COMPNAME1,CSTARTDATE1,CENDDATE1,JOB1,COMPNAME2,CSTARTDATE2,CENDDATE2,JOB2,COMPNAME3,CSTARTDATE3,CENDDATE3,JOB3,FNAME1,RELATION1,ADDR1,FPHONE1,FNAME2,RELATION2,ADDR2,FPHONE2,FNAME3,RELATION3,ADDR3,FPHONE3,DATE,DEPT,STATUS,LEAVEREASON,LINKMAN,LINKTEL,DELFLAG FROM " + statpersonstatusdbbean.getTableName() + " WHERE DELFLAG= ? ");
            statpersonstatusdbbean.setTableName3("jobchangeinfo");
            statpersonstatusdbbean.setSelectSQL03("SELECT NUMBER,PERSNUM,CHANGEDATE,BEFOREJOB,NOWJOB,CHANGEREASON FROM " + statpersonstatusdbbean.getTableName3() + " WHERE PERSNUM = ? AND DELFLAG = ? order by number desc");
            try
            {
                statpersonstatusdbbean.select01();
                statpersonstatusdbbean.getDataFromResult01();
                for(int i = 0; i < statpersonstatusdbbean.vpersnumbb.size(); i++)
                {
                    statpersonstatusdbbean.setPersNumb((String)statpersonstatusdbbean.vpersnumbb.elementAt(i));
                    statpersonstatusdbbean.select03();
                    statpersonstatusdbbean.getDataFromResult03();
                    statpersonstatusdbbean.vnowjob2.addElement(statpersonstatusdbbean.nowjob);
                }

                statpersonstatusdbbean.setOpcontent("统计员工状态记录");
                HttpSession httpsession = httpservletrequest.getSession(false);
                statpersonstatusdbbean.setOperator((String)httpsession.getValue("persname"));
                statpersonstatusdbbean.setOpdate(datetimebean.getDate());
                statpersonstatusdbbean.setOptime(datetimebean.getTime());
                statpersonstatusdbbean.insertLog();
                statpersonstatusdbbean.commitToDB();
            }
            catch(Exception exception3)
            {
                throw new Exception(exception3.getMessage());
            }
            finally
            {
                statpersonstatusdbbean.releaseConnection();
            }
            httpservletrequest.setAttribute("flag", String.valueOf(statpersonstatusdbbean.getStatusCode()));
            httpservletrequest.setAttribute("statusMessage", statpersonstatusdbbean.getStatusMessage());
            httpservletrequest.setAttribute("currentpage", String.valueOf(statpersonstatusdbbean.getPage()));
            httpservletrequest.setAttribute("pages", String.valueOf(statpersonstatusdbbean.getPages()));
            httpservletrequest.setAttribute("cond", s1);
            httpservletrequest.setAttribute("vnumber", statpersonstatusdbbean.vnumber);
            httpservletrequest.setAttribute("vpersnumb", statpersonstatusdbbean.vpersnumb);
            httpservletrequest.setAttribute("vpersname", statpersonstatusdbbean.vpersname);
            httpservletrequest.setAttribute("vpersgender", statpersonstatusdbbean.vpersgender);
            httpservletrequest.setAttribute("vnation", statpersonstatusdbbean.vnation);
            httpservletrequest.setAttribute("vborndate", statpersonstatusdbbean.vborndate);
            httpservletrequest.setAttribute("vaddress", statpersonstatusdbbean.vaddress);
            httpservletrequest.setAttribute("vedulevel", statpersonstatusdbbean.vedulevel);
            httpservletrequest.setAttribute("vtechnica", statpersonstatusdbbean.vtechnica);
            httpservletrequest.setAttribute("vmarriage", statpersonstatusdbbean.vmarriage);
            httpservletrequest.setAttribute("vskill", statpersonstatusdbbean.vskill);
            httpservletrequest.setAttribute("vlike", statpersonstatusdbbean.vlike);
            httpservletrequest.setAttribute("videntirycard", statpersonstatusdbbean.videntirycode);
            httpservletrequest.setAttribute("vphone", statpersonstatusdbbean.vphone);
            httpservletrequest.setAttribute("vschool1", statpersonstatusdbbean.vschool1);
            httpservletrequest.setAttribute("vstaradate1", statpersonstatusdbbean.vstaradate1);
            httpservletrequest.setAttribute("venddate1", statpersonstatusdbbean.venddate1);
            httpservletrequest.setAttribute("vspecialty1", statpersonstatusdbbean.vspecialty1);
            httpservletrequest.setAttribute("vschool2", statpersonstatusdbbean.vschool2);
            httpservletrequest.setAttribute("vstaradate2", statpersonstatusdbbean.vstaradate2);
            httpservletrequest.setAttribute("venddate2", statpersonstatusdbbean.venddate2);
            httpservletrequest.setAttribute("vspecialty2", statpersonstatusdbbean.vspecialty2);
            httpservletrequest.setAttribute("vschool3", statpersonstatusdbbean.vschool3);
            httpservletrequest.setAttribute("vstaradate3", statpersonstatusdbbean.vstaradate3);
            httpservletrequest.setAttribute("venddate3", statpersonstatusdbbean.venddate3);
            httpservletrequest.setAttribute("vspecialty3", statpersonstatusdbbean.vspecialty3);
            httpservletrequest.setAttribute("vcompname1", statpersonstatusdbbean.vcompname1);
            httpservletrequest.setAttribute("vcstartdate1", statpersonstatusdbbean.vcstartdate1);
            httpservletrequest.setAttribute("vcenddate1", statpersonstatusdbbean.vcenddate1);
            httpservletrequest.setAttribute("vjob1", statpersonstatusdbbean.vjob1);
            httpservletrequest.setAttribute("vcompname2", statpersonstatusdbbean.vcompname2);
            httpservletrequest.setAttribute("vcstartdate2", statpersonstatusdbbean.vcstartdate2);
            httpservletrequest.setAttribute("vcenddate2", statpersonstatusdbbean.vcenddate2);
            httpservletrequest.setAttribute("vjob2", statpersonstatusdbbean.vjob2);
            httpservletrequest.setAttribute("vcompname3", statpersonstatusdbbean.vcompname3);
            httpservletrequest.setAttribute("vcstartdate3", statpersonstatusdbbean.vcstartdate3);
            httpservletrequest.setAttribute("vcenddate3", statpersonstatusdbbean.vcenddate3);
            httpservletrequest.setAttribute("vjob3", statpersonstatusdbbean.vjob3);
            httpservletrequest.setAttribute("vfname1", statpersonstatusdbbean.vfname1);
            httpservletrequest.setAttribute("vrelation1", statpersonstatusdbbean.vrelation1);
            httpservletrequest.setAttribute("vaddr1", statpersonstatusdbbean.vaddr1);
            httpservletrequest.setAttribute("vfphone1", statpersonstatusdbbean.vfphone1);
            httpservletrequest.setAttribute("vfname2", statpersonstatusdbbean.vfname2);
            httpservletrequest.setAttribute("vrelation2", statpersonstatusdbbean.vrelation2);
            httpservletrequest.setAttribute("vaddr2", statpersonstatusdbbean.vaddr2);
            httpservletrequest.setAttribute("vfphone2", statpersonstatusdbbean.vfphone2);
            httpservletrequest.setAttribute("vfname3", statpersonstatusdbbean.vfname3);
            httpservletrequest.setAttribute("vrelation3", statpersonstatusdbbean.vrelation3);
            httpservletrequest.setAttribute("vaddr3", statpersonstatusdbbean.vaddr3);
            httpservletrequest.setAttribute("vfphone3", statpersonstatusdbbean.vfphone3);
            httpservletrequest.setAttribute("vdate", statpersonstatusdbbean.vdate);
            httpservletrequest.setAttribute("vdept", statpersonstatusdbbean.vdept);
            httpservletrequest.setAttribute("vstatus", statpersonstatusdbbean.vstatus);