ÓйØ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 ......
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 ......
ÎÒÏÖÔÚÓÃstruts2¿ò¼Ü,ÐèҪʹÓÃajaxʵÏÖ¾Ö²¿Ë¢Ð£¬µ«ÊÇ´ÓÈÝÆ÷Àï·µ»ØµÄÖµ²»ÖªµÀÔõô´Óstruts.xmlÅäÖÃÎļþÀïÓ³Éäµ½jspÒ³ÃæÀÒÔǰservletÀïдout.orint("xxxxx")¾Í¿ÉÒԵõ½~£¬µ«ÊÇÏÖÔÚÓÃstruts¾Í²»ÖªµÀÔõôР......
ÎÊÌâÊÇÕâÑùµÄ£º
ÎÒÓÐÒ»¸öÎļþnagiv.jsp ÁíÒ»¸öÎļþfailure.jsp°üº¬Ëû£¬Í¬Ê±nagivÎļþÖÐÓÐÒ»¸ö¿ÉÒÔÌø×ªµ½yy.jspµÄcommandButton£¬µ«ÊÇÎÒ½«failureÖеã»÷nagivÖеÄÄĸöcommandButton£¬Ò²Ãæ²»»áÌø×ª ......
jspÖÐinclude.incµÄ×÷ÓÃÊÇʲô£¿
include.incɶÒâ˼£¿Ã»Ìý˵¹ý
Java code:
<%include file="include.inc"%>¼ÓÔØÍøÕ¾Ä¿Â¼include.incÎļþÄÚÈÝ
°üº¬Ò»¸ö¾²Ì¬Ò³Ãæ°É···
& ......