Mabatis通用SQL语句

通用sql语句

DAO层

 //新增
Long add(@Param("tableName")String tableName, @Param("params") Map<String,Object> params);
//查询
List<Map<String,Object>> listByKeys(@Param("tableName")String tableName, @Param("params") Map<String,Object> params);
//修改
int modify(@Param("tableName")String tableName, Map<String,Object> params);

 

Mapper.xml

<insert id="add" parameterType="Map">
        insert into ${tableName}
        <foreach collection="params.keys" item="key" index="index" open="(" close=")" separator=",">
            ${key}
        </foreach>
        values
        <foreach collection="params.values" item="value" index="index" open="(" close=")" separator=",">
            #{value}
        </foreach>
    </insert>

    <select id="listByCondition" parameterType="Map" resultType="java.util.Map">
        select * from ${tableName}
        where 1 = 1 and
        <foreach collection="params" index="key" item="value" separator="and">
            ${key} = #{value}
        </foreach>
    </select>

    <update id="modify" parameterType="Map" >
        update ${tableName}
        set
        <foreach collection="params" index="key" item="value" separator=",">
            ${key} = #{value}
        </foreach>
        where id = #{params.id}
    </update>