aphm101servlet.java

HW-中国移动企业信息机,请查看

package com.sxit.phonemanager;

import com.sxit.common.*;
import com.sxit.operator.*;
import javax.servlet.http.*;
import javax.servlet.*;
import java.util.*;
import java.sql.*;
import java.io.*;
/**
 * <p>类名: APHM101Servlet</p>
 * <p>功能: 显示规格列表</p>
 * <p>公司: 深讯信科</p>
 * <p>版本: 1.0</p>
 * @程序 sxit
 * @日期 2005-03-22
 * @修改纪录
 */

public class APHM101Servlet extends ServletAdminBase{
     public APHM101Servlet(){
          super();
          operationRight = "APHM1,1";
     }
     public String perform(HttpServletRequest request, HttpServletResponse response) throws Exception{

          Connection con=null;
          String nextPage="";
          int pageSize=10;
          int pageNo=1;

          TphmmodeList tphmmodelist=null;

          Topmuser myMember=(Topmuser)request.getSession().getAttribute("_currentUser");
          try{

               con=ConnPoolHandler.getConnection();
               if(request.getParameter("pageNo")!=null && !request.getParameter("pageNo").equals("")){
                    pageNo=Integer.parseInt(request.getParameter("pageNo"));
               }
               pageSize = Integer.parseInt(getConfig("APHM","pageSize"));
               if(request.getParameter("pageSize")!=null && !request.getParameter("pageSize").equals("")){
                    pageSize=Integer.parseInt(request.getParameter("pageSize"));
               }

               String strSearch="";

               //在此加入查询域，以下是下拉表单查询代码和多个查询域
               String selectID=request.getParameter("selectID");
               String selectMsg=request.getParameter("selectMsg");

               if(selectID==null){
                    selectID="0";
               }
               if(selectMsg==null){
                    selectMsg="";
               }
               //添加字段，修改相应的JSP
               if(selectID.equals("0")){
                    strSearch="";
                 }else if(selectID.equals("1") && !selectMsg.equals("")){
                    strSearch=" and (a.modeid="+selectMsg+")";
               }

               //过滤数据，用户只能看属于自己的数据
               //如果表中有corporationid staffid字段,需要判断用户使用数据

               //如果表中有createdate,需要判断时间段
               //添加排序
               strSearch=strSearch+" order by a.modeid desc ";

               Hashtable recSearch=new Hashtable();
               recSearch.put("selectID",selectID);
               recSearch.put("selectMsg",selectMsg);

               //在此加入List调用
               tphmmodelist=new TphmmodeList();
               tphmmodelist.createList1(con,pageNo,pageSize,strSearch);
               tphmmodelist.setRecSearch(recSearch);

               //在此加入List传递到JSP
               request.setAttribute("tphmmodelist",tphmmodelist);

               nextPage="/aphm/aphm101.jsp";
//               writeLog("APHM",LogManager.LOGTYPE_APP,myMember.getStaffid(),"显示规格列表成功");

          }
          catch (SQLException e){
               System.out.println(e);
               request.setAttribute("messageID","显示规格列表数据错");
               request.setAttribute("returnPage","../aphm/aphm101");
               nextPage="/aphm/aphmmessage.jsp";
               writeLog("APHM",LogManager.LOGTYPE_APP,myMember.getStaffid(),"显示规格列表数据错");
          }
          catch (Exception e){
               System.out.println(e);
               request.setAttribute("messageID","显示规格列表系统错");
               request.setAttribute("returnPage","../aphm/aphm101");
               nextPage="/aphm/aphmmessage.jsp";
               writeLog("APHM",LogManager.LOGTYPE_APP,myMember.getStaffid(),"显示规格列表系统错");
          }finally{
               ConnPoolHandler.closeConnection(con);
          }
          javax.servlet.RequestDispatcher rd =getServletContext().getRequestDispatcher(nextPage);
          rd.forward(request,response);
          return nextPage;
     }
}