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
Ïà¹ØÎÊ´ð£º
ÎÒ´æ´¢¹ý³ÌÏë
begin
select * from newsys;
end
µ«´æ´¢¹ý³ÌµÄ²ÎÊýÓ¦¸ÃÔõôд?
phpÓÖÔõôµ÷Óã¬Çë¸øÎÒÍêÕûµÄʵÀý£¬ÎÒÔÚÍøÉÏËÑÁËÒ»´ó¶Ñ£¬½á¹û¶¼Ã»³É¹¦£¬Ð»Ð»¸÷λ£¡
ûÓùý£¬¶¥Ò»Ï£¡
......
¶ÔMYSQLÖд洢µÄXML¸ñʽµÄÊý¾Ý½øÐвéѯ¸üÐÂÒÔ¼°É¾³ýij½áµã´¦ÀíµÄÀý×Ó£¬Çë·¢ÎÒÓÊÏ䣬лл£¬
30367940@qq.com
·¢ËͺóÇë»ØÌû£¬ÊÕµ½¼°½áÌû
ÄãÒªmysql¸ÉÂï?
ÂãÇó¿ÉÒÔ¿¼ÂÇ!
¶¥ÉÏÈ¥
¶Á³öÀ´È»ºóÓÃSimpleXML´ ......
ÎÒÓõÄÊÇeclipse-jee-galileo-SR1-win32 tomca6.0 Mysql5.1 ÏÂÔØÏÂÀ´µÄÇý¶¯ÊÇmysql-connector-java-5.1.10-bin.jar ÎÒ½«Ëü·ÅÔÚÁËD:\Ŀ¼Ï²¢Ð´½øÁËϵͳ±äÁ¿calsspath »¹°ÑËü·Å½øÁËeclipse¹¤×÷ÇøµÄ ÏîÄ¿\WebContent\W ......
ÓÃjsp×ö¶«Î÷¸øÍêÈ«²»¶®mysqlµÄÈËÓ㬿ÉÊDZ¸·ÝʱֻÓпÕÎļþ£¬ÕâÊÇʲôÇé¿ö£¬
×îºÃÓÐÔ´´úÂ룬лл
Æäʵ±¸·ÝµÄ¹ý³ÌÎÒÏë´ó¸ÅÊÇÕâÑùµÄ£º
½«±íAÖеÄÊý¾Ý·Åµ½ArrayListÖУ¬È»ºó½«Õâ¸öArrayListÖеÄÊý¾ÝÔÙ´æµ½±íBÖС£ ......
ÇëÎÊһϣ¬mysqlµÄsequenceÊÇ×Ô¶¯µÝÔöµÄ£¬²»ÐèÒª½øÐвÙ×÷¡£
ÄÇÎÒÔÚ²åÈëÒ»ÌõÖ÷¼Ç¼µÄʱºò£¬Í¬Ê±Òª¸øÕâ¸öÖ÷¼üµÄÆäËû±í½øÐвåÈëÊý¾Ý¡£Õâʱºò£¬ÎÒ¸ù±¾È¡²»µ½Õâ¸öµÝÔöµÄsequence°¢¡£¡£
Õâ¸öÎÊÌâÔõô½â¾ö°¢¡£¡£
......