javaweb 检验账号_Javaweb实现用户登录并且在数据库中查找匹配的账号密码

最新推荐文章于 2023-09-22 01:46:34 发布

斯提利科

最新推荐文章于 2023-09-22 01:46:34 发布

阅读量1.1k

点赞数

文章标签： javaweb 检验账号

本文链接：https://blog.csdn.net/weixin_36077932/article/details/113570122

版权

本文档介绍了如何使用JavaWeb进行用户登录功能的实现，包括Dao层、Service层和UI层的代码实现。通过三层架构设计，实现了从数据库中查找匹配的账号和密码的功能。用户输入的账号和密码会与数据库中的数据进行比对，验证登录是否成功。同时，展示了登录界面的前端JSP代码和登录验证的后端代码。

摘要由CSDN通过智能技术生成

1.业务需求：

2 后端代码：

三层架构：

(1)Dao层：

package cn.dao;

import java.util.List;

import cn.domain.User;

public interface UserDao {

List find();

boolean login(String username, String password);

}

package cn.dao;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.ArrayList;

import java.util.List;

import org.junit.Test;

import DBHelper.DBConnection;

import cn.domain.User;

public class UserDaoImpl implements UserDao {

private Connection connection = DBConnection.getConnection();

private PreparedStatement preparedStatement = null;

private ResultSet resultSet = null;

private String sql = "";

@Test

public void test0() {

UserDao dao = new UserDaoImpl();

for(User e: dao.find()) System.out.println(e);

}

public List find() {

List users = null;

sql = "SELECT * FROM tb_user";

try {

preparedStatement = (PreparedStatement) connection.prepareStatement(sql);

resultSet = preparedStatement.executeQuery();

users = new ArrayList();

User user;

while (resultSet.next()) {

user = new User(resultSet.getInt(1), resultSet.getString(2), resultSet.getString(3));

users.add(user);

}

} catch (Exception e) {

e.printStackTrace();

}

return users;

}

(2)Service层：

package cn.service;

import java.util.List;

import cn.domain.User;

public interface UserBll {

List find();

boolean login(String username, String password);

}

package cn.service;

import java.util.List;

import cn.dao.UserDao;

import cn.dao.UserDaoImpl;

import cn.domain.User;

public class UserBllImpl implements UserBll {

private UserDao dao = new UserDaoImpl();

public List find() {

return dao.find();

}

(3)UI层：

实体类User：

package cn.domain;

public class User {

private int id;

private String username;

private String password;

public User() {

super();

}

public User(int id, String username, String password) {

super();

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;

}

@Override

public String toString() {

return "User [id=" + id + ", username=" + username + ", password=" + password + "]";

}

UserServlet：

package cn.ui;

import java.io.IOException;

import javax.servlet.ServletException;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import cn.service.UserBll;

import cn.service.UserBllImpl;

/**

* Servlet implementation class UserServlet

@WebServlet("/UserServlet")

public class UserServlet extends HttpServlet {

private static final long serialVersionUID = 1L;

private UserBll bll = new UserBllImpl();

protected void doGet(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

// 接收业务请求-业务分发-调用bll-传递数据-跳转至前端

// 以下两行解决数据录入乱码问题

request.setCharacterEncoding("UTF-8");

response.setCharacterEncoding("UTF-8");

String op = request.getParameter("op").toString(); // 客户请求数据

/**

* 显示用户所有信息

if ("find".equals(op)) { // 业务分发

request.setAttribute("USERS", bll.find());

request.getRequestDispatcher("user/showUsers.jsp").forward(request, response); // 跳转到前端

}

response.getWriter().append("Served at: ").append(request.getContextPath());

}

protected void doPost(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

this.doGet(request, response);

}

链接数据库的工具

(4)DBHelper：

package DBHelper;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import org.junit.Test;

import com.mysql.jdbc.PreparedStatement;

public class DBConnection {

private static Connection connection = null;

private static String className = "com.mysql.jdbc.Driver";

private static String url = "jdbc:mysql://localhost:3306/ebus?useUnicode=true&characterEncoding=utf-8&useSSL=false";

private static String user = "root";

private static String password = "wangjian";

//连接数据库

public static Connection getConnection() {

try {

Class.forName(className); //加载驱动

connection = DriverManager.getConnection(url, user, password); //创建连接

} catch (Exception e) {

e.printStackTrace();

}

return connection;

}

//关闭连接

public static void Close(Connection connection, PreparedStatement preparedStatement, ResultSet resultSet) {

try {

if (resultSet != null)

resultSet.close();

if (preparedStatement != null)

preparedStatement.close();

if (connection != null)

connection.close();

} catch (Exception e) {

e.printStackTrace();

}

@Test

public void test() {

System.out.println(DBConnection.getConnection());

}

3 前端JSP代码：

(1)login.jsp登录界面：

pageEncoding="UTF-8"%>

javaweb 检验账号_Javaweb实现用户登录并且在数据库中查找匹配的账号密码

用户登陆

登录