JAVA-EE实现修改页面信息的动态并动态修改返回展示页面------计算机网络经典

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.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class ModifyServlet extends HttpServlet
{
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("UTF-8");
        String deptno = request.getParameter("deptno");
        String dname = request.getParameter("dname");
        String loc = request.getParameter("loc");
        Connection connection = null;
        PreparedStatement statement = null;
        ResultSet resultSet = null;
        try
        {
            connection = DBUtil.getConnection();
            connection.setAutoCommit(false);
            String sql = "update dept set dname = ?,loc = ? where deptno = ?";
            statement = connection.prepareStatement(sql);
            statement.setString(1,dname);
            statement.setString(2,loc);
            statement.setString(3,deptno);
            int count = statement.executeUpdate();
            connection.commit();
            if(count == 1)
            {
                request.getRequestDispatcher("/dept/list").forward(request,response);
            }
            else
            {
                request.getRequestDispatcher("/Error.html").forward(request,response);
            }
        }
        catch (SQLException e)
        {
            if (connection != null) {
                try {
                    connection.rollback();
                } catch (SQLException ex) {
                    throw new RuntimeException(ex);
                }
            }
            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.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class ModifyServlet extends HttpServlet
{
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("UTF-8");
        String deptno = request.getParameter("deptno");
        String dname = request.getParameter("dname");
        String loc = request.getParameter("loc");
        Connection connection = null;
        PreparedStatement statement = null;
        ResultSet resultSet = null;
        try
        {
            connection = DBUtil.getConnection();
            connection.setAutoCommit(false);
            String sql = "update dept set dname = ?,loc = ? where deptno = ?";
            statement = connection.prepareStatement(sql);
            statement.setString(1,dname);
            statement.setString(2,loc);
            statement.setString(3,deptno);
            int count = statement.executeUpdate();
            connection.commit();
            if(count == 1)
            {
                request.getRequestDispatcher("/dept/list").forward(request,response);
            }
            else
            {
                request.getRequestDispatcher("/Error.html").forward(request,response);
            }
        }
        catch (SQLException e)
        {
            if (connection != null) {
                try {
                    connection.rollback();
                } catch (SQLException ex) {
                    throw new RuntimeException(ex);
                }
            }
            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 EditServlet extends HttpServlet
{
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String deptno = request.getParameter("deptno");
        Connection connection = null;
        PreparedStatement statement = null;
        ResultSet resultSet = null;
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();
        String contextPath = request.getContextPath();
        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");
                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>\n" +
                        "\t\t<form method=\"post\" action=\"" + contextPath +"/dept/modify\">\n" +
                        "\t\t\t部门编号:<input type=\"text\" name=\"deptno\" value=\"" + deptno);
                out.println("\" readonly/><br>\n" +
                        "\t\t\t部门名称:<input type=\"text\" name=\"dname\" value=\"" + dname + "\"");
                out.println("/><br>\n" +
                        "\t\t\t部门位置:<input type=\"text\" name=\"loc\" value=\"" + loc + "\"");
                out.println("\"/><br>\n" +
                        "\t\t\t<input type=\"submit\" value=\"保存\"/>\n" +
                        "\t\t</form>\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 EditServlet extends HttpServlet
{
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String deptno = request.getParameter("deptno");
        Connection connection = null;
        PreparedStatement statement = null;
        ResultSet resultSet = null;
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();
        String contextPath = request.getContextPath();
        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");
                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>\n" +
                        "\t\t<form method=\"post\" action=\"" + contextPath +"/dept/modify\">\n" +
                        "\t\t\t部门编号:<input type=\"text\" name=\"deptno\" value=\"" + deptno);
                out.println("\" readonly/><br>\n" +
                        "\t\t\t部门名称:<input type=\"text\" name=\"dname\" value=\"" + dname + "\"");
                out.println("/><br>\n" +
                        "\t\t\t部门位置:<input type=\"text\" name=\"loc\" value=\"" + loc + "\"");
                out.println("\"/><br>\n" +
                        "\t\t\t<input type=\"submit\" value=\"保存\"/>\n" +
                        "\t\t</form>\n" +
                        "\t</body>\n" +
                        "</html>");
            }
        }
        catch (SQLException e)
        {
            throw new RuntimeException(e);
        }
        finally
        {
            DBUtil.close(connection,statement,resultSet);
        }
    }
}
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"
         version="4.0">
    <servlet>
        <servlet-name>listDept</servlet-name>
        <servlet-class>com.bjpowernode.oa.web.action.DeptListServlet</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>listDept</servlet-name>
<!--        这个pattern是不带项目名的-->
        <url-pattern>/dept/list</url-pattern>
    </servlet-mapping>
    <servlet>
        <servlet-name>detail</servlet-name>
        <servlet-class>com.bjpowernode.oa.web.action.DetailServlet</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>detail</servlet-name>
        <url-pattern>/dept/detail</url-pattern>
    </servlet-mapping>
    <servlet>
        <servlet-name>delete</servlet-name>
        <servlet-class>com.bjpowernode.oa.web.action.DeleteServlet</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>delete</servlet-name>
        <url-pattern>/dept/delete</url-pattern>
    </servlet-mapping>
    <servlet>
        <servlet-name>save</servlet-name>
        <servlet-class>com.bjpowernode.oa.web.action.SaveServlet</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>save</servlet-name>
        <url-pattern>/dept/save</url-pattern>
    </servlet-mapping>
    <servlet>
        <servlet-name>edit</servlet-name>
        <servlet-class>com.bjpowernode.oa.web.action.EditServlet</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>edit</servlet-name>
        <url-pattern>/dept/edit</url-pattern>
    </servlet-mapping>
    <servlet>
        <servlet-name>modify</servlet-name>
        <servlet-class>com.bjpowernode.oa.web.action.ModifyServlet</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>modify</servlet-name>
        <url-pattern>/dept/modify</url-pattern>
    </servlet-mapping>
</web-app>
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"
         version="4.0">
    <servlet>
        <servlet-name>listDept</servlet-name>
        <servlet-class>com.bjpowernode.oa.web.action.DeptListServlet</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>listDept</servlet-name>
<!--        这个pattern是不带项目名的-->
        <url-pattern>/dept/list</url-pattern>
    </servlet-mapping>
    <servlet>
        <servlet-name>detail</servlet-name>
        <servlet-class>com.bjpowernode.oa.web.action.DetailServlet</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>detail</servlet-name>
        <url-pattern>/dept/detail</url-pattern>
    </servlet-mapping>
    <servlet>
        <servlet-name>delete</servlet-name>
        <servlet-class>com.bjpowernode.oa.web.action.DeleteServlet</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>delete</servlet-name>
        <url-pattern>/dept/delete</url-pattern>
    </servlet-mapping>
    <servlet>
        <servlet-name>save</servlet-name>
        <servlet-class>com.bjpowernode.oa.web.action.SaveServlet</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>save</servlet-name>
        <url-pattern>/dept/save</url-pattern>
    </servlet-mapping>
    <servlet>
        <servlet-name>edit</servlet-name>
        <servlet-class>com.bjpowernode.oa.web.action.EditServlet</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>edit</servlet-name>
        <url-pattern>/dept/edit</url-pattern>
    </servlet-mapping>
    <servlet>
        <servlet-name>modify</servlet-name>
        <servlet-class>com.bjpowernode.oa.web.action.ModifyServlet</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>modify</servlet-name>
        <url-pattern>/dept/modify</url-pattern>
    </servlet-mapping>
</web-app>
  • 1
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

旧约Alatus

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

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

余额充值