数据库登录验证——DAO

最新推荐文章于 2024-01-07 01:00:56 发布

Flora_M

最新推荐文章于 2024-01-07 01:00:56 发布

阅读量1.5k

点赞数 1

分类专栏： JavaWeb

本文链接：https://blog.csdn.net/Flora_SM/article/details/95079205

版权

JavaWeb 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

beans:

package beans;
import java.sql.*;
public class DBconnection {

	private static Connection conn;
	private static Statement stmt;
	private static ResultSet rs;
	
	public Connection getCon() throws ClassNotFoundException, SQLException {
		String url="jdbc:mysql://localhost:3306/user?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8&useSSL=false";
		String name="root";
		String pwd="root";
		Class.forName("com.mysql.cj.jdbc.Driver");
		Connection conn=DriverManager.getConnection(url,name,pwd);
		return conn;
	}
	
	public void close() throws SQLException {
		if(rs!=null) rs.close();
		if(stmt!=null) stmt.close();
		if(conn!=null) conn.close();
	}
}

package beans;

public class User {

	private String name;
	private String pwd;

	public User(String name, String pwd) {
		this.name = name;
		this.pwd = pwd;
	}

	public User() {

	}

	public String getName() {
		return name;
	}

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

	public String getPwd() {
		return pwd;
	}

	public void setPwd(String pwd) {
		this.pwd = pwd;
	}
	
	

}

DAO:

package dao;

import beans.User;

public abstract class IUserDAO {

	public abstract boolean login_check(User uu) throws Exception;
}

package dao;

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

import beans.DBconnection;
import beans.User;

public class UserDAO extends IUserDAO {

	@Override
	public boolean login_check(User uu) throws Exception {
		DBconnection db = new DBconnection();
		Connection conn = db.getCon();
		String sql = "select * from login where(uname=? and upwd=?)";
		PreparedStatement pstm = conn.prepareStatement(sql);
		pstm.setString(1, uu.getName());
		pstm.setString(2, uu.getPwd());
		ResultSet rs = pstm.executeQuery();
		if (rs.next())
			return true;
		else
			return false;
	}

}

servlets

package servlets;

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 beans.User;
import dao.UserDAO;

/**
 * Servlet implementation class Servlet
 */
@WebServlet("/Servlet")
public class Servlet extends HttpServlet {
	private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public Servlet() {
        super();
        // TODO Auto-generated constructor stub
    }

	/**
	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		/*
		 * response.getWriter().append("Served at: ").append(request.getContextPath());
		 */
	}

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		String xm=request.getParameter("name");
		String mm=request.getParameter("pwd");
		User uu=new User(xm,mm);
		UserDAO dao=new UserDAO();
		try {
			if(dao.login_check(uu))
				request.getRequestDispatcher("/success.jsp").forward(request,response);
			else
				request.getRequestDispatcher("/error.jsp").forward(request, response);
		} catch (Exception e) {
			e.printStackTrace();
		}
		
	}

}

jsp:

tijiao.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<form action="Servlet" method="post">
用户名：<input name="name"><br><br>
密码：<input name="pwd"><br><br>
<input type="submit" value="登录"> &nbsp;
<input type="reset">
</form>
</body>
</html>

success.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
success!
</body>
</html>

error.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
error!
</body>
</html>

Flora_M

关注

1
点赞
踩
9

收藏

觉得还不错? 一键收藏
0
评论
数据库登录验证——DAO

beans:package beans;import java.sql.*;public class DBconnection { private static Connection conn; private static Statement stmt; private static ResultSet rs; public Connection getCon() th...
复制链接

扫一扫

专栏目录