8.在线考试管理系统登录

最新推荐文章于 2024-05-20 21:44:40 发布

苏七qaq

最新推荐文章于 2024-05-20 21:44:40 发布

阅读量109

点赞数

分类专栏： Servlet 文章标签： java-ee

本文链接：https://blog.csdn.net/weixin_45974277/article/details/120606184

版权

Servlet 专栏收录该内容

15 篇文章 0 订阅

订阅专栏

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
</head>
<body>
    <center>
        <form action="/myWeb/user/login" method="post">
            <table border="2">
                <tr>
                    <td>登录名</td>
                    <td><input type="text" name="userName"></td>
                </tr>
                <tr>
                    <td>密码</td>
                    <td><input type="text" name="password"></td>
                </tr>
                <tr>
                    <td><input type="submit" value="登录"></td>
                    <td><input type="reset" value="重置"></td>
                </tr>
            </table>
        </form>
    </center>
</body>
</html>

Dao:

public int login(String userName,String password) throws SQLException {
        ResultSet resultSet=null;
        int result = 0;
        String sql = "select count(*) from users where userName=? and password =?";
        try {
            PreparedStatement ps = jdbcUtil.createStatement(sql);
            ps.setString(1,userName);
            ps.setString(2,password);
            resultSet = ps.executeQuery();
            while (resultSet.next())
            {
                 result = resultSet.getInt("count(*)");
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            jdbcUtil.close(resultSet);
        }
        return result;
    }

servlet:

public class UserLoginServlet extends HttpServlet
{
    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException
    {
        int result = 0;
        UserDao userDao = new UserDao();
        String userName,password;
        req.setCharacterEncoding("utf-8");
        userName = req.getParameter("userName");
        password = req.getParameter("password");
        try {
            result = userDao.login(userName,password);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        if(result==1)
        {
            resp.sendRedirect("/myWeb/index.html");
        }else
        {
            resp.sendRedirect("/myWeb/loginError.html");
        }
    }
}

loginError:

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
</head>
<body>
    <center>
        <font style="color: red;font-size: 30px;">登录信息不存在，请重新登录</font>
        <form action="/myWeb/user/login" method="post">
            <table border="2">
                <tr>
                    <td>登录名</td>
                    <td><input type="text" name="userName"></td>
                </tr>
                <tr>
                    <td>密码</td>
                    <td><input type="text" name="password"></td>
                </tr>
                <tr>
                    <td><input type="submit" value="登录"></td>
                    <td><input type="reset" value="重置"></td>
                </tr>

            </table>
        </form>
    </center>
</body>
</html>

苏七qaq

关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
8.在线考试管理系统登录

login.html<!DOCTYPE html><html lang="en"><head> <meta charset="UTF-8"> <title>Title</title></head><body> <center> <form action="/myWeb/user/login" method="post"> ...
复制链接

扫一扫