modifyemptyservlet.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:   ModifyEmptyServlet.java

package utility.empty;

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

// Referenced classes of package utility.empty:
//            ModifyEmptyDBBean

public class ModifyEmptyServlet extends ParentServlet
{

    public ModifyEmptyServlet()
    {
    }

    public void performTask(HttpServletRequest httpservletrequest, HttpServletResponse httpservletresponse)
    {
        try
        {
            ModifyEmptyDBBean modifyemptydbbean = new ModifyEmptyDBBean();
            DateTimeBean datetimebean = new DateTimeBean();
            ParseInputStringBean parseinputstringbean = new ParseInputStringBean();
            String s = httpservletrequest.getParameter("inputString");
            Vector vector = parseinputstringbean.parseCommonFormatIS(s);
            Vector vector1 = (Vector)getServletContext().getAttribute("Para");
            modifyemptydbbean.setUserID((String)vector1.elementAt(0));
            modifyemptydbbean.setPassword((String)vector1.elementAt(1));
            modifyemptydbbean.setURL((String)vector1.elementAt(2));
            modifyemptydbbean.setDriver((String)vector1.elementAt(3));
            modifyemptydbbean.setDataSourceName((String)vector1.elementAt(4));
            modifyemptydbbean.setPageindex(((String)vector.elementAt(0)).trim());
            modifyemptydbbean.setRetrieveindex(((String)vector.elementAt(1)).trim());
            modifyemptydbbean.setRetrievecon(((String)vector.elementAt(2)).trim());
            modifyemptydbbean.setRetrievecom(((String)vector.elementAt(3)).trim());
            modifyemptydbbean.setSelectnum(((String)vector.elementAt(4)).trim());
            modifyemptydbbean.setPagecount(((String)vector.elementAt(5)).trim());
            modifyemptydbbean.setNumber1(((String)vector.elementAt(6)).trim());
            modifyemptydbbean.setSubArea(((String)vector.elementAt(7)).trim());
            modifyemptydbbean.setBuilding(((String)vector.elementAt(8)).trim());
            modifyemptydbbean.setStair(((String)vector.elementAt(9)).trim());
            modifyemptydbbean.setFloor(((String)vector.elementAt(10)).trim());
            modifyemptydbbean.setCell(((String)vector.elementAt(11)).trim());
            modifyemptydbbean.setUsetype(((String)vector.elementAt(12)).trim());
            modifyemptydbbean.setUsedept(pureInput(((String)vector.elementAt(13)).trim()));
            modifyemptydbbean.setUsedate(((String)vector.elementAt(14)).trim() + "-" + ((String)vector.elementAt(15)).trim() + "-" + ((String)vector.elementAt(16)).trim());
            modifyemptydbbean.setRecorder(((String)vector.elementAt(17)).trim());
            modifyemptydbbean.setExponent(pureInput(((String)vector.elementAt(18)).trim()));
            modifyemptydbbean.setRemark(pureInput(((String)vector.elementAt(19)).trim()));
            modifyemptydbbean.setTableName("emptyuse");
            modifyemptydbbean.setUpdateSQL01(" update " + modifyemptydbbean.getTableName() + " set  subarea = ?, building = ?, stair =?, floor =?, cell =?, usetype =?, usedept = ?, usedate = ?, recorder = ?, exponent = ?,remark = ?  where (number = ?) ");
            try
            {
                modifyemptydbbean.initialize();
            }
            catch(Exception exception1)
            {
                modifyemptydbbean.setStatusCode(0x69337);
                modifyemptydbbean.setStatusMessage("初始化数据库连接错误" + exception1.getMessage());
                throw new Exception(modifyemptydbbean.getStatusMessage() + exception1);
            }
            try
            {
                modifyemptydbbean.update01();
                modifyemptydbbean.setTableName("emptyrooms");
                if(modifyemptydbbean.getUsetype().equals("维护"))
                    modifyemptydbbean.setStatus("维修");
                if(modifyemptydbbean.getUsetype().equals("使用"))
                    modifyemptydbbean.setStatus("使用");
                if(modifyemptydbbean.getUsetype().equals("交回"))
                    modifyemptydbbean.setStatus("未用");
                modifyemptydbbean.setUpdateSQL02(" update " + modifyemptydbbean.getTableName() + "  set  status =?   where ((subarea = ?)and(building = ?)and(stair =?)and(floor =?)and(cell =?)and(delflag='0')) ");
                modifyemptydbbean.update02();
                modifyemptydbbean.setOpcontent("修改空置房使用记录");
                HttpSession httpsession = httpservletrequest.getSession(false);
                modifyemptydbbean.setOperator((String)httpsession.getValue("persname"));
                modifyemptydbbean.setOpdate(datetimebean.getDate());
                modifyemptydbbean.setOptime(datetimebean.getTime());
                modifyemptydbbean.insertLog();
                modifyemptydbbean.commitToDB();
                modifyemptydbbean.setStatusCode(0x69338);
                modifyemptydbbean.setStatusMessage("成功修改空置房使用记录");
            }
            catch(Exception exception3)
            {
                modifyemptydbbean.rollbackFromDB();
                modifyemptydbbean.setStatusCode(0x69339);
                modifyemptydbbean.setStatusMessage("修改空置房使用记录失败");
                throw new Exception(exception3.getMessage());
            }
            finally
            {
                modifyemptydbbean.releaseConnection();
            }
            httpservletrequest.setAttribute("number", modifyemptydbbean.getNumber1());
            httpservletrequest.setAttribute("pageindex", String.valueOf(modifyemptydbbean.getPageindex()));
            httpservletrequest.setAttribute("retrieveindex", modifyemptydbbean.getRetrieveindex());
            httpservletrequest.setAttribute("retrievecon", modifyemptydbbean.getRetrievecon());
            httpservletrequest.setAttribute("retrievecom", modifyemptydbbean.getRetrievecom());
            httpservletrequest.setAttribute("pagecount", modifyemptydbbean.getPagecount());
            httpservletrequest.setAttribute("selectnum", modifyemptydbbean.getSelectnum());
            httpservletrequest.setAttribute("statusMessage", modifyemptydbbean.getStatusMessage());
            httpservletrequest.setAttribute("statusCode", String.valueOf(modifyemptydbbean.getStatusCode()));
            RequestDispatcher requestdispatcher1 = getServletContext().getRequestDispatcher("/utility/empty/ModifyEmptyResult.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());
            }
        }
    }

    public String pureInput(String s)
    {
        String s1 = s;
        String s2 = "";
        for(int i = 0; i < s.length(); i++)
        {
            char c = s1.charAt(i);
            switch(c)
            {
            case 60: // '<'
                s2 = s2 + "&lt;";
                break;

            case 62: // '>'
                s2 = s2 + "&gt;";
                break;

            case 38: // '&'
                s2 = s2 + "&amp;";
                break;

            case 34: // '"'
                s2 = s2 + "&quot;";
                break;

            case 10: // '\n'
                s2 = s2 + "<br>";
                break;

            default:
                s2 = s2 + c;
                break;
            }
        }

        return s2;
    }
}