Mapper代理开发

• MyBatis的配置文件要放在main/resource下
• 如何写一个Mapper

• 如何快速写一个Mapper

• 多条件查询

• 动态条件查询

<select id="SelectByCondition" resultMap="BrandMap">
        select * from tb_brand
        <where>
            <if test="status != null">
                and status = #{status}
            </if>
            <if test="companyName != null and companyName != '' ">
                and company_name like #{companyName}
            </if>
            <if test="brandName != null and brandName != '' ">
                and brand_name like #{brandName}
            </if>
        </where>
    </select>

• 单条件动态查询

• 添加，但是主键返回

• 批量删除