JSP³öEXCEl±¨±íÖÐÎÄÃû³ÆÂÒÂë
ÎÒÔÚʹÓÿªÔ´µÄJXL ³öEXCEL±¨±íʱÓöµ½ÕâÑùµÄÎÊÌâ¡£
ÎÒÏë³öµÄÎļþÃû³ÆÊÇÕâÑùµÄ£ºÀý£ºtest_ÀîÇ¿.xls
´úÂëÊÇ ....test_+"UserID"+".xls";
µ«ÊÇ¿ØÖÆÌ¨ÎÒ¿´µ½µÄÊä³öÃû³ÆÐ§¹ûÊÇ£ºtest_µ¥°¶·ï .xls
²»ÖªµÀΪɶ£¿
UserID ÊÇÕâÑùÈ¡µ½µÄ
String UserID = request.getParameter("UserID");
È»ºóÎÒÓà System.out.println(UserID);
¿ØÖÆÌ¨Êä³öµÄÊÇÕâÑùµÄ£º??°?·?
ĿǰÎÒ²»Çå³þUserID´«¹ýÀ´Ö®Ç°µÄ±àÂë¸ñʽ »á²»»á¾ÍÊÇÒòΪ ´«À´¹ýµÃ¸ñʽ¶ÔÎÒÕâ±ßÓÐÓ°Ïì
ËùÒÔÎÒÏÂÃæÓõ½µÄ ±àÂëת»»µÄÓï¾ä²»Æð×÷ÓÃ?
´úÂëÓï¾äÊÇÕâÑùµÄ
String filename = new String(UserID.getBytes("GBK"),"gb2312");
µ«ÊÇSystem.out.println(filename )£»ÕâÑùÊä³öµÄ»¹ÊÇ£º??°?·?
ÕâÀïÓиöÎÊÌ⣬UserID.getBytes("GBK"), Õâ¸öGBKÊÇ´ú±íµÄʲôº¬Ò壿 ºóÃæµÄgb2312ÊÇÎÒÒª±ä»»µÄ¸ñʽÂð£¿
ÎÒÊÇ´Óhtm ͨ¹ýjavaScript Ìø×ªµ½ Õâ¸öjsp ÎļþÖÐ Íê³É±¨±íÊä³ö
htm µÄ charset="gb2312"
ÔÚmyecplise ÏÂÏîÄ¿µÄ±àÂë¸ñʽ ĬÈÏΪ GBK £¬²Ù×÷ϵͳΪ windows xp ÖÐÎİæ
ÁíÍâÎÒÔÚÍøÒ³ÖÐÒ²ÊÔÁËÒ»ÏÂ
String UserID =¡°ÀîÇ¿¡±£»
String filename = new String(UserID.getBytes("GBK"),"gb2312");
System.out.println(filename )£»
ÕâÑù³öÀ´µÄЧ¹ûÊÇ¿ÉÒ﵀ £»
¶øÇÒ ÏëÊä³öµÄ test_ÀîÇ¿.xls Ò²Êä³ö³É¹¦ÁË£º
Çë¸÷λÅóÓѰïæ ÌáЩ±¦¹ó½¨Ò飡¸ã²»¶®°¡£¡
Ææ¹ÖµÄÎÊÌ⣬¹Ø×¢Ò»ÏÂ..
Ïà¹ØÎÊ´ð£º
JSPÒ³ÃæÖÐÓжà¸öradio°´Å¥
JSPÒ³Ãæ½«²ÎÊýPOST¸øservlet
ÒªÇóÈçÏÂ;
1.Ñ¡ÔñÒ»¸öradio£¬µ÷ÓÃservlet servletÖиù¾Ý²ÎÊýµ÷ÓÃÆäËû½Ó¿Ú£¬³ý·ÇÑ¡ÖиÃradio²¢µã»÷JSPÖеÄʵР......
¸÷λÀÏ´óºÃ¡£¡£¡£Ð¡µÜÓÐÒ»¸öÂÒÂëÎÊÌâ¼±Ðè°ïæ½â¾ö
ÎÒÔÚ±¾Ò³ÖÐÓÃrequest.getParameter("name")È¡±äÁ¿¡£¡£±äÁ¿µÄ¸³ÖµÎªºº×Ö¡£ÎÒÔÚÒ³ÃæµÄ¿ªÍ·¼ÓÁË<%@ page language = "java" contentType=&quo ......
´ó¼ÒºÃ£¬ÎÒÔÚJSPµÄ³õѧÕߣ¬ÔÚ±à³ÌÖÐÓöµ½ÁËÒ»¸öÎÊÌ⣺
<jsp:useBean id="accountBiz" class="bank.AccountBiz"
scope="application">
Õâ¸ö±êÇ©ÖÐapplicationºÍsessi ......
±ÈÈç˵DB.classÊÇÔÚ°ücom/zhl/jdbcϵÄ
ÄÇôDB.class·ÅÔÚʲôµØ·½ Èç¹ûÓÃ<jsp:useBean id="d" class=""/>À´ÒýÈëbean ÄÇôclassÊôÐÔÓ¦¸ÃÔõôд
Ðè²»ÐèÒªÏñservletÄÇÑù»¹ÒªÅäÖÃweb.xmlµÄ& ......
³ÌÐòÈçÏÂ:
<%@ page contentType="text/html; charset=GBK" %>
<%@ page language="java" %>
<%@ page import="com.mysql.jdbc.Driver" %>
<%@ page import ......