关于jsp分页,有什么方法?什么是cach分页?讲讲方法,给个例子!谢谢! 最简单就是先查询数据库用数组保存,最后按n条调出,实现分页,但这只适合小型数据库,大型数据库,可以做个bean来分页。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 http://www.hnitline.com/bbs/dispbbs.asp?boardID=18&ID=807目前最好的分页技术思想确实很好,看看就知道了! 在新版本的JSPStudio中,通过向导,只要输入一个文件名和选择数据源,自动产生所有数据库操作和表格分页显示,下载地址:ftp://162.105.80.43/incoming/例如:输入文件名:TEST,并通过ODBC选择数据源,自动产生如下6个文件:TEST.javaTESTAction.javaTESTDAO.javaTESTForm.javaTEST.jspTESTOut.jsp代码见:http://expert.csdn.net/Expert/topic/2228/2228055.xml?temp=.1732599 package hzdq.fdjc.Common;import java.sql.*;import java.util.*;/** * Title:分页 * Description: * Copyright: Copyright (c) 2004 * Company: * author:颜喜班 * @version 1.0 */public class SplitPager{ /* * _sql_str:传入的sql语句 * _total_records: 总记录数目 * _pageSize: 每页显示的记录数目 * _page: 所分的逻辑页数 */ private Connection con=null; private Statement stmt=null; private ResultSet rs=null; private ResultSetMetaData rsmd=null; private String _sql_str; private int _total_records; private int _pages; private int _pagesize; public void setConnection(Connection con) { this.con=con; if (this.con == null) System.out.println("Failure to get a connection!"); else System.out.println("Success to get a connection!"); } public void initialize(String sqlStr,int pageSize) { this._sql_str=sqlStr; this._pagesize=pageSize; try{ stmt=this.con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY); rs=stmt.executeQuery(this._sql_str); rsmd=rs.getMetaData(); if (rs!=null) { rs.last(); this._total_records = rs.getRow(); rs.first(); this._pages = (this._total_records - 1) / this._pagesize + 1; } } catch(SQLException e){System.out.println(e.toString()); } } public Vector getPage(int ipage){ Vector vData=new Vector(); int n=ipage; int m=0; m=(n-1)*this._pagesize+1; try{ if (rs!=null) { rs.absolute(m); for(int i=0;i<this._pagesize;i++){ String[] sData=new String[rsmd.getColumnCount()]; for(int j=0;j<rsmd.getColumnCount();j++) { sData[j]=rs.getString(j+1); } if (sData==null) { break; } vData.addElement(sData); rs.next(); } } rs.close(); stmt.close(); } catch(SQLException e){System.out.println(e.toString()); } return vData; } public int getPages() { return this._pages; } public int getTotalRecords() { return this._total_records; }} jquery里调用post方法,IE里面是中文是乱码,FF是好的 tomcat中多资源配置文件如何显示中文 iReport 简单问题,欢迎进来救急呀。100分送上 用jsp怎样实现打印票据的功能?高手进 HELP!!!!HELP!!!! 用 SmartUpload 上传文件出错的问题! 数据库操作问题 在javabean里不能用session.getValue吗? 讨论 数据库做多表查询 用JSP来做WEB数据库的开发比ASP好多少?开发出的程序性能如何?如能详细说明定送高分。 分页显示问题 有人用JavaBean写过分页程序没有?讨论!
TEST.java
TESTAction.java
TESTDAO.java
TESTForm.java
TEST.jsp
TESTOut.jsp代码见:
http://expert.csdn.net/Expert/topic/2228/2228055.xml?temp=.1732599
import java.util.*;/**
* Title:分页
* Description:
* Copyright: Copyright (c) 2004
* Company:
* author:颜喜班
* @version 1.0
*/
public class SplitPager
{
/*
* _sql_str:传入的sql语句
* _total_records: 总记录数目
* _pageSize: 每页显示的记录数目
* _page: 所分的逻辑页数
*/
private Connection con=null;
private Statement stmt=null;
private ResultSet rs=null;
private ResultSetMetaData rsmd=null;
private String _sql_str;
private int _total_records;
private int _pages;
private int _pagesize;
public void setConnection(Connection con)
{
this.con=con;
if (this.con == null)
System.out.println("Failure to get a connection!");
else
System.out.println("Success to get a connection!");
}
public void initialize(String sqlStr,int pageSize)
{
this._sql_str=sqlStr;
this._pagesize=pageSize;
try{
stmt=this.con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
rs=stmt.executeQuery(this._sql_str);
rsmd=rs.getMetaData();
if (rs!=null)
{
rs.last();
this._total_records = rs.getRow();
rs.first();
this._pages = (this._total_records - 1) / this._pagesize + 1;
}
}
catch(SQLException e){System.out.println(e.toString()); }
}
public Vector getPage(int ipage){
Vector vData=new Vector();
int n=ipage;
int m=0;
m=(n-1)*this._pagesize+1;
try{
if (rs!=null)
{
rs.absolute(m);
for(int i=0;i<this._pagesize;i++){
String[] sData=new String[rsmd.getColumnCount()];
for(int j=0;j<rsmd.getColumnCount();j++)
{
sData[j]=rs.getString(j+1);
}
if (sData==null)
{
break;
}
vData.addElement(sData);
rs.next();
}
}
rs.close();
stmt.close();
}
catch(SQLException e){System.out.println(e.toString()); }
return vData;
}
public int getPages()
{
return this._pages;
}
public int getTotalRecords()
{
return this._total_records;
}}