<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">

本文介绍了一个基于Java的Web应用案例,该应用实现了用户数据的分页展示,并提供了查询、添加、修改和删除等功能。通过设定每页显示的记录数,可以有效地管理大量用户数据,提高用户体验。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

<%@ page language="java" import="java.util.*" pageEncoding="GBK"%>
<%@ page import="java.sql.*" %>
<jsp:useBean id="connBean" scope="page" class="com.BBS.Beans.connDB"/>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>


<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">

<title>江枫工作室欢迎你!</title>

<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->


</head>

<body bgcolor="#FFC040">
<%
int pagesize=5;//设置每张网页显示5个记录
int showpage=1;//设置欲显示的页数
int rowcount=0;//ResultSet的记录数
int pagecount=0;//ResultSet分页后的总页数
int gopage=0;//接受用户的页数选择
if(session.getAttribute("user")==null){
response.sendRedirect("logion.jsp");
}
out.println("欢迎进入主页面!");
//
Connection conn=Pool.getInstance().getConnection();
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("Select * from user");
rs.last();
rowcount=rs.getRow();
pagecount =((rowcount%pagesize)==0?(rowcount/pagesize):(rowcount/pagesize)+1);
String topage=request.getParameter("topage");
if(topage!=null){
showpage=Integer.parseInt(topage);
if(showpage>pagecount){
showpage=pagecount;
}else if(showpage<=0){
showpage=1;
}
}
rs.absolute((showpage-1)*pagesize+1);//将指针移动到此 ResultSet 对象的给定行编号。
rs.previous();//将指针移动到此 ResultSet 对象的上一行。
out.println("所有数据显示如下:");
%>
<tr>
<td valign="button">当前第<%=showpage%>页</td>
<td valign="button"> 总共<%=pagecount%>页</td>
</tr>
<table cellspacing="1" cellpadding="1" border="1" bgcolor="#80ffff">
<tr>
<td>ID</td>
<td>用户名</td>
<td>密码</td>
<td>真实姓名</td>
<td>电话</td>
<td>地址</td>
<td>性别</td>
<td>年龄</td>
</tr>
<%
for(int i=0;i<pagesize;i++){
if(rs.next()){
%>
<tr>
<td><%=rs.getInt(1)%></td>
<td><%=rs.getString(2)%></td>
<td><%=rs.getString(3)%></td>
<td><%=rs.getString(4)%></td>
<td><%=rs.getString(5)%></td>
<td><%=rs.getString(6)%></td>
<td><%=rs.getString(7)%></td>
<td><%=rs.getInt(8)%></td>
</tr>
<%
}else{
break;
}
}
%>
</table>
<tr>
<%
//out.print(showpage);
if(showpage!=1){
%>
<td width="94" valign="middle" align="center"><a href="main.jsp? topage=<%=showpage-1%>">上一页</td>
<%
}
%>
<%
if(showpage!=pagecount){
%>
<td width="85" height="33" align="right" valign="middle"><a href="main.jsp? topage=<%=1%>">第一页</td>
<td width="95" align="right" valign="middle"><a href="main.jsp? topage=<%=showpage+1%>">下一页</td>
<td width="87" valign="middle" align="center"><a href="main.jsp? topage=<%=pagecount%>">最后一页</td>
<%
}
%>
<td>
<form name="from2" action="main.jsp" method="post">
<div><br>到
<select name="topage" onChange="MM_jumpMenu(self,this,1)">
<%for(gopage=1;gopage<=pagecount;gopage++){
if(gopage==showpage){%>
<option value="main.jsp?topage=<%=gopage%>"selsected><%=gopage%></option>
<%
}else{%>
<option value="main.jsp?topage=<%=gopage%>"><%=gopage%></option>
<%}} %>
</select>
</div>
</form>
</td>
</tr>
<form action="Result.jsp" method="post" >
<table>
<tr>
<td>ID</td>
<td><input type="text" name="id" value=""/></td>
<td>用户名</td>
<td><input type="text" name="username" value=""/></td>
<td>真实姓名</td>
<td><input type="text" name="realname" value=""/></td>
</tr>
<tr>
<td>地址</td>
<td><input type="text" name="address" value=""/></td>
<td>性别</td>
<td><input type="text" name="gender" value=""/></td>
<td>年龄</td>
<td><input type="text" name="age" value=""/></td>
</tr>
</table>
<input type="submit" value="查询"/>
</form>
<form action="delete.jsp" method="post">
<table>
<tr>
<td>请输入你要删除用户的id:</td>
<td><input type="text" name="id" value=""></td>
</tr>
<tr>
<td>请输入你要删除用户的用户名:</td>
<td><input type="text" name="username" value=""></td>
</tr>
<tr>
<td>请输入你要删除用户的真实姓名:</td>
<td><input type="text" name="realname" value=""></td>
</tr>
</table>
<input type="submit" value="删除"/>
</form>
<form action="add.jsp" method="post" >
<table>
<tr>
<td>ID</td>
<td><input type="text" name="id" value=""/></td>
<td>用户名</td>
<td><input type="text" name="username" value=""/></td>
<td>密码</td>
<td><input type="text" name="pwd" value=""/></td>
</tr>
<tr>
<td>真实姓名</td>
<td><input type="text" name="realname" value=""/></td>
<td>电话</td>
<td><input type="text" name="phone" value=""/></td>
<td>地址</td>
<td><input type="text" name="address" value=""/></td>
</tr>
<tr>
<td>性别</td>
<td><input type="text" name="gender" value=""/></td>
<td>年龄</td>
<td><input type="text" name="age" value=""/></td>
</tr>
</table>
<input type="submit" value="添加"/>
</form>
<form action="update.jsp" method="post">
<table>
<tr>
<td>请输入你要修改的用户ID</td>
<td><input type="text" name="co_id" value=""/></td>
</tr>
<tr>
<td>修改后的用户名</td>
<td><input type="text" name="username" value=""/></td>
<td>修改后的密码</td>
<td><input type="text" name="pwd" value=""/></td>
<td>修改后的真实姓名</td>
<td><input type="text" name="realname" value=""/></td>
</tr>
<tr>
<td>修改后的电话</td>
<td><input type="text" name="phone" value=""/></td>
<td>修改后的地址</td>
<td><input type="text" name="address" value=""/></td>
<td>修改后的性别</td>
<td><input type="text" name="gender" value=""/></td>
</tr>
<tr>
<td>修改后的年龄</td>
<td><input type="text" name="age" value=""/></td>
</tr>
</table>
<input type="submit" value="修改"/>
</form>
</body>
</html>
package com.sshmvc.ljl.web.servlet; import java.io.IOException; import java.io.PrintWriter; import java.util.ArrayList; import java.util.List; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import com.sshmvc.ljl.pojo.Users; import com.sshmvc.ljl.service.UserService; import com.sshmvc.ljl.service.impl.UserServiceImpl; /** * Servlet implementation class ListUserServlet */ public class ListUserServlet extends HttpServlet { private static final long serialVersionUID = 1L; protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { this.doPost(request, response); } protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html"); request.setCharacterEncoding("utf-8"); response.setCharacterEncoding("utf-8"); PrintWriter out = response.getWriter(); ListUserInfo(request, response); out.flush(); out.close(); } private void ListUserInfo(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { List list = new ArrayList(); UserService userService = new UserServiceImpl(); list = userService.listUser(); request.setAttribute("listUsers", list); // response.sendRedirect("/sshmvc/listUser.jsp"); request.getRequestDispatcher("/listUser.jsp") .forward(request, response); } } <% String path = request.getContextPath(); String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort() + path + "/"; List list = (List) request.getAttribute("listUsers"); if (list == null) { list = (List) request.getAttribute("listUs
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值