jsp´«Êý×鏸action
ǰ̨ÓÐÒ»¸öËÑË÷À¸ ËÑË÷ÏëΪ1-3¸ö²ÎÊý ËùÒÔ¶¨ÒåΪÊý×é
´úÂ룺 <input type="text" name="param" value="" size="18" />
<input type="button" value="ËÑË÷" onclick="" />
ͨ¹ýjs°Ñ²ÎÊý´«µ½ºǫ́ jsÈçÏ£º
function search() {
var param = document.getElementsByName("param").valueOf();
alert(param);
window.location.href="${ctx}/retraining/findTheUserAccordingToParam.html?param="+encodeURIComponent(encodeURIComponent(param));
}
ºǫ́ÄܽÓÊܵ½¸ÃÊý×é µ«ÎÒÏëʵÏÖÈçϹ¦ÄÜ£º
Ñ»·Êý×é Èç¹ûµÚÒ»¸ö²ÎÊýΪ¿ÕµÄ»°ÄÇôִÐÐijÌõÓï¾ä£¬Èç¹ûµÚ¶þ¸ö²ÎÊýΪ¿ÕµÄ»°Ö´ÐÐijÌõÓï¾ä£¬µÚÈý¸ö²ÎÊýΪ¿ÕµÄ»°Ö´ÐÐijÌõÓï¾ä¡£
Ôõô¶ÔÊý×éÖеIJÎÊý½øÐÐÅжϣ¿ Ϊ¿Õ²»Îª¿Õ£¿ ÎÒÓõÄÔöÇ¿forÑ»·
for (String i : param) {
if(i != null || !i.isEmpty()) {
hql.append("where account.user.name like '%");
hql.append(i).append("%'");
}
}
Ò»¸öËÑË÷À¸£¬Ôõô»áÊǸöÊý×éÄØ£¿
ÄãµÃÓзָô·û°É£¬ÕâÑù²ÅÄܽâÎö³ÉÊý×é
¶Ô ÏÖÔÚ¾ÍÏëÖªµÀÔõô²Ù×÷ ͨ¹ý¡°£¬¡±ºÅÀ´·Ö¸î ǰ̨ºÍºǫ́µÄÂé·³¸ø½â´ðÏ лл
requestÀïÃæ²»ÄÜ»ñµÃÊý×é
ÏÈparam.split.
findTheUserAccordingToParam.html?
htmlÒ³Ãæ£¿Óкǫ́Âð£¿
ÓÃ","½«Òª´«µÄ½á¹û¼¯Æ´³É×Ö·û´®£¬´«¸øºǫ́¡£
È»ºóÓÃStringµÄsplit·½·¨²ð·Ö¸
Ïà¹ØÎÊ´ð£º
ÎÒÔÚʹÓÿªÔ´µÄJXL ³öEXCEL±¨±íʱÓöµ½ÕâÑùµÄÎÊÌâ¡£
ÎÒÏë³öµÄÎļþÃû³ÆÊÇÕâÑùµÄ£ºÀý£ºtest_ÀîÇ¿.xls
´úÂëÊÇ ....test_+"UserID"+".xls";
µ«ÊÇ¿ØÖÆÌ¨ÎÒ¿´µ½µÄÊä³öÃû³ÆÐ§¹ûÊÇ£ºtest_µ ......
¸÷λ´óÏÀ¾ÈÃü°¡ £¡£¡
¸Õ×°ÁËSQL2000 sp3
ÏëÓÃJSPÁ¬½ÓÊý¾Ý¿âµ«ÊdzöÏÖÎÊÌâÁË
ÎÒÓõÄÊÇJDK6.0+tomcat5.0+SQL2000 SP3+JDBC sp3
ËüÏÔʾµÄÊÇ
javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver fo ......
Óм¸ÖÖÓû§£¬ÆäȨÏÞ²»Í¬¡£Ö»ÓÐÌØ¶¨È¨ÏÞµÄÓû§²ÅÄܽøÐÐÏàÓ¦²Ù×÷¡£ÎÒÏëÔÚjspÒ³ÃæÀï½øÐÐÕâ¸öÉèÖÃ
<input type="submit" value="ÐÞ¸Ä"/> ,ÎÒÏëÈÃÖ»ÓÐÌØ¶¨È¨ÏÞµÄÓû§²ÅÄܰ´Õâ¸ö°´Å¥£¬·ñÔò±¨ ......