mybatis简单案例源码详细【注释全面】——测试层（UserMapperTest.java）

 /**  
* @Title: UserMapperTest.java
* @Package org.test
* @Description: TODO该方法的主要作用：
* @author A18ccms A18ccms_gmail_com  
* @date 2017-10-5 下午7:51:50
* @version V1.0  
*/
package org.test;

import java.io.IOException;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

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.apache.log4j.Logger;
import org.dao.UserMapper;
import org.entity.Users;
import org.junit.Test;
import org.util.MybatisUtils;

 /**   
 *    
 * 项目名称：ssm_chop1   
 * 类名称：UserMapperTest   
 * 类描述：   
 * 创建人：Mu Xiongxiong  
 * 创建时间：2017-10-5 下午7:51:50   
 * 修改人：Mu Xiongxiong   
 * 修改时间：2017-10-5 下午7:51:50   
 * 修改备注：   
 * @version    
 *    
 */
public class UserMapperTest {
	
	/**
	* @Fields logger :该字段的意思：日志
	*/
	private Logger logger = Logger.getLogger(UserMapperTest.class);
	/**
	* @Fields sqlSession :该字段的意思：sqlsession
	*/
	private SqlSession sqlSession = null;
	/**
	* @Fields rel :该字段的意思：区分增删改的是否成功
	*/
	private int rel = 0;
	
	/**
	 * 
	* @Description: 该方法的主要作用：不是用工具类进行测试
	* @Title: test
	* @param   设定文件  
	* @return  返回类型：void   
	* @throws
	 */
	@Test
	public void test_noMybatisUtil(){
		
		String resource = "mybatis-config.xml";
		int count = 0;
		SqlSession sqlSession  = null;
		try {
			//1.获取mybatis-config.xml的输入流
			InputStream inputStream = Resources.getResourceAsStream(resource);
			//2.创建SqlSessionFaction对象，完成对配置文件的读取
			SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(inputStream);
			//3.创建sqlsession
			sqlSession = factory.openSession();
			//4.调用mapper文件来对数据进行操作，必须把mapper文件引入mybatis-config.xml中
			count = sqlSession.selectOne("org.dao.UserMapper.count");
			logger.debug("UserMapperTest count----"+count);
			System.out.println(count);
		} catch (IOException e) {
			// TODO 异常执行块！
			e.printStackTrace();
		}finally{
			sqlSession.close();
		}
		
	}
	
	/**
	 * 
	* @Description: 该方法的主要作用：使用工具类进行测试
	* @Title: test_MybatisUtils
	* @param   设定文件  
	* @return  返回类型：void   
	* @throws
	 */
	@Test
	public void test_MybatisUtils(){
		SqlSession sqlSession = null;
		int count = 0;
		try {
			sqlSession = MybatisUtils.createSqlSession();
			count = sqlSession.selectOne("org.dao.UserMapper.count");
		} catch (Exception e) {
			// TODO 异常执行块！
			e.printStackTrace();
		}finally{
			MybatisUtils.closeSqlSession(sqlSession);
		}
		System.out.println(count);
		
	}
	
	/**
	 * 
	* @Description: 该方法的主要作用：调用接口进行查询
	* @Title: test_Icount
	* @param   设定文件  
	* @return  返回类型：void   
	* @throws
	 */
	@Test
	public void test_Icount(){
		SqlSession sqlSession = null;
		int count = 0;
		try {
			sqlSession = MybatisUtils.createSqlSession();
			//接口UserMapper的名字必须要和映射文件的名字一样
			count = sqlSession.getMapper(UserMapper.class).count();
		} catch (Exception e) {
			// TODO 异常执行块！
			e.printStackTrace();
		}finally{
			MybatisUtils.closeSqlSession(sqlSession);
		}
		System.out.println("总记录数是："+count);
	}
	
	/**
	 * 
	* @Description: 该方法的主要作用：使用接口的方式查询所有的数据
	* @Title: test_IgetUserList
	* @param   设定文件  
	* @return  返回类型：void   
	* @throws
	 */
	@Test
	public void test_IgetUserList(){
		SqlSession sqlSession = null;
		List<Users> userList = new ArrayList<Users>();
		
		try {
			sqlSession = MybatisUtils.createSqlSession();
			userList = sqlSession.getMapper(UserMapper.class).getUserList();
		} catch (Exception e) {
			// TODO 异常执行块！
			e.printStackTrace();
		}finally{
			MybatisUtils.closeSqlSession(sqlSession);
		}
		
		for (Users users : userList) {
			System.out.println("用户名是"+users.getUserName());
		}
		
		
	}
	
