queryVip.jsp
<%@page import="java.sql.Connection"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.DriverManager"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!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=UTF-8">
<title>数据库的增删改查</title>
</head>
<body>
<a href="insert.jsp"><span style="margin-left: 10px">添加数据</span></a>
<center>
<h3 style="margin-top: 5px">查询用户信息</h3>
</center>
<hr color="green">
<table width="98%" align="center" border="0" cellpadding="4"
cellspacing="1" bgcolor="#CBD8AC" style="margin-pttom: 8px">+
<tr align="center" bgcolor="#FAFAF1">
<td>ID</td>
<td>姓名</td>
<td>昵称</td>
<td>电话</td>
<td>地址</td>
<td>学校</td>
<td>操作</td>
</tr>
<%
ResultSet rs=null;
Statement statement=null;
try{
Class.forName("com.mysql.jdbc.Driver");
Connection connection=DriverManager.getConnection("jdbc:mysql://localhost:3306/demo", "root", "933032");
String sql="select * from vip ";
statement=connection.createStatement();
rs=statement.executeQuery(sql);
int pagesize,count,pageCount,intpage;
String strPage;
int i;
pagesize=3;
strPage=request.getParameter("page");
if(strPage==null){
intpage=1;
}else{
intpage=Integer.parseInt(strPage);
}
if(intpage<1){
intpage=1;
}
rs.last();
count=rs.getRow();
pageCount=(count+pagesize-1)/pagesize;
if(intpage>count){
intpage=count;
}
if(count>0){
rs.absolute((intpage-1)*pagesize+1);
}
i=0;
while(i<pagesize&&!rs.isAfterLast()){
%>
<tr align="center" bgcolor="#FAFAF1">
<td><%=rs.getInt("id") %></td>
<td><%=rs.getString("name") %></td>
<td><%=rs.getString("nickname") %></td>
<td><%=rs.getInt("phone") %></td>
<td><%=rs.getString("address") %></td>
<td><%=rs.getString("school") %></td>
<td><a href="editVip.jsp" ? id=<%=rs.getInt("id") %>">修改</a>| <a
href="delVip.jsp? id=<%=rs.getInt("id") %>">删除</a></td>
</tr>
<%rs.next();
i++;
}
rs.close();
statement.close();
connection.close();
%>
</table>
<div align="center">
共<%=count %>条记录,分<%=pageCount %>页显示,第<%=intpage %>页
<%
if(intpage>1){