封装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 }

浙公网安备 33010602011771号