Resolve hibernate+mysql to write to the database

  • 2020-05-09 19:24:06
  • OfStack

hibernate.cfg.xml plus attributes.
< property name="connection.useUnicode" > true < /property >
< property name="connection.characterEncoding" > UTF-8 < /property >
The mysql driver USES version 3.0.15 or above,
Add an Filter, use the UTF-8 character set,
If you use Spring, write it in sessionFactory in spring.
Such as:
< ?xml version='1.0' encoding='UTF-8'? >
< !DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd" >
< !-- Generated by MyEclipse Hibernate Tools. -- >
< hibernate-configuration >
< session-factory >
< property name="connection.username" > root < /property >
< property name="connection.url" >
jdbc:mysql://localhost:3306/hibernate_table
< /property >
< property name="dialect" >
org.hibernate.dialect.MySQLDialect
< /property >
< property name="myeclipse.connection.profile" >
mySql hibernatetable
< /property >
< property name="connection.password" > 12345678 < /property >
< property name="connection.driver_class" >
com.mysql.jdbc.Driver
< /property >
< property name="connection.useUnicode" > true < /property >
< property name="connection.characterEncoding" > UTF-8 < /property >
< property name="show_sql" > true < /property >
< property name="format_sql" > true < /property >
< mapping resource="cn/com/hibernate/Demo/Guestbook.hbm.xml" / >
< mapping resource="cn/com/hibernate/Demo/GMapping.hbm.xml" / >

Related articles: