MYSQLÂÒÂëÔõô½â¾ö£¿
ÎÒÓõÄÊÇmysql Êý¾Ý¿â£¬ÒѾÊÔÁ˺ܶàµÄ·½·¨ÁË£¬¾ÍÊ£ÕâôÎÊÌâûÓнâ¾öÁË£¬JSPÒ³Ãæ ÊÇ gb2312£¬Á¬½ÓµÄurlÀïÒ²ÉèÖÃÁËcharacterEcoding=gb2312£»»¹ÓиöʲôÁ¬½ÓʱµÄÉèÖã¬stmt.execute("set name gb2312;");(ºÃÏñÊÇÕâÑùÆ´)£¬²åÈëµ½Êý¾Ý¿âºò¶¼ÊÇÂÒÂ룬ÔõôŪ°¡£¡£¿£¡
ÂÒÂëÎÊÌâÊǾ³£»áÓöµ½µÄ£¬±ð¼±£¬ÂýÂýµÄÕÒÔÒò¡£
1¡¢ÏÈ¿´¿´Í¨¹ýJSPÌá½»µ½servletÖеÄÊÇ·ñÊÇÂÒÂë
2¡¢ÒªÊÇ1ÖеIJ»ÊÇÂÒÂ룬¾ÍÊÇÊý¾Ý¿âµÄÎÊÌâÁË£¬ÖØÐÂ×°Ò»ÏÂmysql£¬ÔÚ°²×°¹ý³ÌÖУ¬
Óиö±àÂëÑ¡ÏѡÔñUTF-8¼´¿É¡£¡£
Java code:
stmt.execute("set names gb2312");
http://www.china56zx.com
http://blog.csdn.net/limingtianshi/archive/2008/08/21/2805958.aspx
Èç¹ûÊÇ´Ójspµ½Êý¾Ý¿âÀïÃæ³öÏÖÁËÖÐÎÄÂÒÂëÎÊÌ⣬Äã¿ÉÒÔÐÞ¸ÄÒ»ÏÂÄãmysqlµÄÅäÖÃÎļþ£¬Ò²¾ÍÊÇmy¡£iniÎļþ£¬ÖмäÓиöµØ·½ÊǶ¨Òå±àÂëµÄ£¬Çë¸ÄΪ£ºgb2312.
ÔÚ²åÈëÊý¾Ý¿âǰ´òÓ¡Ò»ÏÂÊý¾Ý¿´ÊDz»ÊÇÂÒÂë¡£
ÎÒÒѾ°ÑmysqlµÄĬÈϱàÂë¶¼¸Ä³Égb2312ÁË£¬my.iniÀïÃæµÄÄǸö±àÂëÒ²ÊÇgb2312, jspÖÐÓÃ
String resume = new String(request.getParameter("resume").getBytes("ISO8859_1"),"gb2312");ת±äÁ˱àÂë¸ñʽ£¬µ«ÊÇ»¹ÊDz»ÐУ¡
ÖÕ¼«½â¾ö°ì·¨£º°²×°Ê±£¬ÔÚ±àÂëÏÂÀ²Ëµ¥ÖÐÑ¡Ôñgb2312.ÒÔºó²»¹ÜÔõôŪ£¬¶¼²»»áÂÒÂ룡
²»ÂÒÂ룬ÇëÓÃUTF-8
ÓÃ\s²é¿´Êý¾Ý¿âÀ
Ïà¹ØÎÊ´ð£º
echo %~dp0
CD %~dp0
mysqld.exe --defaults-file=..\my.ini --console
pause
´ó¼Ò¿´¿´ÒÔÉÏbatÎļþµÄÒâ˼£¬Çë´óÏÀ¸ø¸öÏêϸµÄ½âÊͰ¡¡£
ÕâÊÇÆô¶¯mysql·þÎñ°¡¡£
echo %~dp0
ÏÔʾµ±Ç°batËùÔÚĿ¼Ãû
CD %~dp0
......
¸Õ°²×°mysqlµÄʱºò£¬°Ñ³õʼÃÜÂëÍü¼ÇÁË£¬Ö»ºÃÌø¹ýȨÏÞÑéÖ¤£¬ÐÞ¸ÄÃÜÂ룬Ð޸ijɹ¦ºó£¬ÄܵǼ£¬¿ÉÊÇ»úÆ÷ÖØÆôÁË£¬ÓøĹýµÄÃÜÂëÓֵDz»ÉÏÁË£¬ÏÂÎÄÊÇÐ޸ĵķ½·¨£¬²»ÖªµÀÄÄÀï³öÁËÎÊÌ⣿
ÃÜÂëÐ޸ķ½·¨£º
1.ÒÔϵͳ¹ ......
ÇëÎÊÏÂÄÄλÈÊÐÖÓбȽϺõı¸·Ý·½°¸£¬ÓÃʲô¹¤¾ß»òÕßÓÃʲô·½Ê½£¬Ð¡µÜ½è¼øÏÂ
Ö±½ÓÓÃMYSQLDUMP±¸·Ý
OR
ÓÃSQLYOGÖ®ÀàµÄͼÐλ¯¹ÜÀí¹¤¾ß±¸·Ý
Ö±½ÓÓÃmysql×Ô´øµÄ mysqldump ¾Í¿ÉÒÔÁË¡£
http://dev.mysql.com/doc/re ......
ÎÒÒѾ°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......