<%@ pagecontenttype="text/html;charset=utf-8" pageencoding="utf-8"%>
<%@ page language="java"import="java.sql.*" %>
<scriptlanguage="javascript">
function newwin(url) {
var
newwin=window.open(url,"newwin","toolbar=no,location=no,directories=no,status=no,
menubar=no,scrollbars=yes,resizable=yes,width=600,height=450");
newwin.focus();
return false;
}
</script>
function submit10()
{
self.location.replace("fenye.jsp")
<%//变量声明
java.sql.connection sqlcon; //数据库连接对象
java.sql.statement sqlstmt; //sql语句对象
java.sql.resultset sqlrst; //结果集对象
java.lang.string strcon; //数据库连接字符串
java.lang.string strsql; //sql语句
int intpagesize; //一页显示的记录数
int introwcount; //记录总数
int intpagecount; //总页数
int intpage; //待显示页码
java.lang.string strpage;
int i;
//设置一页显示的记录数
intpagesize = 10;
//取得待显示页码
strpage =request.getparameter("page");
if(strpage==null){//表明在querystring中没有page这一个参数，此时显示第一页数据
intpage = 1;
else{//将字符串转换成整型
intpage =java.lang.integer.parseint(strpage);
if(intpage<1) intpage = 1;
//装载jdbc驱动程序
class.forname("com.microsoft.sqlserver.jdbc.sqlserverdriver");
//设置数据库连接字符串
strcon ="jdbc:sqlserver://192.168.0.117;databasename=northwind";
//连接数据库
sqlcon = java.sql.drivermanager.getconnection(strcon,"sa","admin");
//创建一个可以滚动的只读的sql语句对象
sqlstmt=sqlcon.createstatement(java.sql.resultset.type_scroll_insensitive,java.sql.resultset.concur_read_only);//准备sql语句
strsql = "select * from etsa";
//执行sql语句并获取结果集
sqlrst = sqlstmt.executequery(strsql);
//获取记录总数
sqlrst.last();//??光标在最后一行
introwcount = sqlrst.getrow();//获得当前行号
//记算总页数
intpagecount = (introwcount+intpagesize-1)/ intpagesize;
//调整待显示的页码
if(intpage>intpagecount) intpage =intpagecount;
%>
<html>
<head>
<metahttp-equiv="content-type" content="text/html;charset=utf-8">
<title>分頁</title>
</head>
<body>
<form method="post"action="">
第<%=intpage%>页 共<%=intpagecount%>页
<%if(intpage<intpagecount){%>
<ahref="fenye.jsp?page=<%=intpage+1%>">下一页</a>
<%}%>
<%if(intpage>1){%>
<ahref="fenye.jsp?page=<%=intpage-1%>">上一页</a>
转到第:<inputtype="text" name="page" size="8"> 页
<input type="submit"value="go" name="cndok">
</form>
<table border="1"cellspacing="0" cellpadding="0">
<%
if(intpagecount>0){
//将记录指针定位到待显示页的第一条记录上
sqlrst.absolute((intpage-1) * intpagesize +1);
//显示数据
i = 0;
string user_id,user_name;
while(i<intpagesize &&!sqlrst.isafterlast()){
user_id=sqlrst.getstring(1);
user_name=sqlrst.getstring(2);
<tr>
<td><%=user_id%></td>
<td><%=user_name%></td>
</tr>
sqlrst.next();
i++;
</table>
</body>
</html>
//关闭结果集
sqlrst.close();
//关闭sql语句对象
sqlstmt.close();
//关闭数据库
sqlcon.close();
![GitHub连夜封杀！这份阿里 10W 字内部 Java 字面试手册到底有多强？[图]](data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=)