Java EE + Spring + Hibernate 无法将UTF-8字符保存到MySQL数据库中。

Question

这个问题可能会被标记为重复，但是StackOverflow的回答都没有帮到我。 我正在使用Java EE、Spring和Hibernate等技术制作一个网站，但与此相关的只有这些技术。 这个网站是一个网络商店，管理员应该能够添加产品、它的名称、价格、制造商等等... 一切都运作正常，除了不能保存UTF-8字符到数据库中。 问题不在于数据库，它已经被设置成utf-8，在phpmyadmin里也可以将字符改为期望的格式，并且它会正确地显示。

以下是相关的产品添加代码... 管理产品

@Controller
@RequestMapping("/admin")
public class AdminProduct {

    private Path path;

    @Autowired
    ProductService productService;



    @RequestMapping("/product/addProduct")
    public String addProduct(Model model) {

        Product product = new Product();
        product.setProductCategory("toys");
        product.setProductStatus("available");

        model.addAttribute("product", product);

        return "addProduct";


    }



    @RequestMapping(value = "/product/addProduct", method = RequestMethod.POST)
    public String addProductPost(@Valid @ModelAttribute("product") Product product, BindingResult result, HttpServletRequest request) throws UnsupportedEncodingException {
        request.setCharacterEncoding("UTF-8");
        if(result.hasErrors()) {
            return "addProduct";
        }

        productService.addProduct(product);

        MultipartFile productImage = product.getProductImage();
        String rootDirectory = request.getSession().getServletContext().getRealPath("/");

        path = Paths.get(rootDirectory + "\\WEB-INF\\resources\\images\\" + product.getProductId() + ".png");

        if(productImage != null && !productImage.isEmpty()) {
            try {
                productImage.transferTo(new File(path.toString()));
            } catch(Exception e) {
                throw new RuntimeException("Product image saving failed!");
            }
        }

        return "redirect:/admin/productInventory";
    }

产品Dao实现

 @Repository
    @Transactional
    public class ProductDaoImpl implements ProductDao {

        @Autowired
        private SessionFactory sessionFactory;

    public Product getProductById(int id) {
        Session session = sessionFactory.getCurrentSession();
        Product product = (Product) session.get(Product.class, id);
        session.flush();

        return product;
    }

    public List<Product> getProductList() {
        Session session = sessionFactory.getCurrentSession();
        Query query = session.createQuery("from Product");
        List<Product> productList = query.list();
        session.flush();
        return productList;
    }

        public void  addProduct(Product product) {
            Session session = sessionFactory.getCurrentSession();
           session.saveOrUpdate(product);
            session.flush();

        }

        public void  editProduct(Product product) {
            Session session = sessionFactory.getCurrentSession();
            session.saveOrUpdate(product);
            session.flush();

        }

        public void  deleteProduct(Product product) {
            Session session = sessionFactory.getCurrentSession();
            session.delete(product);
            session.flush();

    }

产品型号

@Entity
public class Product implements Serializable {


    private static final long serialVersionUID = -509245862136222627L;

    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    private int productId;

    @NotEmpty (message = "Ime proizvoda ne moze biti prazno!")
    private String productName;

    private String productCategory;
    private String productDescription;

    @Min(value=0, message = "Cena proizvoda ne moze biti manja od nule!")
    private double productPrice;

    private String productCondition;
    private String productStatus;

    @Min(value=0, message = "Broj na lageru ne moze biti manji od nule!")
    private int unitInStock;

    private String productManufacturer;

    @Transient
    private MultipartFile productImage;

    @OneToMany(mappedBy = "product", cascade = CascadeType.ALL, fetch = FetchType.EAGER)
    @JsonIgnore
    private List<CartItem> cartItemList;

    public int getProductId() {
        return productId;
    }

    public void setProductId(int productId) {
        this.productId = productId;
    }

    public String getProductName() {
        return productName;
    }

    public void setProductName(String productName) {
        this.productName = productName;
    }

