jspÒ³ÃæÈçºÎÔÚÊý¾Ý¿âÀï²éѯÖÐÎÄ£¿
Êý¾Ý¿âÓõÄSQLserver2005,°²×°µ½ÓС°ÊÇ·ñÇø·Ö´óС¡±Ñ¡ÏîÄÇÀïµÄʱºòÒòΪ²»ÊǺÜÇå³þ¡°×Ö·û¼¯¡±ËùÒÔÑ¡ÔñµÄĬÈÏ¡£
JSPÒ³ÃæÊäÈëÓ¢ÎÄ¿ÉÒÔ²éѯ£¬µ«ÊÇÊäÈëÖÐÎľͲ鲻µ½¡£
JSPÒ³ÃæÊ¹ÓõÄGBK×Ö·û¼¯¡£
<%@ page language="java" import="java.util.*" pageEncoding="GBK" %>
²»ÖªµÀʲôÔÒò£¬µÈ´ý½Ê¾¡ÄÔÖ¡£¡£¡£
1 ÏÈÈ·ÈÏÄãÊý¾Ý¿âµÄÊý¾ÝÊÇÖÐÎÄ£¬²»ÊÇÂÒÂ룡
2 ½«ÄãÒª²éѯµÄÄÚÈÝ´òÓ¡³öÀ´¿´¿´£¬ÊDz»ÊÇÂÒÂë
3 ÄãÓ¦¸Ã²ÉÓÃpost·½Ê½Ìá½»²éѯ£¬¶ø²»ÊÇGET·½Ê½
4 ÄãµÄËÑË÷Ò³ÃæÓ¦¸Ã¼ÓÉÏ
request.setCharacterEncoding("GBK");
»òÕßʹÓùýÂËÆ÷
Ê×Ïȼì²éÊý¾Ý¿âÀïµÄÖÐÎÄ
Ò»¸öÊDzéѯһÏ£¬ÏÔʾÊDz»ÊÇÕý³£µÄ£¬ÁíÒ»·½Ãæ¿´¿´ÔÚwhereÌõ¼þÖмÓÖÐÎÄ¿´¿´Äܲ»Äܲéѯ³öÀ´
Èç¹ûÕâÁ½·½Ã涼ûÓÐÎÊÌ⣬ÄǾÍ˵Ã÷Êý¾Ý¿âÀïÖÐÎÄÕý³£
Æä´Î£¬¿´¿´actionÀï²éѯµÄ¹Ø½¡×ÖÊDz»ÊÇÕý³£µÄ¡£
ºÜÓпÉÄÜÔÚactionÀ²éѯµÄ¹Ø¼ü×ÖÒѾÊÇÂÒÂëÁË£¬µ±È»Ò²¾Í²é²»³öÀ´ÁË¡£
Èç¹û¹Ø¼ü×ÖÂÒÁË£¬ÄǾÍҪתÂë¡£¿ÉÒÔÖ±½ÓתÂ룬Ҳ¿ÉÒÔͨ¹ý¹ýÂËÆ÷תÂë¡£
Ò»°ãÎÒÃÇ»áÓùýÂËÆ÷¶Ô×Ö·û½øÐÐͳһ´¦Àí¡£
ÔٴΣ¬½¨Òé²éѯµÄʱºòÓÃpost·½·¨½øÐÐ±íµ¥Ìá½»¡£
ͬÒâ¶þÂ¥µÄ£ºrequest.setCharacterEncoding("GBK");
request.setCharacterEncoding("GBK");
Ê×ÏÈÈ·ÈÏÄãÊý¾Ý¿âÓõÄÊÇʲô±àÂë¡£
È»ºóÔÙ±£Ö¤Ç°Ì¨ÊäÈëµÄÖÐÎĵ½ºǫ́´òÓ¡³öÀ´²»ÊÇÂÒÂë¡£
×îºóÔÙתÂëΪÊý¾Ý¿âµÄ±àÂëÀàÐÍ£¬½øÈ¥ºÍ³öÀ´¶¼Òª×ª£¡
1 È·ÈÏÏÂÊý¾Ý¿â±àÂë
2 ×îºÃд¸ö¹ýÂËÆ÷
1 È·ÈÏÏÂÊý¾Ý¿â±àÂë
2 ×îºÃд¸ö¹
Ïà¹ØÎÊ´ð£º
ÎÒÏÖÔÚÏëÓÃsshÕûºÏÀ´×öÒ»¸öÂÛ̳£¬µ«Êý¾Ý¿â·½Ãæ²»ÐУ¬ÎÒÖ÷Òª²»»áÉæ¼°Êý¾Ý¿â£¬²»ÖªµÀ·¢Ìû±í£¬ºÍ»ØÌû±íÒªÈçºÎÉè¼ÆºÍÇø·Ö¡£²»ÖªµÀËÓÐÒ»¸ö¼òµ¥µÄ˼·£¬À´Éè¼ÆÕâЩ±í¡£Ð»Ð»ÁË¡£
·¢ÌûºÍ»ØÌûÓÃͬһÕÅ±í ¡£·¢Ìû id user ......
ÎÒÔÚʹÓÿªÔ´µÄJXL ³öEXCEL±¨±íʱÓöµ½ÕâÑùµÄÎÊÌâ¡£
ÎÒÏë³öµÄÎļþÃû³ÆÊÇÕâÑùµÄ£ºÀý£ºtest_ÀîÇ¿.xls
´úÂëÊÇ ....test_+"UserID"+".xls";
µ«ÊÇ¿ØÖÆÌ¨ÎÒ¿´µ½µÄÊä³öÃû³ÆÐ§¹ûÊÇ£ºtest_µ ......
ÔÚjspÀïÃæ£¬Óøöselect¼ÈÄÜÊäÈë×Ô¶¯Æ¥ÅäÓÖÄÜÏÂÀÑ¡ÔñµÄ£¬ÔõôʵÏÖ£¿
²»»á¡£¡£¡£¡£¡£¡£°ï¶¥ ѧϰ¡£¡£
×Ô¶¯Æ¥ÅäʲôÒâ˼£¿¾ßÌåµã
¾ÍÊÇÄãÊäÈëÄÚÈݺ󣬺ÍÄãÄÚÈÝÏàͬѡÏîµÄ¶¼ÁгöÀ´
ÄãselectÊÇÏÂÀ¿ò¡£¡£ ......
ÎÊÌâ1.
ÈçºÎͨ¹ýRandomAccessFileÀàµÄseek()·½·¨½«Ö¸ÕëÒÆ¶¯µ½Îļþĩ⣬ÔÙÓÃwriteChars(String s)½«Êý¾ÝдÈëij¸öÎĵµÎļþ
ÎÊÌâ2.
StringTokenizerÊÇʲô¶«Î÷£¬¸ÉÂïÓõģ¿
ÓÉÓÚСµÜ³õѧjs ......
jsÖеķ½·¨£¬²»ÄÜÔÚjspÖе÷ÓÃÔõô½â¾ö£¿¼±£¡£¡!
²»Ã÷°×Òâ˼
ºÃºÃ¼ì²éÊDz»ÊÇ·¾¶µÄÎÊÌ⣬ºÜÓпÉÄÜ·¾¶²»¶Ôµ¼Öµ÷Óò»µ½
Ìùһϵ÷ÓõĴúÂë¿´¿´°¡~~
ÓÐûÓÐÕýÈ·ÒýÓÃjs£¿º¯ÊýÓÐûÓгõʼ»¯£¿....
jsp´úÂë±¾À´¾ ......