iBatis动态查询

最新推荐文章于 2021-02-04 15:15:00 发布

原创最新推荐文章于 2021-02-04 15:15:00 发布 · 328 阅读

0 ·

CC 4.0 BY-SA版权

ibatis 专栏收录该内容

4 篇文章

订阅专栏

public List queryProjectWarning(Map projectMap) {
    try {
      return dao.queryForList("MapService.queryProjectWarning", projectMap);
    } catch (SQLException e) {
      log.error(e);
      throw new RuntimeException(e);
    }
}

   select id="queryProjectWarning" resultClass="java.util.HashMap">
         SELECT * FROM PD_ALARM_PROJ_VOU

    dynamic prepend = " where ">
        isNotNull prepend="and" property="coCode">
            co_code like #coCode#||'%'
        /isNotNull>

        isNotNull prepend="and" property="uScaleText">
            level_name = #uScaleText#
        /isNotNull>

        isNotNull prepend="and" property="projectText">
                project_name like '%'|| #projectText# ||'%'
        /isNotNull>

        isNotNull prepend="and" property="pScaleText">
                scale_name = #pScaleText#
        /isNotNull>

        isNotNull prepend="and" property="beginText">
                vou_date >= #beginText#
        /isNotNull>

        isNotNull prepend="and" property="endText">
                vou_date <= #endText#

        /isNotNull>
    /dynamic>
    ORDER BY co_name,project_code,acc_code,outlay_code
/select>