    public String getProductCategory() {
        return productCategory;
    }

    public void setProductCategory(String productCategory) {
        this.productCategory = productCategory;
    }

    public String getProductDescription() {
        return productDescription;
    }

    public void setProductDescription(String productDescription) {
        this.productDescription = productDescription;
    }

    public double getProductPrice() {
        return productPrice;
    }

    public void setProductPrice(double productPrice) {
        this.productPrice = productPrice;
    }

    public String getProductCondition() {
        return productCondition;
    }

    public void setProductCondition(String productCondition) {
        this.productCondition = productCondition;
    }

    public String getProductStatus() {
        return productStatus;
    }

    public void setProductStatus(String productStatus) {
        this.productStatus = productStatus;
    }

    public int getUnitInStock() {
        return unitInStock;
    }

    public void setUnitInStock(int unitInStock) {
        this.unitInStock = unitInStock;
    }

    public String getProductManufacturer() {
        return productManufacturer;
    }

    public void setProductManufacturer(String productManufacturer) {
        this.productManufacturer = productManufacturer;
    }

    public MultipartFile getProductImage() {
        return productImage;
    }

    public void setProductImage(MultipartFile productImage) {
        this.productImage = productImage;
    }

    public List<CartItem> getCartItemList() {
        return cartItemList;
    }

    public void setCartItemList(List<CartItem> cartItemList) {
        this.cartItemList = cartItemList;
    }
}

最后是addProduct jsp页面

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>

    <%@ page contentType="text/html;charset=UTF-8" language="java" %>
    <html>
    <%@page pageEncoding="UTF-8"%>
    <%@taglib prefix="form" uri="http://www.springframework.org/tags/form" %>
    <%@include file="/WEB-INF/views/template/header.jsp" %>

    <div class="container-wrapper">
        <div class="container">

            <div class="page-header">
                <h1>Dodaj Proizvod</h1>
        <p class="lead">Popunite informacije dole kako biste dodali proizvod:</p>

            </div>

            <form:form action="${pageContext.request.contextPath}/admin/product/addProduct" method="post" commandName="product" enctype="multipart/form-data" acceptCharset="UTF-8">

                <div class="form-group">
                    <label for="name">Ime</label> <form:errors path="productName" cssStyle="color:red"/>
                    <form:input path="productName" id="name" class="form-Control" acceptCharset="UTF-8"/>
                </div>
     <%--Category --%>
            <div class="form-group">
            <label for="category">Kategorija</label>
            <label class="checkbox-inline"><form:radiobutton  acceptCharset="UTF-8" path="productCategory" id="category" value="Školski/Kancelarijski pribor"/> Školski/Kancelarijski pribor</label>
            <label class="checkbox-inline"><form:radiobutton  acceptCharset="UTF-8" path="productCategory" id="category" value="Pokloni"/> Pokloni</label>
            <label class="checkbox-inline"><form:radiobutton  acceptCharset="UTF-8" path="productCategory" id="category" value="Igračke"/> Igračke</label>
            </div>

     <%--Description --%>
            <div class="form-group">
                <label for="description">Opis</label>
                <form:textarea path="productDescription" id="description" class="form-Control" acceptCharset="UTF-8"/>
            </div>
    <%--Price --%>
            <div class="form-group">
                <label for="price">Cena</label> <form:errors path="productPrice" cssStyle="color:red"/>
                <form:input path="productPrice" id="price" class="form-Control"/>
            </div>

    <%--Status --%>
            <div class="form-group">
                <label for="status">Status</label>
                <label class="checkbox-inline"><form:radiobutton path="productStatus" id="status" value="Dostupno"/> Dostupno</label>
                <label class="checkbox-inline"><form:radiobutton path="productStatus" id="status" value="Nedostupno"/> Nedostupno</label>

            </div>

                <%--Manufacturer --%>
            <div class="form-group">
                <label for="productManufacturer">Proizvođač</label>
                <form:input path="productManufacturer" id="manufacturer" class="form-Control" acceptCharset="UTF-8"/>
            </div>