	/**
	 * 
	* @Description: 该方法的主要作用：根据用户名进行模糊查询信息
	* @Title: test_IgetUsersByName
	* @param   设定文件  
	* @return  返回类型：void   
	* @throws
	 */
	@Test
	public void test_IgetUsersByName(){
		SqlSession sqlSession  = null;
		Users users = null;
		
		try {
			sqlSession = MybatisUtils.createSqlSession();
			users = sqlSession.getMapper(UserMapper.class).getUsersByName("明");
			
		} catch (Exception e) {
			// TODO 异常执行块！
			e.printStackTrace();
		}finally{
			MybatisUtils.closeSqlSession(sqlSession);
		}
		
		System.out.println(users.getPhone());
		
	}
	
	/**
	 * 
	* @Description: 该方法的主要作用：根据用户对象进行查询
	* @Title: test_IgetUserListByUser
	* @param   设定文件  
	* @return  返回类型：void   
	* @throws
	 */
	@Test
	public void test_IgetUserListByUser(){
		SqlSession sqlSession = null;
		List<Users> users1 = null;
		Users users = new Users();
		
		try {
			users.setUserName("李");
			users.setUserrole(2);
			sqlSession = MybatisUtils.createSqlSession();
			users1  = sqlSession.getMapper(UserMapper.class).getUserListByUser(users);
		} catch (Exception e) {
			// TODO 异常执行块！
			e.printStackTrace();
		}finally{
			MybatisUtils.closeSqlSession(sqlSession);
		}
		for (Users user : users1) {
			System.out.println(user.getUserName());
		}
	}
	
	/**
	 * 
	* @Description: 该方法的主要作用：查询用户列表，参数是Map
	* @Title: test_IgetUsersListByMap
	* @param   设定文件  
	* @return  返回类型：void   
	* @throws
	 */
	@Test
	public void test_IgetUsersListByMap(){
		SqlSession sqlSession = null;
		List<Users> usersList = null;
		
		try {
			sqlSession = MybatisUtils.createSqlSession();
			Map<String, String> map = new HashMap<String, String>();
			map.put("userName", "李");
			map.put("userrole", "2");
			usersList = sqlSession.getMapper(UserMapper.class).getUsersListByMap(map);
		} catch (Exception e) {
			// TODO 异常执行块！
			e.printStackTrace();
		}finally{
			MybatisUtils.closeSqlSession(sqlSession);
		}
		for (Users user : usersList) {
			System.out.println(user.getUserName());
		}
		
	}

	/**
	 * 
	* @Description: 该方法的主要作用：连接查询
	* @Title: test_IgetUserListAndRole
	* @param   设定文件  
	* @return  返回类型：void   
	* @throws
	 */
	@Test
	public void test_IgetUserListAndRole(){
		SqlSession sqlSession = null;
		List<Users> userList = null;
		
		try {
			sqlSession = MybatisUtils.createSqlSession();
			Users users = new Users();
			users.setUserName("李");
			users.setUserrole(2);
			userList = sqlSession.getMapper(UserMapper.class).getUserListAndRole(users);
		} catch (Exception e) {
			// TODO 异常执行块！
			e.printStackTrace();
		}finally{
			MybatisUtils.closeSqlSession(sqlSession);
		}
		
		
		for (Users users : userList) {
			System.out.println(users.getAddress());
		}
	}
	
	/**
	 * 
	* @Description: 该方法的主要作用：添加用户信息
	* @Title: test_IsaveUser
	* @param   设定文件  
	* @return  返回类型：void   
	* @throws
	 */
	@Test
	public void test_IsaveUser(){
		try {
			sqlSession =  MybatisUtils.createSqlSession();
			Users users  = new Users();
			users.setAddress("山东省济南市");
			users.setBirthday(new Date());
			users.setCreateBy(1);
			users.setCreationDate(new Date());
			users.setGender("1");
			users.setModifyBy(2);
			users.setModifyDate(new Date());
			users.setPhone("15066675713");
			users.setUserCode("wangwei");
			users.setUserName("王伟");
			users.setUserPassword("123456");
			users.setUserrole(1);
			rel = sqlSession.getMapper(UserMapper.class).saveUser(users);
			if(rel>0){
				System.out.println("添加成功");
			}else{
				System.out.println("添加失败");
			}
		} catch (Exception e) {
			// TODO 异常执行块！
			e.printStackTrace();
		}finally{
			sqlSession.commit();
			MybatisUtils.closeSqlSession(sqlSession);
		}
	}
	
