JSP+Servlet+SQL串联小案例

最新推荐文章于 2023-06-03 18:03:34 发布

朵朵宝

最新推荐文章于 2023-06-03 18:03:34 发布

阅读量186

点赞数

文章标签： java sql 数据库

本文链接：https://blog.csdn.net/magic_818/article/details/127854631

版权

本文详细介绍了如何使用Lombok简化Java实体类，并通过Servlet与MySQL连接，获取数据后在JSP页面上动态显示用户列表。涉及依赖管理、Entity类创建、Servlet编写及JSP模板的遍历输出。

摘要由CSDN通过智能技术生成

案例需求:

准备工作:

代码如下:

创建实体类:(此处用的是lombok,详细了解lombok博客)

案例需求:

实现如下效果(数据由sql库中传来)

准备工作:

导入依赖:Mysql,EL和JSTL

代码如下:

 <!-- Servlet -->
    <dependency>
      <groupId>javax.servlet</groupId>
      <artifactId>javax.servlet-api</artifactId>
      <version>3.1.0</version>
    </dependency>
    <!-- MySQL -->
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>8.0.30</version>
    </dependency>
    <!--EL和JSTL-->
    <dependency>
      <groupId>taglibs</groupId>
      <artifactId>standard</artifactId>
      <version>1.1.2</version>
    </dependency>
    <dependency>
      <groupId>javax.servlet</groupId>
      <artifactId>jstl</artifactId>
      <version>1.2</version>
    </dependency>
    <dependency>
      <groupId>org.projectlombok</groupId>
      <artifactId>lombok</artifactId>
      <version>1.18.12</version>
      <!--这里是设置作用域-->
      <!--注释作用域，表明我想让它为全局使用-->
      <!--<scope>provided</scope>-->
    </dependency>
    <dependency>
      <groupId>com.alibaba</groupId>
      <artifactId>fastjson</artifactId>
      <version>1.2.79</version>
    </dependency>

创建实体类:(此处用的是lombok,详细了解lombok博客)

写Servlet类

代码如下:

package controller;

import com.alibaba.fastjson.JSON;
import dao.impl.UserDAOImpl;
import entity.User;

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 javax.servlet.http.HttpSession;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.List;

@WebServlet("/user_list")
public class UserListServlet  extends HttpServlet {
    @Override
    protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        req.setCharacterEncoding("UTF-8");
        resp.setCharacterEncoding("UTF-8");
        resp.setHeader("content-type", "text/html;charset=utf-8");
        UserDAOImpl dao = new UserDAOImpl();
        List<User> list = dao.selectAll();
        HttpSession session = req.getSession();
        session.setAttribute("list",list);
        req.getRequestDispatcher("user_list.jsp").forward(req,resp);
        resp.sendRedirect("user_list.jsp");
    }
}

写JSP文件

代码如下:

<%--
  Created by IntelliJ IDEA.
  User: ohana
  Date: 2022/11/14
  Time: 18:49
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html>
<head>
    <title>Title</title>
</head>
<body>
<table>
    <tr>
        <th>用户名</th>
        <th>昵称</th>
        <th>姓名</th>
        <th>生日</th>
        <th>操作</th>
    </tr>
    <c:forEach items="${list}" var = "li">
        <tr>
            <td>${li.userName}</td>
            <td>${li.nickName}</td>
            <td>${li.sex}</td>
            <td>${li.birth}</td>
            <td>
                <button>修改</button>
                <button>删除</button>
            </td>
        </tr>
    </c:forEach>
</table>
</body>
</html>