|
|
开放源代码的，把常用的JSP分页代码封装的很好！重用性高，也灵活。推荐！
下载和使用介绍去这里www.lucas-lee.com
例子：
<%@ page contentType="text/html; charset=GBK" %>
<%@page import="com.lucaslee.tools.paging.*,java.sql.*,java.util.*" %>
<html>
<head>
<title>
Pageing
</title>
</head>
<body bgcolor="#ffffff">
<%
String tradeMark=request.getParameter("tradeMark");
%>
<form name="form1" action="" method="post">
商标：<input type=text name="tradeMark" value="<%=(tradeMark==null?"":tradeMark)%>">
<input type="submit" value="查询">
</form>
<%
String whereSql=(tradeMark==null?"":" where tradeMark like '%"+tradeMark+"%'");
Connection con=null;
Class.forName("oracle.jdbc.driver.OracleDriver");
con=DriverManager.getConnection("jdbc:oracle:thin:@t3:1521:ora",
"username", "username");
BusinessObjFactory f=new BusinessObjFactory(){
public Object getBusinessObj(ResultSet rs)throws PagingException{
Vector v=new Vector();
try{
v.add(rs.getString(1));
v.add(rs.getString(2));
v.add(rs.getString(3));
v.add(rs.getString(4));
} catch(SQLException ex){
ex.printStackTrace();
throw new PagingException(ex.getMessage());
}
return v;
}
};
out.println("<form name=form1>");
Page p=Page.getPage("select count(*) from marketpriceview"+whereSql
,"select * from marketpriceview"+whereSql
,con,f,5,request);
out.println(p.getPagingHTMLCode("form1"));
Iterator itr=p.getData().iterator();
int count=0;
out.print("<table border=1 width=\"75%\">");
while(itr.hasNext()){
Vector v=(Vector)itr.next();
count++;
out.print("<tr><td>"+count);
for (int i = 0; i < v.size(); i++) {
out.print("<td>"+(String)v.elementAt(i));
}
}
out.println("</table>");
out.println(p.getPagingHTMLCode("form1"));
out.println("</form>");
con.close();
%>
</body>
</html>
|
|
