tomcatÁ´½Ó³ØÁ´½ÓMysqlÊý¾Ý¿âÖÐÎÄÂÒÂë½â¾ö°ì·¨
1¡¢Ê×ÏÈ×Ô¼ºÐ½¨µÄÊý¾Ý¿â±àÂë¸ñʽÉèΪUTF-8
2¡¢½«mysql-connector-java-5.1.6-bin¿½±´µ½tomcat\LibĿ¼Ï¡£
3¡¢ÐÞ¸ÄTomcat\conf\ϵÄcontext.xmlÎļþÄÚÈÝÈçÏ£º
<Context>
<WatchedResource>WEB-INF/web.xml</WatchedResource>
<Resource
name="jdbc/mysqlds"
type="javax.sql.DataSource“
driverClassName="com.mysql.jdbc.Driver"
password="abc" //ÄãÉèÖõĵǼÃÜÂë
maxIdle="30"
maxWait="5000"
username="root“ //Á¬½ÓÊý¾Ý¿âÃû×Ö
url="jdbc:mysql://localhost/my_bbs?characterEncoding=UTF-8"
maxActive="4100" />
</Context>
¡ùÕâÀï´ó¼ÒÒ»¶¨Òª×¢ÒâÕâ¶Î´úÂëµÄºÚÌå×Ö£º
url="jdbc:mysql://localhost/my_bbs?characterEncoding=UTF-8" >
Èç¹û²»¼ÓcharacterEncoding=UTF-8Õâ¾ä»°£¬tomcat»á½«Êý¾ÝÉèΪĬÈÏËüµÄµÄ±àÂë¸ñʽ£¬Ìí¼Óµ½MySqlÊý¾Ý¿âºó»¹ÊÇ»áÂÒÂ룬ºÜÖØÒª°¡¡£
4¡¢ÔÚÏîÄ¿ÖÐÉæ¼°µ½Êý¾Ý¿âµÄ¶Áдʱ£¬¼ÓÈëÕâ¾ä»°£ºrequest.setCharacterEncoding("UTF-8");
Ïà¹ØÎĵµ£º
MYSQL Ó¦ÓÃÊ®·Ö¹ã·¶£¬ºÜ¶àÍøÕ¾¼¸ºõ¶¼ÔÚÓÃËû£¬ÒòΪËûµÄСÇɺÍÁé»îÐԵȷ½ÃæÈÃÎÒ¾ö¶¨Òª¶ÔËû½øÐÐÑо¿£¬µ½ÏÖÔÚÒѾ³É¹¦µÄ²»Óþ¹ýODBC£¬ADOµÈ·½Ê½¾Í¿ÉÒÔ¶ÁÈ¡ºÍ¸üÐÂÊý¾Ý¡£
ºÃÁ˲»¶àÂÞ࣬ÒÔÏÂÎÒÀ´½éÉÜ×ܸö³ÌÐòµÄϸ½Ú:
£¨Ò»£©APIÉùÃ÷
1. '·ÖÅä»ò³õʼ»¯ÊʺÏmysql_real_connect()µÄÒ»¸öMYSQL¶ÔÏñ¡ ......
¸Õ¸Õ°²×°Íêmysqlºó
´ÓcmdÖнøÈëmysqlÊý¾Ý¿â
ÃüÁîÐÐÖÐÊäÈ룺
mysql -uroot -p123
½øÈëmysqlÊý¾Ý¿âÖÐ
ÃüÁîÐÐÖÐÊäÈë:
status;
²é¿´µ±Ç°Êý¾Ý¿âÖеıàÂë
ÈçÏ£º
--------------
mysql Ver 14.12 Distrib 5.1.7-beta, for Win32 (ia32)
Connection id: &nb ......
1. mysql Èë¿âÂÒÂëÎÊÌâ
½â¾ö°ì·¨
Ê×ÏÈ °²×°µÄʱºò±ØÐëÑ¡Ôñutf-8×Ö·û¼¯
Èç¹û²»ÊÇ¿ÉÒÔ½øÐÐÔÙ´ÎÅäÖûòÕßÉèÖÃÏà¹Ø±äÁ¿
£¨¿ÉÒÔÓà SHOW VARIABLES LIKE %CHARACTER%; ²é¿´ Óà set CHARACTER_** = UTF8£©
Æä´ÎÁ¬½ÓµÄʱºò Ö¸¶¨×Ö·û¼¯
jdbc:mysql://localhost/guestbooktes ......
×÷Õߣº°½Ê¿Î°
·þÎñÆ÷£ºIBM X346
CPU:Intel Xeon 3.0 *4
Äڴ棺2GB
Ó²ÅÌ£ºRAID5
OS£ºwin2003 SE
Ò»¡¢MySQL 5.5 M2
MySQL ĬÈÏÒýÇæInnoDB£¬ÓÅ»¯Ç°ºó¼¸ºõÎÞ²î±ð
¶þ¡¢SQL SERVER 2000 SE
´ÓÕâû´Î²âÊÔ¿´£¬MysqlÔÚÊÂÎñÐÔÄܱíÏÖ²»ÈçSQL SERVER¡£Í¬Ê±£¬Á½ÕßÔÚĬÈÏÇé¿ö£¬ÅúÁ¿Insert£¬Mysql±íÏ ......