关于提取方案用JAVA代码实现的使用说明.docVIP

关于提取方案SQL语句用JAVA代码的使用说明 将原提取方案SQL替换为为： categorysingle/category modefast/mode cname单位联系人/cname clscom.zfscm.app.fjzdj.bean.S_sp_spls/cls retvaldwid,dwbh,dwmc,lxrid,lxrbh,lxr,ywyid,ywy,bmid,bm,is_zddw,cwysye,jyfw,jyfws,dwxde,ywyxde,xdq,kkpje,qyid,sxmcs/retval cols col name=dwid cname=单位ID visible=false / 在对应代码路径下面添加S_Sp_spls.java 代码如下： package com.zfscm.app.fjzdj.bean; import java.util.List; import java.util.Map; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.apache.log4j.Logger; import org.apache.struts.action.ActionForward; import com.zfsys.app.acl.vo.Acl_userVO; import com.zfsys.tools.dataquery.DQMapListDatasource; import com.zfsys.tools.dataquery.ZFDataquery; import com.zfsys.tools.zfquery.Executer; import com.zfsys.tools.zfquery.Query; import com.zfsys.tools.zfquery.QueryQuery; import mon.CollectionUtil; import mon.TextUtil; import com.zfsys.util.dao.DAOException; public class S_sp_spls extends DQMapListDatasource { static Logger logger = Logger.getLogger(Yyjk.class.getName()); public void doexec(ZFDataquery dq, Map params, int pagesize, int currentpage) throws DAOException { String jiajia = dq.getName(); // 数据提取参数效验 String zjm = (String) params.get(zjm); zjm = zjm.toUpperCase(); if (zjm == null || .equals(zjm)) { throw new DAOException(请输入助记码！); } String is_cjyh = 0000; String jgid = (String) params.get(jgid); if (jgid == null || .equals(jgid)) { throw new DAOException(机构参数错误！); } String userid = (String) params.get(userid); // 查找当前用户是否被授权 Acl_userVO yhyz = (Acl_userVO) Acl_userVO.load( and userid= + userid); if (yhyz != Acl_userVO.NULL) { if (yhyz.getNote() != null) { is_cjyh = yhyz.getNote(); } if (yhyz.getYwlxc() != null) { userid = userid + , + yhyz.getYwlxc(); } } if (userid == null || .equals(userid)) { throw new DAOException(用户错误！); } String dhcx = (String) params.get(dhcx); if (dhcx == null || .equals(dhcx)) { dhcx = ;