SpringBoot - SpringBoot整合Druid

SpringBoot整合Druid

创建新模块

导入druid所需依赖

Maven Repository: Search/Browse/Explore (mvnrepository.com)

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

编写yml（方案一）

#配置
spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/mybatis
    username: root
    password: 12345

编写yml（方案二）-推荐

#druid专用配置
spring:
  datasource:
    druid:
      driver-class-name: com.mysql.cj.jdbc.Driver
      url: jdbc:mysql://localhost:3306/mybatis?serverTimezone=UTC
      username: root
      password: 12345

编写Dao层接口

package com.taotao.Dao;

import com.taotao.domain.user;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

/**
 * create by 刘鸿涛
 * 2022/5/1 21:14
 */
@SuppressWarnings({"all"})
@Mapper

public interface UserDao {
    @Select("select * from tb_user where id = #{id}")
    public user getById(Integer id);

}

编写实体类

package com.taotao.domain;

/**
 * create by 刘鸿涛
 * 2022/5/1 21:12
 */
@SuppressWarnings({"all"})
public class user {
    private int id;
    private String username;
    private int password;
    private String gender;
    private String addr;

    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 int getPassword() {
        return password;
    }

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

    public String getGender() {
        return gender;
    }

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

    public String getAddr() {
        return addr;
    }

    public void setAddr(String addr) {
        this.addr = addr;
    }

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

编写测试

package com.taotao;

import com.taotao.Dao.UserDao;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;

@SpringBootTest
class Springboot07DruidApplicationTests {

    @Autowired
    private UserDao userDao;
    
    @Test
    void contextLoads() {
        System.out.println(userDao.getById(1));
    }

}

测试成功

小结