纯jsp实现数据库的连接和验证登录

最新推荐文章于 2023-10-22 20:24:15 发布

南笙离

最新推荐文章于 2023-10-22 20:24:15 发布

阅读量1.5k

点赞数 2

分类专栏： Java对数据库的增删改查创建数据库表文章标签： jsp mysql

本文链接：https://blog.csdn.net/qq_44472453/article/details/116356676

版权

Java对数据库的增删改查创建数据库表专栏收录该内容

2 篇文章 0 订阅

订阅专栏

纯jsp实现数据库连接并且登录

代码段

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!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>登录页面</title>
</head>
<body>
<form action="dologin.jsp" method="post">
<h3>登录界面</h3>
账户：<input name="username" type="text"><br>
密码：<input name="passward" type="password"><br>
<input type="submit" value="登录">
</form>
</body>
</html>

数据库连接和处理阶段

dologin.jsp

数据库连接名：root 密码自己设置的

数据库名：root

表明：user


<%@page import="java.sql.DriverManager"%>
<%@page import="com.mysql.jdbc.Driver"%>
<%@page import="java.sql.Connection"%>
<%@page import="java.sql.*"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>
<!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>
	<%
		String name = request.getParameter("username");
		String pwd = request.getParameter("password");

		Class.forName("com.mysql.jdbc.Driver");
		Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/root", "root", "123456");
		PreparedStatement preparedStatement=connection.prepareStatement("select * from user where username=? and password=?");
		preparedStatement.setString(1,name);
		preparedStatement.setString(2,pwd);
		
		ResultSet resultSet=preparedStatement.executeQuery();
		if(resultSet.next()){
			response.sendRedirect("default.jsp");
		}else{
			response.sendRedirect("success.jsp");
		}
		connection.close();
		preparedStatement.close();
	%>

</body>
</html>

登录成功页面

success.jsp


<%@page import="java.sql.DriverManager"%>
<%@page import="com.mysql.jdbc.Driver"%>
<%@page import="java.sql.Connection"%>
<%@page import="java.sql.*"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>
<!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>
成功！！
</body>
</html>

登录失败页面

default.jsp


<%@page import="java.sql.DriverManager"%>
<%@page import="com.mysql.jdbc.Driver"%>
<%@page import="java.sql.Connection"%>
<%@page import="java.sql.*"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>
<!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>
失败！！
</body>
</html>

南笙离

关注

2
点赞
踩
45

收藏

觉得还不错? 一键收藏
2
评论
纯jsp实现数据库的连接和验证登录

目录纯jsp实现数据库连接并且登录代码段login.jsp<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%><!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html>
复制链接

扫一扫