java - Springboot crud Repository插入空值
问题描述
如果我使用 crud 存储库,Springboot 会在其中插入空值,即使所有配置正确并且休眠查询正在控制台中执行,但是如果我们检查数据库中的数量和类别值是否作为 NULL 值插入
票务.java
package com.vinay.api.model;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.Table;
import lombok.AllArgsConstructor;
import lombok.Getter;
import lombok.NoArgsConstructor;
import lombok.Setter;
import lombok.ToString;
@Entity
@Table(name = "Ticket")
@Getter
@Setter
@NoArgsConstructor
@AllArgsConstructor
@ToString
public class Ticket {
@Id
@GeneratedValue
private int id;
private double amount;
private String category;
}
TicketDao.java
package com.vinay.api.dao;
import org.springframework.data.repository.CrudRepository;
import com.vinay.api.model.Ticket;
public interface TicketDao extends CrudRepository<Ticket, Integer>{
}
票务控制器.java
package com.vinay.api.controller;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import com.vinay.api.dao.TicketDao;
import com.vinay.api.model.Ticket;
@RestController
@RequestMapping("/tickets")
public class TicketController {
@Autowired
private TicketDao ticketDao;
@PostMapping("/bookTickets")
public String bookTicket(@RequestBody List<Ticket> tickets)
{
ticketDao.saveAll(tickets);
return "tickets booked: "+tickets.size();
}
@GetMapping("/getTickets")
public List<Ticket> getTickets()
{
return (List<Ticket>) ticketDao.findAll();
}
}
SpringMysqlApplication.java
package com.vinay.api;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
@SpringBootApplication
public class SpringMysqlApplication {
public static void main(String[] args) {
SpringApplication.run(SpringMysqlApplication.class, args);
}
}
应用程序属性
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url= jdbc:mysql://localhost:3306/ticket
spring.datasource.username= root
spring.datasource.password=
spring.jpa.show-sql= true
spring.jpa.hibernate.ddl-auto= update
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQL5Dialect
pom.xml
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.2.2.RELEASE</version>
<relativePath/> <!-- lookup parent from repository -->
</parent>
<groupId>com.example</groupId>
<artifactId>spring-mysql</artifactId>
<version>0.0.1-SNAPSHOT</version>
<name>spring-mysql</name>
<description>Springboot mysql</description>
<properties>
<java.version>1.8</java.version>
</properties>
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<optional>true</optional>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
<exclusions>
<exclusion>
<groupId>org.junit.vintage</groupId>
<artifactId>junit-vintage-engine</artifactId>
</exclusion>
</exclusions>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
</plugin>
</plugins>
</build>
</project>
解决方案
我能够解决这个问题我没有在我的IDE中配置lambok所以我使用手动getter和setter删除了@getter和@Setter注释帮助我解决了这个问题
推荐阅读
- angular - Angular 自定义材质对话框单元测试
- php - 使用共享选项和目录位置编译 PHP
- sails.js - 如何使用 Sails.js 设置 Tailwind CSS?
- asp.net-core - 采用 sitename.com/en/Page 形式的 Asp 核心 URL
- javascript - Discord Webhook 消息无法发送
- flutter - 每次关闭终端后,颤振路径都不会永久保存在 z shell mac os catalina 上
- netlogo - 在列表中查找项目的“源龟”
- python - 使用 pandas groupby 将行折叠成一行?
- c++ - 使用Win32读取文件时glShaderSource访问冲突
- asynchronous - asyncio.create_task 立即执行协程