Idea中搭建MyBatis

搭建MyBaits首先需要一些准备工作。

1.需要一个数据库，里面存储一些数据
2.新建一个maven项目

3.在pom.xml中导入一些需要的jar包依赖

<dependencies>
       <dependency>
           <groupId>org.mybatis</groupId>
           <artifactId>mybatis</artifactId>
           <version>3.5.2</version>
       </dependency>
       <dependency>
           <groupId>junit</groupId>
           <artifactId>junit</artifactId>
           <version>4.12</version>
       </dependency>
       <dependency>
           <groupId>mysql</groupId>
           <artifactId>mysql-connector-java</artifactId>
           <version>8.0.16</version>
       </dependency>
   </dependencies>

---

准备完成后，新建这些类，接口，和配置文件，名字可以任意起

1. 在mybatis-config.xml中粘贴,value中的值可以先直接填入

<?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>

2.在UserUtils中写

public class UserUtils {
   private static SqlSessionFactory sqlSessionFactory;
   static{
       try{
           String resource = "mybatis-config.xml";
           InputStream inputStream = Resources.getResourceAsStream(resource);
            sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);}
   catch (Exception e){
   e.printStackTrace();}
   }
   public static SqlSession getsqlsession(){
       return  sqlSessionFactory.openSession();
   }
}

上面的步骤在以后的配置中是固定的，相当于JDBC中的注册驱动和获取连接

3.User是一个实体类，可根据数据库中的数据创建相应的成员，我的是这样的：

public class User {
    private int id;
    private String name;
    private String url;
    private int alexa;
    private String county;

    public User() {
    }

    public User(int id, String name, String url, int alexa, String county) {
        this.id = id;
        this.name = name;
        this.url = url;
        this.alexa = alexa;
        this.county = county;
    }

    public void setId(int id) {
        this.id = id;
    }

    public void setName(String name) {
        this.name = name;
    }

    public void setUrl(String url) {
        this.url = url;
    }

    public void setAlexa(int alexa) {
        this.alexa = alexa;
    }

    public void setCounty(String county) {
        this.county = county;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", url='" + url + '\'' +
                ", alexa=" + alexa +
                ", county='" + county + '\'' +
                '}';
    }
}

4.在UserMapper中写

public interface UserMapper {
    List<User> setuserlist();
}

5.在UserMapper.xml中写

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.zheng.mapper.UserMapper">
    <select id="setuserlist" resultType="com.zheng.pojo.User">
    select * from jdbc.websites
  </select>
</mapper>

这里面是创建的接口的路径

<mapper namespace="com.zheng.mapper.UserMapper">

id为接口中的方法名，resultType是结果集，路径是创建的实体类的路径

<select id="setuserlist" resultType="com.zheng.pojo.User">

select标签中是要执行的sql语句。这个配置文件相当于实现了接口的类，我的理解是类似与JDBC的操作对象和获取结果集

注意：返回mybatis-config.xml，把这个路径<mapper resource="org/mybatis/example/BlogMapper.xml"/>
修改为UserMapper.xml的路径

6.新建一个测试类

在测试类中写

public class UserMapperTest {
    @Test
    public void test(){
        SqlSession sqlsession = UserUtils.getsqlsession();
        UserMapper mapper = sqlsession.getMapper(UserMapper.class);
        List<User> setuserlist = mapper.setuserlist();
        for(User use:setuserlist){
            System.out.println(use);
        }
    }
}

执行即可，我的结果如下

学习MyBatis可以参考MyBatis的中文文档https://mybatis.org/mybatis-3/zh/index.html，祝大家学习愉快！