	/**
	 * 
	* @Description: 该方法的主要作用：根据编号修改
	* @Title: test_IupdateUser
	* @param   设定文件  
	* @return  返回类型：void   
	* @throws
	 */
	@Test
	public void test_IupdateUser(){
		try {
			sqlSession  = MybatisUtils.createSqlSession();
			Users users  = new Users();
			users.setAddress("山东省济南市");
			users.setBirthday(new Date());
			users.setCreateBy(1);
			users.setCreationDate(new Date());
			users.setGender("1");
			users.setModifyBy(2);
			users.setModifyDate(new Date());
			users.setPhone("15066675713");
			users.setUserCode("wangwei");
			users.setUserName("李伟");
			users.setUserPassword("123456");
			users.setUserrole(1);
			users.setId(19);
			rel = sqlSession.getMapper(UserMapper.class).updateUser(users);
			if(rel>0){
				System.out.println("修改成功");
			}else{
				System.out.println("修改失败");
			}
		} catch (Exception e) {
			// TODO 异常执行块！
			e.printStackTrace();
		}finally{
			sqlSession.commit();
			MybatisUtils.closeSqlSession(sqlSession);
		}
	}
	
	/**
	* @Description: 该方法的主要作用：根据id删除数据
	* @Title: test_IdelUser
	* @param   设定文件  
	* @return  返回类型：void   
	* @throws
	 */
	@Test
	public void test_IdelUser(){
		try {
			sqlSession = MybatisUtils.createSqlSession();
			rel = sqlSession.getMapper(UserMapper.class).delUser(19);
			if(rel>0){
				System.out.println("删除成功！");
			}else{
				System.out.println("删除失败！");
			}
		} catch (Exception e) {
			// TODO 异常执行块！
			e.printStackTrace();
		}finally{
			sqlSession.commit();
			MybatisUtils.closeSqlSession(sqlSession);
		}
	}
	
	/**
	 * 
	* @Description: 该方法的主要作用：根据id查询用户信息
	* @Title: test_IgetUsersById
	* @param   设定文件  
	* @return  返回类型：void   
	* @throws
	 */
	@Test
	public void test_IgetUsersById(){
		try {
			sqlSession = MybatisUtils.createSqlSession();
			Users users = sqlSession.getMapper(UserMapper.class).getUsersById(15);
			System.out.println(users.getUserName());
		} catch (Exception e) {
			// TODO 异常执行块！
			e.printStackTrace();
		}finally{
			MybatisUtils.closeSqlSession(sqlSession);
		}
	}
	
	/**
	 * 
	* @Description: 该方法的主要作用：根据角色id查询用户信息
	* @Title: test_IgetUsersByRoleId
	* @param   设定文件  
	* @return  返回类型：void   
	* @throws
	 */
	@Test
	public void test_IgetUsersByRoleId(){
		try {
			sqlSession = MybatisUtils.createSqlSession();
			List<Users> userList = sqlSession.getMapper(UserMapper.class).getUsersByRoleId(2);
			for (Users users : userList) {
				System.out.println(users.getUserName());
			}
		} catch (Exception e) {
			// TODO 异常执行块！
			e.printStackTrace();
		}finally{
			MybatisUtils.closeSqlSession(sqlSession);
		}
	}
	
	/**
	 * 
	* @Description: 该方法的主要作用：根据userName和userrole动态查询用户信息
	* @Title: test_IgetUsersListByUserNameAndRole_if
	* @param   设定文件  
	* @return  返回类型：void   
	* @throws
	 */
	@Test
	public void test_IgetUsersListByUserNameAndRole_if(){
		try {
			sqlSession = MybatisUtils.createSqlSession();
			List<Users> userList = sqlSession.getMapper(UserMapper.class).getUsersListByUserNameAndRole_if(null, 3);
			for (Users users : userList) {
				System.out.println(users.getUserName());
			}
		} catch (Exception e) {
			// TODO 异常执行块！
			e.printStackTrace();
		}finally{
			MybatisUtils.closeSqlSession(sqlSession);
		}
	}
	
	/**
	 * 
	* @Description: 该方法的主要作用：动态根据用户名和角色id查询用户列表，where and|or
	* @Title: getUsersListByUserNameAndRole_ifAndwhere
	* @param   设定文件  
	* @return  返回类型：void   
	* @throws
	 */
	@Test
	public void test_IgetUsersListByUserNameAndRole_ifAndwhere(){
		try {
			sqlSession = MybatisUtils.createSqlSession();
			List<Users> userList = sqlSession.getMapper(UserMapper.class).getUsersListByUserNameAndRole_ifAndwhere(null, 2);
			for (Users users : userList) {
				System.out.println(users.getUserName());
			}
		} catch (Exception e) {
			// TODO 异常执行块！
			e.printStackTrace();
		}finally{
			MybatisUtils.closeSqlSession(sqlSession);
		}
	}
	
