ÈçºÎÓÃjspʵÏÖmysqlÊý¾Ý¿â±àÂ룿
ÔÚphpÖÐÓÃÕâ¾ä¾Í¿ÉʵÏÖ¶Ô¿Í»§¶Ë×Ö·û¼¯µÄÉèÖÃ....
mysql_query("set names gb2312")
ÇëÎÊÔÚjspÖÐÈçºÎʵÏÖÕâ¾ä¹¦ÄÜ£¿£¿£¿
jspÖУº
<%@page language="java" contentType="text/html;charset=utf-8"%>
servletÖУº
request.setCharacterEncoding("utf-8");
mysqlµÄ×Ö·û¼¯Ö÷Òª»¹ÊÇÔÚдjdbcµÄurlʱ¾ÍҪȷ¶¨¡£
È磺
jdbc:mysql://127.0.0.1/exam?Unicode=true&characterEncoding=utf-8
1¡¢jspÒ³ÃæÂÒÂë
µ±½¨Á¢Ò»¸öjspÒ³ÃæÊ±£¬Ä¬ÈÏpageEncoding="iso-8859-1"
µ±Ò³Ãæ³öÏÖÖÐÎÄʱ»á³öÏÖÂÒÂë,ÒòΪiso-8859-1²»Ö§³ÖÖÐÎıàÂë
½â¾ö·½·¨,½«pageEncodingÉèÖóÉÖ§³ÖÖÐÎĵıàÂëeg:utf-8 or gbk or gb2312
2¡¢servletµÄÖÐÎÄÂÒÂë
ÏìÓ¦±àÂ룬£¨Êä³ö±àÂ룩
ĬÈÏresponse.setContentType("text/html");
ûÓÐÉèÖñàÂë,ËùÒÔ³öÏÖÖÐÎÄʱ»á³öÏÖÂÒÂë
½â¾ö°ì·¨:response.setContentType("text/html;charset=utf-8");
3¡¢post±íµ¥´«µÝ²ÎÊýÂÒÂë
½ÓÊܲÎÊýÂÒÂë±àÂë
* ͨ¹ýjspÒ³Ãæ£¬htmlÒ³Ãæ»òÕßservletÖÐµÄ±íµ¥ÔªËØÌá½»²ÎÊý¸ø¶ÔÓ¦µÄjspÒ³Ãæ»òservlet
¶øjspºÍservlet½ÓÊյIJÎÊý²úÉúÖÐÎÄÂÒÂë
* ÔÚ½ÓÊÕpostÌá½»µÄ²ÎÊý֮ǰ£¬Ê¹ÓÃrequest.setCharactEncoding("utf-8")É趨½ÓÊÕ²ÎÊýµÄÄÚÈÝʹÓÃ"utf-8"±àÂë
* ¸üºÃµÄ½â¾ö°ì·¨ÊÇÌí¼Ó¹ýÂËÆ÷
4¡¢URI·½Ê½´«µÝ²ÎÊýÂÒÂë
* ʹÓÃ±íµ¥´«µÝ²ÎÊý¿ÉÒÔͨ¹ýgetºÍpost·½Ê½´«µÝ²ÎÊý,Ò²¿ÉÒÔͨ¹ýÁ¬½ÓµÄ·½Ê½´«µÝ²ÎÊý,Õâ¸ö´«µÝ²ÎÊýµÄ·½Ê½Êµ¼ÊÉϾÍÊÇget
Ïà¹ØÎÊ´ð£º
ÎÒµãºóÍËʱÊǿհ×Ò³Ãæ
ÐèˢвÅÄÜÏÔʾ
Õâ¸öÔõô´¦Àí°¡
Çë´ó¼Ò°ï°ïæ
°ÑÎÊÌâ˵µÄÏêϸһЩ£¬ÕâÑùÓÐÖúÓÚÎÊÌâµÄ»Ø¸´£¬¼°´ð°¸µÄ׼ȷÐÔ£¡
ÎÒ¾õµÃÊÇÄãµÄä¯ÀÀÆ÷Æ÷µÄÎÊÌâ°É£¬ÎÒÒÔǰÓöµ½¹ýÕâÑùµÄÎÊÌ⣬°ÑIEµÄËùÓÐÊôÐÔÖ ......
¸÷λ´óÏÀ¾ÈÃü°¡ £¡£¡
¸Õ×°ÁËSQL2000 sp3
ÏëÓÃJSPÁ¬½ÓÊý¾Ý¿âµ«ÊdzöÏÖÎÊÌâÁË
ÎÒÓõÄÊÇJDK6.0+tomcat5.0+SQL2000 SP3+JDBC sp3
ËüÏÔʾµÄÊÇ
javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver fo ......
ÎÒÏëµÇ¼ºó£¬Èç¹ûµÇ¼³É¹¦¾ÍÈ¥Ö´ÐÐij¸öÒ³Ãæ
ÎÒÏÖÔڵĴúÂëÊÇÕâÑùµÄ£º
if(rs.next()){
session.setAttribute( "username" , user);
<jsp:include page="login.jsp" />// ......
<%@page language="java" contentType="text/html;charset=gb2312" import="java.sql.*"%>
<jsp:useBean id="db" class="wang.connectDB"/>
< ......