2021.11.30 mybatis主要类

主要类的介绍

·Resources:mybatis中的一个类，负责读取主配置文件

InputStream in = Resource.getResourceAsStream(“mybatis.xml”);
·SqlSessionFactoryBuilder : 创建SqlSessionFactory对象，
SqlSessionFactoryBuilder builder= new SqlSessionFactoryBuilder();
//创建SqlSessionFactory对象
SqlSessionFactory factory = builder.build(in);

·SqlSessionFactory : 重量级对象，程序创建一个对象耗时比较长，使用资源比较多。在整个项目中有一个就够用了

SqlSessionFactory 接口，实现类：DefaultSqlSessionFactory
SqlSessionFactory 作用：获取SqlSession对象。SqlSession sqlSession = factory.openSession();

·openSession()方法说明：

1.openSession()：无参数，获取非自动提交事务的SqlSession对象.
2.openSession(boolean):openSession(true)获取自动提交事务的SqlSession.
openSession(false):非自动提交事务的SqlSession对象.

·SqlSession:

SqlSession接口 ：定义了操作数据库的方法 例如selectOne,selectList(),insert(),update(),delete(),commit(),rollback();
SqlSession接口的实现类DefaultSqlSession
使用要求：SqlSession对象不是线程安全的，需要在方法内部使用，在执行sql语句之前，使用openSession()获取SqlSession,在执行完sql语句后，需要关闭它，执行SqlSession.close();这样能保证它的使用是线程安全的。

····································································································································
可以使用一个工具类将这些繁杂的类包装起来
新建一个utils包，创建类MyBatisUtils，

package org.example.utils;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import java.io.IOException;
import java.io.InputStream;

public class MyBatisUtils {

    private static SqlSessionFactory factory = null;

    static {
        String config ="mybatis.xml";
        try {
            InputStream in = Resources.getResourceAsStream(config);
            //创建SqlSessionFactory对象，使用SqlSessionFactoryBuild
             factory = new SqlSessionFactoryBuilder().build(in);
        } catch (IOException e) {
            e.printStackTrace();
        }
    }


    //获取SqlSession的方法
    public static SqlSession getSqlSession(){
        SqlSession sqlSession = null;
        if(factory !=null){
            sqlSession = factory.openSession();
        }
        return  sqlSession;
    }
}

在测试类中测试：

package org.example;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.example.domain.Student;
import org.example.utils.MyBatisUtils;

import java.io.IOException;
import java.io.InputStream;
import java.util.List;

public class MyApp2 {
    public static void main(String[] args) throws IOException {
        SqlSession sqlSession = MyBatisUtils.getSqlSession();
        String sqlId = "org.example.dao.StudentDao"+"."+"selectStudents";
        List<Student> studentList = sqlSession.selectList(sqlId);
        for (Student stu:studentList) {
            System.out.println(stu);
        }
        sqlSession.close();
    }
}