org.springframework.boot
spring-boot-starter-webflux
application配置文件
r2dbc
spring:
r2dbc:
url: r2dbc:mysql://localhost/r2dbc?useUnicode=true&characterEncoding=UTF-8
username: root
password: root
pool:
enabled: true
max-size: 10
initial-size: 10
validation-query: select 1
表结构
DROP TABLE IF EXISTS user
;
CREATE TABLE user
(
id
int(11) NOT NULL AUTO_INCREMENT,
name
varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
age
int(11) NULL DEFAULT NULL,
email
varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
phone_number
int(11) NULL DEFAULT NULL,
PRIMARY KEY (id
) USING BTREE
) ENGINE = InnoDB AUTO_I