jsp mysql完整注册登陆_JSP+MySQL最简单的登录和注册的实现 --Java Web温习

一、开发环境

开发工具：eclipse 2018-09

操作系统：win10

二、实现

1、目录结构：

2、数据库(创建tmp数据库，新建user表，user表结构如下)

3、功能简介

功能比较简单，在这简要叙述一下。在注册页面register.jsp对应的输入框中输入用户名和密码，跳转到check_reg.jsp页面。check_reg.jsp只是用来获取提交的表单，主要是连接MySQL数据库，将用户名和密码存入数据库中。如果注册成功，则跳转(重定向)到登陆页面login.jsp。在登陆页面中，在对应输入框中输入用户名和密码，将表单数据提交到check_login.jsp页面。check_login.jsp负责接受表单数据，向数据库中查询数据，如果查找到，跳转到login_success.jsp页面。

4、代码实现

login.jsp:

pageEncoding="UTF-8"%>

href="https://cdn.jsdelivr.net/npm/bootstrap@3.3.7/dist/css/bootstrap.min.css"

integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u"

crossorigin="anonymous">

integrity="sha384-Tc5IQib027qvyjSMfHjOMaLkfuWVxZxUPnCJA7l2mCWNIpG9mGCD8wGNIcPD7Txa"

crossorigin="anonymous">

function checkForm() {

var name = loginForm.name.value;

var pwd = loginForm.pwd.value;

//alert(name + pwd);

if (name == "" || name == null) {

alert("请输入用户名");

loginForm.name.focus();

return false;

} else if (pwd == "" || pwd == null) {

alert("请输入密码");

loginForm.pwd.focus();

return false;

}

return true;

}

check_reg.jsp：

pageEncoding="UTF-8"%>

Connection conn = null;

PreparedStatement ps = null;

Class.forName("com.mysql.jdbc.Driver");

String url = "jdbc:mysql://localhost:3306/tmp?useSSL=false";

String username = "root";

String password = "nxl123";

conn = DriverManager.getConnection(url, username, password);

request.setCharacterEncoding("utf-8");//设置编码方式，防止中文乱码

String name = request.getParameter("name");

String pwd = request.getParameter("pwd");

String sql = "INSERT user(name,pwd) VALUES(?,?)";

ps = conn.prepareStatement(sql);

ps.setString(1, name);

ps.setString(2, pwd);

int row = ps.executeUpdate();

if (row > 0) {

response.sendRedirect("./login.jsp");//重定向到登陆页面

}

%>

login.jsp：

pageEncoding="UTF-8"%>

href="https://cdn.jsdelivr.net/npm/bootstrap@3.3.7/dist/css/bootstrap.min.css"

integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u"

crossorigin="anonymous">

integrity="sha384-Tc5IQib027qvyjSMfHjOMaLkfuWVxZxUPnCJA7l2mCWNIpG9mGCD8wGNIcPD7Txa"

crossorigin="anonymous">

function checkForm() {

var name = loginForm.name.value;

var pwd = loginForm.pwd.value;

//alert(name + pwd);

if (name == "" || name == null) {

alert("请输入用户名");

loginForm.name.focus();

return false;

} else if (pwd == "" || pwd == null) {

alert("请输入密码");

loginForm.pwd.focus();

return false;

}

return true;

}

check_login.jsp：

pageEncoding="UTF-8"%>

Connection conn = null;

PreparedStatement ps = null;

ResultSet rs = null;

Class.forName("com.mysql.jdbc.Driver");

String url = "jdbc:mysql://localhost:3306/tmp?useSSL=false";

String username = "root";

String password = "nxl123";

conn = DriverManager.getConnection(url, username, password);

request.setCharacterEncoding("utf-8");

String name = request.getParameter("name");

String pwd = request.getParameter("pwd");

String sql = "SELECT *FROM user WHERE name ='" + name + "'AND pwd = '" + pwd + "'";

ps = conn.prepareStatement(sql);

rs = ps.executeQuery();

if (rs.next()) {

response.sendRedirect("./login_success.jsp");

}else{

response.sendRedirect("./login.jsp");

}

%>

login_success.jsp：

pageEncoding="UTF-8"%>

href="https://cdn.jsdelivr.net/npm/bootstrap@3.3.7/dist/css/bootstrap.min.css"

integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u"

crossorigin="anonymous">