- foreach实现批量插入
批量插入用户信息
UserMapper接口:
/**
* 批量插入用户信息
* @param userList
* @return
*/
int insertList(List<SysUser> userList);
UserMapper.xml文件:
<!-- 批量插入用户信息 -->
<insert id="insertList" keyProperty="id" useGeneratedKeys="true">
INSERT INTO sys_user(
user_name, user_password, user_email,
user_info, head_img, create_time
) values
<foreach collection="list" item="user" separator=",">
(
#{user.userName}, #{user.userPassword},
#{user.userEmail}, #{user.userInfo},
#{user.headImg, jdbcType=BLOB},
#{user.createTime, jdbcType=TIMESTAMP}
)
</foreach>
</insert>
测试代码:
//foreach 批量插入用户信息
@Test
public void testInsertList(){
SqlSession sqlSession = getSqlSession();
try{
UserMapper userMapper =