쿼리 SELECT to_char(current_timestamp,'yyyymmdd')||lpad(nextval('seq_test')::TEXT, 3, '0') INSERT INTO test( id, name ) VALUES ( #{id}, #{name} )서비스public String create(Map attach) { testMapper.create(attach); return attach.get("id").toString(); // Retrieve pre-generated ID}

SELECT LPAD(NEXTVAL('my_sequence')::TEXT, 5, '0') AS padded_value;

그냥 dual없이 select만 하면 됨SELECT CURRENT_TIMESTAMP;만약 오라클 쿼리처럼 사용하려면, 아래 처럼 테이블을 만들면 됨CREATE TABLE dual ( dummy CHAR(1));INSERT INTO dual VALUES ('X');

filePath 정보를 계속 변경해서 while문으로 존재여부를 확인하는게 중요@PostMapping("/upload")public ResponseEntity handleFileUpload(@RequestParam("file") MultipartFile file) throws IOException { // Define the directory where files will be saved String uploadDir = "uploads/"; // Ensure the directory exists Path uploadPath = Paths.get(uploadDir); if (!Files.exists(uploadPath)) { Files.createDirectorie..

작은 파일public Map upload(@RequestParam("file") MultipartFile file) { Path filePath = uploadPath.resolve(file.getOriginalFilename()); Files.write(filePath, file.getBytes());큰 파일public Map upload(@RequestParam("file") MultipartFile file) { Path filePath = uploadPath.resolve(newFilename); Files.copy(file.getInputStream(), filePath, StandardCopyOption.REPLACE_EXISTING);

application.ymlfile: upload-dir: /path/uploadsController@Value("${file.upload-dir}")private String uploadDir;