MyBatis SqlSessionFactory

来源：互联网发布：氪项目编程编辑：程序博客网时间：2024/05/04 17:37

1. MyBatisUtil类

import java.io.IOException;import java.io.Reader;import org.apache.ibatis.io.Resources;import org.apache.ibatis.session.SqlSessionFactory;import org.apache.ibatis.session.SqlSessionFactoryBuilder;public class MyBatisUtil {// 每一个MyBatis的应用程序都以一个SqlSessionFactory对象的实例为核心// 使用SqlSessionFactory的最佳实践是在应用运行期间不要重复创建多次,最佳范围是应用范围private final static SqlSessionFactory sqlSessionFactory;static {String resource = "mybatis.xml";Reader reader = null;try {reader = Resources.getResourceAsReader(resource);} catch (IOException e) {System.out.println(e.getMessage());}// SqlSessionFactory对象的实例可以通过SqlSessionFactoryBuilder对象来获得// SqlSessionFactoryBuilder实例的最佳范围是方法范围（也就是本地方法变量）。sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);}public static SqlSessionFactory getSqlSessionFactory() {return sqlSessionFactory;}}

2. 测试

//@Testpublic void test() throws Exception {List<SysUsers> list = null;SqlSession sqlSession = sqlSessionFactory.openSession();list = sqlSession.selectList("getUserByUserName", "user1");System.out.println(list.get(0).getUsername());list = sqlSession.selectList("getUserByUserName", "user1");System.out.println(list.get(0).getUsername());sqlSession.close();}

0 0