JSP中结合Js制作分页功能--Java免费学习网

<%@ page language="java" import="java.sql.*" pageEncoding="UTF-8"%>
<%
Connection con;
Statement st;
ResultSet rs;
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=MyDatabase";
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
con = DriverManager.getConnection(url, "sa", "");
st = con.createStatement();

int curpage = 1;//当前要显示的页面
int lastpage=0;//最后一页
int pagesize = 4;//页面大小
String topage = request.getParameter("topage");
if (topage != null) {
curpage = Integer.parseInt(topage);
}
if (curpage <= 0) {
curpage = 1;
}
//获取记录条数，用来计算一共有多少页
String sql_page= "select count(*) as recordcount from student";
rs = st.executeQuery(sql_page);
rs.next();
int rowcount=rs.getInt("recordcount");
lastpage=((rowcount % pagesize) == 0 ? (rowcount / pagesize)
: (rowcount / pagesize) + 1);

//获取当前要显示的页面内容
String sql = "select top "
+ pagesize
+ " * from student where xuehao not in(select top "
+ ((curpage-1) * pagesize)
+ " xuehao from student order by xuehao desc)order by xuehao desc";
rs = st.executeQuery(sql);
%>
<table border="1">
<tr>
<td>学号</td>
<td>姓名</td>
<td>操作系统</td>
<td>微机原理</td>
<td>数据结构</td>
<td>修改</td>
<td>删除</td>
</tr>
<%
while (rs.next()) {
%>
<tr>
<td><%=rs.getString("xuehao") %></td>
<td><%=rs.getString("xingming") %></td>
<td><%=rs.getString("czxt") %></td>
<td><%=rs.getString("wjyl") %></td>
<td><%=rs.getString("sjjg") %></td>
<td><a href="modify.jsp?xuehao=<%=rs.getString("xuehao") %>">修改</a></td>
<td><a href="delete.jsp?xuehao=<%=rs.getString("xuehao") %>">删除</a></td>
</tr>
<%
}
st.close();
con.close();
%>
</table>
<table>
<tr>
<td><a href="showSQL.jsp?topage=<%=0%>">第一页</a></td>
<td><a href="showSQL.jsp?topage=<%=curpage - 1%>">上一页</a></td>
<td><a href="showSQL.jsp?topage=<%=((curpage + 1)<lastpage)?(curpage + 1):lastpage%>">下一页</a></td>
<td><a href="showSQL.jsp?topage=<%=lastpage%>">最后一页</a></td>
</tr>

</table>

文章转载自 http://www.javalearns.com/Html/?1619.html


更多Java知识学习请访问 Java免费学习网  http://www.javalearns.com