分页 jsp分页用for怎样实现 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 jsp用for实现分页???没能理解楼主的意思,希望下面的例子对你有用,该例子有些是写死的,你也可以写成动态的,自己加油琢磨一下下吧。jsp+oracle实现分页简单例子:<%@ page language="java" import="java.util.*,java.sql.*" pageEncoding="utf-8"%><%@page import="java.beans.IntrospectionException"%><% String path = request.getContextPath(); String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort() + path + "/";%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html> <head> <base href="<%=basePath%>"> <title>My JSP 'fenye .jsp' starting page</title> <meta http-equiv="pragma" content="no-cache"> <meta http-equiv="cache-control" content="no-cache"> <meta http-equiv="expires" content="0"> <meta http-equiv="keywords" content="keyword1,keyword2,keyword3"> <meta http-equiv="description" content="This is my page"> <!-- <link rel="stylesheet" type="text/css" href="styles.css"> --> </head> <body> <table border=1> <tr> <td> 员工编号 </td> <td> 员工姓名 </td> <td> 员工职位 </td> <td> 员工薪水 </td> </tr> <% int pageSize = 3; //定义每页显示几条记录 int pageNow = 1; //定义要显示第几页 int pageCount = 0; //定义一共有几页 int rowCount = 0; //一共有朵少条记录 //连接字符串 Class.forName("oracle.jdbc.driver.OracleDriver"); Connection conn = DriverManager.getConnection( "jdbc:oracle:thin:@localhost:1521:sg186nd", "zhanshen_zhang", "zhang"); Statement st = conn.createStatement(); ResultSet rs1 =st.executeQuery("select count(*) from emp"); String sPageNow=request.getParameter("pageNow"); System.out.println(sPageNow); pageNow=Integer.parseInt(sPageNow); System.out.println(pageNow); ResultSet rs = st .executeQuery("select * from emp where empno not in (select empno from emp where rownum<=('" + pageNow + "'-1)*3) and rownum<=3"); while (rs.next()) { %> <tr> <td> <% out.println(rs.getInt(1)); %> </td> <td> <% out.println(rs.getString(2)); %> </td> <td> <% out.println(rs.getString(3)); %> </td> <td> <% out.println(rs.getInt(4)); %> </td> </tr> <% } %> </table> <br /> <% for(int i=1;i<=5;i++){ out.println("<a href=fenye.jsp?pageNow="+i+">["+i+"]</a>"); } %> </body></html> HOME_ning(玩物丧志) 用pager-taglib,这个功能还算比较强 什么叫效率,速度?占用资源少?读写快?谁来指教? 高分求思路: 关于得到在线用户,这样做是否正确? 大家帮下! 学习jsp大家给点提示! input1輸入數字,要如何連到特定網站抓文字填入input2 怎样做一个.exe的可执行文件?? mondrian result 关于文件上传和下载的问题 【求教】优酷视频处理算法 xiaofenguser(风雨) 乱码???????问题请进啊!! 页面计数器 页面计数器二
该例子有些是写死的,你也可以写成动态的,自己加油琢磨一下下吧。jsp+oracle实现分页简单例子:
<%@ page language="java" import="java.util.*,java.sql.*"
pageEncoding="utf-8"%>
<%@page import="java.beans.IntrospectionException"%><%
String path = request.getContextPath();
String basePath = request.getScheme() + "://"
+ request.getServerName() + ":" + request.getServerPort()
+ path + "/";
%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>"> <title>My JSP 'fenye .jsp' starting page</title> <meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
--> </head> <body>
<table border=1>
<tr>
<td>
员工编号
</td>
<td>
员工姓名
</td>
<td>
员工职位
</td>
<td>
员工薪水
</td>
</tr>
<% int pageSize = 3; //定义每页显示几条记录
int pageNow = 1; //定义要显示第几页
int pageCount = 0; //定义一共有几页
int rowCount = 0; //一共有朵少条记录 //连接字符串
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:sg186nd",
"zhanshen_zhang", "zhang");
Statement st = conn.createStatement();
ResultSet rs1 =st.executeQuery("select count(*) from emp");
String sPageNow=request.getParameter("pageNow");
System.out.println(sPageNow);
pageNow=Integer.parseInt(sPageNow);
System.out.println(pageNow);
ResultSet rs = st
.executeQuery("select * from emp where empno not in (select empno from emp where rownum<=('"
+ pageNow + "'-1)*3) and rownum<=3"); while (rs.next()) {
%>
<tr>
<td>
<%
out.println(rs.getInt(1));
%>
</td>
<td>
<%
out.println(rs.getString(2));
%>
</td>
<td>
<%
out.println(rs.getString(3));
%>
</td>
<td>
<%
out.println(rs.getInt(4));
%>
</td>
</tr>
<%
}
%> </table>
<br />
<%
for(int i=1;i<=5;i++){
out.println("<a href=fenye.jsp?pageNow="+i+">["+i+"]</a>");
}
%>
</body>
</html>
HOME_ning(玩物丧志)