如何使用spring boot JPA在mysql中存储html文件？

Question

我想在MySQL数据库中存储一个HTML文件，这样对于每个用户，我都可以用他们的名字和电子邮件id从数据库中更改HTML标记，并替换那个HTML文件并呈现它？

另外，我需要在数据库中存储主示例HTML文件。 请帮帮我。

Answer 1

我假设您将发送html文件作为表单数据。 下面是您可以使用的代码

实体

    @Id
    @GeneratedValue(generator = "uuid")
    @GenericGenerator(name = "uuid", strategy = "uuid2")
    private String id;

    private String fileName;

    private String fileType;

    @Lob
    private byte[] data;

控制器

public class FileHandlingController 
{
    @Autowired
    FileHandlingService fileHandlingSgervice;
    
    @PostMapping(value = "/upload")
    @ResponseStatus(HttpStatus.ACCEPTED)
    public FileInformation uploadDoc(@RequestParam("file") MultipartFile file) throws Exception
    {
        return fileHandlingSgervice.uploadDoc(file);
    }

    @GetMapping("/download/{fileId}")
    public ResponseEntity<Resource> downloadFile(@PathVariable String fileId) throws Exception 
    {
        return fileHandlingSgervice.downloadFile(fileId);
    }
}

服务

public class FileHandlingService 
{
    @Autowired
    DBFileStorageService dbFileStorageService;
    
    public FileInformation uploadDoc(MultipartFile file) throws Exception 
    {
        try
        {
            FileInformation fileUploadSuccessData = new FileInformation();
            DBFile dbFile = dbFileStorageService.storeFile(file);
            fileUploadSuccessData.setFileUUId(dbFile.getId());
            fileUploadSuccessData.setFileName(dbFile.getFileName());
            return fileUploadSuccessData;
        }
        catch(MaxUploadSizeExceededException e)
        {
            throw new Exception("File size too large. Max allowed size - 15 MB");
        }
        catch(Exception e)
        {
            throw new Exception("Error uploading file.");
        }
    }

    public ResponseEntity<Resource> downloadFile(String fileId) throws Exception 
    {
        try
        {
            DBFile dbFile = dbFileStorageService.getFile(fileId);
            return ResponseEntity.ok()
                .contentType(MediaType.parseMediaType(dbFile.getFileType()))
                .header(HttpHeaders.CONTENT_DISPOSITION, "attachment; filename=\"" + dbFile.getFileName() + "\"")
                .body(new ByteArrayResource(dbFile.getData()));
        }   
        catch(Exception e)
        {
            throw new Exception("Error downloading file");
        }
    }

}