首先要配置好Java开发环境,新建一个JSP页面
1.加载驱动
2.获取connection
3.新建命令
4.执行命令查询
5.输出查询结果
6.关闭资源
附上代码
<%@ page language="java" import="java.util.*,java.sql.*" contentType="text/html; charset=gbk"
pageEncoding="gbk"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<h2>Oracle分页案例</h2>
<table>
<tr><td>用户名</td><td>薪水</td></tr>
<%
//加载驱动
Class.forName("oracle.jdbc.driver.OracleDriver");
//得到链接
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:ORCL","scott","tiger");
//新建命令
Statement sm=con.createStatement();
int PageNo=0;
int PageCount=0;
int PageSize=3;
int PageNow=1;
String S_PageNow=(String)request.getParameter("PageNow");
if(S_PageNow!=null)
{
PageNow=Integer.parseInt(S_PageNow);
}
ResultSet pc=sm.executeQuery("select count(*) as pagecount from emp");
while(pc.next())
{
String PageCountstr=pc.getString("pagecount");
PageCount=Integer.parseInt(PageCountstr);
}
if((PageCount%PageSize)==0)
{
PageNo=PageCount/PageSize;
}
else
{
PageNo=(PageCount/PageSize)+1;
}
for(int i=1;i<=PageNo;i++)
{
out.print("<a href='index.jsp?PageNow="+i+"'>"+i+"</a>");
}
//执行SQL
ResultSet rs=sm.executeQuery
("select * from (select t.*,rownum rn from (select * from emp) t where rownum<="+PageNow*PageSize+") where rn>="+((PageNow-1)*PageSize+1)+"");
while(rs.next())
{
out.print("<tr>");
out.print("<td>"+rs.getString("ENAME")+"</td>");
out.print("<td>"+rs.getString("SAL")+"</td>");
out.print("<tr>");
}
//关闭资源
rs.close();
sm.close();
con.close();
%>
</table>
</body>
</html>