메모장

public static String doubleToString(double d) { if (d == (long) d) { return String.format("%d", (long) d); } else { return String.format("%s", d); } }

// 생성되는 시점에 수행 @PrePersist public void preInit() { this.createdDate = LocalDateTime.now(); this.modifiedDate = LocalDateTime.now(); } // 업데이트 되는 시점에 수행 @PreUpdate public void preUpdate() { this.modifiedDate = LocalDateTime.now(); }

Contorller@GetMapping("/{infoSeq}")@ApiOperation("엑셀 다운로드")public void getInfoExcel(HttpServletResponse response, @PathVariable Long infoSeq) throws IOException { Workbook workbook = infoService.getInfoExcel(infoSeq); try { response.setContentType("application/vnd.ms-excel; charset=utf-8"); response.setHeader("Content-Disposition", "attachment; filename=\"info.xlsx\""); ..

Entity@Getter@Entity@NoArgsConstructor(access = AccessLevel.PROTECTED)@AllArgsConstructor@Table(name = "info")public class Info { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) @Column(name = "info_seq", length = 11) private Integer infoSeq; @Column(name = "a") private String a; @Column(name = "b") private String b; @Column(name = "c") private String c; ..

@Transactional(propagation = Propagation.REQUIRES_NEW)

delete();insert();이렇게 코드를 작성해도 쿼리는 insert -> delete 순으로 동작된다.delete();flush();insert(); delete(); 다음에 flush();를 사용하여 delete 쿼리가 먼저 동작하도록 한다.