客户端用户数据展示

客户端用户数据展示"/>

客户端用户数据展示

案例来自www.51doit.com多易教育–行哥的小案例练习

需求:客户端页面显示用户数据 和 删除 数据

展示用户数据

1. 用户组绑定Servlet文件

//day13是项目名 Users是Servlet文件
<a href="/day13/Users">用户组</a>

2. Users实现

protected void service(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {try {UserService userService = new UserServiceImpl();//调用Service层的showAllUsers 得到所有用户信息List<User> showAllUsers = userService.showAllUsers();//将list集合添加到request域中request.setAttribute("list", showAllUsers);//转发到/page/views/users.jsprequest.getRequestDispatcher("/page/views/users.jsp").forward(request, response);} catch (Exception e) {e.printStackTrace();}}

2.1 Service层实现

@Overridepublic int deleteUser(String name, String pwd) throws Exception {return userDao.deleteUser(name, pwd);}

2.2 Dao层实现

static QueryRunner runner;static {//数据库建立连接ComboPooledDataSource dataSource = new ComboPooledDataSource();runner = new QueryRunner(dataSource);}@Overridepublic List<User> getAllUsers() throws Exception {String sql = "select *,phone_num phoneNum from user";return runner.query(sql, new BeanListHandler<>(User.class));}

3. user.jsp

<!--导入jstl 核心标签库 -->
<%@taglib uri="" prefix="x" %><!-- jstl结合El表达式获取域中数据-->
<x:forEach items="${list}" var="user"><tr><td>${user.name }</td><td>${user.gerder }</td><td>${user.address }</td><td>${user.phoneNum }&nbsp;&nbsp; <button type="button"><a href="/day13/UserDelete?name=${user.name},pwd=${user.password}">删除</a></button></td></tr>
</x:forEach>

删除用户数据

1. 在td标签中添加删除按钮

<td>${user.phoneNum }&nbsp;&nbsp; <button type="button">//?后面跟要提交给服务端的数据<a href="/day13/UserDelete?name=${user.name},pwd=${user.password}">删除</a></button>
</td>

2. UserDelete实现

protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {try {//苍老师andpwd=654321String queryString = request.getParameter("name");//切割 之后 [苍老师, pwd=654321]String[] split = queryString.split(",");//再切String name = split[0];String pwd = split[1].split("=")[1];UserService userService = new UserServiceImpl();int deleteUser = userService.deleteUser(name,pwd);if(deleteUser>0) {//删除user成功,将所有用户信息添加到request域中List<User> showAllUsers = userService.showAllUsers();request.setAttribute("list", showAllUsers);//转发request.getRequestDispatcher("/page/views/users.jsp").forward(request, response);}} catch (Exception e) {e.printStackTrace();}}

Service层和Dao与之前的展示数据没什么大的变化,这里就不贴出