使用MySQL数据库,用户名root,密码为空,新建数据库名为lin_0917,新建表名为person,表中字段为:ID,NAME,PASSWORD。
示例为每页显示15条记录
JSP代码如下:
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ page import="java.sql.*"%>
<html>
<head>
<title>My JSP 'Jdbc2.jsp' starting page</title>
</head>
<body>
<center>
<h1>
人员列表
</h1>
<hr />
<br />
<%!final String jspurl = "Jdbc2.jsp";%>
<%
int linesize = 15;
int currentpage = 1;
int alldata = 100;
int pagesize = 0;
pagesize = (alldata + linesize - 1) / linesize;
%>
总页数为
<%=pagesize%>页
<%
try {
currentpage = Integer.parseInt(request.getParameter("cp"));
} catch (Exception e) {
}
%>
<%
String driverName = "com.mysql.jdbc.Driver";
String userName = "root";
String userPasswd = "";
String dbName = "l