	/**
	 * 
	* @Description: 该方法的主要作用：使用is+set动态修改用户表信息
	* @Title: updateUser_ifAndSet
	* @param   设定文件  
	* @return  返回类型：void   
	* @throws
	 */
	@Test
	public void test_IupdateUser_ifAndSet(){
		try {
			sqlSession  = MybatisUtils.createSqlSession();
			Users users  = new Users();
			users.setAddress("山东省济南市");
			users.setBirthday(new Date());
			users.setCreateBy(1);
			users.setCreationDate(new Date());
			users.setGender("1");
			users.setModifyBy(2);
			users.setModifyDate(new Date());
			users.setPhone("15066675713");
			users.setUserCode("wangwei");
			users.setUserName("李伟");
			users.setUserPassword("123456");
			users.setUserrole(1);
			users.setId(15);
			rel = sqlSession.getMapper(UserMapper.class).updateUser_ifAndSet(users);
			if(rel>0){
				System.out.println("修改成功");
			}else{
				System.out.println("修改失败");
			}
		} catch (Exception e) {
			// TODO 异常执行块！
			e.printStackTrace();
		}finally{
			sqlSession.commit();
			MybatisUtils.closeSqlSession(sqlSession);
		}
	}

	/**
	 * 
	* @Description: 该方法的主要作用：动态根据用户名和角色id查询用户列表，使用trim进行查询用户信息，where and|or
	* @Title: getUsersListByUserNameAndRole_ifAndwhere_trim
	* @param   设定文件  
	* @return  返回类型：void   
	* @throws
	 */
	@Test
	public void test_IgetUsersListByUserNameAndRole_ifAndwhere_trim(){
		try {
			sqlSession = MybatisUtils.createSqlSession();
			List<Users> userList = sqlSession.getMapper(UserMapper.class)
						.getUsersListByUserNameAndRole_ifAndwhere_trim("张", 3);
			for (Users users : userList) {
				System.out.println(users.getUserName());
			}
		} catch (Exception e) {
			// TODO 异常执行块！
			e.printStackTrace();
		}finally{
			MybatisUtils.closeSqlSession(sqlSession);
		}
	}

	/**
	 * 
	* @Description: 该方法的主要作用：使用trim代替set进行动态修改用户信息
	* @Title: updateUser_ifAndTrim
	* @param   设定文件  
	* @return  返回类型：void   
	* @throws
	 */
	@Test
	public void test_IupdateUser_ifAndTrim(){
		try {
			sqlSession  = MybatisUtils.createSqlSession();
			Users users  = new Users();
			users.setAddress("山东省济南市");
			users.setBirthday(new Date());
			users.setCreateBy(1);
			users.setCreationDate(new Date());
			users.setGender("1");
			users.setModifyBy(2);
			users.setModifyDate(new Date());
			users.setPhone("15066675713");
			users.setUserCode("wangwei");
			users.setUserName("李伟伟");
			users.setUserPassword("123456");
			users.setUserrole(1);
			users.setId(15);
			rel = sqlSession.getMapper(UserMapper.class).updateUser_ifAndTrim(users);
			if(rel>0){
				System.out.println("修改成功");
			}else{
				System.out.println("修改失败");
			}
		} catch (Exception e) {
			// TODO 异常执行块！
			e.printStackTrace();
		}finally{
			sqlSession.commit();
			MybatisUtils.closeSqlSession(sqlSession);
		}
	}

	/**
	 * 
	* @Description: 该方法的主要作用：根据用户角色列表，获取该角色刘表下用户列表信息foreach_array
	* @Title: test_IgetUsersByRoleId_foreach_array
	* @param   设定文件  
	* @return  返回类型：void   
	* @throws
	 */
	@Test
	public void test_IgetUsersByRoleId_foreach_array(){
		try {
			sqlSession = MybatisUtils.createSqlSession();
			Integer roleids [] = {1,2,3};
			List<Users> userList = sqlSession.getMapper(UserMapper.class).getUsersByRoleId_foreach_array(roleids);
			for (Users users : userList) {
				System.out.println(users.getUserName());
			}
		} catch (Exception e) {
			// TODO 异常执行块！
			e.printStackTrace();
		}finally{
			MybatisUtils.closeSqlSession(sqlSession);
		}
	}
	
