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

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");


Ïà¹ØÎĵµ£º

VB6.0ÈçºÎÓà libmySQL.dll API·ÃÎÊMYSQLÊý¾Ý¿â

MYSQL Ó¦ÓÃÊ®·Ö¹ã·¶£¬ºÜ¶àÍøÕ¾¼¸ºõ¶¼ÔÚÓÃËû£¬ÒòΪËûµÄСÇɺÍÁé»îÐԵȷ½ÃæÈÃÎÒ¾ö¶¨Òª¶ÔËû½øÐÐÑо¿£¬µ½ÏÖÔÚÒѾ­³É¹¦µÄ²»Óþ­¹ýODBC£¬ADOµÈ·½Ê½¾Í¿ÉÒÔ¶ÁÈ¡ºÍ¸üÐÂÊý¾Ý¡£
 
ºÃÁ˲»¶àÂÞ࣬ÒÔÏÂÎÒÀ´½éÉÜ×ܸö³ÌÐòµÄϸ½Ú:
 
£¨Ò»£©APIÉùÃ÷
 
1.  '·ÖÅä»ò³õʼ»¯ÊʺÏmysql_real_connect()µÄÒ»¸öMYSQL¶ÔÏñ¡ ......

¸ü¸ÄmysqlÊý¾Ý¿â±àÂëΪGBK

¸Õ¸Õ°²×°Íêmysqlºó
´ÓcmdÖнøÈëmysqlÊý¾Ý¿â
ÃüÁîÐÐÖÐÊäÈ룺
mysql -uroot -p123
½øÈëmysqlÊý¾Ý¿âÖÐ
ÃüÁîÐÐÖÐÊäÈë:
status;
²é¿´µ±Ç°Êý¾Ý¿âÖеıàÂë
ÈçÏ£º
--------------
mysql  Ver 14.12 Distrib 5.1.7-beta, for Win32 (ia32)
Connection id:       &nb ......

ÈçºÎ½â¾ömysqlÖÐÎÄÈë¿âÂÒÂëÎÊÌâ

1. mysql Èë¿âÂÒÂëÎÊÌâ
  ½â¾ö°ì·¨
  Ê×ÏÈ °²×°µÄʱºò±ØÐëÑ¡Ôñutf-8×Ö·û¼¯
  Èç¹û²»ÊÇ¿ÉÒÔ½øÐÐÔÙ´ÎÅäÖûòÕßÉèÖÃÏà¹Ø±äÁ¿
  £¨¿ÉÒÔÓà SHOW VARIABLES LIKE %CHARACTER%; ²é¿´ Óà set  CHARACTER_** = UTF8£©
  Æä´ÎÁ¬½ÓµÄʱºò Ö¸¶¨×Ö·û¼¯
  jdbc:mysql://localhost/guestbooktes ......

¹ØÓÚMySQLÊý¾Ý¿âµÄ´æ´¢ÒýÇæ

MySQLÖеÄÊý¾ÝÓø÷ÖÖ²»Í¬µÄ¼¼Êõ´æ´¢ÔÚÎļþ(»òÕßÄÚ´æ)ÖС£ÕâЩ¼¼ÊõÖеÄÿһÖÖ¼¼Êõ¶¼Ê¹Óò»Í¬µÄ´æ´¢»úÖÆ¡¢Ë÷Òý¼¼ÇÉ¡¢Ëø¶¨Ë®Æ½²¢ÇÒ×îÖÕÌṩ¹ã·ºµÄ²»Í¬µÄ¹¦ÄܺÍÄÜÁ¦¡£Í¨¹ýÑ¡Ôñ²»Í¬µÄ¼¼Êõ£¬ÄãÄܹ»»ñµÃ¶îÍâµÄËÙ¶È»òÕß¹¦ÄÜ£¬´Ó¶ø¸ÄÉÆÄãµÄÓ¦ÓõÄÕûÌ幦ÄÜ¡£
ÀýÈ磬Èç¹ûÄãÔÚÑо¿´óÁ¿µÄÁÙʱÊý¾Ý£¬ÄãÒ²ÐíÐèҪʹÓÃÄÚ´æ´æ´¢ÒýÇæ¡£ÄÚ´æ´æ´ ......

MySQLË÷ÒýµÄ²é¿´´´½¨ºÍɾ³ý


1£®Ë÷Òý×÷ÓÃ
ÔÚË÷ÒýÁÐÉÏ£¬³ýÁËÉÏÃæÌáµ½µÄÓÐÐò²éÕÒÖ®Í⣬Êý¾Ý¿âÀûÓø÷ÖÖ¸÷ÑùµÄ¿ìËÙ¶¨Î»¼¼Êõ£¬Äܹ»´ó´óÌá¸ß²éѯЧÂÊ¡£ÌرðÊǵ±Êý¾ÝÁ¿·Ç³£´ó£¬²éÑ¯Éæ¼°¶à¸ö±íʱ£¬Ê¹ÓÃË÷ÒýÍùÍùÄÜʹ²éѯËٶȼӿì³ÉǧÉÏÍò±¶¡£
ÀýÈ磬ÓÐ3¸öδË÷ÒýµÄ±ít1¡¢t2¡¢t3£¬·Ö±ðÖ»°üº¬ÁÐc1¡¢c2¡¢c3£¬Ã¿¸ö±í·Ö±ðº¬ÓÐ1000ÐÐÊý¾Ý×é³É£¬Ö¸Îª1¡«1000µÄÊýÖµ£¬² ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