Mybatis测试方法 & 善用封装思维

配置流程图

测试方法的基本步骤

@Test
	public void testUpdate() throws IOException {
		//1.加载配置mybatis-config.xml
		InputStream in = Resources.getResourceAsStream("mybatis-config.xml");
		//2.创建SqlSessionFactory
		SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(in);
		//3.创建SqlSession
		SqlSession session = factory.openSession();
		
		//4.获取Mapper
		UserMapper userMapper = session.getMapper(UserMapper.class);
		
		User user = new User();
		user.setId(38);
		user.setUsername("zhangsansansan");
		user.setPassword("123123123");
		//5.调用mapper中对应的方法
		int result = userMapper.updateUser(user);
		//6.提交事务
		session.commit();
		//7.关闭资源
		session.close();
	}

创建MyBatisUtil工具类

MyBatisUtil工具类的作用主要用于 读取配置文件，创建工厂对象，提供创建SqlSession数据库操作对象的方法

public class MyBatisUtil {
	private MyBatisUtil() {
	}
	
	//SqlSessionFactory 会话工厂对象
	private static SqlSessionFactory  factory;
	//类加载到JVM中就立马执行static代码块,并且只会执行一次
	static {
		//资源文件
		String resource = "mybatis-config.xml";
		//try(){}catch(Exception e){} try的圆括号内部能够自动释放/关闭资源
		try(InputStream inputStream = Resources.getResourceAsStream(resource)) {
			//创建SqlSessionFactory 对象
			factory = new SqlSessionFactoryBuilder().build(inputStream);
		} catch (Exception e) {
			e.printStackTrace();
		}
		
	}
	/**
	 * 创建SqlSession对象
	 * @return SqlSession对
	 */
	public static SqlSession openSession() {
		//创建Session对象
		SqlSession session = factory.openSession();
		return session;
	}

}