mybatis插入数据、批量插入数据

/*
     * 新增用户-----使用useGeneratedKeys方式
     * 测试主键自增的值 这里 主键自增的值不作为参数传递  直接由数据库那边赋值
     * */
    int insert4(SysUser sysUser);

<insert id="insert4" useGeneratedKeys="true" keyProperty="id">
        insert into sys_user (
            user_name,user_password,
            <if test="userEmail != null and  userEmail !=‘‘">
                user_email,
            </if>
            user_info,head_img,create_time)
            values (
            #{userName}, #{userPassword},
        <if test="userEmail != null and  userEmail !=‘‘">
            #{userMail},
        </if>
        #{userInfo},#{headImg, jdbcType = BLOB},
        #{createTime, jdbcType= TIMESTAMP}
        );
    </insert>

@Test
    public void testInsert4(){
        SqlSession sqlSession = getSqlSession();
        try{
            UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
            //创建一个user对象
            SysUser user = new SysUser();
            user.setUserName("test1");
            user.setUserPassword("123456");
            user.setUserEmail("test@mybatis.tk");
            user.setUserInfo("test info");
            user.setHeadImg(new byte[]{1,2,3});
            user.setCreateTime(new Date());
            int result = userMapper.insert3(user);
            Assert.assertEquals(1,result);
            Assert.assertNotNull(user.getId());
        }finally {
            sqlSession.commit();
            sqlSession.close();
        }
    }