Day32——MyBatis的foreach标签完成批量操作

迷南。 2023-07-04 15:40 24阅读 0赞

# 一. 例子 #

EmployeeMapperDynamicSQL.java

package com.atguigu.mybatis.dao;
    
    import java.util.List;
    
    import org.apache.ibatis.annotations.Param;
    
    import com.atguigu.mybatis.beans.Employee;
    
    public interface EmployeeMapperDynamicSQL { 
    	
    	public void insertEmployeeBatch(@Param("emps")List<Employee> emps);
    }

EmployeeMapperDynamicSQL.xml

<insert id="insertEmployeeBatch">
    	   <foreach collection="emps" item="emp">
    		    insert into tbl_employee (last_name, email, gender) 
    		    values (#{emp.lastName}, #{emp.email}, #{emp.gender});
    	   </foreach>
    	</insert>

TestMyBatisDynamicSQL.java

@Test
    	public void testBatch() throws Exception{ 
    		SqlSessionFactory ssf = getSqlSessionFactory();
    		SqlSession session = ssf.openSession();
    		try { 
    			EmployeeMapperDynamicSQL mapper = session.getMapper(EmployeeMapperDynamicSQL.class);
    			List<Employee> emps = new ArrayList<>();
    			emps.add(new Employee(null, "AA", "aa@sina.com", "1"));
    			emps.add(new Employee(null, "BB", "bb@sina.com", "0"));
    			emps.add(new Employee(null, "CC", "cc@sina.com", "1"));
    			
    			mapper.insertEmployeeBatch(emps);
    			
    			session.commit();
    		} finally { 
    			// TODO: handle finally clause
    			session.close();
    		}
    		
    	}