使用Hibernate和Mysql中文乱码问题解决

首先，确定Mysql用的是utf-8字符集，如果不是可以在Mysql的congfig wizard里配置，或者使用Mysql命令（下篇文章介绍，呵呵）

其次，页面charset=utf-8

最后，hibernate.cfg.xml文件中使用utf-8

问题解决。

 

hibernate.cfg.xml

 

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration
    PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN"
    "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>

<session-factory>

 <property name="hibernate.connection.driver_class">
  com.mysql.jdbc.Driver
 </property>

 <property name="hibernate.connection.url">
  jdbc:mysql://localhost:3306/blog?useUnicode=true&amp;characterEncoding=UTF-8
 </property>

 <property name="hibernate.connection.username">root</property>

 <property name="hibernate.connection.password">leekey</property>

 <property name="hibernate.connection.pool_size">100</property>

 <property name="show_sql">false</property>

 <!-- Mapping files -->
 <property name="myeclipse.connection.profile">123</property>
 <property name="connection.url">jdbc:mysql://localhost:3306/blog?useUnicode=true&amp;characterEncoding=UTF-8
 </property>
 <property name="connection.username">root</property>
 <property name="connection.password">leekey</property>
 
 <property name="dialect">org.hibernate.dialect.MySQLDialect</property>
 <mapping resource="model.hbm.xml" />

</session-factory>

</hibernate-configuration>

 

 

model.hbm.xml

 

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
      "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
          "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping package="cn.com.blogonline">

    <class name="com.cyl.Blog"
            table="blog"
            discriminator-value="C">
               
        <id name="id">
             <generator class="increment"/>
        </id>

        <property name="username"/>
        <property name="password"/>
        <property name="subject"/>
        <property name="email"/>
        <property name="image"/>
        <property name="visitcount"/>
 </class>
 
    <class name="com.cyl.Sort"
            table="sort"
            discriminator-value="C">
               
         <id name="id">
                 <generator class="increment"/>
         </id>

        <property name="name"/>
        <property name="blogid"/>
 </class>
 
    <class name="com.cyl.Article"
            table="article"
            discriminator-value="C">
               
        <id name="id">
             <generator class="increment"/>
        </id>

        <property name="title"/>
        <property name="content"/>
        <property name="pubtime"/>
        <property name="blogid"/>
        <property name="sortid"/>
 </class>
 
    <class name="com.cyl.FeedBack"
            table="feedback"
            discriminator-value="C">
               
        <id name="id">
             <generator class="increment"/>
        </id>

        <property name="uname"/>
        <property name="content"/>
        <property name="pubtime"/>
        <property name="articleid"/>
 </class>
 
    <class name="com.cyl.Links"
            table="links"
            discriminator-value="C">
               
         <id name="id">
                 <generator class="increment"/>
         </id>

        <property name="name"/>
        <property name="url"/>
        <property name="blogid"/>
 </class>
 
 
</hibernate-mapping>

以上是我的解决方案。