ÈçºÎÓÃ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
Ïà¹ØÎÊ´ð£º
ÎÒÔÚʹÓÿªÔ´µÄJXL ³öEXCEL±¨±íʱÓöµ½ÕâÑùµÄÎÊÌâ¡£
ÎÒÏë³öµÄÎļþÃû³ÆÊÇÕâÑùµÄ£ºÀý£ºtest_ÀîÇ¿.xls
´úÂëÊÇ ....test_+"UserID"+".xls";
µ«ÊÇ¿ØÖÆÌ¨ÎÒ¿´µ½µÄÊä³öÃû³ÆÐ§¹ûÊÇ£ºtest_µ ......
jsÖеķ½·¨£¬²»ÄÜÔÚjspÖе÷ÓÃÔõô½â¾ö£¿¼±£¡£¡!
²»Ã÷°×Òâ˼
ºÃºÃ¼ì²éÊDz»ÊÇ·¾¶µÄÎÊÌ⣬ºÜÓпÉÄÜ·¾¶²»¶Ôµ¼Öµ÷Óò»µ½
Ìùһϵ÷ÓõĴúÂë¿´¿´°¡~~
ÓÐûÓÐÕýÈ·ÒýÓÃjs£¿º¯ÊýÓÐûÓгõʼ»¯£¿....
jsp´úÂë±¾À´¾ ......
Óм¸ÖÖÓû§£¬ÆäȨÏÞ²»Í¬¡£Ö»ÓÐÌØ¶¨È¨ÏÞµÄÓû§²ÅÄܽøÐÐÏàÓ¦²Ù×÷¡£ÎÒÏëÔÚjspÒ³ÃæÀï½øÐÐÕâ¸öÉèÖÃ
<input type="submit" value="ÐÞ¸Ä"/> ,ÎÒÏëÈÃÖ»ÓÐÌØ¶¨È¨ÏÞµÄÓû§²ÅÄܰ´Õâ¸ö°´Å¥£¬·ñÔò±¨ ......
ÎÒÏë×ö¹»¹ºÎï³µÓÃsession µ«ÊDz»ÖªµÀÔõô»ñÈ¡¹ºÂòÊýÁ¿ ËÓоßÌåµÄ´úÂëÂð Ï£ÍûÄܸîÉá
ÏÂÃæÊǹºÎï³µµÄºËÐÄ´úÂë
ÓÐÁËÕâ¸ö ¾ÍÓ¦¸ÃÄܹ»×ö³öÀ´°É
Java code:
public void doPost(HttpServletRequest reque ......