mybatis(ssm,springboot+mybatis)通用查询

有时候为了开发效率,特别讨厌去添加各种文件,写各种sql语句,而这些语句可能只使用一次,于是就有了做通用查询的想法.在这里,我不做技术说明,只发实现代码实例.只是为了简介

这是Mapper文件

<?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="CommonMapper">

    <!-- 动态查询语句.缺点是效率低,理论上有安全风险.试用场景:读取数据库配置 -->
    <select id="commonFind" resultType="java.util.Map" parameterType="java.util.Map" statementType="STATEMENT">
        SELECT ${_fields} FROM ${_table}
        WHERE 1=1
        <if test=" condition0!='' and condition0!=null ">
            AND ${_field0}=${condition0}
        </if>
        <if test=" condition1!='' and condition1!=null ">
            AND ${_field1}=${condition1}
        </if>