addjobchngservlet.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:   AddJobChngServlet.java

package personaladmin;

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

// Referenced classes of package personaladmin:
//            AddJobChngDBBean, DeleteJobPersonDBBean, AddPersonForJobDBBean

public class AddJobChngServlet extends ParentServlet
{

    public AddJobChngServlet()
    {
    }

    public void performTask(HttpServletRequest httpservletrequest, HttpServletResponse httpservletresponse)
    {
        try
        {
            AddJobChngDBBean addjobchngdbbean = new AddJobChngDBBean();
            AddPersonForJobDBBean addpersonforjobdbbean = new AddPersonForJobDBBean();
            DeleteJobPersonDBBean deletejobpersondbbean = new DeleteJobPersonDBBean();
            ParseInputStringBean parseinputstringbean = new ParseInputStringBean();
            Vector vector = (Vector)getServletContext().getAttribute("Para");
            addjobchngdbbean.setUserID((String)vector.elementAt(0));
            addjobchngdbbean.setPassword((String)vector.elementAt(1));
            addjobchngdbbean.setURL((String)vector.elementAt(2));
            addjobchngdbbean.setDriver((String)vector.elementAt(3));
            addjobchngdbbean.setDataSourceName((String)vector.elementAt(4));
            String s = httpservletrequest.getParameter("inputString");
            Vector vector1 = parseinputstringbean.parseCommonFormatIS(s);
            addjobchngdbbean.setPersNumb((String)vector1.elementAt(0));
            addjobchngdbbean.setChangeDate((String)vector1.elementAt(1) + "年" + (String)vector1.elementAt(2) + "月" + (String)vector1.elementAt(3) + "日");
            addjobchngdbbean.setBeforeJob((String)vector1.elementAt(4));
            addjobchngdbbean.setNowJob((String)vector1.elementAt(5));
            addjobchngdbbean.setChangeReason((String)vector1.elementAt(6));
            addjobchngdbbean.setDelFlag("0");
            String s1 = addjobchngdbbean.getBeforeJob();
            int i = 0;
            i = s1.indexOf("*");
            s1 = s1.substring(0, i);
            String s2 = addjobchngdbbean.getNowJob();
            int j = 0;
            j = s2.indexOf("*");
            s2 = s2.substring(0, j);
            addpersonforjobdbbean.setJobnumb(s2);
            addpersonforjobdbbean.setPersnumb((String)vector1.elementAt(0));
            addpersonforjobdbbean.setDelflag("0");
            deletejobpersondbbean.setJobnumb(s1);
            deletejobpersondbbean.setPersnumb((String)vector1.elementAt(0));
            deletejobpersondbbean.setDelflag2("1");
            try
            {
                addjobchngdbbean.initialize();
            }
            catch(Exception exception1)
            {
                throw exception1;
            }
            addpersonforjobdbbean.connBean = ((ParentDBBean) (addjobchngdbbean)).connBean;
            deletejobpersondbbean.connBean = ((ParentDBBean) (addjobchngdbbean)).connBean;
            addjobchngdbbean.setTableName("jobchangeinfo");
            addjobchngdbbean.setInsertSQL01(" INSERT INTO " + addjobchngdbbean.getTableName() + " (NUMBER,PERSNUM,CHANGEDATE,BEFOREJOB,NOWJOB,CHANGEREASON,DELFLAG) VALUES (?,?,?,?,?,?,?)");
            addpersonforjobdbbean.setTableName("personneljob");
            addpersonforjobdbbean.setInsertSQL01(" INSERT INTO " + addpersonforjobdbbean.getTableName() + " (NUMBER, JOBNUMB, PERSNUMB, DELFLAG ) VALUES (?,?,?,?)");
            deletejobpersondbbean.setTableName("personneljob");
            deletejobpersondbbean.setUpdateSQL02("UPDATE " + deletejobpersondbbean.getTableName() + " set delflag=? where persnumb = ? AND jobnumb=?");
            try
            {
                addjobchngdbbean.selectMaxnum();
                addjobchngdbbean.insert01();
                addjobchngdbbean.commitToDB();
                addpersonforjobdbbean.selectMaxnum();
                addpersonforjobdbbean.insert01();
                addpersonforjobdbbean.commitToDB();
                deletejobpersondbbean.update02();
                deletejobpersondbbean.commitToDB();
                addjobchngdbbean.setStatusCode(3023);
                addjobchngdbbean.setStatusMessage("成功增加岗位变动记录！");
            }
            catch(Exception exception3)
            {
                addjobchngdbbean.rollbackFromDB();
                throw new Exception(exception3.getMessage());
            }
            finally
            {
                addjobchngdbbean.releaseConnection();
            }
            httpservletrequest.setAttribute("vpersnumb", (String)vector1.elementAt(0));
            httpservletrequest.setAttribute("flag", String.valueOf(addjobchngdbbean.getStatusCode()));
            httpservletrequest.setAttribute("statusMessage", addjobchngdbbean.getStatusMessage());
            RequestDispatcher requestdispatcher1 = getServletContext().getRequestDispatcher("/personaladmin/AddJobChngResults.jsp");
            requestdispatcher1.forward(httpservletrequest, httpservletresponse);
        }
        catch(Throwable _ex)
        {
            try
            {
                RequestDispatcher requestdispatcher = getServletContext().getRequestDispatcher("/common/Error.jsp");
                requestdispatcher.forward(httpservletrequest, httpservletresponse);
            }
            catch(Exception exception)
            {
                System.out.println(exception.getMessage());
            }
        }
    }
}