SpringBoot - SpringBoot整合Druid

• SpringBoot整合Druid
• • 创建新模块
  • • 导入druid所需依赖
  • 编写yml（方案一）
  • • 编写yml（方案二）-推荐
  • 编写Dao层接口
  • 编写实体类
  • 编写测试
  • • 测试成功
  • 小结

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

    com.alibaba
    druid-spring-boot-starter
    1.2.6

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

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

package com.taotao.Dao;

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


@SuppressWarnings({"all"})
@Mapper

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

}

package com.taotao.domain;


@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));
    }

}