Hibernate MySQL ÖÐÎÄÂÒÂëÎÊÌâ
Hibernate MySQL ÖÐÎÄÂÒÂëÎÊÌâ
»·¾³£ºHibernate 2.1.7 + MySQL4.1£¨MySQLµÄ±àÂëÒÑÉèÖÃΪutf8£©
ÎÊÌ⣺ͨ¹ýHibernateÏòMySQLдÈëÖÐÎĺó£¬Í¨¹ýHibernateÈ¡»ØÊý¾Ý£¬ÔÚconsoleÖдòÓ¡java¶ÔÏóÏÔʾÕý³£¡£µ«ÔÚMySQL Query BrowserÖп´µ½µÄÊÇÂÒÂ룬´«¸øÇ°¶ËµÄFlexÒ²ÊÇÂÒÂë¡£
ÔÒò£ºHibernateµÄ»ù´¡»¹ÊÇJDBC£¬ËùÒÔÒ»ÑùÐèÒªÉèÖÃcharacterEncoding£¡
½â¾ö·½·¨£º
ÔÚhibernate.cfg.xmlÖÐÓ¦¸ÃÕâÑùд
<property name="connection.url">jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8</property>
Èç¹ûÓÃhibernate.properties
#hibernate.connection.url jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8
ps£º´¦ÀíÖÐÎĵĻ°£¬characterEncodingÓÃGBKÒ»Ñù¿ÉÒÔ¡£
µ«×Ö½Ú±àÂëÎÊÌâ×îºÃµÄ½â¾ö·½·¨»¹ÊÇͳһʹÓÃUTF-8£¡£¡£¡
posted on 2005-06-10 21:35 °åÇÅ¾Ó ÔĶÁ(140) ÆÀÂÛ(0) ±à¼ ÊÕ²Ø
ÁíÍâÒ»¸öblog»¹ÓÐÏêϸµÄÈýÖÖ½â¾ö·½·¨£ºhttp://www.cnblogs.com/josson/
Hibernate+mysql ÖÐÎÄÎÊÌâ½â¾ö·½°¸.
1, mysql°²×°Ê±ÉèÖÃ×Ö·û¼¯utf-8, jdbcÇý¶¯3.0.15ÒÔÉÏ.
2. hibernateÅäÖÃÎļþÖÐ,¼ÓÉÏÊôÐÔ
<property name="connection.useUnicode">true</property>
<property name="connection.characterEncoding">UTF-8</property>
3. web.xmlÉèÖÃFilter
=================================================
<filter>
<filter-name>
Set Web Application Character Encoding
</filter-name>
<filter-class>cn.com.commnet.util.SetEncodeFilter</filter-class>
<init-param>
<param-name>defaultencoding</param-name>
<param-value>UTF-8</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>
Set Web Application Character Encoding
</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
=================
Ïà¹ØÎĵµ£º
Java´úÂë
mysql> select version(),current_date;
²éѯmysqlµÄ°æ±¾ºÅ ºÍ ÈÕÆÚ
mysql> select version();
²éѯmysqlµÄ°æ±¾ºÅ
select now();
²éѯµ±Ç°ÈÕÆÚºÍ׼ȷµÄʱ¼ä
Java ......
×÷ÕߣºÐûÕ×Åô
--------------------------------------------------------------------------------------------------------------------------------------------
½ñÌìÔÚ±¾±¾ÉÏ°²×°MYSQL£¬ÔÚ°²×°¹ý³Ì³öÏÖÁËһЩÆæ¹ÖµÄÎÊÌ⣬Òò´ËÔÚÕâÀï·ÖÏíÕû¸ö°²×°Á÷³ÌÓë´íÎó½â¾ö·½·¨¡£
MySQL°æ±¾£º5.1.40-community
1¡¢ÏÂÔØ°²×°°ü²¢° ......
Ò» UNIONÓï·¨
´úÂë ¸´ÖÆ´úÂë
SELECT ...
UNION [ALL | DISTINCT]
SELECT ...
[UNION [ALL | DISTINCT]
SELECT ...]
SELECT ... UNION [ALL | DISTINCT] SELECT ... [UNION [ALL | DISTINCT] SELECT ...]
UNIONÓÃÓÚ°Ñ ......
×÷ÕߣºÀÏÍõ
MySQL5.X¶¼ÒѾ·¢²¼ºÃ¾ÃÁË£¬µ«ÊÇ»¹ÓкܶàÈËÈÏΪMySQLÊDz»Ö§³ÖÊÂÎñ´¦ÀíµÄ£¬Õâ²»µÃ²»¹ÖËûÃÇÊǹª¹ÑÎŵģ¬Æäʵ£¬Ö»ÒªÄãµÄMySQL°æ±¾Ö§³ÖBDB»òInnoDB±íÀàÐÍ£¬ÄÇôÄãµÄMySQL¾Í¾ßÓÐÊÂÎñ´¦ÀíµÄÄÜÁ¦¡£ÕâÀïÃ棬ÓÖÒÔInnoDB±íÀàÐÍÓõÄ×î¶à£¬ËäÈ»ºóÀ´·¢ÉúÁËÖîÈçOracleÊÕ¹ºInnoDBµÈÁîMySQL²»Ë¬µÄÊÂÇ飬µ«ÄÇЩÉÌÒµÉϵĶ·ÕùÓ ......
ĬÈÏÇé¿öÏ£¬innodbµÄ²ÎÊýÉèÖõķdz£Ð¡£¬ÔÚÉú²ú»·¾³ÖÐÔ¶Ô¶²»¹»ÓÃ
±ÈÈç×îÖØÒªµÄÁ½¸ö²ÎÊý
innodb_buffer_pool_size
ĬÈÏÊÇ8M
innodb_flush_logs_at_trx_commit ĬÈÏÉèÖõÄÊÇ1 Ò²¾ÍÊÇͬ²½Ë¢ÐÂlog(¿ÉÒÔÕâôÀí½â)
innodb_buffer_pool_size£º
ÕâÊÇInnoDB×îÖØÒªµÄÉèÖ㬶ÔInnoDBÐÔÄÜÓоö¶¨ÐÔµÄÓ°Ï졣ĬÈϵÄÉèÖÃÖ»ÓÐ8M£¬ËùÒÔ ......