jspÖÐÎÒÏë´ÓÊý¾Ý¿âÖвéѯ²¿·Ö¶«Î÷£¬Ôõôд´úÂ룿
ÎÒÓÃSqlServer½¨Á¢ÁËÒ»¸ö±í¡£ÀïÃæÓУ¬Îļþ±àºÅ: ÎļþÃû³Æ: ³§¼ÒÃû³Æ: ¹éµµ²¿ÃÅ: µÈµÈ£»
ÏÖÔÚÎÒÏë´ÓÕâ¸ö±íÖвéÎļþ±àºÅ£¬´úÂëÔõôд°¡£¬
ÀýÈ磬±íÃ÷dengjibiao Îļþ±àºÅnumberµÈ
Çó´úÂ룬ллÐֵܽãÃÃÃǰ¡£¬ÔÚÏߵȰ¡¡£
SQL code:
SELECT t.number, t.name, t.factory, t.axxxx
from dengjibian t
WHERE t.number = '007755';
¸ø¸ö½âÊͰ¡£¬ÀÏ´ó£¬ÎÒÊÇÐÂÊÖ£¬ºÇºÇ
¿ñÔΣ¡
½Ó1Â¥--------------
SELECT t.number, t.name, t.factory, t.axxxx //²éѯ³öÎļþ±àºÅ¡¢Ãû×Ö¡¢³§¼Ò¡¢µÈµÈ
from dengjibian t //´Ó±ídengjibianÖУ¬²¢°ÑdengjibianÖØÃüÃûΪt
WHERE t.number = '007755'; //µ±Îļþ±àºÅÊÇ'007755'µÄʱºò
t.number //±íʾt±íÖеÄnumberÕâÒ»ÁУ¨ÆäËüÀàÍÆ£©
Ö§³Ö
ûµÃ˵ ÈÏÕæ¿´×ÊÁÏ ÉϵÛ˵£ºÄãÓ¦¸Ã˼¿¼£¬ÊÂÇé¾ÍÊÇÕâô¼òµ¥£¡
Ïà¹ØÎÊ´ð£º
ÎÒÏÖÔÚÏëÓÃsshÕûºÏÀ´×öÒ»¸öÂÛ̳£¬µ«Êý¾Ý¿â·½Ãæ²»ÐУ¬ÎÒÖ÷Òª²»»áÉæ¼°Êý¾Ý¿â£¬²»ÖªµÀ·¢Ìû±í£¬ºÍ»ØÌû±íÒªÈçºÎÉè¼ÆºÍÇø·Ö¡£²»ÖªµÀËÓÐÒ»¸ö¼òµ¥µÄ˼·£¬À´Éè¼ÆÕâЩ±í¡£Ð»Ð»ÁË¡£
·¢ÌûºÍ»ØÌûÓÃͬһÕÅ±í ¡£·¢Ìû id user ......
ÎÒÔÚʹÓÿªÔ´µÄJXL ³öEXCEL±¨±íʱÓöµ½ÕâÑùµÄÎÊÌâ¡£
ÎÒÏë³öµÄÎļþÃû³ÆÊÇÕâÑùµÄ£ºÀý£ºtest_ÀîÇ¿.xls
´úÂëÊÇ ....test_+"UserID"+".xls";
µ«ÊÇ¿ØÖÆÌ¨ÎÒ¿´µ½µÄÊä³öÃû³ÆÐ§¹ûÊÇ£ºtest_µ ......
include.jspÖÐ
<jsp:include page="divide.jsp?value1=2&value2=3 flush="true">
value1 , value2 µÄÖµ¿ÉÒÔ´ÓÉÏÒ»¸ö´«¸øinclude.jspµÄdata.jspÖÐÈ¡Âð£¿
Èç¹û¿ÉÒÔÕâôд° ......
<script language="javaScript">
function select()
{
document.selectpages.selectnum.value=document.selectpages.selectpage.value;
document.selectpages.submit();
}
&l ......
²ËÄñÌáÎʸ÷λ´óϺ£¬ÈçÌ⣺²»Ã÷°×Ϊʲôһ¸öjspÒ³ÃæÄÜͬʱÏìÓ¦¶à¸öÇëÇó£¿
¸öÈËÀí½â,jspÊǶÔservletµÄ·â×°,serlvetÊÇÖ§³Ö¶àÏ̷߳ÃÎʵÄ
JSP±¾ÖÊÉϾÍÊÇSERVLET,¶øËüÓÖÊǵ¥ÊµÀýµÄ£¬Ḭ̈߳²È«£¡ÄãµÄÎÊÌâ¾ÍµÈͬÓÚÒ»¸öSER ......