在spring boot中从单个实体创建两个表

Question

意味着我需要跟踪原始表，类似于用值和已经进行的操作记录表

 @Id
    @GeneratedValue
    private Long _id;
    private String description;
    private BigDecimal price;
    private String imageUrl;

指导我在春靴中实现这一点。

Answer 1

您可以使用Spring JPA审计来解决这个问题。

主实体类：

@Entity @EntityListeners(MyEntityListener.class)
public class MyEntity {

    @Id
    @GeneratedValue
    private Long _id;
    private String description;
    private BigDecimal price;
    private String imageUrl;
    // Getter Setter
}

审核侦听器类：

@Component
public class MyEntityListener {

    @Autowired
    private LogEntryRepositoy logEntryRepositoy;

    @PrePersist
    @PreUpdate
    @PreRemove
    private void beforeAnyOperation(MyEntity myEntity) { 

        LogEntry entry = new LogEntry();
        //Your custom logic
        logEntryRepositoy.save(entry);
    }
}

@Entity
public class LogEntry {

    @Id
    @GeneratedValue
    private Long _id;
    private String operation;
    //Add other properties

}

@Repository
public interface LogEntryRepositoy extends JpaRepository<LogEntry, Long> {

}

@SpringBootApplication
@EnableJpaRepositories(considerNestedRepositories = true)
@EnableJpaAuditing
public class Application{
    public static void main(String[] args) {
        SpringApplication.run(Application.class, args);
    }
}

如果您使用的是h2以外的任何其他数据库，请在应用程序属性中进行配置。

spring.jpa.database=mysql
spring.datasource.url=jdbc:mysql://localhost:3306/_your_data_name
spring.datasource.username=your_user_name
spring.datasource.password=your_password

和MySQL在pom.xml中的依赖性：

 <dependency>
       <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>6.0.6</version>
    </dependency>