天天看點

解決jsp+MysQL輸入和輸出中文亂碼的方法!

? 褰?浣跨??SP椤甸?㈠?涓????版??娣誨????ySql?版??搴?涓????跺?????闆??涓轟貢??锛?????浠?mysql涓?璇誨??涓??????跺???虹?頒貢??锛?杩?浜???棰??規??芥???變?瀛?绗????涓?涓??撮????????瑕??ラ????婧???浠?涔???浠????藉?圭??涓???锛???浠ユ??灏???棰?浜х????杩?绋?绠?????杩頒?涓?锛?濡???涓?瀵規??楂?浜鴻???锛?

???浠?浠ヤ?涓?浠?form琛ㄥ??璇誨???版??骞跺????ysql?版??搴???渚?瀛??ヨ?茶В锛?

HTML椤甸?㈠???扳??(浠ユ?瑙??ㄧ??缂????瑰?????)????JSP椤甸?⑩??(浠?SP瀹?涔???缂????瑰?琚?缂?璇?)????琚?JSP寮???缂?璇?涓?.class??浠垛????????SP瀹瑰?ㄤ腑杩?琛???????浼???缁?Mysql?版??搴???(浠ユ?版??搴???缂????瑰?璇誨???版??骞跺????????璇誨??Mysql??(浠ユ?版??搴???缂????瑰?璇誨??)????JSP椤甸?㈡?ュ?????ㄦ?瑙??ㄤ腑?劇ず(浠ユ?瑙??ㄧ????瑰?瑙g???劇ず)锛?

娉ㄦ??锛?杩???????娴?瑙??ㄧ???????JSP椤甸?㈢???????JSP椤甸?㈣??虹???????JSP椤甸?㈣??ョ????????版??搴???缂????????藉???ㄦ??ㄧ??涓?涓??達?褰?瀹?浠?涓???浠繪??涓?涓?涓??稿?????跺??灏變??虹?頒貢??锛?灏卞ソ??浼?璇?娓告??涓??鳳?寮?涓?瑕???璇?浼?缁?????锛???????浠????扮??浼?缁???浜?锛?瑕?璁╃??浜??ラ??寮?涓?璇寸??浠?涔?灏遍??瑕?浠?浠?涓?涓?浜轟嬌?ㄧ???稿??璇?瑷?锛?濡?????????涓?????浜猴?浠?褰??跺??涓???寮?涓?璇翠?涔?锛??跺??浠?杩?涓???????瀵圭??浜?璇寸????璇?锛?涔辯??锛?锛?缁?????浜?灏卞???藉???頒貢??浜???锛?姣??繪??杈?姹?~~^_^!锛?

濂戒?锛??闆?ㄦ??浠?灏變?娆℃????涓?缂????瑰??逛負?稿??灏卞??浠ヤ?锛?

//-------------------------娴?瑙??ㄧ???-----------------

<html>

? <head>< meta http-equiv="Content-Type" content="text/html; charset= GB2312"></head>

</html>

//---------------------------JSP椤甸??------------------

<%@ page pageEncoding="GB2312"%>??????????????????????????? //JSP椤甸?㈢???锛?

<%@ page contentType="text/html;charset=gb2312"%>????//JSP椤甸?㈣??虹???:

<% request.setCharacterEncoding("gb2312");?%>?????????????? //JSP椤甸?㈣??ョ???:

//------------------------MySql缂???-------------------

Connection connect = java.sql.DriverManager.getConnection(

"jdbc:mysql://localhost/mydb?user=?婚??甯???amp;password=浣???瀵???&useUnicode=true&characterEncoding=gb2312");

//-------------------------------------------------------

娉ㄦ??锛?gb2312????娉?锛?绾㈣?查?ㄥ??锛? ?ㄦ?瑙??ㄥ???版??搴?涓?????娉?瑕??哄??锛?

浠ヤ???缃?娴?璇?????锛?锛?tomcat5.5+MySql5.0锛?

//?????浜?缃?涓???寰?澶???绔?锛?姣?濡???杩??芥?拌漿????~~?歸??缃???浠跺??~~?戒?濡?杩??鋒?ョ??绠?渚誇???????楂?锛?

?ㄨ??锛?