userhandler.java

一套完整的工商12315的源程序jsp部分在12315里,后台JAVA部分在gs12315src里,没有打包数据库.

package com.gs.control.handlers.pageBuilder.query;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2003</p>
 * <p>Company: </p>
 * @author liu wei li 2004-03-30
 * @version 1.0
 */
import java.util.*;
import javax.servlet.http.*;
import com.gs.control.handlers.DefaultHandlerSupport;
import com.gs.control.exceptions.WebException;
import com.gs.control.event.HandlerEvent;
import com.gs.util.*;
import com.gs.pageBuilder.util.AutoBuild;
import com.gs.control.util.PageBuilderScreen;
import com.gs.component.sysadmin.model.*;
import com.gs.component.out.dao.*;

public class UserHandler extends DefaultHandlerSupport{
    public HandlerEvent processEvent(HttpServletRequest request) throws
        WebException{
        Debug.println("[QuerySuperHandler]ProcessEvent------->start!");

        HandlerEvent fhe = null;
        ArrayList al = new ArrayList();
        String sql = null;
        String sql1 = null;
        try{

            String eName = request.getParameter("name"); //姓名
            String Num = request.getParameter("num"); //身份证号码
            String Ynum = request.getParameter("ynum"); //优惠证编号
            String first = request.getParameter("first"); //优惠证编号

            if(first == null || (first != null && first.equals(""))){
                return fhe;
            }

            String BID = "020401";

            //Modified by chen dan yu 2004-03-31
            sql = "select s.field012,s.field053,s.field054 ,s.field043,b.field009,b.field099 "
                + " from gsgsjin_sub02 s,gsgsjin_basis02 b"
                + " where s.field002='sub02_02' ";

            eName = PubFunc.toSql(eName);
            if(eName != null && !eName.equals("")){
                eName = "%" + eName + "%";
                sql = sql + " and s.field012 like '" + eName + "' ";
            }

            if(Num != null && !Num.equals("")){
                Num = "%" + Num + "%";
                sql = sql + " and s.field053 like '" + Num + "' ";
            }
            if(Ynum != null && !Ynum.equals("")){
                Ynum = "%" + Ynum + "%";
                sql = sql + " and s.field054 like '" + Ynum + "' ";
            }

            sql = sql + " and s.field001 = b.field001 "
                + " and b.field002 like '02%'"
                + " and b.field023 ='09'"; //个体

            String current_org = request.getParameter("current_org"); //是否选中“查询本管辖范围”
            //如果选中则得到当前用户的管辖单位
            if(current_org != null && current_org.equals("ON")){
                HttpSession session = request.getSession(false);
                UserModel user = (UserModel) session.getAttribute("userModel");
                String areaCoding = user.getAreaCoding();
                sql = sql + " and b.field105 = '"+areaCoding+"'";
            }

            Debug.println("current_org=" + current_org);

            Debug.println("UserHandler-->sql=" + sql);
            OutDAOFactory outDAOFactory = new OutDAOFactory();
            OutDAO outDAO = outDAOFactory.getDAO();

            ArrayList finisheedBusiness = null;
            finisheedBusiness = outDAO.getYouhui(sql);
            request.setAttribute("businessinfo",finisheedBusiness);

        } catch(Exception ex){
            Debug.println("[OutHandler]Exception----->" + ex);
            throw new WebException(ex);
        }
        Debug.println("[OutHandler]processEvent----->end!");

        return fhe;
    }

}