springboot整合mybatis

springboot整合mybatis

①搭建springb的工程

next直到创建好项目

②引入mybatis起步依赖，添加mysql驱动

 <dependencies>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.2.0</version>
        </dependency>

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
    </dependencies>

③编写DataSource和MyBatis相关配置

在application.yml 中配置数据库信息

#datasource
spring:
  datasource:
    url: jdbc:mysql:///springboot?serverTimezone=UTC
    username: root
    password: root
    driver-class-name: com.mysql.jdbc.Driver

#mybatis的配置
mybatis:
  mapper-locations: classpath:mapper/*Mapper.xml #mapper映射文件的路径
  type-aliases-package: com.javaqian.springbootmybatis.domain
#pconfig-location: 指定mybatis的核心配置文件

④创建表并定义实体类

数据库表

CREATE DATABASE `springboot` ;
USE `springboot`;
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
insert  into `t_user`(`id`,`username`,`password`) values (1,'zhangsan','123'),(2,'lisi','234');

实体类

package com.javaqian.springbootmybatis.domain;
public class User {
    private int id;
    private String userName;
    private String password;
    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 String getPassword() {
        return password;
    }
    public void setPassword(String password) {
        this.password = password;
    }
    public User(int id, String userName, String password) {
        this.id = id;
        this.userName = userName;
        this.password = password;
    }
    public User() {
    }

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

⑤编写dao和mapper文件/纯注解开发

编写dao层

package com.javaqian.springbootmybatis.mapper;

import com.javaqian.springbootmybatis.domain.User;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;

import java.util.List;
@Mapper
@Repository
public interface UserXmlMapper {
    public List<User> findAll();
}

编写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 namespace="com.javaqian.springbootmybatis.mapper.UserXmlMapper">
<select id="findAll" resultType="user">
    select  * from t_user
</select>
</mapper>

⑥测试

package com.javaqian.springbootmybatis;

import com.javaqian.springbootmybatis.domain.User;
import com.javaqian.springbootmybatis.mapper.UserMapper;
import com.javaqian.springbootmybatis.mapper.UserXmlMapper;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;

import java.util.List;

@SpringBootTest
class SpringbootMybatisApplicationTests {
  	@Autowired
    private UserXmlMapper userXmlMapperr;
  	@Test
    void mybatisFindTest() {
        List<User> users=userXmlMapperr.findAll();
        for (User user : users) {
            System.out.println(user);
        }
    }
}