Ŀǰ×îºÃµÄ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ΪÀý£¬ÆäµäÐÍ´úÂëÈçÏ£º
// ¼ÆËã×ܵļǼÌõÊý
String SQL = "SELECT Count(*) AS total " + this.QueryPart;
rs = db.executeQuery(SQL);
if (rs.next())
Total = rs.getInt(1);
// ÉèÖõ±Ç°Ò³ÊýºÍ×ÜÒ³Êý
TPages = (int)Math.ceil((double)this.Total/this.MaxLine);
CPages = (int)Math.floor((double)Offset/this.MaxLine+1);
// ¸ù¾ÝÌõ¼þÅжϣ¬È¡³öËùÐè¼Ç¼
if (Total > 0) {
SQL = Query + " LIMIT " + Offset + " , " + MaxLine;
rs = db.executeQuery(SQL);
}
return rs;
}
¸´ÖÆ´úÂë
¡¡¡¡ºÁÎÞÒÉÎÊ£¬Õâ¶Î´úÂëÔÚÊý¾Ý¿âÊÇMysqlʱ½«»áÊÇÆ¯ÁÁµÄ£¬µ«ÊÇ×÷Ϊһ¸öͨÓõÄÀࣨÊÂʵÉÏÎÒºóÃæÒªÌṩµÄ¾ÍÊÇÒ»¸öͨÓÃÀà¿âÖеÄÒ»²¿·Ö£©£¬ÐèÒªÊÊÓ¦²»Í¬µÄÊý¾Ý¿â£¬¶ø»ùÓÚÕâ¸öÀࣨ¿â£©µÄÓ¦Óã¬Ò²¿ÉÄÜʹÓò»Í¬µÄÊý¾Ý¿â£¬ËùÒÔ£¬ÎÒÃǽ«²»Ê¹ÓÃÕâÖÖ·½·¨¡£
ÁíÒ»ÖÖ·±ËöµÄʵÏÖ·½·¨
¡¡¡¡ÎÒ¿´¹ýһЩÈ˵Ä×ö·¨£¨ÊÂʵÉϰüÀ¨ÎÒÔÚÄÚ£¬Ò»¿ªÊ¼Ò²ÊÇʹÓÃÕâÖÖ·½·¨µÄ£©£¬¼´²»Ê¹ÓÃÈκηâ×°£¬ÔÚÐèÒª·ÖÒ³µÄµØ·½£¬Ö±½Ó²Ù×÷ResultSet¹öµ½ÏàÓ¦µÄλÖã¬ÔÙ¶ÁÈ¡ÏàÓ¦ÊýÁ¿µÄ¼Ç¼¡£ÆäµäÐÍ´úÂëÈçÏ£º
<%
sqlStmt = sqlCon.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,
java.sql.ResultSet.CONCUR_READ_ONLY);
strSQL = "select name,age fro
Ïà¹ØÎĵµ£º
<%@ page contentType=”text/html; charset=GB2312″ %>
<META http-equiv=Content-Type content=”text/html; charset=gb2312″>
pageEncoding ÊÇjspÎļþ±¾ÉíµÄ±àÂë
contentTypeµÄcharsetÊÇ·þÎñÆ÷·¢Ë͸ø¿Í»§¶ËµÄÄÚÈݵıàÂë¡£
ÔÚÍøÒ³µÄHTMLÔ´´úÂëÖÐÒ»¸öÖØÒªµ ......
1£º³¬Á¬½ÓÌø×ª
ÎÒÃÇÔÚ³¬Á¬½ÓµÄʱºò£¬³£³£Á¬½Óµ½Ò»¸öjsp»òÕßAction,±ÈÈç:
XXX
ÕâÑù×ö»áÓÐÒ»¸öÎÊÌ⣺ÔÚtest.jspÖУ¬³ýÄã´«µÝµÄparam1ºÍparam2²ÎÊýÍâ,ÄãÓÃrequest.getParamter()È¡ÈκÎÔÀ´Ò³ÃæµÄ±íµ¥ÔªËض¼»áΪ¿Õ£¬ÕâÊÇÒòΪÕâÖÖ·½Ê½»á²úÉúеÄrequestÉúÃüÖÜÆÚ£¬ÔÚÕâ¸örequestÖÐÖ»»á°üº¬³¬Á¬½Óºó¸úËæµÄ?param1ÕâÖÖ²ÎÊý£¬ Òò´ ......
Impl
public class BaseDAOImpl extends HibernateDaoSupport implements IBaseDAO
//Ìí¼ÓÊý¾Ý
this.getHibernateTemplate().save(achi);
//ɾ³ý
this.getHibernateTemplate().delete(this.getById(achi));
//²éѯËùÓÐ
return this.getHibernateTemplate().find("from Achievement a ......
package com.demo.filter;
import javax.servlet.Filter;
import javax.servlet.FilterConfig;
import javax.servlet.ServletException;
import javax.servlet.ServletRequest;
import javax.servlet.ServletResponse;
import javax.servlet.FilterChain;
import java.io.IOException;
public class SetCharacterEn ......