modifycommservlet.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:   ModifyCommServlet.java

package utility.committee;

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

// Referenced classes of package utility.committee:
//            ModifyCommDBBean

public class ModifyCommServlet extends ParentServlet
{

    public ModifyCommServlet()
    {
    }

    public void performTask(HttpServletRequest httpservletrequest, HttpServletResponse httpservletresponse)
    {
        try
        {
            ModifyCommDBBean modifycommdbbean = new ModifyCommDBBean();
            DateTimeBean datetimebean = new DateTimeBean();
            ParseInputStringBean parseinputstringbean = new ParseInputStringBean();
            String s = httpservletrequest.getParameter("inputString");
            Vector vector = parseinputstringbean.parseCommonFormatIS(s);
            Vector vector1 = (Vector)getServletContext().getAttribute("Para");
            modifycommdbbean.setUserID((String)vector1.elementAt(0));
            modifycommdbbean.setPassword((String)vector1.elementAt(1));
            modifycommdbbean.setURL((String)vector1.elementAt(2));
            modifycommdbbean.setDriver((String)vector1.elementAt(3));
            modifycommdbbean.setDataSourceName((String)vector1.elementAt(4));
            modifycommdbbean.setPageindex(((String)vector.elementAt(0)).trim());
            modifycommdbbean.setRetrieveindex(((String)vector.elementAt(1)).trim());
            modifycommdbbean.setRetrievecon(((String)vector.elementAt(2)).trim());
            modifycommdbbean.setRetrievecom(((String)vector.elementAt(3)).trim());
            modifycommdbbean.setSelectnum(((String)vector.elementAt(4)).trim());
            modifycommdbbean.setPagecount(((String)vector.elementAt(5)).trim());
            modifycommdbbean.setNumber1(((String)vector.elementAt(6)).trim());
            modifycommdbbean.setSubArea(((String)vector.elementAt(7)).trim());
            modifycommdbbean.setBuilding(((String)vector.elementAt(8)).trim());
            modifycommdbbean.setStair(((String)vector.elementAt(9)).trim());
            modifycommdbbean.setFloor(((String)vector.elementAt(10)).trim());
            modifycommdbbean.setCell(((String)vector.elementAt(11)).trim());
            modifycommdbbean.setName(((String)vector.elementAt(12)).trim());
            modifycommdbbean.setAge(((String)vector.elementAt(13)).trim());
            modifycommdbbean.setTouchWay(((String)vector.elementAt(14)).trim());
            modifycommdbbean.setWorkPlace(((String)vector.elementAt(15)).trim());
            modifycommdbbean.setDuty(((String)vector.elementAt(16)).trim());
            modifycommdbbean.setRemark(((String)vector.elementAt(17)).trim());
            modifycommdbbean.setTableName("livecomm");
            modifycommdbbean.setSelectSQL01("select number from " + modifycommdbbean.getTableName() + " where ((subarea = ?)and (building = ?)and (stair = ?)and (floor = ?)and (cell = ?)and (number != ?)and (delflag='0'))");
            modifycommdbbean.setUpdateSQL01(" update " + modifycommdbbean.getTableName() + " set  subarea = ?, building = ?, stair = ?, floor = ?, cell = ?, name = ?, age=?, touchway=?, workplace=?, duty=?, remark=?  where (number = ?) ");
            try
            {
                modifycommdbbean.initialize();
            }
            catch(Exception exception1)
            {
                modifycommdbbean.setStatusCode(1655);
                modifycommdbbean.setStatusMessage("初始化数据库连接错误" + exception1.getMessage());
                throw new Exception(modifycommdbbean.getStatusMessage() + exception1);
            }
            try
            {
                modifycommdbbean.select01();
                if(modifycommdbbean.getStatusCode() == 0x669e1)
                {
                    modifycommdbbean.update01();
                    modifycommdbbean.setOpcontent("修改业主委员会成员记录");
                    HttpSession httpsession = httpservletrequest.getSession(false);
                    modifycommdbbean.setOperator((String)httpsession.getValue("persname"));
                    modifycommdbbean.setOpdate(datetimebean.getDate());
                    modifycommdbbean.setOptime(datetimebean.getTime());
                    modifycommdbbean.insertLog();
                    modifycommdbbean.commitToDB();
                    modifycommdbbean.setStatusCode(2187);
                    modifycommdbbean.setStatusMessage("成功修改业主委员会成员记录");
                }
            }
            catch(Exception exception3)
            {
                modifycommdbbean.rollbackFromDB();
                modifycommdbbean.setStatusCode(2188);
                modifycommdbbean.setStatusMessage("修改业主委员会成员失败");
                throw new Exception(exception3.getMessage());
            }
            finally
            {
                modifycommdbbean.releaseConnection();
            }
            httpservletrequest.setAttribute("number", modifycommdbbean.getNumber1());
            httpservletrequest.setAttribute("pageindex", String.valueOf(modifycommdbbean.getPageindex()));
            httpservletrequest.setAttribute("retrieveindex", modifycommdbbean.getRetrieveindex());
            httpservletrequest.setAttribute("retrievecon", modifycommdbbean.getRetrievecon());
            httpservletrequest.setAttribute("retrievecom", modifycommdbbean.getRetrievecom());
            httpservletrequest.setAttribute("pagecount", modifycommdbbean.getPagecount());
            httpservletrequest.setAttribute("selectnum", modifycommdbbean.getSelectnum());
            httpservletrequest.setAttribute("statusMessage", modifycommdbbean.getStatusMessage());
            httpservletrequest.setAttribute("statusCode", String.valueOf(modifycommdbbean.getStatusCode()));
            RequestDispatcher requestdispatcher1 = getServletContext().getRequestDispatcher("/utility/committee/ModifyCommResult.jsp");
            requestdispatcher1.forward(httpservletrequest, httpservletresponse);
        }
        catch(Throwable throwable)
        {
            System.out.println(throwable.getMessage());
            try
            {
                RequestDispatcher requestdispatcher = getServletContext().getRequestDispatcher("/common/Error.jsp");
                requestdispatcher.forward(httpservletrequest, httpservletresponse);
            }
            catch(Exception exception)
            {
                System.out.println(exception.getMessage());
            }
        }
    }
}