Html+Servlet+c3p0+DBUtils+MySQL 实现登录注册功能

最新推荐文章于 2024-07-21 17:58:14 发布

MaGgIeOo0

最新推荐文章于 2024-07-21 17:58:14 发布

阅读量74

点赞数

分类专栏： javaweb 文章标签： html servlet mysql

本文链接：https://blog.csdn.net/weixin_62971115/article/details/132514438

版权

javaweb 专栏收录该内容

11 篇文章 0 订阅

订阅专栏

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>登录页面</title>
</head>
<body>
<form action="managerServlet?type=login" method="post" >
    <h1>登录</h1>
    <table>
        <tr>
            <td>账号：</td>
            <td><input type="text" name="usernameLog"></td>
        </tr>
        <tr>
            <td>密码：</td>
            <td><input type="password" name="passwordLog"></td>
        </tr>
    </table>
    <input type="submit">
</form>
</body>
</body>
</html>

registered.html

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>注册页面</title>
</head>
<body>
<h1>注册</h1>
<form action="managerServlet?type=registered" method="post" >
    用户名：<input type="text" name="usernameRes"><br>
    密码：<input type="password" name="passwordRes">
    <input type="submit" >
</form>
</body>
</html>

web.xml

<?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>ManagerServlet</servlet-name>
        <servlet-class>com.etime.servlet.ManagerServlet</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>ManagerServlet</servlet-name>
        <url-pattern>/managerServlet</url-pattern>
    </servlet-mapping>
</web-app>

实体类

package com.etime.entity;

public class Manager {
    private int id;
    private String username;
    private String password;

    public Manager() {
    }

    public Manager(int id, String username, String password) {
        this.id = id;
        this.username = username;
        this.password = password;
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }
}

dao

package com.etime.dao;

import com.etime.entity.Manager;
import com.etime.util.QueryRunnerUtils;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;
import org.junit.Test;

import java.sql.SQLException;

public class ManagerDao {
    //登录
    public Manager login(String username , String password){
        QueryRunner queryRunner = QueryRunnerUtils.getQueryRunner();
        String sql = "select * from manager where username = ? and password = ?";
        Manager manager = null;
        try {
            manager = queryRunner.query(sql, new BeanHandler<>(Manager.class), username, password);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return manager;
    }
    //注册
    public int registered(String username , String password){
        QueryRunner queryRunner = QueryRunnerUtils.getQueryRunner();
        String sql = "insert into manager(username,password) values(?,?)";
        int i = 0;
        try {
            i = queryRunner.update(sql,username,password);
        } catch (SQLException e) {
            e.printStackTrace();
        }
       return i;
    }
}

工具层

package com.etime.util;

import com.mchange.v2.c3p0.ComboPooledDataSource;
import org.apache.commons.dbutils.QueryRunner;

public class QueryRunnerUtils {
    private static ComboPooledDataSource comboPooledDataSource = new ComboPooledDataSource();
    private static QueryRunner queryRunner = new QueryRunner(comboPooledDataSource);

    public static QueryRunner getQueryRunner() {
        return queryRunner;
    }
}

servlet

package com.etime.servlet;

import com.etime.dao.ManagerDao;
import com.etime.entity.Manager;

import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.annotation.*;
import java.io.IOException;

public class ManagerServlet extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

    }

    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        ManagerDao managerDao = new ManagerDao();
        String type = request.getParameter("type");
        if (type.equals("login")) {
            String user = request.getParameter("usernameLog");
            String pass = request.getParameter("passwordLog");

            Manager manager = managerDao.login(user, pass);
            if (manager == null) {
                response.sendRedirect("login.html");
            } else {
                response.sendRedirect("index.jsp");
            }
        } else if(type.equals("registered")) {
            String userRes = request.getParameter("usernameRes");
            String passRes = request.getParameter("passwordRes");

            int registered = managerDao.registered(userRes, passRes);
            if (registered != 0) {
                response.sendRedirect("login.html");
            } else {
                response.sendRedirect("registered.html");
            }
        }


    }
}