@Scheduled不會將我的JSON值更新為FALSE

我正在嘗試在下午 1:00 將我的 H2 銀行列的所有值設定為 false，但我在這樣做時遇到了困難，訊息正在控制臺上列印，但投票仍然為 TRUE。

我的表看起來像這樣，我希望每天下午 1:00 投票欄位的值為 FALSE

這是我在 UserServices.java 中使用的邏輯

盡管專案正在運行，但在@Scheduled 中確定的時間之后，用戶仍然保持為 TRUE

@Scheduled(cron = "0 00 13* * *")
    public void resetVotes() throws InterruptedException {
            
    List<User> userArray = repository.findAll();
    for(User user: userArray ) {
        user.setVoted(false);
    }
}

這是我在@Scheduled 中確定的時間到達控制臺時收到的訊息

Hibernate: 
    select
        user0_.id as id1_1_,
        user0_.email as email2_1_,
        user0_.password as password3_1_,
        user0_.name as name4_1_,
        user0_.voted as voted5_1_ 
    from
        db_users user0_

以下是我用于該專案的類：

用戶.java

package com.dbserver.restaurantes.entities;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;

@Entity
@Table(name = "db_users")
public class User {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    @Column(name = "Name")
    private String username;
    private String email;
    private String password;
    private Boolean voted = false;

    public Long getId() {
        return id;
    }

    public void setId(Long id) {
        this.id = id;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getEmail() {
        return email;
    }

    public void setEmail(String email) {
        this.email = email;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    public Boolean getVoted() {
        return voted;
    }

    public void setVoted(Boolean voted) {
        this.voted = voted;
    }

}

用戶DTO.java

package com.dbserver.restaurantes.dto;

import com.dbserver.restaurantes.entities.User;

public class UserDTO {
    private Long id;
    private String username;
    private String email;
    private String password;
    private Boolean voted = false;

    public UserDTO() {
    }

    public UserDTO(Long id, String username, String email, String password, Boolean voted) {
        this.id = id;
        this.username = username;
        this.email = email;
        this.password = password;
        this.voted = voted;
    }

    public UserDTO(User user) {
        id = user.getId();
        username = user.getUsername();
        email = user.getEmail();
        password = user.getPassword();
        voted = user.getVoted();
    }

    public Long getId() {
        return id;
    }

    public void setId(Long id) {
        this.id = id;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getEmail() {
        return email;
    }

    public void setEmail(String email) {
        this.email = email;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    public Boolean getVoted() {
        return voted;
    }

    public void setVoted(Boolean voted) {
        this.voted = voted;
    }

    
}

用戶服務.java

package com.dbserver.restaurantes.services;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.scheduling.annotation.Scheduled;
import org.springframework.security.crypto.bcrypt.BCryptPasswordEncoder;
import org.springframework.security.crypto.password.PasswordEncoder;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import com.dbserver.restaurantes.entities.User;
import com.dbserver.restaurantes.exceptions.HttpClientErrorException;
import com.dbserver.restaurantes.repositories.UserRepository;

@Service
public class UserServices {

    @Autowired
    private UserRepository repository;

    PasswordEncoder passwordEncoder;

    public UserServices(UserRepository userRepository) {
        this.passwordEncoder = new BCryptPasswordEncoder();
    }

    @SuppressWarnings("rawtypes")
    @Transactional(readOnly = true)
    public List<User> findAllUsers(List list) {
        List<User> result = repository.findAll();
        return result;
    }

    @Transactional
    public User addUser(User newUser) {
        if (repository.findByEmail(newUser.getEmail()) != null) {
            throw new HttpClientErrorException("O e-mail informado já existe no sistema");
        }
        String encodedPassword = this.passwordEncoder.encode(newUser.getPassword());
        newUser.setPassword(encodedPassword);
        return repository.saveAndFlush(newUser);
    }
    
    @Scheduled(cron = "0 00 13* * *")
      public void resetVotes() throws InterruptedException {
        
        List<User> userArray = repository.findAll();
        for(User user: userArray ) {
            user.setVoted(false);
        }
      }

}

用戶存盤庫.java

package com.dbserver.restaurantes.repositories;

import org.springframework.data.jpa.repository.JpaRepository;

import com.dbserver.restaurantes.entities.User;

public interface UserRepository extends JpaRepository<User, Long> {

    User findByEmail(String email);
}

用戶控制器.java

package com.dbserver.restaurantes.controllers;

import org.springframework.beans.factory.annotation.Autowired;
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.dbserver.restaurantes.entities.User;
import com.dbserver.restaurantes.services.UserServices;

@RestController
@RequestMapping(value = "/users")
public class UserController {

    @Autowired
    private UserServices service;

    @PostMapping
    public User addUser(@RequestBody User newUser) {
        return service.addUser(newUser);
    }

}

uj5u.com熱心網友回復：

我認為您需要在之后重新更新用戶串列setVoted(false)

@Scheduled(cron = "0 00 13* * *")
public void resetVotes() throws InterruptedException {
            
    List<User> userArray = repository.findAll();
    for(User user: userArray ) {
        user.setVoted(false);
    }

    repository.save(userArray);
} 

uj5u.com熱心網友回復：

您不需要從資料庫加載所有用戶。

您可以通過自定義查詢來更新資料。

   @Scheduled(cron = "0 00 13* * *")
    public void resetVotes() throws InterruptedException {
                
        repository.resetVotes();
    }

用戶存盤庫.java

package com.dbserver.restaurantes.repositories;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import com.dbserver.restaurantes.entities.User;

public interface UserRepository extends JpaRepository<User, Long> {

User findByEmail(String email);

//update custom query 
@Modifying
@Query("update User set voted=false ")
int resetVotes();

}

標籤：爪哇 春天 春季预定

上一篇：SpringMVC：使用屬性從POST重定向到GET

下一篇：JPA按ID查找物件