JAVA-EE使用JSP和Servlet实现登录页面效果------计算机网络经典

一时失言乱红尘 2024-02-22 09:47 50阅读 0赞

>     package com.bjpowernode.oa.web.action;
>     
>     import com.bjpowernode.oa.utils.DBUtil;
>     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;
>     
>     @WebServlet("/user/login")
>     public class UserServlet extends HttpServlet
>     {
>         @Override
>         protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
>             request.setCharacterEncoding("UTF-8");
>             String username = request.getParameter("username");
>             String password = request.getParameter("password");
>             Connection connection = null;
>             PreparedStatement statement = null;
>             ResultSet resultSet = null;
>             boolean flag = false;
>             try
>             {
>                 connection = DBUtil.getConnection();
>                 String sql = "select * from t_user where username = ? and pssword = ?";
>                 statement = connection.prepareStatement(sql);
>                 statement.setString(1,username);
>                 statement.setString(2,password);
>                 resultSet = statement.executeQuery();
>                 if(resultSet.next())
>                 {
>                     request.setAttribute("flag",flag);
>                     request.getRequestDispatcher("/dept/list").forward(request,response);
>                 }
>                 else
>                 {
>                     response.sendRedirect(request.getContextPath() + "/Error.jsp");
>                 }
>             }
>             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.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;
>     
>     @WebServlet("/user/login")
>     public class UserServlet extends HttpServlet
>     {
>         @Override
>         protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
>             request.setCharacterEncoding("UTF-8");
>             String username = request.getParameter("username");
>             String password = request.getParameter("password");
>             Connection connection = null;
>             PreparedStatement statement = null;
>             ResultSet resultSet = null;
>             boolean flag = false;
>             try
>             {
>                 connection = DBUtil.getConnection();
>                 String sql = "select * from t_user where username = ? and pssword = ?";
>                 statement = connection.prepareStatement(sql);
>                 statement.setString(1,username);
>                 statement.setString(2,password);
>                 resultSet = statement.executeQuery();
>                 if(resultSet.next())
>                 {
>                     request.setAttribute("flag",flag);
>                     request.getRequestDispatcher("/dept/list").forward(request,response);
>                 }
>                 else
>                 {
>                     response.sendRedirect(request.getContextPath() + "/Error.jsp");
>                 }
>             }
>             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>
>     <form method="post" action="<%=(request.getContextPath())%>/dept/edit">
>         部门编号:<input type="text" name="deptno" value="<%=dept.getDeptno()%>" readonly/><br>
>         部门名称:<input type="text" name="dname" value="<%=dept.getDname()%>"/><br>
>         部门位置:<input type="text" name="loc" value="<%=dept.getLoc()%>"/><br>
>         <input type="submit" value="保存"/>
>     </form>
>     </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>
>     <form method="post" action="<%=(request.getContextPath())%>/dept/edit">
>         部门编号:<input type="text" name="deptno" value="<%=dept.getDeptno()%>" readonly/><br>
>         部门名称:<input type="text" name="dname" value="<%=dept.getDname()%>"/><br>
>         部门位置:<input type="text" name="loc" value="<%=dept.getLoc()%>"/><br>
>         <input type="submit" value="保存"/>
>     </form>
>     </body>
>     </html>

>     <%@ page contentType="text/html;charset=UTF-8" language="java" %>
>     <!DOCTYPE html>
>     <html lang="en">
>     <head>
>         <meta charset="UTF-8">
>         <title>Error</title>
>     </head>
>     <body>
>         <h1>操作失败,<a href="javascript:void(0)" onclick="window.history.back()">返回</a></h1>
>     </body>
>     </html>
> 
>     <%@ page contentType="text/html;charset=UTF-8" language="java" %>
>     <!DOCTYPE html>
>     <html lang="en">
>     <head>
>         <meta charset="UTF-8">
>         <title>Error</title>
>     </head>
>     <body>
>         <h1>操作失败,<a href="javascript:void(0)" οnclick="window.history.back()">返回</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>用户登录</h1>
>         <hr>
>         <form action="<%=request.getContextPath()%>/user/login" method="post">
>             username:<input type="text" name="username"><br>
>             password:<input type="password" name="password"><br>
>             <input type="submit" value="login">
>         </form>
>     <%--    前端发送请求路径的时候,如果请求路径是绝对路径,要以/开始,加项目名--%>
>     <%--    <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>用户登录</h1>
>         <hr>
>         <form action="<%=request.getContextPath()%>/user/login" method="post">
>             username:<input type="text" name="username"><br>
>             password:<input type="password" name="password"><br>
>             <input type="submit" value="login">
>         </form>
>     <%--    前端发送请求路径的时候,如果请求路径是绝对路径,要以/开始,加项目名--%>
>     <%--    <h1><a href="<%=(request.getContextPath())%>/dept/list">查看部门列表</a></h1>--%>
>     </body>
>     </html>