JavaWeb测试数据库 JavaWeb实战之编写单元测试类测试数据库操作

public class MybatisTool {
	public static SqlSessionFactory sessionFactory;
    
    static{
        try {
        	Reader reader = Resources.getResourceAsReader("sqlMapConfig.xml");           
            sessionFactory = //构建sqlSession的工厂
		 new SqlSessionFactoryBuilder().build(reader);
        } catch (Exception e) {
            e.printStackTrace();
        }         
    }
    //创建能执行映射文件中sql的sqlSession
    public static SqlSession getSession(){
        return sessionFactory.openSession(true);//自动事务提交
    }
}

class TestConnnect {

	@Test
	void test() throws IOException {
		SqlSession session = MybatisTool.getSession();
		Db45Mapper mapper = session.getMapper(Db45Mapper.class);
		Db45 info = mapper.selectByPrimaryKey(1);
		System.out.println(info);
	}
}