mybatis开发常用

<?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="com.inspur.generate.dao.BasAnalyticalTemplateMapper">
    <!-- 写错了instr(#{ids},id)写反了。应该是 instr(id,#{ids}) -->
    <select id="getAllListByIds" resultType="com.inspur.generate.entity.BasAnalyticalTemplate">
        select * from  bas_analytical_template where instr(#{ids},id)
    </select>

    <insert id="insertBatch" parameterType="java.util.List">
        insert into bas_analytical_template
        (id,title,content,`type`,template)
        values
        <foreach collection="list" item="list" separator=",">
            (#{list.id},#{list.title},#{list.content},#{list.type},#{list.template})
        </foreach>
    </insert>
</mapper>

/**
 * 分析模板表
 */
public interface BasAnalyticalTemplateMapper extends BaseMapper<BasAnalyticalTemplate> {

    List<BasAnalyticalTemplate> getAllListByIds(@Param("ids") List<String> questionIds);

    void insertBatch(@Param("list") List<BasAnalyticalTemplate> templates);
}

其他

<?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="com.inspur.generate.dao.BasAnalyticalTemplateMapper">
    <insert id="insertAuthor">
      insert into Author (id,username,password,email,bio)
      values (#{id},#{username},#{password},#{email},#{bio})
    </insert>
    
    <update id="updateAuthor">
      update Author set
        username = #{username},
        password = #{password},
        email = #{email},
        bio = #{bio}
      where id = #{id}
    </update>
    
    <delete id="deleteAuthor">
      delete from Author where id = #{id}
    </delete>
</mapper>