首先,确定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&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&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>
以上是我的解决方案。