当前页面: 开发资料首页 → JSP 专题 → jsp/javabean分页列出数据
摘要: jsp/javabean分页列出数据
我的第一个jsp分页代码
jsp文件:pagedata.jsp //显示数据
javabean:DataConn.java //连接数据库
javabean:GetCount.java //获得数据记录数
DataConn.java文件内容:
package aliang_org;
import java.sql.*;
public class DataConn{
public static Connection getDataConn() {
Connection conn = null;
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=your","your","your");
}
catch(Exception ex) {
ex.printStackTrace();
}
return conn;
}
}
GetCount .java文件内容:
package aliang_org;
import java.sql.*;
import java.util.*;
import java.io.*;
public class GetCount {
private Connection conn;
public GetCount()throws Exception{
conn = DataConn.getDataConn();
}
public int getCounter()throws Exception{
int ret = 0;
Statement stmt = conn.createStatement();
ResultSet rset = stmt.executeQuery("select count(*) from UserInfos");
while(rset.next()){
ret = rset.getInt(1);
}
return ret;
}
}
pagedata.jsp 文件内容:
<%@ page contentType="text/html; charset=gb2312" language="java"%>
<%@ page import = "aliang_org.*"%>
<%@ page import = "java.util.*"%>
<%@ page import = "java.io.*"%>
<%@ page import = "java.sql.*"%>
<head>
//得到请求页
if(request.getParameter("pages") == null){
pages = 1;
}else{
pages = new Integer(request.getParameter("pages")).intValue();
}
//得到当前实际页面
if(pages > pageCount){
nowPages = 1;
}else{
nowPages = pages;
}
//获取记录集
Connection conn = dataConnection.getDataConn();
ResultSet rs = conn.createStatement().executeQuery("Select top "+ countPerPage +" * from UserInfos where ID not in (select top "+ (nowPages-1)*countPerPage +" ID from UserInfos order by id desc) order by ID desc");
while(rs.next()){
int ID = rs.getInt("ID");
String username = rs.getString("username");
String password = rs.getString("password");
String email = rs.getString("email");
%>
<tr>
<td align="center"><%= ID %></td>
<td><%= username %></td>
<td><%= password %></td>
<td><%= email %></td>
<td align="center">">修改</td>
<td align="center">">删除</td>
</tr>
<%
}
//关闭连接
rs.close();
conn.close();
%>
<form method="get">
<tr align="right">
<td colspan="6">共有<%= recordCount %>条记录 当前<%= nowPages %>/<%= pageCount %>页
<% if(pageCount > 1){ %>
<% if(pages > 1){%>
首页
<%}if(pages < pageCount){%>
">下一页
<%}if(pages != 1){%>
">上一页
<%}%>
">尾页
<% } %>跳转到
<select name="pages" onChange="javascript:this.form.submit();">
<% for(int i=1;i<=pageCount;i++){%>
<option value="<%= i %>" <% if(nowPages == i){%>selected<% } %>><%= i %></option>
<% } %>
</select>页</td>
</tr>
</form>
</table>
还有不要忘了把sql-jdbc驱动安装了,并拷贝C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib文件夹到web目录下的WEB-INF下面。
最近刚刚开始搞java,还请各位大虾赐教email:webmaster@aliang.org,呵呵