123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116 |
- <?xml version="1.0" encoding="UTF-8"?>
- <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
- <mapper namespace="${basePackage}.module.${modulePackage}.dao.${moduleClass}Dao">
- <resultMap id="${moduleClass}VO" type="${basePackage}.module.${modulePackage}.domain.vo.${moduleClass}VO"></resultMap>
- <resultMap id="${moduleClass}ExcelVO" type="${basePackage}.module.${modulePackage}.domain.vo.${moduleClass}ExcelVO"></resultMap>
- <sql id="baseSql">
- #foreach($column in $columnList)
- #if($velocityCount != $columnList.size())
- a.$column.columnName,
- #else
- a.$column.columnName
- #end
- #end
- </sql>
- <sql id="baseCondition">
- 1=1
- #foreach($queryField in $queryFieldList)
- #if ($queryField.sqlOperate == 'like')
- <if test="queryDTO.${queryField.fieldName} != null and queryDTO.${queryField.fieldName} != ''">
- AND INSTR(a.$queryField.columnName,#{queryDTO.$queryField.fieldName})
- </if>
- #end
- #if ($queryField.sqlOperate == 'equals')
- #if ($queryField.fieldType == 'String')
- <if test="queryDTO.${queryField.fieldName} != null and queryDTO.${queryField.fieldName} != ''">
- AND a.$queryField.columnName = #{queryDTO.$queryField.fieldName}
- </if>
- #else
- <if test="queryDTO.${queryField.fieldName} != null">
- AND a.$queryField.columnName = #{queryDTO.$queryField.fieldName}
- </if>
- #end
- #end
- #if ($queryField.sqlOperate == 'in')
- <if test="queryDTO.${queryField.fieldName}List !=null and queryDTO.${queryField.fieldName}List.size() > 0">
- and a.$queryField.columnName in
- <foreach collection="queryDTO.${queryField.fieldName}List" open="(" index="index" separator="," close=")" item="item">
- #{item}
- </foreach>
- </if>
- #end
- #end
- <if test="queryDTO.idList !=null and queryDTO.idList.size() > 0">
- and a.id in
- <foreach collection="queryDTO.idList" open="(" index="index" separator="," close=")" item="item">
- #{item}
- </foreach>
- </if>
- <if test="queryDTO.createTimeBegin != null ">
- AND a.create_time >= #{queryDTO.createTimeBegin}
- </if>
- <if test="queryDTO.createTimeEnd != null ">
- AND a.create_time <= #{queryDTO.createTimeEnd}
- </if>
- <if test="queryDTO.updateTimeBegin != null ">
- AND a.update_time >= #{queryDTO.updateTimeBegin}
- </if>
- <if test="queryDTO.updateTimeEnd != null ">
- AND a.update_time <= #{queryDTO.updateTimeEnd}
- </if>
- </sql>
- <select id="queryByPage" resultMap="${moduleClass}VO">
- select
- <include refid="baseSql"/>
- from ${tableName} a
- <where>
- <include refid="baseCondition"/>
- </where>
- </select>
- <select id="queryAllExportData" resultMap="${moduleClass}ExcelVO">
- select
- <include refid="baseSql"/>
- from ${tableName} a
- <where>
- <include refid="baseCondition"/>
- </where>
- </select>
- <select id="queryBatchExportData" resultMap="${moduleClass}ExcelVO">
- select
- <include refid="baseSql"/>
- from ${tableName} a
- where a.id in
- <foreach collection="idList" open="(" close=")" separator="," item="item">
- #{item}
- </foreach>
- </select>
- <delete id="deleteById">
- delete from ${tableName} where id = #{id}
- </delete>
- <delete id="deleteByIdList">
- delete from ${tableName} where id in
- <foreach collection="idList" open="(" close=")" separator="," item="item">
- #{item}
- </foreach>
- </delete>
- <select id="listAll" resultMap="${moduleClass}VO">
- select
- <include refid="baseSql"/>
- from ${tableName} a
- <where>
- <include refid="baseCondition"/>
- </where>
- </select>
- </mapper>
|