怎么实现CSDN里的分页显示?如1 2 3 4....等
最好能有源代码!
最好能有源代码!
解决方案 »
- Unexpected exception parsing XML document from ServletContext resource
- http://reg.163.com/Main.jsp?username=aihuichuanshuo
- 关于中文无法登陆的问题
- frame 取值 问题
- request.getSession().getServletContext().getRealPath("/")
- JSP 用file浏览用button来提交浏览的文件txt类型的。
- JSP内部对象详解(连载)
- ireport 里如何实现word里的分散排列
- 测试问题
- 在jsp里用jsp:useBean创建bean是能否往构造函数里穿参数
- jbuilder 9与weblogic server815整合出错
- 求一个正则表达式,要把里面符合条件的子串提取出来,然后生成数组。谢谢
然后用循环把URL填充上。
就这么简单。
<%jbean.jobsBean objB = new jbean.jobsBean(); %>
<html>
<head>
<title>
jsp1
</title>
</head>
<body bgcolor="#ffffff">
<table border="1">
<tr>
<th>Job_ID</th>
<th>Job_Desc</th>
<th>Job_Min</th>
<th>Job_Max</th>
</tr>
<%
String s = request.getParameter("page");
if(s==null){s="1";}
ArrayList objAL = objB.query(s);
//if(objAL==null){ ;}
for(int i=0;i<objAL.size();i++){
objB = (jbean.jobsBean)objAL.get(i);
%>
<tr>
<td><%=objB.getJob_id() %></td>
<td><%=objB.getJob_desc() %></td>
<td><%=objB.getMin() %></td>
<td><%=objB.getMax() %></td>
</tr>
<%} %>
</table>
---------------------csdn--------------------------<br />
<%
int sumPage = objB.getMaxPage();
for(int i=1;i<=sumPage;i++){
%>
<a href="jsp1.jsp?page=<%=i%>"><%=i %></a>
<%} %>
</body>
</html>
import java.util.*;public class jobsBean {
jbean.conBean objconBean = jbean.conBean.newInstanse();
private int job_id;
private String job_desc;
private int min;
private int max;
Connection con = null;
private int curPage=1;
private int maxPage;
private int rowsInPage=5; public jobsBean() {
this.init();
} public void setJob_id(int job_id) {
this.job_id = job_id;
} public void setJob_desc(String job_desc) {
this.job_desc = job_desc;
} public void setMin(int min) {
this.min = min;
} public void setMax(int max) {
this.max = max;
} public void setCurPage(int curPage) {
this.curPage = curPage;
} public void setMaxPage(int maxPage) {
this.maxPage = maxPage;
} public int getJob_id() {
return job_id;
} public String getJob_desc() {
return job_desc;
} public int getMin() {
return min;
} public int getMax() {
return max;
} public int getCurPage() {
return curPage;
} public int getMaxPage() {
return maxPage;
} public ArrayList query(String page)
{
ArrayList objAL = new ArrayList();
try
{
int pageNum = Integer.parseInt(page);
jobsBean objBean = new jobsBean();
con = objconBean.getConn();
Statement sm = con.createStatement();
ResultSet rs = sm.executeQuery("select top "+pageNum*this.rowsInPage+" * from jobs");
int i=1;
while(rs.next())
{
if(i>(pageNum-1)*this.rowsInPage){
objBean = new jobsBean();
objBean.setJob_id(rs.getInt(1));
objBean.setJob_desc(rs.getString(2));
objBean.setMin(rs.getInt(3));
objBean.setMax(rs.getInt(4));
objAL.add(objBean);
}
i++;
}
objBean.setCurPage(pageNum);
rs.close();
sm.close();
}
catch(Exception ex)
{
System.out.println(ex);
}
finally
{
try {
if(con!=null)
con.close();
}
catch (Exception ex) {
System.out.println(ex);
}
}
return objAL;
} public void init()
{
int result=0;
try
{
con = objconBean.getConn();
Statement sm = con.createStatement();
ResultSet rs = sm.executeQuery("select count(*) from jobs");
while(rs.next())
{
result=rs.getInt(1);
}
rs.close();
sm.close();
}
catch(Exception ex)
{
System.out.println(ex);
}
finally
{
try {
if(con!=null)
con.close();
}
catch (Exception ex) {
System.out.println(ex);
}
}
if(result%this.rowsInPage==0)
{
this.maxPage=result/this.rowsInPage;
}
else
{
this.maxPage=result/this.rowsInPage+1;
}
}
}
static conBean cb = new conBean();
public conBean() {
} public static conBean newInstanse()
{
return cb;
} public Connection getConn()
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn=DriverManager.getConnection("jdbc:odbc:pubs");
}
catch(Exception ex)
{
System.out.println(ex);
}
return conn;
}
}