            <div class="form-group">
                <label class="control-label" for="productImage">Odaberi sliku</label>
                <form:input id="productImage" path="productImage" type="file" class="form:input-large"/>
            </div>

            <br><br>

            <input type="submit" value="Dodaj" class="btn btn-default">
            <a href="<c:url value="/admin/productInventory"/>" class="btn btn-default">Odustani</a>
        </form:form>

    <%@include file="/WEB-INF/views/template/footer.jsp" %>

- David Misic

---

你尝试过调试控制器查看数值吗？也许表单请求中的编码已经出错了。 - smsnheck

我尝试了一下，控制器也打印出了错误的值... - David Misic

在HTML标签中删除<%@page pageEncoding="UTF-8"%>。 - Ye Win

如果删除不可行，请在您的Spring配置中设置UTF-8编码过滤器。 - Ye Win

发生了什么？有时“垃圾”可以成为出错的线索。请参见https://dev59.com/WFoT5IYBdhLWcg3wnQn9 - Rick James

Answer 1

当指定数据驱动程序时，您可以在Hibernate XML文件中设置以下内容：

jdbc:mysql://localhost/mydatabase?useUnicode=true&characterEncoding=UTF-8

- KayV

---

我已经有了: <property name="url" value="jdbc:mysql://localhost:3306/calypso?useUnicode=true&characterEncoding=UTF-8" />然而，它没有改变任何东西... - David Misic

没有错误，它只是不能保存UTF-8，并用不正确的字符替换它。 - David Misic

@DavidMisic - 请粘贴一些“不正确的字符”示例；这可以帮助确定问题所在，如 https://dev59.com/WFoT5IYBdhLWcg3wnQn9 所示。 - Rick James

无内容提供。请提供需要翻译的具体内容。 - David Misic

Answer 2

请尝试以下步骤：

1. Put the UTF-8 encoding filter in your web.xml (the filter must be first filter)

    <filter>
        <filter-name>encoding-filter</filter-name>
        <filter-class>
            org.springframework.web.filter.CharacterEncodingFilter
        </filter-class>
        <init-param>
           <param-name>encoding</param-name>
           <param-value>UTF-8</param-value>
        </init-param>
        <init-param>
           <param-name>forceEncoding</param-name>
           <param-value>true</param-value>
        </init-param>
     </filter>
   
    <filter-mapping>
         <filter-name>encoding-filter</filter-name>
         <url-pattern>/*</url-pattern>
    </filter-mapping>
   

2. If you use Maven, add below to your pom.xml

     <properties>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
         ...
      </properties>
   

3. If you use tomcat, add URIEncoding="UTF-8" to your server.xml like this

   <Connector port="8080" protocol="HTTP/1.1" connectionTimeout="20000"  redirectPort="8443"  URIEncoding="UTF-8" />
   

- Sai Ye Yan Naing Aye

---

是的，我同时使用Maven和Tomcat，但我不知道Tomcat的server.xml在哪里... - David Misic

在你的<<TOMCAT_HOME>>\conf目录下 - Sai Ye Yan Naing Aye

改了所有的东西，问题还是一样出现 :( - David Misic

是的，已经重启了Tomcat和其他所有东西，但仍然出现相同的问题 :( - David Misic

我认为应用程序方面已经处理了UTF-8的事情，你已经配置了web.xml、maven、tomcat、特定的jsp页面，在连接字符串中添加了utf-8。所以只需要检查你的数据库。我知道整个模式都是utf-8的，但需要逐个表级别进行检查。检查所有表是否都是utf-8。 - Sai Ye Yan Naing Aye

过滤器中有一个错别字，我要自杀了。 现在它可以工作了，非常感谢！！！ - David Misic

Answer 3

可能是拼写错误？

• HTML 有 accept-charset 属性
• JavaScript 有 acceptCharset 属性

参考资料：https://msdn.microsoft.com/en-us/library/ms533061

- Rick James