使用jdbc+servlet进行登陆账号的认证

最新推荐文章于 2019-08-06 15:53:14 发布

于先森啊

最新推荐文章于 2019-08-06 15:53:14 发布

阅读量597

点赞数

分类专栏： servlet 文章标签： jdbc servlet 数据库

本文链接：https://blog.csdn.net/yuhui123999/article/details/51520219

版权

servlet 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

首先应该新建一个配置文件用来放连接jdbc的所需的信息

conflg.properties

<span style="font-size:14px;">driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost/javaBook
username=root
password=123456</span>

新建一个class去进行连接数据库

DBUtil.class

import java.io.FileNotFoundException;
import java.io.FileReader;
import java.io.Reader;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;


public class DBUtil {
	private static String driver;
	private static String url;
	private static String username;
	private static String password;
	
	static{
		Properties prop = new Properties();
		try {
//			Reader in = new FileReader("src\\conflg.properties");
			prop.load(DBUtil.class.getClassLoader().getResourceAsStream("conflg.properties"));
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}	
		driver = prop.getProperty("driver");
		url = prop.getProperty("url");
		username = prop.getProperty("username");
		password = prop.getProperty("password");
	}
	
	public static Connection open(){
		try {
			Class.forName(driver);
			return DriverManager.getConnection(url,username,password);
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return null;
	}
	
	public static void close(Connection conn){
		if(conn!=null){
			try {
				conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}
}

新建两个html文件

<span style="font-size:14px;"><!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<form action="MyLogin" method="post">
UserName:<input type="text" name="username"><br/>
Password:<input type="password" name="password"><br/>
<input type="submit" value="Login">
</form>
</body>
</html></span>

Welcome.jsp 登录成功页面

<span style="font-size:14px;"><%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
welcom,${UserSession.username}
</body>
</html></span>

新建一个class存放用户表的信息

User.class

<span style="font-size:14px;">public class User {
	private String username;
	private String password;
	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;
	}
	
}</span>

新建一个接口，里面定义一个登入验证的方法

UserDao.interface

public interface UserDao {
	public User login(String username,String password);
}

新建一个类去实现UserDao接口

UserDaoImpl.class

<span style="font-size:14px;">import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class UserDaoImpl implements UserDao{

	@Override
	public User login(String username, String password) {
		// TODO Auto-generated method stub
		Connection conn = DBUtil.open();
		String sql = "select username,password from user where username=? and password=?";
		try {
			PreparedStatement pstmt = conn.prepareStatement(sql);
			pstmt.setString(1, username);
			pstmt.setString(2, password);
			
			ResultSet rs = pstmt.executeQuery();
			if(rs.next()){
				User u = new User();
				u.setUsername(username);
				u.setPassword(password);
				return u;
			}
			
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return null;
	}

}</span><span style="color:#ff0000;font-size:18px;">
</span>

新建一个servlet去对用户输入的信息进行获取并处理

MyLogin.class

<span style="font-size:14px;">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 javax.servlet.http.HttpSession;

/**
 * Servlet implementation class MyLogin
 */
@WebServlet("/MyLogin")
public class MyLogin extends HttpServlet {
	private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public MyLogin() {
        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
		String username = request.getParameter("username");
		String password = request.getParameter("password");
		
		UserDao dao = new UserDaoImpl();
		User u = dao.login(username, password);
		if(u!=null){
			HttpSession session = request.getSession();
			session.setAttribute("UserSession", u);
			request.getRequestDispatcher("Welcome.jsp").forward(request, response);
		}
		else{
			System.out.println("username or password error,please relog!");
			request.getRequestDispatcher("login.html").forward(request, response);
		}
	}

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		doGet(request, response);
	}

}
</span>

最重要的一点是一定要把mysql的jar包导入到WebContent/WEB-INF/lib下

如果无法导入，可以参考http://dev-song.iteye.com/blog/1290639

于先森啊

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
使用jdbc+servlet进行登陆账号的认证

首先应该新建一个配置文件用来放连接jdbc的所需的信息conflg.propertiesdriver=com.mysql.jdbc.Driverurl=jdbc:mysql://localhost/javaBookusername=rootpassword=123456新建一个class去进行连接数据库DBUtil.classimport java.io.
复制链接

扫一扫

专栏目录