mybatis框架流程

1.创建maven项目

2.在pom.xml中导入mybatis，mysql和junit（测试）等依赖

3.通过database连接数据库

 

4.编写mybatis配置文件mybatis-config.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
  PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
  "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
  <environments default="development">
    <environment id="development">
      <transactionManager type="JDBC"/>
      <dataSource type="POOLED">
        <property name="driver" value="${driver}"/>
        <property name="url" value="${url}"/>
        <property name="username" value="${username}"/>
        <property name="password" value="${password}"/>
      </dataSource>
    </environment>
  </environments>
  <mappers>
    <mapper resource="org/mybatis/example/BlogMapper.xml"/>
  </mappers>
</configuration>

每个xml文件都需要在mybatis中绑定

5.编写mybatis工具类，从SqlSessionFactory中获取SqlSeseion来执行sql语句

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;

//从SqlSessionFactory中获取SqlSession
public class mybatisUtils{
    private static SqlSessionFactory sqlSessionFactory;
    static {
        try {
            String resource = "src/main/resources/mybatis-config.xml";
            InputStream inputStream = Resources.getResourceAsStream(resource);
            SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        }catch (IOException e) {
            e.printStackTrace();
        }
    }
    public static SqlSession getSession(){
         return sqlSessionFactory.openSession();//返回sqlsession，执行sql操作
     }
}

6.编写实体类，业务类接口和与业务绑定的xml文件，来执行具体的sql语句

7.编写test类

import com.yx.pojo.User;
import com.yx.utils.mybatisUtils;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;
import java.util.List;

public class UserDaoTest{
    @Test
    public void test(){
        //获取sqlSession
        SqlSession sqlSession = mybatisUtils.getSession();
        //getMapper获取接口UserDao中具体实现方法
        UserDao mapper = sqlSession.getMapper(UserDao.class);
        List<User> userList = mapper.getUserList();
        for (User user:userList){
            System.out.println(user);
        }
        sqlSession.close();
    }
}

sqlsession需要关闭，否则可能消耗内存

8.测试可能会出现绑定问题

<build>
        <resources>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.xml</include>
                    <include>**/*.properties</include>
                </includes>
            </resource>

            <resource>
                <directory>src/main/resources</directory>
                <includes>
                    <include>**/*.xml</include>
                    <include>**/*.properties</include>
                </includes>
            </resource>
        </resources>
    </build>

项目会识别src/main中的所有xml和properties文件