Servlet+Jsp+jdbcTemplate实现基础的CRUD

最新推荐文章于 2024-10-08 17:06:25 发布

秃顶中……

最新推荐文章于 2024-10-08 17:06:25 发布

阅读量240

点赞数 3

文章标签： servlet java 开发语言

本文链接：https://blog.csdn.net/qq_52747920/article/details/142378527

版权

通过这三种技术我们可以实现一个简单的前端页面表格展示，并附带基础的CRUD功能，这里只书写搜索，更多代码见附件
1.首先我们需要书写对应的实体类，dao接口，以及接口实现类，在这里我们定义连接数据库需要的方法以及方法实现。
2.我们需要书写jsp页面-userList.jsp，用来展示信息

<%--
  Created by IntelliJ IDEA.
  User: 高
  Date: 2024/9/18
  Time: 10:51
  To change this template use File | Settings | File Templates.
--%>
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>


<%
    String path = request.getContextPath();
    String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML>
<html>
<meta http-equiv="content-type" content="text/html;charset=utf-8" /><!-- /Added by HTTrack -->
<head>
    <meta charset="UTF-8">
    <meta name="description" content="">
    <meta name="keywords" content="">
    <title>数码在线</title>
</head>
<body>
<form action="userPage" method="get">
    <input type="text" size="30" name="keyword" placeholder="请输入搜索关键字">
    <input type="submit" value="搜"/>
</form>
<a href="add.html">添加用户</a>
<table border="1px">
    <tr>
        <th>编号</th>
        <th>姓名</th>
        <th>操作</th>
    </tr>
    <c:forEach items="${list}" var="u">
        <tr>     <!-- el表达式 -->
            <td>${u.userId}</td>
            <td><a href="userDetail?userId=${u.userId}">${u.userName}</a></td>
            <td>
                <a href="userUpdate?userId=${u.userId}&userName=${u.userName}&userPic=${u.userPic}">修改</a>
                <a href="userDelete?userId=${u.userId}" onclick="return confirmDelete(this)">删除</a>
            </td>
        </tr>
    </c:forEach>

    <tr>
        <td colspan="3">
            <a href="userPage?pageIndex=1">首页</a>
            <a href="userPage?pageIndex=${pageIndex-1}&keyword=${keyword}">上一页</a>
            <a href="userPage?pageIndex=${pageIndex+1}&keyword=${keyword}">下一页</a>
            <a href="userPage?pageIndex=${totalPages}">最后一页</a>
        </td>
    </tr>

</table>
</body>
<script>
    function confirmDelete(link) {
        if (confirm("您确定要删除此用户吗？")) {
            // 如果用户点击了确认按钮，则继续跳转
            return true;
        } else {
            // 如果用户点击了取消按钮，则阻止跳转
            return false;
        }
    }
</script>
</html>

3.书写对应的servlet

package com.by.servlet;

import com.by.dao.UserDao;
import com.by.dao.impl.UserDaoImpl;
import com.by.entity.User;
import com.by.service.UserService;
import com.by.service.impl.UserServiceImpl;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.util.List;

/**
 * @author gsh
 * @date 2024/9/18 14:00</p>
 */
@WebServlet("/userPage")
public class UserPageServlet extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String currPage= request.getParameter("pageIndex");
        String keyword = request.getParameter("keyword");
        if(currPage==null){
            currPage="1";
        }
        if (keyword==null){
            keyword="";
        }
        int pageIndex= Integer.parseInt(currPage);
        if (pageIndex<1){
            pageIndex=1;
        }

        UserDao userDao=new UserDaoImpl();
        int count=userDao.selectUserCount();

        //总页数
        UserService userService = new UserServiceImpl();
        int totalPages=userService.pageCount(count,UserService.PAGE_SIZE);
        if (pageIndex>totalPages){
            pageIndex=totalPages;
        }
        List<User> list= userDao.selectAllUserByPage(pageIndex,UserService.PAGE_SIZE,keyword);
        request.setAttribute("list",list);
        request.setAttribute("totalPages",totalPages);
        request.setAttribute("pageIndex",pageIndex);
        request.setAttribute("keyword",keyword);
        request.getRequestDispatcher("userList.jsp").forward(request,response);
    }

    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        super.doGet(req, resp);
    }
}