ÓйØ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
ÈçºÎÖØÆô
ËùÓÐÊÂÇé¾Í¸ã¶¨ÁË
Ïà¹ØÎÊ´ð£º
ÎÒÏÖÔÚÏëÓÃsshÕûºÏÀ´×öÒ»¸öÂÛ̳£¬µ«Êý¾Ý¿â·½Ãæ²»ÐУ¬ÎÒÖ÷Òª²»»áÉæ¼°Êý¾Ý¿â£¬²»ÖªµÀ·¢Ìû±í£¬ºÍ»ØÌû±íÒªÈçºÎÉè¼ÆºÍÇø·Ö¡£²»ÖªµÀËÓÐÒ»¸ö¼òµ¥µÄ˼·£¬À´Éè¼ÆÕâЩ±í¡£Ð»Ð»ÁË¡£
·¢ÌûºÍ»ØÌûÓÃͬһÕÅ±í ¡£·¢Ìû id user ......
µ±ÖªµÀÒ»¸öÈÕÆÚ£¬ÈçºÎ°ÑÕâ¸öÈÕÆÚËùÔÚÑ®µÄǰºóÁ½¸öÈÕÆÚÈ¡³ö
±ÈÈçÊäÈë20090905£¬¾ÍÊäÈë20090901 20090910
Êä³ö20090901 20090910
È¡µÃÌìÊýºó×÷Ò»ÏÂÅжÏÔÙ°ÑÕâ¸ö·½·¨ÓÃÏÂvoid set(int field, int value)
......
ÎÒÏÖÔÚÓÃstruts2¿ò¼Ü,ÐèҪʹÓÃajaxʵÏÖ¾Ö²¿Ë¢Ð£¬µ«ÊÇ´ÓÈÝÆ÷Àï·µ»ØµÄÖµ²»ÖªµÀÔõô´Óstruts.xmlÅäÖÃÎļþÀïÓ³Éäµ½jspÒ³ÃæÀÒÔǰservletÀïдout.orint("xxxxx")¾Í¿ÉÒԵõ½~£¬µ«ÊÇÏÖÔÚÓÃstruts¾Í²»ÖªµÀÔõôР......
¸÷λ´ó¸ç:
ÏîÄ¿ÖÐÓö¼ûÒ»¸öÄÑÌâ,ÄǾÍÊÇÈçºÎÔÚÐÞ¸ÄÊý¾Ý¿âÀïÃæµÄij¸ö×Ö¶ÎÊÇÄܲúÉúÒ»¸öÏûÏ¢,ʵʱÌáÐѵ½Ê×Ò³ÄØ?
¶øÇÒ¿Í»§ÒªÇó¿ÉÒÔ×Ô¼º¶¨ÖÆÄÄЩ×Ö¶Î,±ÈÈçÓÐA,B,C×Ö¶Î,ÎÒ¿ÉÒÔÑ¡ÔñÆäÖÐÒ»¸ö»òÁ½¸ö×Ö¶Î,µ±ÕâÁ½¸ö×Ö¶Î ......
ÎÊÌâÊÇÕâÑùµÄ£º
ÎÒÓÐÒ»¸öÎļþnagiv.jsp ÁíÒ»¸öÎļþfailure.jsp°üº¬Ëû£¬Í¬Ê±nagivÎļþÖÐÓÐÒ»¸ö¿ÉÒÔÌø×ªµ½yy.jspµÄcommandButton£¬µ«ÊÇÎÒ½«failureÖеã»÷nagivÖеÄÄĸöcommandButton£¬Ò²Ãæ²»»áÌø×ª ......