封装Mybatis的工具类获取sqlSession对象

 1 package com.bjpowernode.utils;
 2 
 3 import org.apache.ibatis.io.Resources;
 4 import org.apache.ibatis.session.SqlSession;
 5 import org.apache.ibatis.session.SqlSessionFactory;
 6 import org.apache.ibatis.session.SqlSessionFactoryBuilder;
 7 
 8 import java.io.IOException;
 9 import java.io.InputStream;
10 
11 public class MybatisUtil {
12     public static SqlSessionFactory sqlSessionFactory = null;
13     static {
14         String config = "mybatis.xml";
15         try {
16             InputStream in = Resources.getResourceAsStream(config);
17             SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
18             sqlSessionFactory = builder.build(in);
19         } catch (IOException e) {
20             e.printStackTrace();
21         }
22     }
23     public static SqlSession getSqlSession(){
24         SqlSession sqlSession=null;
25         if(sqlSessionFactory!=null){
26             sqlSession = sqlSessionFactory.openSession();
27         }
28         return sqlSession;
29     }
30 }

============使用工具类

 1 package com.bjpowernode;
 2 
 3 import com.bjpowernode.domain.Student;
 4 import com.bjpowernode.utils.MybatisUtil;
 5 import org.apache.ibatis.io.Resources;
 6 import org.apache.ibatis.session.SqlSession;
 7 import org.apache.ibatis.session.SqlSessionFactory;
 8 import org.apache.ibatis.session.SqlSessionFactoryBuilder;
 9 
10 import java.io.IOException;
11 import java.io.InputStream;
12 import java.util.List;
13 
14 public class MyApp2 {
15     public static void main(String[] args) throws IOException {
16 
17         SqlSession sqlSession = MybatisUtil.getSqlSession();
18         String sqlId ="com.bjpowernode.dao.StudentDao"+"."+"selectStudents";
19         List<Student> studentList = sqlSession.selectList(sqlId);
20         for (Student stu:studentList
21              ) {
22             System.out.println(stu);
23         }
24         sqlSession.close();
25 
26     }
27 }

 

posted @ 2021-02-20 01:22  渐行、渐远  阅读(409)  评论(0)    收藏  举报