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ÖеÄʵР......
ÎÒÊǸöÐÂÊÖ£¬×öÒ»¸öJSPÍøÒ³£¬ÎÒÒª¶Á³öÊý¾Ý¿âÕý³££¬µ«ÊÇÎÒÒªÐ޸ĵÄʱºò£¬Ò²¾ÍÊǶÁÈëµÄʱºò³öÏÖÂÒÂ룬Çë¸ßÊÖ¸æËßÎÒÔõô½â¾ö£¬ÏÈллÁË¡£
request.setCharacterEncoding("UTF-8");
°Ñ±àÂëͳһ
/**
......
×î½üÒ»¸öÏîÄ¿ÖÐÓöµ½Ò»¸öÎÊÌ⣺ÔÚÔÓеÄÒ»Ì×ϵͳÖÐ(php¿ª·¢)Ìí¼ÓһЩС¹¦ÄÜ(jsp¿ª·¢)£¬ÔÀ´Óû§ÏµÍ³¶¼ÊÇphp¿ª·¢µÄ£¬ÎÒÈçºÎÔÚjsp¿ª·¢µÄ¹¦ÄÜÖÐ×öµ½Óû§ÐÅÏ¢sessionͬ²½ÄØ£¿ ÓÐÈËÊÇ·ñÓÐ×ö¹ýÀàÒÔÏîÄ¿£¬ÏëÌýÌý´ó¼ÒµÄ¿´·¨
......
JSPÖÐÒª´ÓÊý¾Ý¿âÀïÃæ¶ÁÈ¡Êý¾Ý ÿҳÏÔʾ5ÌõÊý¾Ý£¬Òª½øÐзҳ£¬»¹Òª·µ»ØÇ°Ò»Ò³ ¸ÃÔõôʵÏÖ°¡
ÓõÄʲôÊý¾Ý¿âÄØ£¿£¿£¿
MYSQL
....лл ÎÒÏÈ¿´¿´´úÂë
http://my.donews.com/benz/2006/10/21/YnmQXKsKWNgKiTJ ......
ÇëÎÊÎÒµÄjspΪʲô²»ÄÜÌø×ª,лл
<%@ page contentType="text/html; charset=utf-8" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE html PUB ......