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

旧约Alatus

已于 2023-11-29 11:45:28 修改

阅读量71

点赞数 1

分类专栏：计算机网络 JAVA 文章标签： jsp java-ee tomcat servlet 后端 xml java

于 2023-10-15 11:08:19 首次发布

本文链接：https://blog.csdn.net/2201_75960169/article/details/133839917

版权

JAVA 同时被 2 个专栏收录

543 篇文章 3 订阅

订阅专栏

计算机网络

134 篇文章 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>