jsp+oracle 实现简单的分页

最新推荐文章于 2021-04-11 15:18:42 发布

josephiney

最新推荐文章于 2021-04-11 15:18:42 发布

阅读量4.9k

点赞数 2

分类专栏： JAVA学习文章标签： oracle jsp string 数据库驱动程序 exception list

本文链接：https://blog.csdn.net/josephiney/article/details/6989841

版权

JAVA学习专栏收录该内容

4 篇文章 0 订阅

订阅专栏

list_emp.jsp

代码如下：

<%@ page contentType="text/html" pageEncoding="GBK"%>
<%@ page import="java.sql.*"%>
<html>
<head><title>java study</title></head>
<body>
<%!
	//定义数据库驱动程序
	public static final String DBDRIVER="oracle.jdbc.driver.OracleDriver";
	//数据库连接地址
	public static final String DBURL="jdbc:oracle:thin:@localhost:1521:yy";
	public static final String DBUSER="scott";
	public static final String DBPASS="tiger";

%>
<%
	Connection conn=null;
	PreparedStatement pstmt=null;
	ResultSet rs=null;
%>
<%
try{
	Class.forName(DBDRIVER);
	conn=DriverManager.getConnection(DBURL,DBUSER,DBPASS);
	int pageSize=3;
	int pageNow=1;//默认显示第一页
	int rowCount=0;//总笔数
	int pageCount=0;
	String s_pageNow=(String)request.getParameter("pageNow");
	if(s_pageNow!=null){
		pageNow = Integer.parseInt(s_pageNow);
	}
	String sql1 = "select count(*) from emp";
	pstmt=conn.prepareStatement(sql1);
	rs=pstmt.executeQuery();
	if(rs.next()){
		rowCount = rs.getInt(1);
	}
	if(rowCount%pageSize==0){
		pageCount = rowCount/pageSize;
	}else{
		pageCount = rowCount/pageSize + 1;
	}
	String sql="SELECT empno,ename,job,hiredate,sal FROM (select a1.*,rownum rn from (select * from emp order by sal desc) a1 WHERE  rownum<="+pageSize*pageNow+") where  rn>="+((pageNow-1)*pageSize+1);
	pstmt=conn.prepareStatement(sql);
	rs=pstmt.executeQuery();
%>
<center>
	<table border="1" width="80%">
		<tr>
			<td>雇员编号</td>
			<td>雇员姓名</td>
			<td>雇员工作</td>
			<td>雇员日期</td>
			<td>雇员工资</td>
		</tr>
<%
	while(rs.next()){
		int empno=rs.getInt(1);
		String ename=rs.getString(2);
		String job=rs.getString(3);
		java.util.Date date=rs.getDate(4);
		float sal=rs.getFloat(5);
%>
		<tr>
			<td><%=empno%></td>
			<td><%=ename%></td>
			<td><%=job%></td>
			<td><%=date%></td>
			<td><%=sal%></td>
		</tr>
<%
	}
%>
	</table>
<form   Action= ""   method= "post"> 
<%  
for(int i=1;i<=pageCount;i++){ 
	out.println("<a href=list_emp.jsp?pageNow="+i+">["+i+"]</a>"); 
} 
if(pageNow != 1){ 
	out.println( " <a  href=list_emp.jsp?pageNow=1>首页</a> "); 
	out.println( " <a   href=list_emp.jsp?pageNow="+(pageNow - 1)+">上一页</a> "); 
} 
if(pageNow != pageCount){ 
	out.println( " <a   href= list_emp.jsp?pageNow="+ (pageNow + 1)+"> 下一页</a>"); 
	out.println( " <a   href= list_emp.jsp?pageNow="+ pageCount+"> 最后一页</a>"); 
} 
%>
</form>
</center>
<%
}catch(Exception e){
	System.out.println(e);
}
finally{
	try{
		rs.close();
		pstmt.close();
		conn.close();
	}catch(Exception e){
		System.out.println(e);
	}
}
%>
</body>
</html>

josephiney

关注

2
点赞
踩
7

收藏

觉得还不错? 一键收藏
2
评论
jsp+oracle 实现简单的分页

list_emp.jsp代码如下：java study<%! //定义数据库驱动程序 public static final String DBDRIVER="oracle.jdbc.driver.OracleDriver"; //数据库连接地址 public static final String DBURL="jdbc:oracle:thin:@lo
复制链接

扫一扫