在spring boot中使用@Scheduled annotation调度函数

Question

我想在我的角度表上指定的日期和时间执行以下方法-以下是输入：

<input required [(ngModel)]="emailNotification.sendingDate" class="form-control" type="datetime-local" name="sendingDate" id="time">

发送电子邮件的方法（来自控制器）

@PostMapping(value="/getdetails")
    public @ResponseBody void sendMail(@RequestBody EmailNotification details) throws Exception {
        try {
            JavaMailSenderImpl jms = (JavaMailSenderImpl) sender;
            MimeMessage message = jms.createMimeMessage();
            MimeMessageHelper helper = new MimeMessageHelper(message, MimeMessageHelper.MULTIPART_MODE_MIXED_RELATED, StandardCharsets.UTF_8.name());

            
            helper.setFrom("[e-mail]");
            List<String> recipients = fileRepo.findWantedEmails(details.getDaysNum());
            String[] to = recipients.stream().toArray(String[]::new);
            helper.setTo(to);
            helper.setText(details.getMessage(),true);
            helper.setSubject("Test Mail");
            details.setRecipients(to);
            sender.send(message);
            enr.save(new EmailNotification(details.getId(), "Test mail", details.getMessage(), details.getDaysNum(), details.getRecipients(), details.getSendingDate()));
        } catch (MessagingException e) {
            throw new RuntimeException("fail to send emails: " + e.getMessage());
        }
       

电子邮件otification.class

public class EmailNotification {
    
    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    private long id;
    private String subject;
    private String message;
    private int daysNum;
    private String[] recipients;
    /*
     * @Temporal(TemporalType.TIMESTAMP)
     */ 
    //"yyyy-MM-dd'T'HH:mm:ss.SSSX"
    @Column(name = "sending_date")
    @Basic(fetch = FetchType.EAGER)
    private LocalDateTime sendingDate;

    public EmailNotification(long id, String subject,String message, int daysNum, String[] recipients, LocalDateTime sendingDate) {
        super();
        this.sendingDate = sendingDate;
        this.daysNum = daysNum;
        this.id = id;
        this.message = message;
        this.subject = subject;
    }
    
    

我不知道该怎么做，如果有人帮忙，我会很感激的

Answer 1

现在我想我明白了你想要实现的目标，所以检查一下这是否对你有效。

假设你想在给定的表格中发送电子邮件（我将命名为PAYMENT），截止日期还有5天。假设这个表有一个名为Payment的等效实体类，您可以这样做：

1. 如果支付实体有自己的CRUDEPository扩展，您可以使用它访问dabatase，您可以进行查询，查找接近截止日期的付款。这当然取决于您访问数据库的方式。下一个示例查询可能不起作用（因为据我所知，JPA不支持DATEDIFF），但将作为您试图实现的目标的基础

@Repository
public interface PaymentRepository extends CrudRepository<Payment, Integer> {

    /* You need to find every payment that's 5 days from the deadline */
    @Query("SELECT p FROM PAYMENT p WHERE DATEDIFF(day, CURRENT_TIMESTAMP, p.deadline) <= 5")
    public List<PaymentRepository> findPaymentsCloseToDeadline();
    
}

@Configuration
@EnableScheduling
public class EmailScheduler {

    @Autowired
    private PaymentRepository paymentRepository;

    @Scheduled(cron = "0 0 10 * * ?")
    public void sendEmails() {
        JavaMailSenderImpl jms = (JavaMailSenderImpl) sender;
        MimeMessage message = jms.createMimeMessage();
        MimeMessageHelper helper = new MimeMessageHelper(message, MimeMessageHelper.MULTIPART_MODE_MIXED_RELATED, StandardCharsets.UTF_8.name());

        // Here you are accessing the payments close to the deadline
        List<Payment> payments = paymentRepository.findPaymentsCloseToDeadline();

        /* Send an email for each payment. Use the database info you already have to fill the information */
        for (Payment payment : payments) {
            try {
                helper.setFrom("[e-mail]");
                // Fill the recipients with the info you need
                String[] recipients = {payment.getUserEmail(), "[e-mail]"};
                helper.setTo(recipients);
                String msg = "Here would go the message";
                helper.setText(msg, true);
                helper.setSubject("Test Mail");
                sender.send(message);
                // You would still need to calculate the ID and the days if you require them
                enr.save(new EmailNotification(id, "Test mail", msg, days,
                        recipients, "today's date in LocalDate"));
            } catch (MessagingException e) {
                throw new RuntimeException("fail to send emails: " + e.getMessage());
            }
        }
    }

}

这只是一个指南，因为关于你的代码，我仍然有一些不知道的地方，但我希望它足够清晰，这样对你有帮助。祝你好运