MultipartFile / Blob问题保存在数据库中

Z时代
2024-01-10
分类：问答

嗨，我想上传图片并将其存储在数据库中，我使用Spring MVC和Hibernate

这是模特

import java.sql.Blob;
import java.util.Date;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.Lob;
import javax.persistence.Table;
@Entity
@Table(name = "article")
public class Article {
@Id
@GeneratedValue
@Column(name = "article_id")
private Long articleId;
@Column(name = "article_name", nullable = false, length=20)
private String articleName;
@Column(name = "article_desc", nullable = false)
private String articleDesc;
@Column(name = "date_added")
private Date addedDate;
 @Lob
    private Blob content;
public Article() {      
}
public Long getArticleId() {
    return articleId;
}
public void setArticleId(Long articleId) {
    this.articleId = articleId;
}
public String getArticleName() {
    return articleName;
}
public void setArticleName(String articleName) {
    this.articleName = articleName;
}
public String getArticleDesc() {
    return articleDesc;
}
public void setArticleDesc(String articleDesc) {
    this.articleDesc = articleDesc;
}
public Date getAddedDate() {
    return addedDate;
}
public void setAddedDate(Date addedDate) {
    this.addedDate = addedDate;
}
public String toString(){
    return this.articleName;
}
public void setContent(Blob content) {
    this.content = content;
}
public Blob getContent() {
    return content;
}

}

这是控制器（保存文章的方法）

  @RequestMapping(value = "/save", method = RequestMethod.POST)
public String save(
        @ModelAttribute("article") Article article,
        @RequestParam("file") MultipartFile file) {
    try {
        Blob blob = Hibernate.createBlob(file.getInputStream());
        article.setContent(blob);
    } catch (IOException e) {
        e.printStackTrace();
    }
    try {
         articleService.addArticle( article);
    } catch(Exception e) {
        e.printStackTrace();
    }
    return "redirect:/articles.html";
}

当我想用JSP表单保存新文章时出现此错误

33266

[http-8080-2]调试org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerExceptionResolver-

解决处理程序[net.roseindia.controller.ArticleController@10e8647]中的异常：org.springframework.beans.ConversionNotSupportedException：无法转换将’java.lang.String’类型的值更改为所需的’org.springframework.web.multipart.MultipartFile’类型的值；嵌套异常是java.lang.IllegalStateException：

类型[ ]的值为所需的类型[

]：找不到匹配的编辑器或转换策略33270

[http-8080-2]调试org.springframework.web.servlet.mvc.annotation.ResponseStatusExceptionResolver-

解决处理程序[net.roseindia.controller.ArticleController@10e8647]的异常：组织。

springframework.beans.ConversionNotSupportedException：无法将类型“

java.lang.String”的值转换为所需的类型“

org.springframework.web.multipart.MultipartFile”；嵌套异常为java.lang.IllegalStateException：无法将[java.lang.String]类型的值转换为所需的[org.springframework.web.multipart.MultipartFile]类型：找不到匹配的编辑器或转换策略33270

[http-8080-2

]调试org.springframework.web.servlet.mvc.support.DefaultHandlerExceptionResolver-

解决处理程序[net.roseindia.controller.ArticleController@10e8647]中的异常：组织。springframework.beans.ConversionNotSupportedException：无法将类型“

java.lang.String”的值转换为所需的类型“

有谁能够帮助我