java - 在查询注释中更新时间戳字段 Spring JPA

Question

在使用@Query 注释更新卡住状态时，如何将 FROZEN_DATE 设置为当前时间。如果我更新 frozen 以外的字段，frozen_state 将不会更新。

@Repository
public interface UserEntryRepository extends CrudRepository <UserEntry, String> {

   UserEntry findByUsername(String username);

   @Transactional
   @Modifying
   @Query("UPDATE UserEntry o SET o.frozen = 1 WHERE o.username = :username")
   int setFrozenForOfuser(@Param("username") String username);

}

实体:

@Entity
@Table(name = "OFUSER", schema = "TIMS")
public class UserEntry implements Serializable {

   private static final long serialVersionUID = 546720609517412501L;

   @Id
   @Column(name = "USERNAME", nullable = false)
   private String username;

   @Column(name = "FROZEN")
   private Integer frozen;

   @Column(name = "FROZEN_DATE")
   private Date frozendate;


}

Answer 1

您可以像这样使用 CURRENT_DATE:

UPDATE UserEntry o SET o.frozen = 1, o.frozen = CURRENT_DATE WHERE o.username = :username