ÓйØ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 ......
ÎÒÏë×ö¹»¹ºÎï³µÓÃsession µ«ÊDz»ÖªµÀÔõô»ñÈ¡¹ºÂòÊýÁ¿ ËÓоßÌåµÄ´úÂëÂð Ï£ÍûÄܸîÉá
ÏÂÃæÊǹºÎï³µµÄºËÐÄ´úÂë
ÓÐÁËÕâ¸ö ¾ÍÓ¦¸ÃÄܹ»×ö³öÀ´°É
Java code:
public void doPost(HttpServletRequest reque ......
ÓÃRandomAccessFileдÈëTXTÎļþ²é¿´Ê±ÊÇÂÒÂ룬ÇëÎÊÓÐʲô·½·¨¿ÉÒÔд³É¿É¶ÁµÄÎļþ£¬²»ÊÇÓÃÆäËûµÄÎļþ²Ù×÷£¬¾ÍÊÇÖ»ÓÃRandomAccessFileµÄ·½·¨ÊÇ·ñ¿ÉÒÔʵÏÖ£¿
Java code:
import java.io.*;
public class RandomAcce ......
µ±ÖªµÀÒ»¸öÈÕÆÚ£¬ÈçºÎ°ÑÕâ¸öÈÕÆÚËùÔÚÑ®µÄǰºóÁ½¸öÈÕÆÚÈ¡³ö
±ÈÈçÊäÈë20090905£¬¾ÍÊäÈë20090901 20090910
Êä³ö20090901 20090910
È¡µÃÌìÊýºó×÷Ò»ÏÂÅжÏÔÙ°ÑÕâ¸ö·½·¨ÓÃÏÂvoid set(int field, int value)
......
ÎÒÏÖÔÚÓÃstruts2¿ò¼Ü,ÐèҪʹÓÃajaxʵÏÖ¾Ö²¿Ë¢Ð£¬µ«ÊÇ´ÓÈÝÆ÷Àï·µ»ØµÄÖµ²»ÖªµÀÔõô´Óstruts.xmlÅäÖÃÎļþÀïÓ³Éäµ½jspÒ³ÃæÀÒÔǰservletÀïдout.orint("xxxxx")¾Í¿ÉÒԵõ½~£¬µ«ÊÇÏÖÔÚÓÃstruts¾Í²»ÖªµÀÔõôР......