mybatis-批量操作

代码如下：

 

1、获取sqlSession

/**
	 * 使用XML配置文件获取sqlsession
	 * @return
	 */
	public static SqlSession createSqlSessionByXML(){
		//获取config.xml文件
		String resource = "conf/config.xml";
		InputStream input = null;
		try {
			input = Resources.getResourceAsStream(resource);
			//获得sqlsession
			SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(input);
			session = factory.openSession();
			return session;
		} catch (IOException e) {
			e.printStackTrace();
			return null;
		}
	}

 

2、批量插入

 

/**
	 * 批量增加
	 */
	//@Test
	public void insertBatch(){
		
		List<User> users = new ArrayList<User>();
		for(int i=0;i <= 20;i++){
			User user = new User("姓名"+i, i%2, i+20);
			users.add(user);
		}
		
		//使用xml配置执行
		try{
			session = SessionUtil.createSqlSessionByXML();
			//使用mapper.xml文件执行
			User user = session.selectOne("org.mybatis.UserMapper.insertBatch",users);
		}finally{
			session.close();
		}
	}

//xml配置；

<!-- 批量插入数据 -->
	<insert id="insertBatch" >
       insert into user(name,sex,age) values
    	<foreach collection="list" item= "item" index ="index" separator=",">
	       (#{item.name}, #{item.sex},#{item.age})
    	</foreach >
 	</insert>

 

2、批量更新

 

/**
	 * 批量更新
	 */
	//@Test
	public void updateBatch(){
		
		Map<String,Object> map = new HashMap<String,Object>();
		List<Integer> idlist = new ArrayList<Integer>();
		for(int i=0;i<10;i++){
			idlist.add(i+45);
		}
		map.put("idlist", idlist);
		map.put("name", "姓名x");
		
		//使用xml配置执行
		try{
			session = SessionUtil.createSqlSessionByXML();
			//使用mapper.xml文件执行
			User user = session.selectOne("org.mybatis.UserMapper.updateBatch",map);
		}finally{
			session.close();
		}
	}

//xml 文件配置
<!-- 批量更新数据 -->
 	<update id= "updateBatch" parameterType= "map">
	    update user
	    set name = #{name} where id in
	    <foreach collection="idlist" item= "uid" index ="index"
	            open= "(" close =")" separator=",">
	            #{ uid}
	     </foreach >
    </update >

 

3、批量删除

 

/**
	 * 批量删除
	 */
	@Test
	public void deleteBatch(){
		
		List<Integer> idList = new ArrayList<Integer>();
		for(int i=0;i <= 5;i++){
			idList.add(i);
		}
		
		//使用xml配置执行
		try{
			session = SessionUtil.createSqlSessionByXML();
			//使用mapper.xml文件执行
			User user = session.selectOne("org.mybatis.UserMapper.deleteBatch",idList);
		}finally{
			session.close();
		}
	}

//xml文件配置
<!-- 批量删除 -->
    <delete id="deleteBatch" parameterType="java.util.List">  
	    DELETE FROM user WHERE id IN  
	    <foreach collection="list" index="index" item="item" open="(" separator="," close=")">   
	        #{item}   
	    </foreach>  
	</delete>

 

 

操作过程成偶然报错误：

 

org.apache.ibatis.exceptions.PersistenceException: 

### Error querying database.  Cause: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for org.mybatis.UserMapper.updateBatch

### Cause: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for org.mybatis.UserMapper.updateBatch

at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:26)

 

 

该错误大意就是，*mapper.xml未找到或里面的sql中跟mapper接口中的方法不对应。我因为在xml文件中的id,与session.selectOne("org.mybatis.UserMapper.deleteBatch",idList)的方法不符合，造成该错误