JAVA-EE使用Servlet替代超链接用get请求实现动态展示页面信息并从服务器取值------计算机网络经典

已于 2023-11-06 14:29:32 修改
阅读量53 收藏
点赞数 1
分类专栏： JAVA 计算机网络 文章标签： tomcat servlet java-ee maven xml java 后端
于 2023-10-10 15:36:08 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/2201_75960169/article/details/133748321
版权 
<!DOCTYPE html>
<html>
	<head>
		<meta charset="utf-8">
		<title>欢迎页</title>
	</head>
	<body>
<!--	前端超链接发送请求,请求路径以/开始,且要带着项目名-->
		<a href="/OA/dept/list">查看部门列表</a>
	</body>
</html>
<!DOCTYPE html>
<html>
    <head>
       <meta charset="utf-8">
       <title>欢迎页</title>
    </head>
    <body>
<!--    前端超链接发送请求,请求路径以/开始,且要带着项目名-->
       <a href="/OA/dept/list">查看部门列表</a>
    </body>
</html>
package com.bjpowernode.oa.web.action;

import com.bjpowernode.oa.utils.DBUtil;
import jakarta.servlet.ServletException;
import jakarta.servlet.http.HttpServlet;
import jakarta.servlet.http.HttpServletRequest;
import jakarta.servlet.http.HttpServletResponse;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.*;

