java sql变更跟踪_如何使用Spring动态跟踪数据库更改？

我使用spring，spring-data，spring-cronjobs和java-mail。我需要立即扫描my-

sql数据库中存在的表中的更改，并将有关更改的邮件发送给管理员。

我要做的所有工作都是运行cronjob来扫描表中的所有更改，但这是一个繁重的过程，因为表与货币交易有关，并且消耗大量资源，因此应用程序变得太慢。

因此，是否有更好的过程可用来跟踪数据库中的当前更改。例如，如果有任何方法可以在spring设置观察者以触发数据库更改过程，则将很有帮助。

以下是我正在扫描的表的实体的示例。

/** Import statements **/

@Entity

public class UserWalletTransaction {

@Id

@GeneratedValue

private Long Id;

private String toAccount;

@ManyToOne(fetch = FetchType.LAZY)

User user;

@ManyToOne(fetch = FetchType.LAZY)

Wallet wallet;

private String senderOrMobile;

private String benificiaryName;

private String beniMobile;

private Double transferAmount;

private Double sTax;

private Double charge;

private Double netAmount;

private String apiTId;

private String apiComment;

private String agentId;

private Double apiSTax;

private Double apiCharge;

private Double apiNetAmount;

private Double apiBalanceAmount;

private String transactionMode;

private String bankName;

private String userTrackId;

private String referenceNumber;

private String operatorDescription;

private String mobileNumber;

private String rechargeDateTime;

private String operatorTransactionId;

private String hermesPnr;

private String utId;

private String status;

private Double previousAmount;

private Double balanceAmount;

private Double amountTransacted;

private String transactionType;

private boolean isRaised;

private boolean isRefunded;

@Column(name = "created_by")

private String createdBy;

@Column(name = "created_date")

private Date createdDate;

@Column(name = "updated_by")

private String updatedBy;

@Column(name = "updated_date")

private Date updatedDate;

private String operationPerformed;

@OneToOne

private UserWalletTransaction relationalTransaction;

private String errorComments;

@OneToOne

private User debitUser;

@OneToOne

private User creditUser;

@OneToOne

private ServiceProvider serviceProvider;

@OneToOne

private RefundRequest refundRequests;

..... Getters and setters......

}

以下是我用来扫描数据库后启动邮件的示例cron作业。

/** Import statements **/

@Component

@EnableScheduling

public class ValidateCron {

@Autowired

RechargeService rechargeService;

@Scheduled(fixedDelay = 2)

public void demoServiceMethod() {

// Perform tasks related to scan and track the number of records added //after the previous scan. Fire a mail if any change in the database is found.

}

}

请分享我可以改善此功能性能的任何方法。提前致谢。