ÓйØmysqlµÄÎÊÌ⣡ - Java / Web ¿ª·¢
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ
ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£
ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö·û¸®¸ÄΪGB2312»òGBK£¬²»ÒªÊ¹ÓÃĬÈϵÄ×Ö·û¼¯¡£¾Í²»´æÔÚÄã˵µÄÎÊÌâÁË¡£
Õâ¸öÂÒÂëµÄ¶«Î÷ºÜÄÑ˵ÊÇmysqlµÄÎÊÌ⣬ÄãÒª¶Ï¶¨ÄãµÄ²åÈëÓï¾äÖÐȷʵÊÇÖÐÎÄ£¬Ëµ²»¶¨Äã²åÈë֮ǰÒѾÊÇ£¿ÁËÄØ£¬ÔÚ²åÈë֮ǰÄã´ò³ösql¿´¿´£¬ÒªÊÇÄãµÄÒ³Ãæ±àÂëºÍÄãµÄÊý¾Ý¿â±àÂëͳһ£¬Í¬Ê±sqlµÄ²åÈëÓï¾äÖÐȷʵÊÇÖÐÎÄ£¬ÄÇ´æÈëµÄÊý¾Ý¿Ï¶¨ÊÇÖÐÎÄ
ÔÚmysql°²×°Ä¿Â¼Ï´ò¿ªmy.iniÎļþ£¬°Ñdefault_character_setµÄÖµ¸ÄΪutf8»òÕßgbk
Êý¾Ý¿â±àÂëÓùú¼Ê±ê×¼UTF-8±àÂë,²»¹Üʲô±àÂëµÄÊý¾Ý´¢´æÐÎʽ¶¼ÎªUTF-8
Êý¾Ý¿âÁ¬½Ó²ÉÓÃGBK ±àÂë,±£´æÈ¡³ö¾ÍÊÇGBK±àÂë.
Êý¾Ý¿âÁ¬½Ó²ÉÓÃis8859-1±àÂë,±£´æÈ¡³ö¾ÍÊÇis8859-1±àÂë.
ÔÚmysql°²×°Ä¿Â¼Ï´ò¿ªmy.iniÎļþ£¬°Ñdefault_character_setµÄÖµ¸ÄΪutf8»òÕßgbk
×îºÃÉèÖóÉutf8
mysql±àÂëÓÐÎÊÌâ°É£¬Ä㽫ÄãÊý¾Ý¿âµÄ±àÂë¸ÄΪutf8¾ÍºÃÁË
ÔÚmysql°²×°Ä¿Â¼Ï´ò¿ªmy.iniÎļþ£¬°ÑËùÓÐdefault-character-set=µÄÖµ¶¼»»³Égbk
ÈçºÎÖØÆô
ËùÓÐÊÂÇé¾Í¸ã¶¨ÁË
Ïà¹ØÎÊ´ð£º
ÎÒÏëÓÃJavaдһ¸ö³ÌÐò£¬¾ÍÊÇÎÒÏëÔÚÔËÐдúÂëºó£¬ÔÚÖ¸¶¨µÄʱ¼ä´ò¿ªÄ³³ÌÐò£¬ÀýÈçÎÒÔËÐдúÂëºó£¬½²ÔÚ12£º00´ò¿ª"D:\Program Files\Tencent\QQ2009\Bin\QQ.exe"Õâ¸ö³ÌÐò£¬Çó¸ßÈËÖ¸µã¡£»¹ÓпÉÄܵĻ°ÔÚÖ¸¶¨µÄʱ¼ä ......
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class QueryTest&n ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
ÎÒÏÖÔÚÓÃstruts2¿ò¼Ü,ÐèҪʹÓÃajaxʵÏÖ¾Ö²¿Ë¢Ð£¬µ«ÊÇ´ÓÈÝÆ÷Àï·µ»ØµÄÖµ²»ÖªµÀÔõô´Óstruts.xmlÅäÖÃÎļþÀïÓ³Éäµ½jspÒ³ÃæÀÒÔÇ°servletÀïдout.orint("xxxxx")¾Í¿ÉÒԵõ½~£¬µ«ÊÇÏÖÔÚÓÃstruts¾Í²»ÖªµÀÔõôР......
Èý¸öÊýx,y,z ±È´óС..
var x,y,z,t;
if (x>y)
{t=x;x=y;y=t;} //½»»»x,yµÄÖµ
if(x>z)
{t=z;z=x;x=t;}//½»»»x,zµÄÖµ
if(y>z)
{t=y;y=z;z=t;}//½»»»z,yµÄÖµ
ÕâÊÇ ......