public class DetailServlet extends HttpServlet
{
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
    {
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();
        String deptno = request.getParameter("deptno");
        Connection connection = null;
        ResultSet resultSet = null;
        PreparedStatement statement = null;
        try
        {
            connection = DBUtil.getConnection();
            String sql = "select * from dept where deptno = " + deptno;
            statement = connection.prepareStatement(sql);
            resultSet = statement.executeQuery();
            if(resultSet.next())
            {
                String deptno1 = resultSet.getString("deptno");
                String dname = resultSet.getString("dname");
                String loc = resultSet.getString("loc");
                out.println("<!DOCTYPE html>\n" +
                        "<html>\n" +
                        "\t<head>\n" +
                        "\t\t<meta charset=\"utf-8\">\n" +
                        "\t\t<title>部门详情</title>\n" +
                        "\t</head>\n" +
                        "\t<body>\n" +
                        "\t\t<h1>部门详情</h1>\n" +
                        "\t\t<hr>");
                out.println("部门编号:" + deptno + "<br>");
                out.println("部门名称:" + dname + "<br>");
                out.println("部门位置:" + loc + "<br>");
                out.println("\t\t\n" +
                        "\t\t<input type=\"button\" value=\"后退\" onclick=\"window.history.back()\"/>\n" +
                        "\t</body>\n" +
                        "</html>");
            }
        }
        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 jakarta.servlet.ServletException;
import jakarta.servlet.http.HttpServlet;
import jakarta.servlet.http.HttpServletRequest;
import jakarta.servlet.http.HttpServletResponse;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.*;

public class DetailServlet extends HttpServlet
{
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
    {
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();
        String deptno = request.getParameter("deptno");
        Connection connection = null;
        ResultSet resultSet = null;
        PreparedStatement statement = null;
        try
        {
            connection = DBUtil.getConnection();
            String sql = "select * from dept where deptno = " + deptno;
            statement = connection.prepareStatement(sql);
            resultSet = statement.executeQuery();
            if(resultSet.next())
            {
                String deptno1 = resultSet.getString("deptno");
                String dname = resultSet.getString("dname");
                String loc = resultSet.getString("loc");
                out.println("<!DOCTYPE html>\n" +
                        "<html>\n" +
                        "\t<head>\n" +
                        "\t\t<meta charset=\"utf-8\">\n" +
                        "\t\t<title>部门详情</title>\n" +
                        "\t</head>\n" +
                        "\t<body>\n" +
                        "\t\t<h1>部门详情</h1>\n" +
                        "\t\t<hr>");
                out.println("部门编号:" + deptno + "<br>");
                out.println("部门名称:" + dname + "<br>");
                out.println("部门位置:" + loc + "<br>");
                out.println("\t\t\n" +
                        "\t\t<input type=\"button\" value=\"后退\" οnclick=\"window.history.back()\"/>\n" +
                        "\t</body>\n" +
                        "</html>");
            }
        }
        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 jakarta.servlet.ServletException;
import jakarta.servlet.http.HttpServlet;
import jakarta.servlet.http.HttpServletRequest;
import jakarta.servlet.http.HttpServletResponse;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class DeptListServlet extends HttpServlet
{
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
    {
        String contextPath = request.getContextPath();
        Connection connection = null;
        PreparedStatement statement = null;
        ResultSet resultSet = null;
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter writer = response.getWriter();
        writer.println("<!DOCTYPE html>");
        writer.println("<html>");
        writer.println("	<head>");
        writer.println("		<meta charset='utf-8'>");
        writer.println("		<title>部门列表</title>");
        writer.println("	</head>");
        writer.println("	<body>");
        writer.println("		<h1 align='center'>部门列表</h1>");
        writer.println("		<hr>");
        writer.println("		<table align='center' border='1px' width='50%'>");
        writer.println("			<tr>");
        writer.println("				<th>序号</th>");
        writer.println("				<th>部门编号</th>");
        writer.println("				<th>部门名称</th>");
        writer.println("				<th>操作</th>");
        writer.println("			</tr>");
        try
        {
            connection = DBUtil.getConnection();
            String sql = "select * from dept";
            statement = connection.prepareStatement(sql);
            resultSet = statement.executeQuery();
            int i = 0;
            while(resultSet.next())
            {
                String deptno = resultSet.getString("deptno");
                String dname = resultSet.getString("dname");
                String loc = resultSet.getString("loc");
                writer.println("			<tr>");
                writer.println("				<td>" + (++i) + "</td>");
                writer.println("				<td>" + (deptno) + "</td>");
                writer.println("				<td>" + (dname) + "</td>");
                writer.println("				<td>");
                writer.println("					<a href='javascript:void(0)' onclick='window.confirm('亲,确认删除该数据吗?')'>删除</a>");
                writer.println("					<a href='edit.html'>修改</a>");
                writer.println("					<a href='" + (contextPath) + "/dept/detail?deptno=" + deptno +"'>详情</a>");
                writer.println("				</td>");
                writer.println("			</tr>");
            }
        }
        catch (SQLException e)
        {
            throw new RuntimeException(e);
        }
        finally
        {
            DBUtil.close(connection,statement,resultSet);
        }
        writer.println("		</table>");
        writer.println("		<hr>");
        writer.println("		<a href='add.html'>新增部门</a>");
        writer.println("	</body>");
        writer.println("</html>");
    }
}

package com.bjpowernode.oa.web.action;

import com.bjpowernode.oa.utils.DBUtil;
import jakarta.servlet.ServletException;
import jakarta.servlet.http.HttpServlet;
import jakarta.servlet.http.HttpServletRequest;
import jakarta.servlet.http.HttpServletResponse;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class DeptListServlet extends HttpServlet
{
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
    {
        String contextPath = request.getContextPath();
        Connection connection = null;
        PreparedStatement statement = null;
        ResultSet resultSet = null;
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter writer = response.getWriter();
        writer.println("<!DOCTYPE html>");
        writer.println("<html>");
        writer.println("    <head>");
        writer.println("       <meta charset='utf-8'>");
        writer.println("       <title>部门列表</title>");
        writer.println("    </head>");
        writer.println("    <body>");
        writer.println("       <h1 align='center'>部门列表</h1>");
        writer.println("       <hr>");
        writer.println("       <table align='center' border='1px' width='50%'>");
        writer.println("          <tr>");
        writer.println("             <th>序号</th>");
        writer.println("             <th>部门编号</th>");
        writer.println("             <th>部门名称</th>");
        writer.println("             <th>操作</th>");
        writer.println("          </tr>");
        try
        {
            connection = DBUtil.getConnection();
            String sql = "select * from dept";
            statement = connection.prepareStatement(sql);
            resultSet = statement.executeQuery();
            int i = 0;
            while(resultSet.next())
            {
                String deptno = resultSet.getString("deptno");
                String dname = resultSet.getString("dname");
                String loc = resultSet.getString("loc");
                writer.println("          <tr>");
                writer.println("             <td>" + (++i) + "</td>");
                writer.println("             <td>" + (deptno) + "</td>");
                writer.println("             <td>" + (dname) + "</td>");
                writer.println("             <td>");
                writer.println("                <a href='javascript:void(0)' οnclick='window.confirm('亲,确认删除该数据吗?')'>删除</a>");
                writer.println("                <a href='edit.html'>修改</a>");
                writer.println("                <a href='" + (contextPath) + "/dept/detail?deptno=" + deptno +"'>详情</a>");
                writer.println("             </td>");
                writer.println("          </tr>");
            }
        }
        catch (SQLException e)
        {
            throw new RuntimeException(e);
        }
        finally
        {
            DBUtil.close(connection,statement,resultSet);
        }
        writer.println("       </table>");
        writer.println("       <hr>");
        writer.println("       <a href='add.html'>新增部门</a>");
        writer.println("    </body>");
        writer.println("</html>");
    }
}
旧约Alatus
关注
  • 1
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值