idea2021版本使用mybatis（详细步骤）

首先我们打开idea添加mybatis，mysql，junit依赖。

---

  <dependencies>

    <!-- junit测试 -->
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.13.1</version>
    </dependency>

    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>8.0.28</version>
    </dependency>

    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>3.5.6</version>
    </dependency>

  </dependencies>

---

总体结构如下图，mysql.xml是我自己测试用的，小伙伴可以不用搭理。

---

 

---

首先java层中mapper放我们的接口，pojo放实体类，Test则放测试类。

resources则写一个mybatis核心配置文件。代码如下

---

<?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="first">
        <environment id="first">
<!--            配置事务-->
            <transactionManager type="JDBC"></transactionManager>
<!--            配置数据库的地址 驱动 账号-->
<!--            pool表示mybatis自带的数据源-->
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.cj.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/t155?characterEncoding=utf8"/>
                <property name="username" value="root"/>
                <property name="password" value="root"/>
            </dataSource>
        </environment>
    </environments>
    <!--引用Mybatis的映射文件    -->
    <mappers>
     <mapper resource="mapper/OrangeMapper.xml"></mapper>
    </mappers>
</configuration>

---

mapper层下面xml代码如下，写我们的执行sql语句。

---

<?xml version="1.0" encoding="utf8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="mapper.OrangeMapper">

    <select id="count" resultType="int">

        select  count(*) from  orange

    </select>

    <select id="select_ALL" resultType="pojo.orange">

        select  * from  orange

    </select>

</mapper>

---

测试类则放我们的执行方法

    public static void main(String[] args) {
        try {
            //如何读取核心配置文件
            InputStream is = Resources.getResourceAsStream("mybatis-config.xml");
            //创建 SqlSessionFactory对象
            SqlSessionFactory sql= new SqlSessionFactoryBuilder().build(is);
            //从SqlSessionFactory中构建一个SqlSession
            SqlSession session = sql.openSession();
            OrangeMapper orangeMapper =session.getMapper(OrangeMapper.class);
//            int aaa=orangeMapper.count();
            List<orange> list =  orangeMapper.select_ALL();
            System.out.println("结果为: "+list);

        } catch (IOException e) {

            e.printStackTrace();
        }


    }

---

输出如下图，则证明mybati掌握的没问题了，

---