一、准备工作
配置德鲁伊坐标:
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.2.8</version>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
</dependency>
架构图:
二、编写代码
Book:
@Data
@AllArgsConstructor
@NoArgsConstructor
public class Book {
private Integer id;
private String name;
private String description;
}
BookDao:
@Mapper
public interface BookDao {
@Select("select * from boot_db.table")
public List<Book> getAll();
}
application.yml
spring:
datasource:
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://localhost:3306/boot_db?useSSL=false&characterEncoding=UTF-8
username: root
password: 123456
#自定义数据源
type: com.alibaba.druid.pool.DruidDataSource
test类:
@SpringBootTest
class SpringbootTestApplicationTests {
@Autowired
private BookDao bookDao;
@Test
void testGetAll() {
List<Book> all = bookDao.getAll();
System.out.println(all);
}
}