简易的Java Web Application 实现用户登录功能，环境配置加代码实现

最新推荐文章于 2022-09-17 10:53:59 发布

OrangRain

最新推荐文章于 2022-09-17 10:53:59 发布

阅读量709

点赞数 2

文章标签： java web app

本文链接：https://blog.csdn.net/qq_42474264/article/details/107468877

版权

项目软件

IntelIij IDEA、Tomcat

项目环境配置

1.新建项目

操作顺序：File->New->Project->Java Enterpise->Web Application

2.导入项目所需包

项目中使用到的jar文件有mysql-connector-java-5.0.8-bin.jar，扩展包有servlet-api.jar

mysql-connector-java-5.0.8-bin.jar导入项目，先在本地下载好这个包，在web->WEB-INF新建文件lib，将mysql文件粘贴在lib目录，右键jar文件，选择 Add as Library
在这里插入图片描述 servlet-api.jar导入项目,servlet-api.jar在安装的Tomcat目录下lib文件夹中,操作步骤File->project Structure->Module->±>Librarys->选择Tomcat安装目录下lib文件夹中的servlet-api.jar
都安装好了效果图
项目使用到的数据库表结构和数据如下
在这里插入图片描述

3. 另外的一些配置

配置TomCat
在这里插入图片描述
修改名称和一些配置
deployment下的Application context删除
index.jsp

<html>
  <head>
    <title>$Title$</title>
  </head>
  <body>
  <form action="/hello" method="get" autocomplete="on">
    userName:<input type="text" name="Username" /><br />
    password: <input type="password" name="passWord" autocomplete="off" /><br />
    <input type="submit" value="登录" onclick="window.location.href=/success"/>
  </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>hello</servlet-name>
        <servlet-class>com.rz.serlet.UserServlet</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>hello</servlet-name>
        <url-pattern>/hello</url-pattern>
    </servlet-mapping>
</web-app>

项目编码

在src目录下，新建package com.zr，再新建四个package，分别为bean,dao,serlet,util。bean存放实体对象User，dao(Data Access Object数据访问接口,数据持久层)存放数据库操作，serlet实现对前端页面的响应，util存放一些公用方法。
在bean中新建java文件User，该类是实体对象。User.java如下所示。

package com.zr.bean;

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

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

    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;
    }

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

在util中新建java文件DBUtil，该文件用于数据的连接和关闭。DBUtil.java如下所示。

package com.zr.util;


import java.sql.*;

public class DBUtil {
    DBUtil(){

    }
    public static Connection getConnection() throws ClassNotFoundException, SQLException {
        Class.forName("com.mysql.jdbc.Driver");
        Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/database","root","123456");
        return connection;
    }

    public static void closeAll(ResultSet resultSet, Statement statement, Connection connection) throws SQLException {
       if(resultSet !=null){
           resultSet.close();
        }
       if(statement!=null) {
           statement.close();
       }
       if(connection!=null) {
           connection.close();
       }
    }
}

在dao包中新建java文件UserDao，该类封装了操作数据库的一些方法

package com.zr.dao;

import com.zr.bean.User;
import com.zr.util.DBUtil;

import java.sql.*;
import java.util.ArrayList;
import java.util.List;

public class UserDao {
    public List<User> findAll() throws SQLException, ClassNotFoundException {
        List<User> userList = new ArrayList<>();
        Connection connection = DBUtil.getConnection();
        String sql = "select * from tb_user";
        PreparedStatement statement = connection.prepareStatement(sql);
        ResultSet resultSet = statement.executeQuery(sql);
        while (resultSet.next()) {
                User user = new User();
                user.setId(resultSet.getInt(1));
                user.setUsername(resultSet.getString(2));
                user.setPassword(resultSet.getString(3));
                userList.add(user);
        }
        DBUtil.closeAll(resultSet,statement,connection);
        return userList;
    }
    public boolean UserExist(String userName,String passWord) throws SQLException, ClassNotFoundException {
        Connection connection = DBUtil.getConnection();
        String sql = "select password from tb_user where username = "+"'"+userName+"'";
        PreparedStatement statement = connection.prepareStatement(sql);
        ResultSet resultSet = statement.executeQuery(sql);
        while (resultSet.next())
        {
            String DBpassWord = resultSet.getString(1);
            if (DBpassWord.equals(passWord))
                return true;
        }
        return false;
    }
}

最后是在serlet中用UserServlet对象处理前端的请求，UserServlet.java具体如下。


package com.zr.serlet;
import com.zr.bean.User;
import com.zr.dao.UserDao;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.sql.SQLException;
import java.util.List;


public class UserServlet extends HttpServlet{
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        req.setCharacterEncoding("UTF-8");
        String userName = req.getParameter("Username");
        String passWord = req.getParameter("passWord");
        UserDao userDao = new UserDao();
        try {
            if(userDao.UserExist(userName,passWord)) {
                resp.getWriter().write("welcome "+ userName);
            }
            else{
                resp.getWriter().write("The user doesn't exist or password is not correct");
            }
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
    }
}