1.不用注解
public void insertList(List<User> users); <insert id="insertList" parameterType="java.util.List" > insert into user (id,name,password,sex,age) values <foreach collection="list" open="(" close=")" separator="," item="item"> (#{item.id,jdbcType=INTEGER}, #{item.name,jdbcType=VARCHAR}, #{item.password,jdbcType=VARCHAR}, #{item.sex,jdbcType=TINYINT}, #{item.age,jdbcType=INTEGER}) </foreach> </insert>2.使用@Param注解
public void insertList(@Param("list") List<User> users); <insert id="insertList"> insert into user (id,name,password,sex,age) values <foreach collection="users" open="(" close=")" separator="," item="item"> (#{item.id,jdbcType=INTEGER}, #{item.name,jdbcType=VARCHAR}, #{item.password,jdbcType=VARCHAR}, #{item.sex,jdbcType=TINYINT}, #{item.age,jdbcType=INTEGER}) </foreach> </insert>1.不用注解
public List<User> selectAllUsers(Integer[] ids); <select id="selectAllUsers" parameterType="java.util.Array" > select * from user where id in <foreach collection="array" open="(" close=")" separator="," item="item"> #{item,jdbcType=INTEGER} </foreach> </select2.使用@Param注解
public List<User> selectAllUsers(@Param("ids") Integer[] ids); <select id="selectAllUsers" parameterType="java.util.Array" > select * from user where id in <foreach collection="ids" open="(" close=")" separator="," item="item"> #{item,jdbcType=INTEGER} </foreach> </select