mybatis之——foreach标签（视频140）

foreach便签来实现数据库中批量数据的删除，这里是根据id值来删除的。
本节课学习用到了三个文件：
（1）ComputerDaoImpl.java
（2）ComputerDaoImpl.xml
（3）mybatis.xml
具体的书写内容，请看下面代码部分里面的注释。



（1）ComputerDaoImpl.java

package cn.java.dao.impl;

import java.io.IOException;
import java.io.InputStream;
import java.util.Arrays;
import java.util.List;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.Before;
import org.junit.Test;

public class ComputerDaoImpl {
	private SqlSession session=null;
	@Before
	public void init() throws IOException{
		InputStream ins=Resources.getResourceAsStream("mybatis.xml");
	    SqlSessionFactoryBuilder ssfb=new SqlSessionFactoryBuilder();
	    SqlSessionFactory factory=ssfb.build(ins);
	    session=factory.openSession();
	}
	@Test
     public void deleteMany1(){
		 List<Integer> paramList=Arrays.asList(1,2,3,4);  //这是一个List集合
    	 int flag= session.delete("cn.java.dao.impl.ComputerDaoImpl.deleteMany1", paramList);
         session.commit();
         System.out.println(flag);
	}
	
	@Test
    public void deleteMany2(){
		int[] attr={5,6,7};//这里写成字符串类型也是可以的String[] attr={"8","9","10"};
   	     int flag= session.delete("cn.java.dao.impl.ComputerDaoImpl.deleteMany2", attr);
        session.commit();
        System.out.println(flag);
	}
}

（2）ComputerDaoImpl.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="cn.java.dao.impl.ComputerDaoImpl">
	  <!-- 
	    foreach标签：可以对List集合、数组等进行遍历
	    collection属性：指定遍历集合的类型
	    collection="list" 意思是传递的参数类型为List集合
	   -->
	  <delete id="deleteMany1" parameterType="List"> 
	     DELETE FROM computers WHERE id IN
	     <foreach collection="list" item="temp" open="(" separator="," close=")">
	         #{temp}
	     </foreach>
	  </delete>
	  
	  <!-- 
	  parameterType="java.util.ArrayList":如果是数组就指定为ArrayList类型
	  collection="array" 代表参数类型是数组 
	  
	   -->
	  <delete id="deleteMany2" parameterType="java.util.ArrayList"> 
	     DELETE FROM computers WHERE id IN
	     <foreach collection="array" item="temp" open="(" separator="," close=")">
	         #{temp}
	     </foreach>
	  </delete>
</mapper>

（3）mybatis.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
	<!-- 配置数据库连接环境：driver、url、username、password -->
	<environments default="p6spy">
		<!-- 开始配置mysql -->
		<environment id="p6spy">
			<!--配置事务  -->
			<transactionManager type="JDBC"></transactionManager>
			<!-- 配置数据源 -->
			<dataSource type="POOLED">
				<property name="driver" value="com.p6spy.engine.spy.P6SpyDriver"/>
				<property name="url" value="jdbc:p6spy:mysql://localhost:3306/dt55"/>
				<property name="username" value="root"/>
				<property name="password" value="root"/>
			</dataSource>
		</environment>
	</environments>
	
	<!-- 关联局部配置文件 -->
	<mappers>
		<!-- <mapper resource="cn/java/dao/impl/CaiPinDaoImpl.xml"/> -->
		<!-- <mapper resource="cn/java/dao/impl/One2OneDaoImpl.xml"/> -->
		<!-- <mapper resource="cn/java/dao/impl/One2ManyDaoImpl.xml"/> -->
		<mapper resource="cn/java/dao/impl/ComputerDaoImpl.xml"/>
	</mappers>
</configuration>