mybatis_005_dynamicSQL_insert

Dao:

 /*批量插入*/

    public void addEmp(@Param("list") List<Employee> list);

Mapper.xml:

<!--  public void addEmp(@Param("list") List<Employee> list);-->
    <insert id="addEmp">
        insert into employee(name,gender,email,d_id) values
        <foreach collection="list" item="emp" separator=",">
             (#{emp.name},#{emp.gender},#{emp.email},#{emp.deptName.id})
        </foreach>
    </insert>

Test:

@Test
    public void DynamicSqlInsertTest() throws IOException {
        SqlSessionFactory sqlSessionFactory = getSessionFactory();
        SqlSession sqlSession =  sqlSessionFactory.openSession();
        try {
            EmployeeDynamicMapper employeeDynamicMapper = sqlSession.getMapper(EmployeeDynamicMapper.class);
            List<Employee> emp = new ArrayList<>();

            emp.add(new Employee(null,"tiger","M","tiger.com",new Dept(1)));
            emp.add(new Employee(null,"lion","M","lion.com",new Dept(2)));
            employeeDynamicMapper.addEmp(emp);
            sqlSession.commit();
        } finally {
            sqlSession.close();
        }

}