02.MyBatis快速入门

02.MyBatis快速入门

案例需求：通过mybatis查询数据库user表的所有记录，封装到User对象中，打印到控制台上

1.步骤分析：

1. 创建数据库及user表
2. 创建maven工程，导入依赖（MySQL驱动、mybatis、junit)
3. 编写User实体类
4. 编写UserMapper.xml映射配置文件（ORM思想）
5. 编写SqlMapConfig.xml核心配置文件
   数据库环境配置
   映射关系配置的引入(引入映射配置文件的路径)
6. 编写测试代码

2.实现过程

2.1创建数据库

CREATE DATABASE `smd`;
USE `smd`;
CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(32) NOT NULL COMMENT '用户名称',
  `birthday` datetime DEFAULT NULL COMMENT '生日',
  `sex` char(1) DEFAULT NULL COMMENT '性别',
  `address` varchar(256) DEFAULT NULL COMMENT '地址',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- insert....
INSERT INTO `user` VALUES (1, '张三', '2022-02-17 15:13:30', '男', '贵州');
INSERT INTO `user` VALUES (2, '李白', '2022-01-07 15:13:47', '女', '杭州');

2.2创建Mevan项目，并导入依赖

• 整体项目结构

  

<dependencies>
        <!--    引入mybatis-->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.4</version>
        </dependency>
<!--        引入mysql-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.32</version>
        </dependency>
        <!--引入junit左单元测试-->
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.12</version>
            <scope>test</scope>
        </dependency>

    </dependencies>

2.3编写User实体

package com.lagou.domain;

import java.util.Date;

public class User {

    private Integer id;
    private String username;
    private Date birthday;
    private String sex;
    private String address;

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

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public Date getBirthday() {
        return birthday;
    }

    public void setBirthday(Date birthday) {
        this.birthday = birthday;
    }

    public String getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", username='" + username + '\'' +
                ", birthday=" + birthday +
                ", sex='" + sex + '\'' +
                ", address='" + address + '\'' +
                '}';
    }
}

2.4编写UserMapper映射文件

<?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="user">
    <select id="findAll" resultType="com.lagou.domain.User">
        select  * from user
    </select>
</mapper>

2.5编写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="mysql">
    <!--       使用mysql环境-->
        <environment id="mysql">
    <!--       使用JDBC类型事务管理器-->
            <transactionManager type="JDBC"></transactionManager>
    <!--       使用连接池-->
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://127.0.0.1:3306/smd?serverTimezone=GMT"/>
                <property name="username" value="root"/>
                <property name="password" value="root"/>
            </dataSource>
        </environment>
    </environments>
<!--    引入mapper.xml文件-->
    <mappers>
        <mapper resource="mapper/UserMapper.xml"/>
    </mappers>
</configuration>

2.6编写测试类

mybatis查询数据的过程为：

1. 加载MyBatis核心配置文件
2. 创建sqlSessionFactory工厂对象
3. 获取sqlSession会话对象
4. 执行sql 参数：statementid（也就是namespace.id）
5. 释放资源

package test;

import com.lagou.domain.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.Test;

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

public class UserTest {
    @Test
    public void testFindAll() throws IOException {
//        1.加载MyBatis核心配置文件
        InputStream inputStream = Resources.getResourceAsStream("SqlMapConfig.xml");
//        2.创建sqlSessionFactory工厂对象
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
//        3.获取sqlSession会话对象
        SqlSession sqlSession = sqlSessionFactory.openSession();
//        4.执行sql 参数：statementid: namespace.id
        List<User> users = sqlSession.selectList("user.findAll");
        for (User user : users){
            System.out.println(user);
        }
//        5.释放资源
        sqlSession.close();
    }
}

3.知识小节

1. 创建mybatis_db数据库和user表
2. 创建项目，导入依赖
3. 创建User实体类
4. 编写映射文件UserMapper.xml
5. 编写核心文件SqlMapConfig.xml
6. 编写测试类

4.测试结果