JAVA-EE使用模板方法模式跳转到对应的信息展示页面展示信息------计算机网络经典

末蓝、 2024-02-22 02:01 32阅读 0赞

>     <%@ page contentType="text/html;charset=UTF-8" language="java" %>
>     <!DOCTYPE html>
>     <html>
>     <head>
>         <meta charset="utf-8">
>         <title>欢迎页</title>
>     </head>
>     <body>
>     <%--    前端发送请求路径的时候,如果请求路径是绝对路径,要以/开始,加项目名--%>
>         <h1><a href="<%=(request.getContextPath())%>/dept/list">查看部门列表</a></h1>
>     </body>
>     </html>
> 
>     <%@ page contentType="text/html;charset=UTF-8" language="java" %>
>     <!DOCTYPE html>
>     <html>
>     <head>
>         <meta charset="utf-8">
>         <title>欢迎页</title>
>     </head>
>     <body>
>     <%--    前端发送请求路径的时候,如果请求路径是绝对路径,要以/开始,加项目名--%>
>         <h1><a href="<%=(request.getContextPath())%>/dept/list">查看部门列表</a></h1>
>     </body>
>     </html>

>     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","/dept/detail"})
>     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);
>             }
>             else if("/dept/detail".equals(servletPath))
>             {
>                 doDetail(request,response);
>             }
>         }
>     
>         private void doDetail(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
>         {
>             Connection connection = null;
>             PreparedStatement statement = null;
>             ResultSet resultSet = null;
>             String deptno = request.getParameter("deptno");
>             try
>             {
>                 connection = DBUtil.getConnection();
>                 String sql = "select * from dept where deptno = ?";
>                 statement = connection.prepareStatement(sql);
>                 statement.setString(1,deptno);
>                 resultSet = statement.executeQuery();
>                 if(resultSet.next())
>                 {
>                     String dname = resultSet.getString("dname");
>                     String loc = resultSet.getString("loc");
>                     Dept dept = new Dept(deptno,dname,loc);
>                     request.setAttribute("dept",dept);
>                 }
>             }
>             catch (SQLException e)
>             {
>                 throw new RuntimeException(e);
>             }
>             finally
>             {
>                 DBUtil.close(connection,statement,resultSet);
>             }
>             request.getRequestDispatcher("/detail.jsp").forward(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","/dept/detail"})
>     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);
>             }
>             else if("/dept/detail".equals(servletPath))
>             {
>                 doDetail(request,response);
>             }
>         }
>     
>         private void doDetail(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
>         {
>             Connection connection = null;
>             PreparedStatement statement = null;
>             ResultSet resultSet = null;
>             String deptno = request.getParameter("deptno");
>             try
>             {
>                 connection = DBUtil.getConnection();
>                 String sql = "select * from dept where deptno = ?";
>                 statement = connection.prepareStatement(sql);
>                 statement.setString(1,deptno);
>                 resultSet = statement.executeQuery();
>                 if(resultSet.next())
>                 {
>                     String dname = resultSet.getString("dname");
>                     String loc = resultSet.getString("loc");
>                     Dept dept = new Dept(deptno,dname,loc);
>                     request.setAttribute("dept",dept);
>                 }
>             }
>             catch (SQLException e)
>             {
>                 throw new RuntimeException(e);
>             }
>             finally
>             {
>                 DBUtil.close(connection,statement,resultSet);
>             }
>             request.getRequestDispatcher("/detail.jsp").forward(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 contentType="text/html;charset=UTF-8" language="java" %>
>     <%Dept dept = (Dept)request.getAttribute("dept");%>
>     <!DOCTYPE html>
>     <html>
>     <head>
>         <meta charset="utf-8">
>         <title>部门详情</title>
>     </head>
>     <body>
>         <h1>部门详情</h1>
>         <hr>
>         部门编号:<%=dept.getDeptno()%><br>
>         部门名称:<%=dept.getDname()%><br>
>         部门位置:<%=dept.getLoc()%><br>
>         <input type="button" value="后退" onclick="window.history.back()"/>
>     </body>
>     </html>
> 
>     <%@ page import="com.bjpowernode.oa.web.Pojo.Dept" %>
>     <%@ page contentType="text/html;charset=UTF-8" language="java" %>
>     <%Dept dept = (Dept)request.getAttribute("dept");%>
>     <!DOCTYPE html>
>     <html>
>     <head>
>         <meta charset="utf-8">
>         <title>部门详情</title>
>     </head>
>     <body>
>         <h1>部门详情</h1>
>         <hr>
>         部门编号:<%=dept.getDeptno()%><br>
>         部门名称:<%=dept.getDname()%><br>
>         部门位置:<%=dept.getLoc()%><br>
>         <input type="button" value="后退" οnclick="window.history.back()"/>
>     </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)" onclick="window.confirm('亲,确认删除该数据吗?')">删除</a>
>                         <a href="<%=(request.getContextPath())%>/edit.jsp">修改</a>
>                         <a href="<%=(request.getContextPath())%>/dept/detail?deptno=<%=dept.getDeptno()%>">详情</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())%>/dept/detail?deptno=<%=dept.getDeptno()%>">详情</a>
>                     </td>
>                 </tr>
>             <%
>                 }
>             %>
>         </table>
>         <hr>
>         <a href="<%=(request.getContextPath())%>/add.jsp">新增部门</a>
>     </body>
>     </html>