JAVA-EE使用JSP实现循环动态展示内容信息------计算机网络经典

旧约Alatus

已于 2023-11-06 14:31:21 修改

阅读量162

点赞数 1

分类专栏：计算机网络 JAVA 文章标签： jsp java-ee tomcat servlet 后端 java xml

于 2023-10-14 11:10:57 首次发布

本文链接：https://blog.csdn.net/2201_75960169/article/details/133822814

版权

JAVA 同时被 2 个专栏收录

534 篇文章 3 订阅

订阅专栏

计算机网络

131 篇文章 0 订阅

订阅专栏

package com.bjpowernode.oa.web.action;

import com.bjpowernode.oa.utils.DBUtil;
import com.bjpowernode.oa.web.Pojo.Dept;
import jakarta.servlet.ServletException;
import jakarta.servlet.annotation.WebServlet;
import jakarta.servlet.http.HttpServlet;
import jakarta.servlet.http.HttpServletRequest;
import jakarta.servlet.http.HttpServletResponse;

import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

@WebServlet(urlPatterns = "/dept/list")
public class DeptServlet extends HttpServlet
{
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
    {
        String servletPath = request.getServletPath();
        if("/dept/list".equals(servletPath))
        {
            doList(request,response);
        }
    }

    private void doList(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
    {
        //连接数据库,查询所有部门信息
        Connection connection = null;
        PreparedStatement statement = null;
        ResultSet resultSet = null;
        List<Dept> list = new ArrayList<Dept>();
        try
        {
            connection = DBUtil.getConnection();
            String sql = "select * from dept";
            statement = connection.prepareStatement(sql);
            resultSet = statement.executeQuery();
            while(resultSet.next())
            {
                String deptno = resultSet.getString("deptno");
                String dname = resultSet.getString("dname");
                String loc = resultSet.getString("loc");
                Dept dept = new Dept(deptno,dname,loc);
                list.add(dept);
            }
            request.setAttribute("dept",list);
            request.getRequestDispatcher("/list.jsp").forward(request,response);
        }
        catch (SQLException e)
        {
            throw new RuntimeException(e);
        }
        finally {
            DBUtil.close(connection,statement,resultSet);
        }
    }
}

package com.bjpowernode.oa.web.action;

import com.bjpowernode.oa.utils.DBUtil;
import com.bjpowernode.oa.web.Pojo.Dept;
import jakarta.servlet.ServletException;
import jakarta.servlet.annotation.WebServlet;
import jakarta.servlet.http.HttpServlet;
import jakarta.servlet.http.HttpServletRequest;
import jakarta.servlet.http.HttpServletResponse;

import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

@WebServlet(urlPatterns = "/dept/list")
public class DeptServlet extends HttpServlet
{
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
    {
        String servletPath = request.getServletPath();
        if("/dept/list".equals(servletPath))
        {
            doList(request,response);
        }
    }

    private void doList(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
    {
        //连接数据库,查询所有部门信息
        Connection connection = null;
        PreparedStatement statement = null;
        ResultSet resultSet = null;
        List<Dept> list = new ArrayList<Dept>();
        try
        {
            connection = DBUtil.getConnection();
            String sql = "select * from dept";
            statement = connection.prepareStatement(sql);
            resultSet = statement.executeQuery();
            while(resultSet.next())
            {
                String deptno = resultSet.getString("deptno");
                String dname = resultSet.getString("dname");
                String loc = resultSet.getString("loc");
                Dept dept = new Dept(deptno,dname,loc);
                list.add(dept);
            }
            request.setAttribute("dept",list);
            request.getRequestDispatcher("/list.jsp").forward(request,response);
        }
        catch (SQLException e)
        {
            throw new RuntimeException(e);
        }
        finally {
            DBUtil.close(connection,statement,resultSet);
        }
    }
}

<%@ page import="com.bjpowernode.oa.web.Pojo.Dept" %>
<%@ page import="java.util.List" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%List<Dept> depts = (List)request.getAttribute("dept");%>
<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8">
    <title>部门列表</title>
</head>
<body>
<h1 align="center">部门列表</h1>
<hr>
    <table align="center" border="1px" width="50%">
        <tr>
            <th>序号</th>
            <th>部门编号</th>
            <th>部门名称</th>
            <th>操作</th>
        </tr>
        <%
            int count = 0;
            for(Dept dept : depts)
            {

        %>
            <tr>
                <td><%= ++count%></td>
                <td><%= dept.getDeptno()%></td>
                <td><%= dept.getDname()%></td>
                <td>
                    <a href="javascript:void(0)" onclick="window.confirm('亲,确认删除该数据吗?')">删除</a>
                    <a href="<%=(request.getContextPath())%>/edit.jsp">修改</a>
                    <a href="<%=(request.getContextPath())%>/detail.jsp">详情</a>
                </td>
            </tr>
        <%
            }
        %>

    </table>
    <hr>
    <a href="<%=(request.getContextPath())%>/add.jsp">新增部门</a>
</body>
</html>

<%@ page import="com.bjpowernode.oa.web.Pojo.Dept" %>
<%@ page import="java.util.List" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%List<Dept> depts = (List)request.getAttribute("dept");%>
<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8">
    <title>部门列表</title>
</head>
<body>
<h1 align="center">部门列表</h1>
<hr>
    <table align="center" border="1px" width="50%">
        <tr>
            <th>序号</th>
            <th>部门编号</th>
            <th>部门名称</th>
            <th>操作</th>
        </tr>
        <%
            int count = 0;
            for(Dept dept : depts)
            {

        %>
            <tr>
                <td><%= ++count%></td>
                <td><%= dept.getDeptno()%></td>
                <td><%= dept.getDname()%></td>
                <td>
                    <a href="javascript:void(0)" οnclick="window.confirm('亲,确认删除该数据吗?')">删除</a>
                    <a href="<%=(request.getContextPath())%>/edit.jsp">修改</a>
                    <a href="<%=(request.getContextPath())%>/detail.jsp">详情</a>
                </td>
            </tr>
        <%
            }
        %>

    </table>
    <hr>
    <a href="<%=(request.getContextPath())%>/add.jsp">新增部门</a>
</body>
</html>