本文主要是介绍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、代码实现
register.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">
注册
用户名
class="form-control" name="name" placeholder="请输入用户名"
autofocus="autofocus">
密码
class="form-control" name="pwd" placeholder="请输入密码">
重复密码
class="form-control" name="repwd" placeholder="请重复密码">
οnclick="return checkForm()">注册
integrity="sha384-Tc5IQib027qvyjSMfHjOMaLkfuWVxZxUPnCJA7l2mCWNIpG9mGCD8wGNIcPD7Txa"
crossorigin="anonymous">
function checkForm() {
var name = registerForm.name.value;
var pwd = registerForm.pwd.value;
var repwd = registerForm.repwd.value;
//alert(name + pwd + repwd);
if (name == "" || name == null) {
alert("请输入用户名");
registerForm.name.focus();
return false;
} else if (pwd == "" || pwd == null) {
alert("请输入密码");
registerForm.pwd.focus();
return false;
} else if (repwd == "" || repwd == null) {
alert("请输入重复密码");
registerForm.repwd.focus();
return false;
}else if(pwd!=repwd){
alert("两次密码输入不一致，请重新输入!");
registerForm.repwd.focus();
return false;
}
alert('注册成功！');
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">
登录
用户名
class="form-control" name="name" placeholder="请输入用户名">
密码
class="form-control" name="pwd" placeholder="请输入密码">
οnclick="return checkForm()">登录
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">
这篇关于jsp mysql_JSP+MySQL最简单的登录和注册的实现 --Java Web温习的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！
