Perhaps it's semi-reactive. :)
first of all
CREATE SCHEMA `app` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
create table people
(
id int auto_increment
primary key,
name char(254) null
);
CREATE USER 'app'@'%' IDENTIFIED BY 'app';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, FILE, REFERENCES, INDEX,
ALTER, SHOW DATABASES, SUPER, LOCK TABLES, CREATE VIEW, SHOW VIEW
on app.* TO 'app'@'%';
GRANT RELOAD on *.* TO 'app'@'%';
FLUSH PRIVILEGES;
@Bean
public Session mySession() {
return new SessionFactory().getSession("mysqlx:https://localhost:33060/app?user=app&password=app");
}
@Bean
public Schema mySchema() {
return mySession().getSchema("app");
}
@Bean
public Table people() {
return mySchema().getTable("people");
}
http POST localhost:8080/people name=Daniel
and you get
HTTP/1.1 201 Created
content-length: 0
http POST localhost:8080/people name=Summer
and you get
HTTP/1.1 201 Created
content-length: 0
http POST localhost:8080/people name=邱张华
and you get
HTTP/1.1 201 Created
content-length: 0
http localhost:8080/people
and you will get
[
{
"id": 1,
"name": "Daniel"
},
{
"id": 2,
"name": "Summer"
},
{
"id": 3,
"name": "邱张华"
}
]
http POST localhost:8080/people name=邱张华
http PUT localhost:8080/people id=4 name=qiuzhanghua
http DELETE localhost:8080/people/4