81,122
社区成员




package page;
import page.*;
public class pagebean {
private int currentPage;//当前页数
private int countRecord;//总记录条数
private int countPage;//总页数
private int sizePage;//每页记录条数
public void setAll(int _countRecord,int _sizePage)
//设置四个成员变量的值
{
countRecord=_countRecord;
sizePage=_sizePage;
if(countRecord%sizePage==0)
countPage=countRecord/sizePage;
else
countPage=countRecord/sizePage+1;
currentPage=1;
}
public int getCurrentPage() {
return currentPage;
}
public int getCountPage() {
return countPage;
}
public long getCountRecord() {
return countRecord;
}
public int getSizePage() {
return sizePage;
}
public void setCurrentPage(int currentPage) {
this.currentPage = currentPage;
}
}
package page; //本javabean处于page包中
import java.sql.*;
public class conndb {
private Connection con;
private ResultSet rs;
public static Connection getConnection() throws SQLException {
try {
//连接MS SQL Server数据库
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
} catch (ClassNotFoundException ex) {
ex.printStackTrace();
return null;
}
return DriverManager.getConnection(
"jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=guestinfo","sa","");
//设置连接的数据库名,登陆的用户名和密码
}
//执行SQL语句的查询操作
public ResultSet executeQuery(String sql) {
try {
con = conndb.getConnection();
Statement statement = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs = statement.executeQuery(sql);
}
catch(SQLException ex)
{
}
return rs;
}
//执行SQL语句的更新操作
public int executeUpdate(String sql)
{
int count = 0;
Statement stmt = null;
try
{
con = conndb.getConnection();
stmt = con.createStatement();
count = stmt.executeUpdate(sql);
}
catch(SQLException ex)
{
}
finally
{
try
{
if(stmt != null)
stmt.close();
if(con != null)
con.close();
}
catch(SQLException ex)
{
System.err.print(ex);
}
}
return count;
}
//释放数据集rs,关闭数据库连接
public void freeRs(ResultSet rs)
{
try
{
if(rs != null)
{
rs.close();
con.close();
}
}
catch(Exception e)
{
}
}
}
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<%@ page import="page.*" %> //这两个javabean都在page包中
<jsp:useBean id="pagebean" scope="session" class="page.pagebean"/>
<jsp:useBean id="databean" scope="session" class="page.conndb"/>
<HTML>
<title>用户数据</title>
<BODY>
<%
ResultSet rs;
String sql="SELECT * FROM guestinfo"; //查询表guestinfo中的所有数据
rs=databean.executeQuery(sql); //执行sql语句,使用了javabean conndb中的executeQuery
String pages=request.getParameter("dipage"); //读取当前的页数
rs.last();
int countRecord=rs.getRow(); //得到记录的条数
int countPageRecord=5; //设置每页记录条数
if(pages==null||(pages.trim()).length()==0) //如果当前页数不存在,也就是初次进入页面
pagebean.setAll(countRecord,countPageRecord); //参数初始化,使用javabean pagebean中的setall,当前页数设为1
else
{
try
{
pagebean.setCurrentPage(Integer.parseInt(pages));
}
catch(Exception e)
{
out.println("参数不正确!");
}
}
//当前记录号
int currentRecord=(pagebean.getCurrentPage()-1)*pagebean.getSizePage();
if(currentRecord==0)
rs.beforeFirst();
else
rs.absolute(currentRecord);
//显示当前页数据
out.print("<Table Border style='font-size: 10pt'>");
out.print("<TR><td colspan=8 align=center>用户数据</td></tr>");
out.print("<TR>");
out.print("<Td width=60 >"+"用户ID号");
out.print("<Td width=50 >"+"用户名");
out.print("<Td width=100>"+"用户真实姓名");
out.print("<Td width=40>"+"年龄");
out.print("<Td width=40>"+"邮政编码");
out.print("<Td width=100>"+"联系地址");
out.print("<Td width=100>"+"联系电话");
out.print("<Td width=100>"+"email");
out.print("</TR>");
int i=0;
while(rs.next())
{ out.print("<TR>");
out.print("<TD >"+rs.getLong(1)+"</TD>");
out.print("<TD >"+rs.getString("guestname")+"</TD>");
out.print("<TD >"+rs.getString("name")+"</TD>");
out.print("<TD >"+rs.getInt("age")+"</TD>");
out.print("<TD >"+rs.getString("postcode")+"</TD>");
out.print("<TD >"+rs.getString("address")+"</TD>");
out.print("<TD >"+rs.getString("tel")+"</TD>");
out.print("<TD >"+rs.getString("email")+"</TD>");
out.print("</TR>") ;
i++;
if(i>=pagebean.getSizePage()) break; //当前页显示完,则退出循环
}
out.print("<TR><td colspan=8 align=center>");
out.print("共"+pagebean.getCountRecord()+"条记录,共"+pagebean.getCountPage()+"页,当前第"+pagebean.getCurrentPage()+"页,每页"+pagebean.getSizePage()+"条记录,");
if(pagebean.getCurrentPage()==1)//当前是首页
;
else//当前不是首页
{
out.print("<a href=usepage.jsp?dipage=1>首页</a>,");
out.print("<a href=usepage.jsp?dipage="+(pagebean.getCurrentPage()-1)+">上一页</a>,");
}
if(pagebean.getCurrentPage()==pagebean.getCountPage())//当前是末页
;
else//当前不是末页
{
out.print("<a href=usepage.jsp?dipage="+(pagebean.getCurrentPage()+1)+">下一页</a>,");
out.print("<a href=usepage.jsp?dipage="+pagebean.getCountPage()+">末页</a>");
}
out.print("</td></tr>");
out.print("</Table>");
databean.freeRs(rs); //释放rs
%>
</BODY>
</HTML>