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

布满荆棘的人生 2024-02-23 08:03 15阅读 0赞

>     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>
>     
>             <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>
>     
>             <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>