MyBatis动态SQLforeach标签实现批量插入的方法示例

 
    SELECT * FROM tb1_emplyee WHERE id IN 
     
      #{item_id} 
     
 

@Test 
  public void testDynamicSqlTest() throws IOException{ 
    SqlSessionFactory sqlSessiOnFactory= getSqlSessionFactory(); 
    //1、获取到的SqlSession不会自动提交数据 
    SqlSession openSession = sqlSessionFactoryopenSession(); 
    try 
    { 
        EmployeeMapperDymanicSQL mapper=openSessiongetMapper(EmployeeMapperDymanicSQLclass); 
        /*Employee employee=new Employee(1,"lili",null,"1");*/ 
        List emps=mappergetEmpsByConditionForeach(ArraysasList(1,2,3,4)); 
        for (Employee e:emps){ 
          Systemoutprintln(e); 
        } 
 
    } 
    finally { 
      openSessionclose(); 
    } 
  } 

 
    INSERT INTO tb1_emplyee(last_name,email,gender,d_id) 
    VALUES  
     
      (#{emplastName},#{empemail},#{empgender},#{empdeptid}) 
     
 

public void addEmps(@Param("emps")List emps); 

@Test 
  public void testBatchSave() throws IOException{ 
    SqlSessionFactory sqlSessiOnFactory= getSqlSessionFactory(); 
    //1、获取到的SqlSession不会自动提交数据 
    SqlSession openSession = sqlSessionFactoryopenSession(); 
    try 
    { 
      EmployeeMapperDymanicSQL mapper=openSessiongetMapper(EmployeeMapperDymanicSQLclass); 
      List emps=new ArrayList(); 
      empsadd(new Employee(null,"Eminem","Eminem@com","1",new Department(1))); 
      empsadd(new Employee(null,"2Pac","2Pac@com","1",new Department(1))); 
      mapperaddEmps(emps); 
      openSessioncommit(); 
    } 
    finally { 
      openSessionclose(); 
    }  
  }