JSPÁ´½Ó²éѯµÄÎÊÌâ
ÔÚjspÒ³ÃæÖУ¬Èç¹ûÎÒÒªµãÏÂÃæµÄÁ´½Ó£¬°Ñcity=bjÕâ¸ö²ÎÊý´«Èëtest.jspµÄ²éÑ¯Ò³Ãæ£¬¿ÉµÃµ½qudao=bjµÄ½á¹û
Ï൱ÓÚÔÚÏÂÒ»¸öÒ³ÃæÖ´ÐÐÁËÒ»¾ä select * from tab where city='bj' AND STATE='F0A' ---STATE='F0A'±íʾ״̬Õý³£
HTML code:
<a href="test.jsp?city=bj&state=F0A>µã´ËÁ´½Ó</a>
ÄÇôÎÊÌâÊÇ£¬Èç¹û£¬ÒªµÃµ½ÀàËÆÓÚ
select * from tab where city in ('bj','sh') and state='F0A'
µÄЧ¹û£¬Á´½ÓµÄÓï¾äÓ¦¸ÃÔõôд£¿
<a href="test.jsp?city=bj,sh&state=F0A>µã´ËÁ´½Ó </a>
µÃµ½²ÎÊýºóÒÔ¡°£¬¡±·Ö¸ôȡֵ¡«
²»¶®ËµµÄÊÇʲôÒâ˼
¿Ø¼þÊý×é¾ÍÊÇÄÇô´«µÝµÄ£¡£¡
Ò³ÃæÖÐÖ´ÐеÄSQLÓï¾ä¸ÄÒ»ÏÂ
select * from tab where city in ('bj','sh') and state='F0A'
²»¹ÜÊÇÒ»¸ö²ÎÊý»¹ÊÇÁ½¸ö²ÎÊý¶¼ÄÜÍùinÀï´«£¬¼ÇµÃÒ»¸ö²ÎÊý²»Òª¼Ó¶ººÅ¾ÍÐÐ
HTML code:
<script language="javascript">
function encode(href,param){
var str=encodeURIComponent(param);
window.location.href=href+"?"+str
}
</script>
<a href="a.jsp" onclick="encode(this.href,'param=select * from tab where city in (\'bj\',\'sh\') and state=\'F0A\'');return false&quo
Ïà¹ØÎÊ´ð£º
ÎÒÏÖÔÚÏëÓÃsshÕûºÏÀ´×öÒ»¸öÂÛ̳£¬µ«Êý¾Ý¿â·½Ãæ²»ÐУ¬ÎÒÖ÷Òª²»»áÉæ¼°Êý¾Ý¿â£¬²»ÖªµÀ·¢Ìû±í£¬ºÍ»ØÌû±íÒªÈçºÎÉè¼ÆºÍÇø·Ö¡£²»ÖªµÀËÓÐÒ»¸ö¼òµ¥µÄ˼·£¬À´Éè¼ÆÕâЩ±í¡£Ð»Ð»ÁË¡£
·¢ÌûºÍ»ØÌûÓÃͬһÕÅ±í ¡£·¢Ìû id user ......
ÎÒÔÚʹÓÿªÔ´µÄJXL ³öEXCEL±¨±íʱÓöµ½ÕâÑùµÄÎÊÌâ¡£
ÎÒÏë³öµÄÎļþÃû³ÆÊÇÕâÑùµÄ£ºÀý£ºtest_ÀîÇ¿.xls
´úÂëÊÇ ....test_+"UserID"+".xls";
µ«ÊÇ¿ØÖÆÌ¨ÎÒ¿´µ½µÄÊä³öÃû³ÆÐ§¹ûÊÇ£ºtest_µ ......
ÎÒµãºóÍËʱÊǿհ×Ò³Ãæ
ÐèˢвÅÄÜÏÔʾ
Õâ¸öÔõô´¦Àí°¡
Çë´ó¼Ò°ï°ïæ
°ÑÎÊÌâ˵µÄÏêϸһЩ£¬ÕâÑùÓÐÖúÓÚÎÊÌâµÄ»Ø¸´£¬¼°´ð°¸µÄ׼ȷÐÔ£¡
ÎÒ¾õµÃÊÇÄãµÄä¯ÀÀÆ÷Æ÷µÄÎÊÌâ°É£¬ÎÒÒÔǰÓöµ½¹ýÕâÑùµÄÎÊÌ⣬°ÑIEµÄËùÓÐÊôÐÔÖ ......
±¾ÈËÔÚ±àдjsp½çÃæÊ±£¬³öÏÖÂÒÂë¡£ÎҵIJ˵¥Ä£¿éÊÇÒýÓõÄÍⲿÎļþ ´úÂ룺 <%@ include file="head.txt" %>
ÔÚÏÔʾʱ£¬²Ëµ¥ÀïÃæµÄ×ÖÈ«ÊÇÂÒÂ룬¶øÒ³ÃæÖ÷ÌåµÄ×ÖÌåÕý³£¡£
head.txtµÄ´úÂëÈçÏ£º
......