模板

mac2022-06-30 75

1.action service dao ibatis ajax

=======================================================ibatis xml<select id="getInvalidProjectMgr" parameterClass="java.lang.String" resultClass="java.lang.String"> <![CDATA[ select g.group_id as projectMrg from ecc_epm.gapm_project_group g where g.role= 'ContractDeliveryPrincipal' and g.enable_flag = 'F' and rownum = 1 and g.project_id = #projectId# order by g.last_update_date desc ]]> </select>

======================================================= 类的注释： /** * 类编号：EPM_CJ402_IBudgetReviewDao * 类名称：IBudgetReviewDao * 内容摘要：预算评审数据访问接口 * 编码作者：lidaofei * 完成日期：2016-04-13 */dao /** * 获取一个最新无效的执行项目经理 * @author lidaofei * @category V10.3.1 * @date 2015-11-24 * @param projectId 项目ID * @return String 执行项目经理编号 * @throws Exception */ public String getInvalidProjectMgr(String projectId) throws Exception;=======================================================daoImpl /** * 获取一个最新无效的执行项目经理 * @author lidaofei * @category V10.3.1 * @date 2015-11-24 * @param projectId 项目ID * @return String 执行项目经理编号 * @throws Exception */ public String getInvalidProjectMgr(String projectId) throws Exception { String projectMgr=""; try { projectMgr = (String)getSqlMapClientTemplate().queryForObject("projectQueryVO.getInvalidProjectMgr",projectId); } catch (Exception e) { PmInfoException.throwPmInfoException(EccExceptionComm.ERROR_LAYER_DAO, this.getClass().getName(), e); } return projectMgr; }

================================================service /** * 获取一个最新无效的执行项目经理 * @author lidaofei * @category V10.3.1 * @date 2015-11-24 * @param projectId 项目ID * @return String 执行项目经理编号 * @throws Exception */ public String getInvalidProjectMgr(String projectId) throws Exception;

====================================================serviceImpl /** * 获取一个最新无效的执行项目经理 * @author lidaofei * @category V10.3.1 * @date 2015-11-24 * @param projectId 项目ID * @return String 执行项目经理编号 * @throws Exception */ public String getInvalidProjectMgr(String projectId) throws Exception { String result = ""; try { result = theIprojectQueryDAO.getInvalidProjectMgr(projectId); } catch (Exception e) { PmInfoException.throwPmInfoException(EccExceptionComm.ERROR_LAYER_SERVICE, this.getClass().getName(), e); } return result; }

====================================================action /** * 获取一个最新无效的执行项目经理 * @author lidaofei * @throws Exception * @category V10.3.1 * @date 2015-11-24 */ public ActionForward getInvalidProjectMgr(ActionMapping mapping, ActionForm form, HttpServletRequest request,HttpServletResponse response) throws Exception { String projectMrg = ""; String projectId = request.getParameter("projectId"); if(StringUtils.isNotBlank(projectId)) { IprojectQueryService proQueryService = (IprojectQueryService) getInrepairServiceFactory().getServiceObject("projectQueryServiceImpl"); if (proQueryService == null) { Debug.println("===get projectQueryService is null===="); } else { projectMrg = proQueryService.getInvalidProjectMgr(projectId); JSONObject json = new JSONObject(); json.element("projectMrg", projectMrg); request.setAttribute("projectMrg", projectMrg); response.setContentType("text/json; charset=GBK"); response.getWriter().write(json.toString()); } } return null; }

======================================================ajaxfunction getInvalidProjectMgr(projectId) { var projectMrg; var url = "<%=request.getContextPath()%>/epm/subcontract/newSub/ui/projectQueryAction.do"; $.ajax({ type:"post", url:url, data:"operation=getInvalidProjectMgr&projectId="+projectId, async: false, dataType:"json", success:function(data) { projectMrg = data.projectMrg; } }); return projectMrg; }

====================================================异常处理1.在页面上显示异常处理信息时：PmInfoException.throwPmInfoException(EccExceptionComm.ERROR_LAYER_DAO, this.getClass().getName(), e);

2.不在页面上显示信息时：参照：com.zte.ecc.epm.subcontract.bidOrNot.web.BidProjectApplyAction的getSmallAmountProjectApply（）dao

try { pstmt = conn.prepareStatement(sql); pstmt.setString(1, requestNo); pstmt.setInt(2, predictSumS); rs = pstmt.executeQuery(); while(rs.next()) { res = rs.getInt(1); } } catch (Exception ex) { throw new Exception(ex.getMessage()); } finally { BaseDAO.closeAll(rs, pstmt, null); // 关闭所有JDBC对象 }

service

try { con = BaseDAO.getConnection(); con.setAutoCommit(false); ProjectApplyDAO projectApplyDAO = new ProjectApplyDAO(con); //立项金额十万美元 int predictSumS = 100000; res = projectApplyDAO.getSmallAmountProjectApply(requstNo,predictSumS); } catch (Exception ex) { res = -1; ReceiveEffectBO bo = new ReceiveEffectBO(); String ee = getExceptionDetailsMessage(ex); if (null != ee && !"".equals(ee)) { if (ee.length() > 800) { ee = ee.substring(0, 800); } } bo.setExceptionInfo(ee); bo.setExceptionOID(requstNo+""); bo.setExceptionSource("根据需求单，获取小额立项申请单"); try { theOper.saveException(bo); } catch (Exception e) { e.printStackTrace(); } ex.printStackTrace(); } finally { try { if (con != null) { con.setAutoCommit(true); BaseDAO.closeConnection(con); } } catch (Exception ex) { ex.printStackTrace(); } } return res;

定义IReceiveEffectService theOper = (IReceiveEffectService)SpringServiceFactory.getInstance().getServiceObject("receiveEffectService");

加一个方法： private String getExceptionDetailsMessage(Exception e) { // 声明输出信息 String input = null; // 初始化StringWriter StringWriter sw = new StringWriter(); // 初始化PrintWriter PrintWriter pw = new PrintWriter(sw); // 打印堆栈 e.printStackTrace(pw); // 获得堆栈信息 input = sw.getBuffer().toString(); return input; }

2.异步模板

1. ajax异步处理 jsp页面（post请求）

java后台（运用json） public ActionForward getSmallAmountProjectApply(ActionMapping mapping, ActionForm form,HttpServletRequest request, HttpServletResponse response)throws Exception { //如果是国际单据才操作 if(IMenuTypeContant.MENU_TYPE_INTERNATIONAL.equals(request.getSession().getAttribute(IMenuTypeContant.MENU_TYPE))) { String requestNo = request.getParameter("requestNo"); int resultCount=0; if(StringUtils.isNotBlank(requestNo)) { ProjectAppyOpr projectAppyOpr = new ProjectAppyOpr(); resultCount = projectAppyOpr.getSmallAmountProjectApply(requestNo); try { JSONObject json = new JSONObject(); json.element("resultCount", resultCount); Debug.debug(json.toString()); response.setContentType("text/json; charset=GBK"); response.getWriter().write(json.toString()); } catch (Exception e) { Debug.printErr(this.getClass().getName() + ".revoke()" + e.toString() + "\n"); } } } return null; }

转载于:https://www.cnblogs.com/lidaofei1991/articles/5984800.html

最新回复(0)