1、mybatis配置版

1、mybatis配置版demo

---

1、环境说明

• JDK11
• maven3.6
• IDEA2020
• mybatis3.5.6
• mysql-connector8.0.21

2、搭建步骤

• 创建普通maven父项目（删除src文件夹）。引入三个通用依赖。

• 搭建数据库环境。创建数据库、表。

• 创建子模块。

• 编写核心配置文件。mybatis-config.xml

• 编写mybatis工具类。MybatisUtil.java

• 编写实体类。

• mapper接口。

• mapper.xml（以前是接口实现类，现在是mapper.xml文件）。

步骤实现

---

1、目录结构

2、搭建数据库环境

1、创建数据库表

-- 创建用户表
drop table if exists t_user;
create table t_user(
id int(20) not null primary key,
name varchar(32) not null,
gender varchar(12) not null,
password varchar(32) not null
)engine=InnoDB default charset=utf8;
-- 插入用户数据信息
insert into t_user(
id,name,gender,password
)
values
(101,'徐凤年','男','xfn'),
(102,'姜泥','女','jn'),
(103,'红薯','女','hs'),
(104,'洛阳','女','ly'),
(105,'李淳罡','男','lcg');

效果展示:

3、导入mybatis的相关jar包（pom.xml）

mybatis官网地址：https://mybatis.org/mybatis-3/zh/index.html

maven仓库地址：https://mvnrepository.com/

主要有两个：mybatis、mysql-connector-java

		<!--导入依赖：mybatis、mysql驱动、Junit-->
    <dependencies>
        <!--导入依赖：mybatis-->
        <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.6</version>
        </dependency>
        <!--导入依赖：mysql驱动-->
        <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.21</version>
        </dependency>
        <!--导入依赖：Junit-->
        <!-- https://mvnrepository.com/artifact/junit/junit -->
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.13.1</version>
            <scope>test</scope>
        </dependency>

    </dependencies>

4、编写mybatis核心配置文件（mybatis-config.xml）

• 配置数据库连接参数
• 配置映射数据库操作的mapper.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="com.mysql.cj.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/ssm"/>
                <property name="username" value="hlm"/>
                <property name="password" value="hlm200266"/>
            </dataSource>
        </environment>
    </environments>
    <!--映射源配置-->
    <mappers>
        <mapper resource="com/sailor/dao/userMapper.xml"/>
    </mappers>
</configuration>

5、编写mybatis工具类

• 获取数据库连接操作

package com.sailor.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;

/**
 * @author Administrator
 * 连接数据库操作
 */
public class MybatisUtil {
    //定义SqlSession工厂
    private static SqlSessionFactory sqlSessionFactory;
    static{
        //引入核心配置文件
        String resource = "mybatis-config.xml";
        try {
            //将配置文件转成流
            InputStream inputStream = Resources.getResourceAsStream(resource);
            //将流传给工厂,创建SqlSession
            sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        } catch (IOException e) {
            e.printStackTrace();
        }
    }

    /**
     * 获取SqlSession连接
     */
    public static SqlSession getSession(){
        return sqlSessionFactory.openSession();
    }
}

6、创建实体类

package com.sailor.entity;

/**
 * @author Administrator
 */
public class User {
    private int id;
    private String name;
    private String gender;
    private String password;

    public User() {
    }

    public User(int id, String name, String gender, String password) {
        this.id = id;
        this.name = name;
        this.gender = gender;
        this.password = password;
    }

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

    public int getId() {
        return id;
    }

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

    public String getName() {
        return name;
    }

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

    public String getGender() {
        return gender;
    }

    public void setGender(String gender) {
        this.gender = gender;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }
}

7、mapper接口

package com.sailor.mapper;

import com.sailor.entity.User;

import java.util.List;

/**
 * @author Administrator
 */
public interface UserMapper {
    List<User> getAll();
}

8、编写mapper.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接口 == 实现了mapper接口-->
<mapper namespace="com.sailor.mapper.UserMapper">
    <!--等于实现了接口里面的方法-->
    <select id="getAll" resultType="com.sailor.entity.User">
        select * from t_user
    </select>
</mapper>

9、测试及结果显示

package com.sailor.mapper;

import com.sailor.entity.User;
import com.sailor.utils.MybatisUtils;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;

import java.util.List;

public class MyTest {
    @Test
    public void test(){
        //获取一个会话 session
        SqlSession session = MybatisUtils.getSession();

        /**
         * 方式一：get一个mapper(官方推荐使用)
         */
        UserMapper mapper = session.getMapper(UserMapper.class);
        List<User> all = mapper.getAll();


        /**
         * 方式二：了解即可
         */
        //List<User> all = session.selectList("com.sailor.mapper.UserMapper.getAll");

        for (User user:all){
            System.out.println(user);
        }

        //关闭session
        session.close();
    }
}

10、总结

1、可能遇到的问题

• 没有在核心配置文件中注册mapper。
  

  解决方法：

  

• maven的静态资源过滤问题导致找不到mapper.xml

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

tering>


src/main/resources

/*.properties
/*.xml

false