SpringBoot整合Druid

Druid:德鲁伊特

除了依赖和yaml配置不一样,其他同整合MyBatis

创建新模块--spring initializr--勾选SQL里的 mybatis framework、mysql driver

1 上maven查坐标依赖,添加到pom文件
    https://mvnrepository.com/

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

*2 配置文件

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

3 bean

package com.qing.bean;

public class Book {
    private Integer id;
    private String name;
    private String description;
    ...
}

4 dao 

package com.qing.dao;

import com.qing.bean.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 book where id = #{id}")
    public Book getById(Integer id);
}

5 测试类

package com.qing;

import com.qing.dao.BookDao;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;

@SpringBootTest
class SpringbootDruidApplicationTests {

	@Autowired
	private BookDao bookDao;

	@Test
	void contextLoads() {
		System.out.println(bookDao.getById(3));
	}

}

结果