一、controller、service、serviceImpl、Mapper、Xml等文件的作用

下图为java约定俗成的几个文件的作用

二、在项目中的使用情况，由于业务逻辑很简单，所以每个文件中的代码行数都很少

• controller.java

1. /**
2. * 资产rim项目信息报表
3. *
4. */
5. @RequestMapping(value = "/hls/cus/rpt/rim/project/detail/query")
6. @ResponseBody
7. public ResponseData rptRimProjecrDetailQuery(@RequestBody Map map) {
8. return new ResponseData(hlsCusRptRimProjectDetailService.rptRimProjectDetailQuery(map));
9. }

• service.java

2. public interface HlsCusRptRimProjectDetailService extends IBaseService<HlsCusRptRimProjectDetail>,ProxySelf<HlsCusRptRimProjectDetailService> {
4. List<Map> rptRimProjectDetailQuery(Map map);
5. }

• serviceImpl.java

1. @Override
2. public List<Map> rptRimProjectDetailQuery(Map map) {
3. int page = Integer.parseInt(String.valueOf(map.get("page")));
4. int pageSize = Integer.parseInt(String.valueOf(map.get("pageSize")));
5. PageHelper.startPage(page,pageSize);
6. return hlsCusRptRimProjectDetailMapper.rptRimProjectDetailQuery(map);
7. }

• mapper.java

1. public interface HlsCusRptRimProjectDetailMapper extends Mapper<HlsCusRptRimProjectDetail> {
3. List<Map> rptRimProjectDetailQuery( Map<String, Object> map);// 资产rim表项目信息报表
5. }

• mapper.xml

1. <select id="rptRimProjectDetailQuery" resultMap="BaseResultMap">
3. SELECT
4. V.*,
5. (case when V.REMAIN_PRINCIPAL > 0 then (V.REMAIN_PRINCIPAL - nvl(
6. (SELECT SUM(CCC.DUE_AMOUNT)
7. FROM CON_CONTRACT_CASHFLOW CCC
8. WHERE CCC.CONTRACT_ID = V.CONTRACT_ID
9. AND CCC.CF_ITEM = 5)
10. ,0)) else 0 end) as PROJECT_EXPOSURE
11. FROM (SELECT
12. --项目编号
13. CC.PROJECT_CONTRACT_NUMBER PROJECT_NUMBER,
15. -------------------------省略部分代码-------------------------
17. -- 项目核销申请日期
18. (SELECT CCT.TERMINATION_DATE
19. FROM CON_CONTRACT_TERMINATION CCT
20. WHERE CCT.CONTRACT_ID = CC.CONTRACT_ID) TERMINATION_DATE,
21. CC.BEFORE_RENT_FLAG
22. FROM CON_CONTRACT CC
23. LEFT JOIN PRJ_PROJECT PP
24. ON CC.PROJECT_ID = PP.PROJECT_ID
25. WHERE
26. cc.contract_status IN ('INCEPT', 'TERMINATE', 'ET')
27. OR (CC.contract_status = 'SIGN' AND cc.before_rent_flag = 'Y')
28. ) V
29. ----------------下面写查询条件----------------------
30. <where>
31. <if test="projectNumber !=null and projectNumber !=''">
32. and v.project_number like concat(concat('%',#{projectNumber}),'%')
33. </if>
34. <if test="businessType !=null and businessType.size() !=0">
35. and v.business_type in
36. <foreach item="item" index="index" collection="businessType" open="(" separator="," close=")">
37. #{item}
38. </foreach>
39. </if>
40. </where>
42. </select>