Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Hibernate²åÈëmysqlÊý¾Ý¿âÖÐÎÄÂÒÂë½â¾ö


ʹÓÃant¹¤¾ß±àÒë³ÌÐò£¬ÔËÐгÌÐò.ÃüÁî:ant -f xxx.xmlÖ¸¶¨Éú³ÉÎļþ£»ant run±àÒë²¢ÔËÐÐÎļþ¡£
Èç¹ûHibernate½«ÖÐÎIJåÈëmysqlÊý¾Ý¿â£¬µ÷ÓÃselectÓï¾äÖÐÎÄÏÔʾÂÒÂ룬ÔòmysqlµÄ±àÂ뷽ʽÉèΪgbk£¬×¢ÒâÕâÀïÊÇСд£¬²»ÓÃÖØа²×°mysqlÊý¾Ý¿â£¬½«MySQL Server 5.1Ŀ¼ÏµÄmy.iniÅäÖÃÎļþÀïµÄËùÓÐdefault-character-setÉèΪgbk£¬×¢ÒâСд£¬¼´¿É¡£
ͬʱ×Ô¼º´´½¨hibernateÊý¾Ý¿âʱҪÉ趨Êý¾Ý¿âµÄĬÈϱàÂ뷽ʽ£º
create database hibernate default charset=gbk;
ÕâÑùÈÔ²»ÐУ¬¿¼ÂÇÉ趨hibernateÊý¾Ý¿âÖбíµÄĬÈϱàÂ뷽ʽ¡££¨ºÜÖØÒª£©ÁíÍ⣬ÔÚjavaÔ´´úÂëÖÐn.setTitle("ÄãºÃÂð");֮ǰҲ¿ÉÌí¼ÓתÂëÓï¾ä£¬¸ù¾ÝÇé¿ö¶ø¶¨£¬ÕâÀï¿ÉÓпÉÎÞ¡£
String na="";
    try{
        na="·è¿ñÁªÃ˳ÉÁ¢ÁË";
        byte bb[]=na.getBytes("GBK");
        na=new String(bb);
       }catch(UnsupportedEncodingException ex){
       throw new RuntimeException("unsupported encoding type.");
     }
È»ºóÔÚhibernate.cfg.xmlÊôÐÔÎļþÀïÌí¼Ó
<property name="connection.useUnicode">true</property>
  <property name="connection.characterEncoding">UTF-8</property>
ÖÐÎÄÂÒÂëÎÊÌâ½â¾ö£¬Ò»ÇÐOK¡£
ÕâÀïUTF-8Ò²¿ÉΪGB2312£¬GBK¡£
×¢ÒâÒªÌí¼Óimport java.io.*;


Ïà¹ØÎĵµ£º

¹ØÓÚMySQLµÄ²éѯ»º´æ

Ô­Àí
QueryCache(ÏÂÃæ¼ò³ÆQC)ÊǸù¾ÝSQLÓï¾äÀ´cacheµÄ¡£Ò»¸öSQL²éѯÈç¹ûÒÔselect¿ªÍ·£¬ÄÇôMySQL·þÎñÆ÷½«³¢ÊÔ¶ÔÆäʹÓÃ
QC¡£Ã¿¸öCache¶¼ÊÇÒÔSQLÎı¾×÷ΪkeyÀ´´æµÄ¡£ÔÚÓ¦ÓÃQC֮ǰ£¬SQLÎı¾²»»á±»×÷Èκδ¦Àí¡£Ò²¾ÍÊÇ˵£¬Á½¸öSQLÓï¾ä£¬Ö»ÒªÏà²îÄÄÅÂÊÇÒ»¸ö×Ö·û£¨ÀýÈç´óСд²»Ò»Ñù£»¶àÒ»¸ö¿Õ¸ñµÈ£©£¬ÄÇôÕâÁ½¸öSQL½«Ê¹Óò»Í¬µÄÒ» ......

MySQL´´Ê¼ÈË·¢ÓʼþÑ°ÇóÖйú°ïÖú!

Ç×°®µÄÕü¾ÈMySQLµÄÖйúÇ©ÃûÖ§³ÖÕß:
    Å·ÃË¿ÉÄÜÎÞ·¨Õü¾ÈMySQL, ÖйúºÍ¶íÂÞ˹¿ÉÄÜÊÇÕü¾ÈMySQLµÄÏ£ÍûÖ®ËùÔÚ¡£ÖйúÓµÓÐÇ¿´ó¡¢¶ÀÁ¢ÒÔ¼°×ÔÐŵķ´Â¢¶ÏÖ÷¹Ü»ú¹Ø£¬Òò´Ë£¬ÎÒ±¾ÈËÔÚ´ËÇëÇóÄúµÄ°ïÖú¡£¶ÔÓÚÄúÔÚ http://helpmysql.org/cn/petition
µÄÇ©Ãû£¬ÎÒÃÇÉî±í¸Ðл¡£Èç¹û¿ÉÒԵĻ°£¬ÎÒÃÇÐèÒªÄúµÄ½øÒ»²½°ïÖú£º
&nb ......

mysqlÖеÄÕýÔò±í´ïʽËÑË÷

Óï·¨£º
select * from table_name where column_name regexp 'ÕýÔò±í´ïʽ'
»òÇø·Ö´óСд
select * from table_name where column_name regexp binary 'ÕýÔò±í´ïʽ'
Ö§³ÖµÄÕýÔò±í´ïʽ·ûºÅ£º
.    ÈÎÒâ×Ö·û
|    »ò£¬È磺a|b|c
[]   ·¶Î§£¬±ÈÈ磺[a-z],[0-9],[^0-9]²»°ü ......

mysqlÖбàÂëµÄÉèÖÃ

1.ÐÞ¸ÄmysqlµÄĬÈϱàÂëΪgbk£ºÐÞ¸Ämy.initÎļþÖеģº[client]ºÍ[mysqld]ϵÄdefault-character-set=gbk£»
2.²é¿´mysqlÊý¾Ý¿âµÄ±àÂ룺show variable like 'character%';»òstatus
3.²é¿´Êý¾Ý¿â±íµÄ±àÂ룺show create table ±íÃû£»
4.ÐÞ¸ÄÊý¾Ý¿âµÄ±àÂ룺ALTER DATABASE `database_name` DEFAULT CHARACTER SET gbk COLLATE ......

MYSQLÍâ¼ü(Foreign Key)µÄʹÓÃ

ÔÚMySQL 3.23.44°æ±¾ºó£¬InnoDBÒýÇæÀàÐ͵ıíÖ§³ÖÁËÍâ¼üÔ¼Êø¡£
Íâ¼üµÄʹÓÃÌõ¼þ£º
1.Á½¸ö±í±ØÐëÊÇInnoDB±í£¬MyISAM±íÔÝʱ²»Ö§³ÖÍâ¼ü£¨¾Ý˵ÒÔºóµÄ°æ±¾ÓпÉÄÜÖ§³Ö£¬µ«ÖÁÉÙÄ¿Ç°²»Ö§³Ö£©£»
2.Íâ¼üÁбØÐ뽨Á¢ÁËË÷Òý£¬MySQL 4.1.2ÒÔºóµÄ°æ±¾ÔÚ½¨Á¢Íâ¼üʱ»á×Ô¶¯´´½¨Ë÷Òý£¬µ«Èç¹ûÔÚ½ÏÔçµÄ°æ±¾ÔòÐèÒªÏÔʾ½¨Á¢£»
3.Íâ¼ü¹ØϵµÄÁ½¸ö± ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