modifycontractservlet.java

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

                    String s10 = (String)vector.elementAt(3);
                    modifycontractdbbean.setContractnumb(s10);
                    if(!s9.equals(s10))
                        try
                        {
                            modifycontractdbbean.setSelectSQL02("SELECT CONTRACTTOPIC FROM " + modifycontractdbbean.getTableName() + " WHERE (CONTRACTNUMB= ? )AND(DELFLAG='0')");
                            modifycontractdbbean.select02();
                        }
                        catch(Exception exception4)
                        {
                            System.out.println("personaladmin.ModifyContractServlet [" + datetimebean.getDate() + " " + datetimebean.getTime() + "] " + modifycontractdbbean.getStatusMessage());
                            modifycontractdbbean.releaseConnection();
                            throw new Exception(exception4.getMessage());
                        }
                    if(modifycontractdbbean.getStatusCode() == 3007)
                    {
                        httpservletrequest.setAttribute("flag", String.valueOf(modifycontractdbbean.getStatusCode()));
                        httpservletrequest.setAttribute("statusMessage", modifycontractdbbean.getStatusMessage());
                    } else
                    {
                        modifycontractdbbean.setUpdateSQL01(" update " + modifycontractdbbean.getTableName() + " set contracttopic = ?,  contractnumb = ?, location = ?, cooperatecom = ?, signman = ?,signdate = ?,limit=?, remark = ? where number = ?");
                        try
                        {
                            modifycontractdbbean.update01();
                            for(int k = 16; k < vector.size();)
                            {
                                modifycontractdbbean.setTableName("contractinfo");
                                String s13 = ((String)vector.elementAt(k)).trim();
                                if(s13.substring(0, 1).equals("0"))
                                {
                                    if(s13.substring(1).equals("1"))
                                    {
                                        modifycontractdbbean.setUpdateSQL02(" update " + modifycontractdbbean.getTableName() + " set contenttype = ?,contentname = ?,content = ? where number = ? ");
                                        modifycontractdbbean.setContent(null);
                                        modifycontractdbbean.update02();
                                        k += 2;
                                    } else
                                    {
                                        k += 2;
                                    }
                                } else
                                if(s13.substring(1).equals("1"))
                                {
                                    if(((String)vector.elementAt(k + 1)).equals(""))
                                    {
                                        modifycontractdbbean.setStatusMessage("修改合同资料成功");
                                    } else
                                    {
                                        String s14 = (String)vector3.elementAt(0);
                                        int l = s14.indexOf(".");
                                        modifycontractdbbean.setContenttype(s14.substring(l + 1));
                                        modifycontractdbbean.setContentname(s14);
                                        byte abyte0[] = new byte[Integer.parseInt((String)vector2.elementAt(0))];
                                        abyte0 = (byte[])vector4.elementAt(0);
                                        modifycontractdbbean.setContent(abyte0);
                                        modifycontractdbbean.setUpdateSQL02(" update " + modifycontractdbbean.getTableName() + " set contenttype = ?, contentname = ?, content=? where number=?");
                                        modifycontractdbbean.update02();
                                        String s16 = getServletConfig().getServletContext().getRealPath("/personaladmin/pictures/");
                                        s16 = s16 + modifycontractdbbean.getTableName() + "-" + modifycontractdbbean.getNumber1() + "-";
                                        parseinputstringbean.generate(0, s16);
                                        i++;
                                    }
                                    k += 2;
                                } else
                                {
                                    String s15 = (String)vector3.elementAt(0);
                                    int i1 = s15.indexOf(".");
                                    modifycontractdbbean.setContenttype(s15.substring(i1 + 1));
                                    modifycontractdbbean.setContentname(s15);
                                    byte abyte1[] = new byte[Integer.parseInt((String)vector2.elementAt(0))];
                                    abyte1 = (byte[])vector4.elementAt(0);
                                    modifycontractdbbean.setContent(abyte1);
                                    modifycontractdbbean.setUpdateSQL02(" update " + modifycontractdbbean.getTableName() + " set contenttype = ?, contentname = ?, content=? where number=?");
                                    modifycontractdbbean.update02();
                                    String s17 = getServletConfig().getServletContext().getRealPath("/personaladmin/pictures/");
                                    s17 = s17 + modifycontractdbbean.getTableName() + "-" + modifycontractdbbean.getNumber1() + "-";
                                    parseinputstringbean.generate(0, s17);
                                    i++;
                                    k += 2;
                                }
                            }

                            modifycontractdbbean.commitToDB();
                        }
                        catch(Exception exception7)
                        {
                            modifycontractdbbean.rollbackFromDB();
                            System.out.println("[personaladmin.ModifyContractServlet] [" + datetimebean.getDate() + " " + datetimebean.getTime() + "] " + modifycontractdbbean.getStatusMessage());
                            throw new Exception(exception7.getMessage());
                        }
                        finally
                        {
                            modifycontractdbbean.releaseConnection();
                        }
                        httpservletrequest.setAttribute("statusMessage", modifycontractdbbean.getStatusMessage());
                        httpservletrequest.setAttribute("flag", String.valueOf(modifycontractdbbean.getStatusCode()));
                    }
                    httpservletrequest.setAttribute("kindnum", s3);
                    httpservletrequest.setAttribute("kindname", s7);
                    httpservletrequest.setAttribute("currentpage", s5);
                    RequestDispatcher requestdispatcher3 = getServletContext().getRequestDispatcher("/personaladmin/ModifyContractResult.jsp");
                    requestdispatcher3.forward(httpservletrequest, httpservletresponse);
                }
            } else
            {
                httpservletrequest.setAttribute("statusMessage", parseinputstringbean.getStatusMessage());
                httpservletrequest.setAttribute("flag", String.valueOf(parseinputstringbean.getStatusCode()));
                RequestDispatcher requestdispatcher1 = getServletContext().getRequestDispatcher("/personaladmin/ModifyContractResult.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);
            }
        }
    }
}