整合MyBatis

核心配置：数据库连接相关信息（）
映射配置：SQL映射（XML/注解）

Maven选择MyBatis Framework、MySQL Driver

yml配置

spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3307/ssm_db?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf-8
    username: root
    password: ele994111

类属性名要与数据库字段对应

package com.itele.domian;

public class Book {
    private Integer id;
    private String type;
    private String name;
    private String description;

    @Override
    public String toString() {
        return "Book{" +
                "id=" + id +
                ", type='" + type + '\'' +
                ", name='" + name + '\'' +
                ", description='" + description + '\'' +
                '}';
    }

    public Integer getId() {
        return id;
    }

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

    public String getType() {
        return type;
    }

    public void setType(String type) {
        this.type = type;
    }

    public String getName() {
        return name;
    }

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

    public String getDescription() {
        return description;
    }

    public void setDescription(String description) {
        this.description = description;
    }
}

@Mapper

package com.itele.dao;

import com.itele.domian.Book;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

@Repository
@Mapper
public interface BookDao {

    @Select("select * from tbl_book where id = #{id}")
    public Book getById (Integer id);
}

整合Mybatis-Plus

与整合Mybatis差不多
需要去maven官网导入相关依赖

<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus-boot-starter</artifactId>
    <version>3.4.3</version>
</dependency>

Dao 定义数据层接口与映射配置，继承BaseMapper

package com.itele.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.itele.domian.Book;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

//@Repository
@Mapper
public interface BookDao extends BaseMapper<Book> {
}

数据库表名与类名不一样，要到yml中配置

假设数据库表名: tbl_book
类名: Book

mybatis-plus:
  global-config:
    db-config:
      table-prefix: tbl_

整合Druid

依赖

<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid-spring-boot-starter</artifactId>
    <version>1.2.6</version>
</dependency>

yml配置

spring:
  datasource:
    druid:
      driver-class-name: com.mysql.cj.jdbc.Driver
      url: jdbc:mysql://localhost:3307/ssm_db?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf-8
      username: root
      password: "ele994111"