mybatis的特殊sql语句

1. 模糊查询

   <!--List<User> getUserByLike(@Param("username") String username);-->
   <select id="getUserByLike" resultType="User">
       <!--select * from t_user where username like '%${username}%'-->
       <!--select * from t_user where username like concat('%',#{username},'%')-->
       select * from t_user where username like "%"#{username}"%"
   </select>
   

   或直接在参数中加入“%”+parameter+“%”
2. 批量删除

   <delete id="deleteMore">
       delete from t_user where id in (${ids})
   </delete>
   

3. 动态设置表名

   <select id="getUserByTableName" resultType="User">
       select * from ${tableName}
   </select>
   

4. 获得自增的id值

   <insert id="insert" useGeneratedKeys="true" keyProperty="payment2.id">
       insert into payment value (null,#{payment2.serial})
   </insert>