本文介绍了一个使用JSP实现的数据库记录分页显示应用案例。通过设置数据库连接参数和页面显示数量，实现了对数据库表中记录的有效管理和展示。用户可以点击前后页按钮浏览不同批次的数据。
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@page import="com.srj.text.*" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<jsp:useBean id="look" class="com.srj.text.ShowRecordByPage" scope="session"></jsp:useBean>
<jsp:setProperty property="databaseName" name="look" value="test2"/>
<jsp:setProperty property="tableName" name="look" value="message"/>
<jsp:setProperty property="user" name="look" value="root"/>
<jsp:setProperty property="password" name="look" value="770880"/>
<jsp:setProperty property="pageSize" name="look" value="5"/>
<head>
<title>My JSP 'showRecord.jsp' starting page</title>
</head>
<body background="b2.jpg">
数据库
<jsp:getProperty property="databaseName" name="look"/>中
<jsp:getProperty property="tableName" name="look"/>表的记录将被分页显示
<br>共有<jsp:getProperty property="pageAllCount" name="look"/>页
每页最多显示<jsp:getProperty property="pageSize" name="look"/>条记录
<jsp:setProperty property="showPage" name="look"/>
<jsp:getProperty property="presentPageResult" name="look"/> presentPageResult
<br>单击“前一页”或“后一页”按钮查看记录（当前显示第<jsp:getProperty property="showPage" name="look"/>页）
<table>
<tr>
<td><form action="" method="post">
<input type="hidden" name="showPage" value="<%=look.getShowPage()-1 %>">
<input type="submit" name="g" value="前一页">
</form>
</td>
<td><form action="" method="post">
<input type="hidden" name="showPage" value="<%=look.getShowPage()+1 %>">
<input type="submit" name="g" value="后一页">
</form>
</td>
<td><form action="" method="post">
<input type="text" name="showPage" >
<input type="submit" name="g" value="提交">
</form>
</td>
</tr>
</table>
</body>
</html>
<%@page import="com.srj.text.*" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<jsp:useBean id="look" class="com.srj.text.ShowRecordByPage" scope="session"></jsp:useBean>
<jsp:setProperty property="databaseName" name="look" value="test2"/>
<jsp:setProperty property="tableName" name="look" value="message"/>
<jsp:setProperty property="user" name="look" value="root"/>
<jsp:setProperty property="password" name="look" value="770880"/>
<jsp:setProperty property="pageSize" name="look" value="5"/>
<head>
<title>My JSP 'showRecord.jsp' starting page</title>
</head>
<body background="b2.jpg">
数据库
<jsp:getProperty property="databaseName" name="look"/>中
<jsp:getProperty property="tableName" name="look"/>表的记录将被分页显示
<br>共有<jsp:getProperty property="pageAllCount" name="look"/>页
每页最多显示<jsp:getProperty property="pageSize" name="look"/>条记录
<jsp:setProperty property="showPage" name="look"/>
<jsp:getProperty property="presentPageResult" name="look"/> presentPageResult
<br>单击“前一页”或“后一页”按钮查看记录（当前显示第<jsp:getProperty property="showPage" name="look"/>页）
<table>
<tr>
<td><form action="" method="post">
<input type="hidden" name="showPage" value="<%=look.getShowPage()-1 %>">
<input type="submit" name="g" value="前一页">
</form>
</td>
<td><form action="" method="post">
<input type="hidden" name="showPage" value="<%=look.getShowPage()+1 %>">
<input type="submit" name="g" value="后一页">
</form>
</td>
<td><form action="" method="post">
<input type="text" name="showPage" >
<input type="submit" name="g" value="提交">
</form>
</td>
</tr>
</table>
</body>
</html>
扫一扫
2557
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
