mybatis测试类(测试Sql语句)的书写

mybatis测试类(测试Sql语句)的书写

package com.atguigu.test;

import com.atguigu.mapper.UserMapper;
import com.atguigu.pojo.User;
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.junit.Before;
import org.junit.BeforeClass;
import org.junit.Test;

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

public class MybatisTest {

    @Test
    public void t1() throws IOException {


        SqlSessionFactoryBuilder sfb=new SqlSessionFactoryBuilder();

        //读取主配置文件
        InputStream inputStream= Resources.getResourceAsStream("mybatis-config.xml");
        //通过配置文件的信息构建工厂类
        SqlSessionFactory factory = sfb.build(inputStream);

        //(sqlSession)connection   得到session(等价于connection,可以调用增删改查方法)
        SqlSession session=factory.openSession();
        /**
         * 接口类型
         * mapper 对象(代理对象)
         * 是实现类
         */
        UserMapper mapper = session.getMapper(UserMapper.class);
        User user = mapper.getUserById(2);
        System.out.println(user);
        session.close();
    }
    SqlSessionFactory factory =null;
    @Before
    public void init() throws IOException {
        SqlSessionFactoryBuilder sfb=new SqlSessionFactoryBuilder();

        //读取主配置文件
        InputStream inputStream= Resources.getResourceAsStream("mybatis-config.xml");
        //通过配置文件的信息构建工厂类
         factory = sfb.build(inputStream);
    }

    /**
     * factory.openSession(true); 自动提交事务
     */
   /**
   *session.commit();
   */