MP中sql片段的简单使用

Harbor Lau

已于 2023-02-03 17:55:02 修改

阅读量261

点赞数

文章标签： java mybatis spring

于 2023-02-03 17:41:00 首次发布

本文链接：https://blog.csdn.net/weixin_61503139/article/details/128873085

版权

控制层

  @PostMapping("/addKey")
    @CrossOrigin
    public String addKey(@RequestBody User user) {
        dictService.addKey(user);
        return "6666";
    }

业务层

mapper

xml

<select id="selectSqlPinjie" resultType="java.util.Map">

        <include refid="getColumns">
            <property name="tableName" value="${tableName}"/>
            <property name="name" value="#{name}"/>
        </include>
            ${sql} limit 1
    </select>

    <sql id="getColumns">
        SELECT * from ${tableName}
    </sql>

拼接成功的sql

<select id="selectSqlPinjie" resultType="java.util.Map">

    <include refid="getColumns">
        <property name="tableName" value="${tableName}"/>
        <property name="name" value="#{name}"/>
    </include>

</select>

<sql id="getColumns">
    SELECT * from ${tableName} where name=#{name} limit 1
</sql>