	/**
	 * 
	* @Description: 该方法的主要作用：根据用户角色列表，获取该角色刘表下用户列表信息foreach_list
	* @Title: getUsersByRoleId_foreach_list
	* @param   设定文件  
	* @return  返回类型：void   
	* @throws
	 */
	@Test
	public void test_IgetUsersByRoleId_foreach_list(){
		try {
			sqlSession = MybatisUtils.createSqlSession();
			List<Integer> roleids = new ArrayList<Integer>();
			roleids.add(1);
			roleids.add(2);
			List<Users> userList = sqlSession.getMapper(UserMapper.class).getUsersByRoleId_foreach_list(roleids);
			for (Users users : userList) {
				System.out.println(users.getUserName());
			}
		} catch (Exception e) {
			// TODO 异常执行块！
			e.printStackTrace();
		}finally{
			MybatisUtils.closeSqlSession(sqlSession);
		}
	}

	/**
	 * 
	* @Description: 该方法的主要作用：根据用户角色列表和性别（多参数），获取该角色刘表下用户列表信息foreach_map
	* @Title: test_IgetUsersByRoleId_foreach_many_map
	* @param   设定文件  
	* @return  返回类型：void   
	* @throws
	 */
	@Test
	public void test_IgetUsersByRoleId_foreach_many_map(){
		try {
			sqlSession = MybatisUtils.createSqlSession();
			List<Integer> roleids = new ArrayList<Integer>();
			Map<String, Object> conditionmap = new HashMap<String, Object>();
			roleids.add(1);
			roleids.add(2);
			conditionmap.put("gender", 1);
			conditionmap.put("roleids", roleids);
			
			List<Users> userList = sqlSession.getMapper(UserMapper.class).getUsersByRoleId_foreach_many_map(conditionmap);
			for (Users users : userList) {
				System.out.println(users.getUserName());
			}
		} catch (Exception e) {
			// TODO 异常执行块！
			e.printStackTrace();
		}finally{
			MybatisUtils.closeSqlSession(sqlSession);
		}
	}
	
	/**
	 * 
	* @Description: 该方法的主要作用：根据用户角色列表（单参数），获取该角色刘表下用户列表信息foreach_map
	* @Title: getUsersByRoleId_foreach_one_map
	* @param   设定文件  
	* @return  返回类型：void   
	* @throws
	 */
	@Test
	public void test_IgetUsersByRoleId_foreach_one_map(){
		try {
			sqlSession = MybatisUtils.createSqlSession();
			List<Integer> roleids = new ArrayList<Integer>();
			Map<String, Object> conditionmap = new HashMap<String, Object>();
			roleids.add(1);
			roleids.add(2);
			conditionmap.put("rKey", roleids);
			
			List<Users> userList = sqlSession.getMapper(UserMapper.class).getUsersByRoleId_foreach_one_map(conditionmap);
			for (Users users : userList) {
				System.out.println(users.getUserName());
			}
		} catch (Exception e) {
			// TODO 异常执行块！
			e.printStackTrace();
		}finally{
			MybatisUtils.closeSqlSession(sqlSession);
		}
	}
	
	/**
	 * 
	* @Description: 该方法的主要作用：查询用户列表，使用choose
	* @Title: getUsersList_choose
	* @param   设定文件  
	* @return  返回类型：void   
	* @throws
	 */
	@Test
	public void test_IgetUsersList_choose(){
		try {
			sqlSession = MybatisUtils.createSqlSession();
			
			List<Users> userList = sqlSession.getMapper(UserMapper.class).getUsersList_choose(null,null,null,new Date());
			for (Users users : userList) {
				System.out.println(users.getUserName());
			}
		} catch (Exception e) {
			// TODO 异常执行块！
			e.printStackTrace();
		}finally{
			MybatisUtils.closeSqlSession(sqlSession);
		}
	}

	/**
	 * 
	* @Description: 该方法的主要作用：分页查询用户信息
	* @Title: getUserList_page
	* @param   设定文件  
	* @return  返回类型：void   
	* @throws
	 */
	@Test
	public void test_IgetUserList_page(){
		try {
			sqlSession = MybatisUtils.createSqlSession();
			
			List<Users> userList = sqlSession.getMapper(UserMapper.class).getUserList_page(4,3);
			for (Users users : userList) {
				System.out.println(users.getUserName());
			}
		} catch (Exception e) {
			// TODO 异常执行块！
			e.printStackTrace();
		}finally{
			MybatisUtils.closeSqlSession(sqlSession);
		}
	}
}