无法将新用户添加到数据库-Spring boot:400 BadRequest

Question

我的应用程序有问题。我创建了两个服务，其中一个(db连接器(连接到数据库并允许一些操作，浏览器使用的第二个(webApp(连接到第一个。

当我尝试使用Postman创建用户时，它是有效的。所以错误必须在以下的方法中

@PostMapping("/createUser")
public String createUser(@ModelAttribute("createQuery") CreateQuery createQuery) {
HttpHeaders headers = new HttpHeaders();
headers.setContentType(MediaType.APPLICATION_JSON);
User user = new User();
user.setLogin(createQuery.getLogin());
user.setPassword(createQuery.getPassword());
user.setFirstName(createQuery.getFirstName());
user.setLastName(createQuery.getLastName());
HttpEntity<User> request = new HttpEntity<>(user, headers);
restTemplate.postForEntity("http://localhost:8080/createUser", request, User.class);
return "createUser";
}

它返回：

Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.web.client.HttpClientErrorException$BadRequest: 400 : [{"timestamp":"2020-09-10T14:57:56.859+00:00","status":400,"error":"Bad Request","message":"","path":"/createUser"}]] with root cause
org.springframework.web.client.HttpClientErrorException$BadRequest: 400 : [{"timestamp":"2020-09-10T14:57:56.859+00:00","status":400,"error":"Bad Request","message":"","path":"/createUser"}]

我尝试过这样一种方式：

HttpEntity<User> request = new HttpEntity<>(new User(), headers);
restTemplate.postForEntity("http://localhost:8080/createUser?userLogin=" + createQuery.getLogin()
+ "&password=" + createQuery.getPassword() + "&firstName=" + createQuery.getFirstName()
+ "&lastName=" + createQuery.getLastName(), request, User.class);

尝试将postForEntity更改为postForObject，但仍然无效。我搞不清楚出了什么问题。

干杯：(

Answer 1

[

2020-09-10 17:39:34.284 DEBUG 2116 --- [nio-8080-exec-1] o.s.jdbc.core.JdbcTemplate               : Executing SQL update and returning generated keys
2020-09-10 17:39:34.285 DEBUG 2116 --- [nio-8080-exec-1] o.s.jdbc.core.JdbcTemplate               : Executing prepared SQL statement [INSERT INTO EXAMPLE_SCHEMA.USERS(login, password, first_name, last_name) values(?, ?, ?, ?)]
2020-09-10 17:39:50.421 DEBUG 2116 --- [nio-8080-exec-2] o.s.jdbc.core.JdbcTemplate               : Executing prepared SQL query
2020-09-10 17:39:50.421 DEBUG 2116 --- [nio-8080-exec-2] o.s.jdbc.core.JdbcTemplate               : Executing prepared SQL statement [SELECT * FROM EXAMPLE_SCHEMA.USERS WHERE login LIKE ?]
2020-09-10 17:39:52.983 DEBUG 2116 --- [nio-8080-exec-3] o.s.jdbc.core.JdbcTemplate               : Executing prepared SQL query
2020-09-10 17:39:52.983 DEBUG 2116 --- [nio-8080-exec-3] o.s.jdbc.core.JdbcTemplate               : Executing prepared SQL statement [SELECT * FROM EXAMPLE_SCHEMA.USERS WHERE login LIKE ?]

]

在此处输入图像描述

这是第一个服务的响应，目的是连接数据库