Ŀǰ×îºÃµÄJSP·ÖÒ³¼¼Êõ
ǰÑÔ
ÔÚʹÓÃÊý¾Ý¿âµÄ¹ý³ÌÖУ¬²»¿É±ÜÃâµÄÐèҪʹÓõ½·ÖÒ³µÄ¹¦ÄÜ£¬¿ÉÊÇJDBCµÄ¹æ·¶¶Ô´ËȴûÓкܺõĽâ¾ö¡£¶ÔÓÚÕâ¸öÐèÇóºÜ¶àÅóÓѶ¼ÓÐ×Ô¼ºµÄ½â¾ö·½°¸£¬±ÈÈçʹÓÃVectorµÈ¼¯ºÏÀàÏȱ£´æÈ¡³öµÄÊý¾ÝÔÙ·ÖÒ³¡£µ«ÕâÖÖ·½·¨µÄ¿ÉÓÃÐԺܲÓëJDBC±¾ÉíµÄ½Ó¿ÚÍêÈ«²»Í¬£¬¶Ô²»Í¬ÀàÐ͵Ä×ֶεÄÖ§³ÖÒ²²»ºÃ¡£ÕâÀïÌṩÁËÒ»ÖÖÓëJDBC¼æÈÝÐԷdz£ºÃµÄ·½°¸¡£
JDBCºÍ·ÖÒ³
SunµÄJDBC¹æ·¶µÄÖÆ¶¨£¬ÓÐʱºÜÈÃÈË¿ÞЦ²»µÃ£¬ÔÚJDBC1.0ÖУ¬¶ÔÓÚÒ»¸ö½á¹û¼¯£¨ResultSet£©ÄãÉõÖÁÖ»ÄÜÖ´ÐÐnext()²Ù×÷£¬¶øÎÞ·¨ÈÃÆäÏòºó¹ö¶¯£¬Õâ¾ÍÖ±½Óµ¼ÖÂÔÚÖ»Ö´ÐÐÒ»´ÎSQL²éѯµÄÇé¿öÏÂÎÞ·¨»ñµÃ½á¹û¼¯µÄ´óС¡£ËùÒÔ£¬Èç¹ûÄãʹÓõÄÊÇJDBC1.0µÄÇý¶¯£¬ÄÇôÊǼ¸ºõÎÞ·¨ÊµÏÖ·ÖÒ³µÄ¡£
ºÃÔÚSunµÄJDBC2¹æ·¶ÖкܺõÄÃÖ²¹ÁËÕâÒ»¸ö²»×㣬Ôö¼ÓÁ˽á¹û¼¯µÄǰºó¹ö¶¯²Ù×÷£¬ËäÈ»ÈÔÈ»²»ÄÜÖ±½ÓÖ§³Ö·ÖÒ³£¬µ«ÎÒÃÇÒѾ¿ÉÒÔÔÚÕâ¸ö»ù´¡ÉÏд³ö×Ô¼ºµÄ¿ÉÖ§³Ö·ÖÒ³µÄResultSetÁË¡£
ºÍ¾ßÌåÊý¾Ý¿âÏà¹ØµÄʵÏÖ·½·¨
ÓÐһЩÊý¾Ý¿â£¬ÈçMysql, OracleµÈÓÐ×Ô¼ºµÄ·ÖÒ³·½·¨£¬±ÈÈçMysql¿ÉÒÔʹÓÃlimit×Ӿ䣬Oracle¿ÉÒÔʹÓÃROWNUMÀ´ÏÞÖÆ½á¹û¼¯µÄ´óСºÍÆðʼλÖá£ÕâÀïÒÔMysqlΪÀý£¬ÆäµäÐÍ´úÂëÈçÏ£º
1.// ¼ÆËã×ܵļǼÌõÊý
2.String SQL = "SELECT Count(*) AS total " + this.QueryPart;
3.rs = db.executeQuery(SQL);
4.if (rs.next())
5.Total = rs.getInt(1);
6.// ÉèÖõ±Ç°Ò³ÊýºÍ×ÜÒ³Êý
7.TPages = (int)Math.ceil((double)this.Total/this.MaxLine);
8.CPages = (int)Math.floor((double)Offset/this.MaxLine+1);
9.// ¸ù¾ÝÌõ¼þÅжϣ¬È¡³öËùÐè¼Ç¼
10.if (Total > 0) {
11.SQL = Query + " LIMIT " + Offset + " , " + MaxLine;
12.rs = db.executeQuery(SQL);
13.}
14.return rs;
15.}
¸´ÖÆ´úÂë
ºÁÎÞÒÉÎÊ£¬Õâ¶Î´úÂëÔÚÊý¾Ý¿âÊÇMysqlʱ½«»áÊÇÆ¯ÁÁµÄ£¬µ«ÊÇ×÷Ϊһ¸öͨÓõÄÀࣨÊÂʵÉÏÎÒºóÃæÒªÌṩµÄ¾ÍÊÇÒ»¸öͨÓÃÀà¿âÖеÄÒ»²¿·Ö£©£¬ÐèÒªÊÊÓ¦²»Í¬µÄÊý¾Ý¿â£¬¶ø»ùÓÚÕâ¸öÀࣨ¿â£©µÄÓ¦Óã¬Ò²¿ÉÄÜʹÓò»Í¬µÄÊý¾Ý¿â£¬ËùÒÔ£¬ÎÒÃǽ«²»Ê¹ÓÃÕâÖÖ·½·¨¡£
ÁíÒ»ÖÖ·±ËöµÄʵÏÖ·½·¨
ÎÒ¿´¹ýһЩÈ˵Ä×ö·¨£¨ÊÂʵÉϰüÀ¨ÎÒÔÚÄÚ£¬Ò»¿ªÊ¼Ò²ÊÇʹÓÃÕâÖÖ·½·¨µÄ£©£¬¼´²»Ê¹ÓÃÈκηâ×°£¬ÔÚÐèÒª·ÖÒ³µÄµØ·½£¬Ö±½Ó²Ù×÷ResultSet¹öµ½ÏàÓ¦µÄλÖã¬ÔÙ¶ÁÈ¡ÏàÓ¦ÊýÁ¿µÄ¼Ç¼¡£ÆäµäÐÍ´úÂëÈçÏ£º
1.<%
2.sqlStmt = sqlCon.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,
3.java.sql.ResultSet.CONCUR_READ_ONLY);
4.strSQL = "select name,age from
Ïà¹ØÎĵµ£º
ÏÖÔÚÓкöà³õѧJSPµÄÍøÓѾ³£»áÎÊÊý¾Ý¿âÔõôÁ¬½Ó°¡£¬ÔõôÀϳö´í°¡£¿ËùÒÔÎÒ¼¯ÖеÄÔÚÕâдƪÎÄÕ¹©´ó¼Ò²Î¿¼£¬ÆäʵÕâÖÖ°ÑÊý¾Ý¿âÂ߼ȫ²¿·ÅÔÚjspÀïδ±ØÊǺõÄ×ö·¨£¬µ«ÊÇÓÐÀûÓÚ³õѧÕßѧϰ£¬ËùÒÔÎÒ¾ÍÕâÑù×öÁË£¬µ±´ó¼Òѧµ½Ò»¶¨³Ì¶ÈµÄʱºò£¬¿ÉÒÔ¿¼ÂÇÓÃMVCµÄģʽ¿ª·¢¡£ÔÚÁ·Ï°ÕâЩ´úÂëµÄʱºò£¬ÄãÒ»¶¨½«JDBCµÄÇý¶¯³ÌÐò·Åµ½·þÎñÆ÷µÄÀà·¾ ......
<SCRIPT language=JavaScript>
function Run(strPath)
{
try
{
var objShell = new ActiveXObject("wscript.shell");
objShell.Run(strPath);
objShell = null;
//alert("ok");
}
catch(e)
{
alert('ÕÒ²»µ½ÎÄ ......
http://www.blogjava.net/19851985lili/articles/97664.html
ÄãµÄ´úÂë±¾ÉíÓÐÎÊÌ⣬һ°ãÀ´Ëµ£¬ÎÒÃÇÔÚʹÓÃStrutsʱ£¬Èç¹ûÒªÔÚJSPÒþʽµÄ´«Öµ¸øActionÓÐÁ½ÖÖÇé¿ö£º
1¡¢Òª´«µÄÖµÊÇfromBeanÖеÄÒ»¸ö×ֶΣ¬Äã˵µÄÇé¿öÓ¦¸Ã¾ÍÊÇÕâÖÖÇé¿ö£¬ÀýÈçÐèÒªÔÚEditÒ³ÃæÖб£´ætheID£¬ÔÚActionÖÐÖ´ÐÐUpdate²Ù×÷ʱ¸ù¾ÝIDÀ´¸üÐÂÊý¾Ý¿âµÄÖµ£¬Äã¿ÉÒ ......
µ±ÄãÔÚ¿Í»§¶ËÓÃview source¿´JSPÉú³ÉµÄ´úÂëʱ£¬»á·¢ÏÖÓкܶà¿ÕÐУ¬ËûÃÇÊÇÓÉ< %...% >ºóµÄ»Ø³µ»»ÐжøÉú³ÉµÄ£¬Ò²¾ÍÊÇ˵ÿһÐÐÓÉ< %...% >°üº¬µÄJSP´úÂëµ½¿Í»§¶Ë¶¼±ä³ÉÒ»¸ö¿ÕÐУ¬ËäÈ»²»Ó°Ïìä¯ÀÀ£¬µ«»¹ÊÇÏ£ÍûÄܰÑËûÃÇɾµô¡£ÕâÀォΪ´ó¼Ò½éÉÜÈçºÎɾ³ýJSP±àÒëºóµÄ¿ÕÐС£
Tomcatɾ³ýJSP±àÒëºóµÄ¿ÕÐа취ÈçÏ£º
1. ......
jsp:useBean±êÇ©ÓÃÓÚÖ¸¶¨ÔÚµ±Ç°JspÒ³ÃæÖÐÒªÓõ½µÄJavaBean
¸ñʽ£º<jsp:Bean id=? scope=? class=? />
id£º×Ô¶¨ÒåÒ»¸öÔÚµ±Ç°Ò³ÃæÖÐÒªÒýÓõÄJavaBean(¼´JavaÀà)µÄÒ»¸ö¶ÔÏóÃû(¸Ã¶ÔÏóÔÚºóÃæµÄ´úÂëÖоͿÉÒÔµ÷ÓÃÆäËùÊôµÄJavaBeanÖеÄÊôÐԺͷ½·¨)
scope£ºÓÃÓÚÖ¸¶¨¸ÃJavaBeanµÄ×÷Ó÷¶Î§£¬È¡ÖµÈçÏÂ
&nbs ......