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

MySQL±àÂëµÄÎÊÌâ

ÎÒµÄMySQL±àÂ룬ÎÒÔÚmy.iniÖÐÉèÖõÄΪutf8,ÔÚ´´½¨Êý¾Ý¿âʱѡÔñµÄ±àÂëΪutf8_Unicode_ci£¬ÎÒÔÚ¡¢´ÓÒ³Ãæ²åÈëÊý¾Ý¿â£¬ÔÚÒ³ÃæÉÏÏÔʾÕý³££¬µ«´ÓphpmyadminÖУ¬²é¿´Ê±£¬ÏÔʾΪÂÒÂ루ÎÒÎÒ¡£¡£¡££©ÀàËÆÓÚÕâÑùµÄÂÒÂ룬´ÓphpmyadminÖУ¬²åÈëÊý¾Ýʱ£¬´ÓÒ³ÃæÉϲ鿴£¬ÏÔʾΪÂÒÂ루£¿£¿£¿£¿£©ÀàËÆÓÚÕâÑùµÄÂÒÂ룬ÎÒµÄÍøÒ³ÖУ¬Ö±½ÓÌí¼ÓµÄform±íµ¥£¬Ã»¼ÓÈë <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />±àÂë˵Ã÷£¬ÔÚÒÔǰûÎÊÌâµÄ£¬½ñÌìÉÏÀ´¾Í³öÎÊÌâÁË¡£¡£¡£
¸÷λ´óÏÀ£¬¸æËßÏÂÔ­Òò¡£¡£¡£
ÉèÖÃÒ»ÏÂphpmyadminµÄ±àÂëÓ¦¸Ã¾Í¿ÉÒÔÁË,Ê×Ò³×óÉϽÇÓиöLanguageµÄµ¥Ñ¡¿ò,Ñ¡Ôñ
ÖÐÎÄ-Chinese simplified

ÎÒÉèÖõľÍÊÇÖÐÎÄ-Chinese simplified

ÔÚÍøÒ³Ö´ÐвåÈëÊý¾Ý֮ǰ²åÈëÕâ¾ä´úÂ룺
mysql_query("set names utf8");

ÐÂÊÖ£¬¿´¿´£¡

ÎÒÉèÖÃmysql_query("set names utf8");
ÔõôÌáʾ´íÎó
ÎҵĴúÂëPHP code:

<?php
function db_connect()
{
$db = @ new mysqli("127.0.0.1","root","","wangliuwei");
mysqli_query("set names 'gbk'");
if (mysqli_connect_errno())
{
echo "Êý¾Ý¿âÁ¬½Óʧ°Ü";
echo mysqli_connect_error();
exit;
}
return $db;
}
?>



¸÷λ´óÏÀÃÇ£¬¸æËßϰɡ£¡£¡£

ÔõôûÈ˻ش𣿣¿£¿£¿
×Ô¼º¶¥ÏÂ

ÄãÊý¾Ý¿â my.in


Ïà¹ØÎÊ´ð£º

jspÁ¬½ÓmysqlÎÊÌâ

ÎÒµÄtomcat6.0.20 jdbcÇý¶¯ÊÇ5.1µÄ  ǰ´ÎÎÒÕÕ×ÅÍøÉϵÄÅäÖþͿÉÒÔÁË Ò²²»ÓÃŪʲô»·¾³±äÁ¿ Õâ´Î¾Í²»ÐÐÁË ÎÒŪÁË»·¾³±äÁ¿Ò²²»ÐÐ tomcatÏÂÃæÃ»ÓÐcomm ËùÒÔÎÒ°Ñmysql-connector-java-5.1.8-bin.jar·Åµ½D:\Tomcat 6. ......

javaÔõôµ÷ÓÃmysql´´½¨µÄ±í

Õâ¸öÎÊÌâÀ§ÈÅÎҺþÃÁË£¬ÎÒÒ²²»ÖªµÀÔõôÎÊ£¬Ö»ÄÜ´óÖÂ˵һÏ£º
ÎÒÓÃMySQL´´½¨ÁËÒ»¸öÊý¾Ý¿â bookinfo±í£¬ÒªÓÃJavaµ÷ÓÃÕâÕÅ±í£¬µ«Êǵ÷Óò»³öÀ´£¬ÒªÊ²Ã´¾ä×Ó²ÅÄܵ÷ÓÃMySQL´´½¨µÄÊý¾Ý¿âÄØ¡£
Java code:
String url = ......

javaÁ¬½Ómysql±»¾Ü¾ø

ÎÒÔÚ³ÌÐòÀïÃæÐ´ÁËÒ»¸ö¼àÌýÆ÷£¬TomcatÆô¶¯µÄʱºò¾Í»áÈ¥¼ì²âÊý¾Ý¿âÊÇ·ñÁ¬½ÓÉÏÁË£¬µ«ÊDZ¨ÁË´í
Access denied for user 'root'@'localhost' (using password: YES)
·ÃÎʱ»¾Ü¾ø£¬ÔõÑùÐ޸ķÃÎÊÓû§µ ......

ÕÒmysql·þÎñͻȻµ±µôÔ­Òò

linuxÉϵÄmysql·þÎñÔÚ½Ú¼ÙÈÕͻȻµ±µô
ÏÖÔÚÕÒÔ­Òò£¬»³ÒÉÊÇ´ÅÅ̿ռ䲻¹»£¬ÏÖÔÚÐèÒªÕÒµ½È·ÔäµÄÖ¤¾Ý¡£
£±¡¡¾ßÌåÔÚÄĸöÎļþÏ¿ÉÒÔÕÒµ½£¬Ëûµ±µôµÄ¾ßÌåʱ¼äºÍÔ­Òò£¿
£²¡¡windowsÏÂcÅÌ¿ÉÒÔ±¨´ÅÅ̿ռ䲻¹»µÄÔ­Òò£¬²» ......

mysqlµÄ sequence µÄÎÊÌâ¡£ÔÚÏߵȴý¡£¡£

ÇëÎÊһϣ¬mysqlµÄsequenceÊÇ×Ô¶¯µÝÔöµÄ£¬²»ÐèÒª½øÐвÙ×÷¡£
ÄÇÎÒÔÚ²åÈëÒ»ÌõÖ÷¼Ç¼µÄʱºò£¬Í¬Ê±Òª¸øÕâ¸öÖ÷¼üµÄÆäËû±í½øÐвåÈëÊý¾Ý¡£Õâʱºò£¬ÎÒ¸ù±¾È¡²»µ½Õâ¸öµÝÔöµÄsequence°¢¡£¡£

Õâ¸öÎÊÌâÔõô½â¾ö°¢¡£¡£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