mybatis sql mapper 用map的写法

来源：互联网发布：2选1数据选择器原理图编辑：程序博客网时间：2024/05/22 01:32

CHAR_LENGTH(str)
返回值为字符串str 的长度，长度的单位为字符。一个多字节字符算作一个单字符。对于一个包含五个二字节字符集, LENGTH()返回值为 10,而CHAR_LENGTH()的返回值为5。
CHARACTER_LENGTH(str)
CHARACTER_LENGTH()是CHAR_LENGTH()的同义词。
BIT_LENGTH(str)
返回2进制长度.
简单的总结来说，mysql中获取字符串长度的有两个函数：
length:返回字符串所占的字节数，是计算字段的长度一个汉字是算三个字符,一个数字或字母算一个字符
char_length:返回字符串所占的字符数，不管汉字还是数字或者是字母都算是一个字符

有时候写mapper的时候用到map类型的传参，写法如下

// 获取方法查询入参        public Map<String, Object> getCommonParams(CaseRecordsInfoModel caseRecordsInfoModel, Pageable pageable) {            Map<String, Object> params = new HashMap<String, Object>();            if (caseRecordsInfoModel.getRecord() != null) {                if (StringUtils.isNotBlank(caseRecordsInfoModel.getRecord().getUserId())) {                    params.put("userId", caseRecordsInfoModel.getRecord().getUserId());                }            if (pageable != null) {                params.put("offset", pageable.getOffset());                params.put("pageSize", pageable.getPageSize());            }            return params;        }

service 层

    @Override    public int selectPageByParamsCount(Map<String, Object> params, Pageable pageable) {        return caseRecordsInfoRepo.selectPageByParamsCount(params);    }

mapper层

    <select id="selectPageByParams" resultMap="BaseResultMap" parameterType="Map">        select        <include refid="Base_Column_Lists" />        from case_records_info a , case_records record  where record.if_out=0        <if test="_parameter.containsKey('userId')" >            and record.user_id not in            <foreach item="item" index="index" collection="items"                     open="(" separator="," close=")">                #{item}            </foreach>        </if>        <if test="_parameter.containsKey('ifAboveM7') and ifAboveM7 =='false'.toString()" >            and record.collection_type in             <foreach item="item" index="index" collection="types"                     open="(" separator="," close=")">                #{item}            </foreach>        </if>        <if test="_parameter.containsKey('ifAboveM7') and ifAboveM7=='true'.toString()" >            and (record.collection_type > 'M7' or LENGTH(record.collection_type)>2 or record.collection_type in             <foreach item="item" index="index" collection="types"                     open="(" separator="," close=")">                #{item}            </foreach>)        </if>        <if test="_parameter.containsKey('sendAreaName') and ifNoAdr=='true'.toString()">           and a.send_area_name = ''        </if>         <if test="_parameter.containsKey('sendAreaName') and ifNoAdr=='false'.toString()">           and a.send_area_name like CONCAT(#{sendAreaName},'%' )         </if>        and a.case_id=record.id and a.is_deleted=0 and        record.is_deleted=0  ORDER  BY record.user_id ASC        <if  test="_parameter.containsKey('offset')">            limit #{offset},#{pageSize}        </if>    </select>

mapper 还有多条件判断
比如<if test="_parameter.containsKey('sendAreaName') and ifNoAdr=='false'.toString()">
这里就是判断某个变量字符串是不是“true”再进行sql语句的编写。

总体mapper 使用map参数的用法就讲到这。

1 0