用servlet实现简易的用户登录

用servlet实现简易的用户登录

今天学习了使用servlet实现简易的用户登录。
项目目录如图：需导入jstl和mysql-connector-java两个jar包。

在src下的com.zr0712里创建5个包，分别为dao，model，service，servlet，util。

util层是工具类，负责连接与关闭数据库：

package com.zr0712.util;
import java.sql.*;
//工具类，连接与关闭数据库
public class DBUtil {
    public static Connection getConnection() throws ClassNotFoundException, SQLException {
        Class.forName("com.mysql.cj.jdbc.Driver");
        Connection connection= DriverManager.getConnection("jdbc:mysql://localhost:3306/asd?serverTimezone=GMT%2B8&useSSL=false","root","");
        return connection;
    }

    public static void closeAll(ResultSet rs, Statement stmt,Connection conn) throws SQLException {
        if(rs!=null){
            rs.close();
        }
        if(stmt!=null){
            stmt.close();
        }
        if(conn!=null){
            conn.close();
        }
    }
}

dao层存放的代码是与数据库直接打交道的，对数据库进行具体的操作：

package com.zr0712.dao;

import com.zr0712.model.User;
import com.zr0712.util.DBUtil;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class UserDao {

    //根据用户输入的用户名，在数据库中找到一整条信息
    public User selectByName(String name) {
        ResultSet rs = null;
        Connection conn = null;
        PreparedStatement pstmt = null;
        DBUtil util = new DBUtil();
        User user = new User();
        try {
            conn = util.getConnection();
            pstmt = conn.prepareStatement("select * from user where name=?");
            pstmt.setString(1, name);//1表示把name值传入第一个问号，若有第二个问号，则用2表示

            rs = pstmt.executeQuery();
            while (rs.next()) {
                user.setId(rs.getInt(1));
                user.setName(rs.getNString(2));
                user.setPassword(rs.getString(3));
                user.setAge(rs.getString(4));
            }

        } catch (SQLException e) {
            e.printStackTrace();
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } finally {
            try {
                util.closeAll(rs, pstmt, conn);
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        return user;
    }
}

model层存放的是实体类，比如用户

package com.zr0712.model;
public class User {
    private int id;
    private String name;
    private String password;
    private String age;

    //getter和setter是有快捷键的，不需要手动写
    //用alt+insert或者鼠标右键generate

    public int getId() {
        return id;
    }

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

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getPassword() {
        return password;
    }

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

    public String getAge() {
        return age;
    }

    public void setAge(String age) {
        this.age = age;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", password='" + password + '\'' +
                ", age='" + age + '\'' +
                '}';
    }
}

service层处理业务逻辑，获取前端的请求，执行具体功能，调用dao层处理数据库的方法：

package com.zr0712.service;
import com.zr0712.dao.UserDao;
import com.zr0712.model.User;

//中介的作用
public class UserSrvice {

    UserDao userDao=new UserDao();

    public User selectByName(String name){
        return userDao.selectByName(name);
    }

}

servlet层：

package com.zr0712.servlet;
import com.zr0712.model.User;
import com.zr0712.service.UserSrvice;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;

public class LoginServlet extends HttpServlet{

    UserSrvice userSrvice=new UserSrvice();

    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws IOException {
        String name=req.getParameter("name");        //通过<input>标签里的name=“name”来传参
        String password=req.getParameter("password");
        System.out.println("name:"+name);
        System.out.println("password:"+password);
        User user=userSrvice.selectByName(name);
        System.out.println(user);
        if(password.equals(user.getPassword())){
            resp.getWriter().write("success");
            System.out.println("success");
        }else {
            resp.getWriter().write("failed");
            System.out.println("failed");
        }

    }

}

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>loginServlet</servlet-name>
        <servlet-class>com.zr0712.servlet.LoginServlet</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>loginServlet</servlet-name>
        <url-pattern>/login</url-pattern>
    </servlet-mapping>
</web-app>

index.jsp:

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
  <head>
    <title>$Title$</title>
  </head>
  <body>
    <h1>登录页面</h1>
    <form action="/login" method="post">
      name:<input name="name" type="text">
      password:<input name="password" type="password">
      <input type="submit" value="登录">
    </form>
  </body>
</html>

运行结果：

登录成功：

登录失败：

数据库中用户表：

控制台的输出提示：