jsp+mysql实现简单的用户登陆以及登陆验证
所需工具:
eclipse、安装mysql数据库、Navicat for mysql(可有可无)、mysql-connector-java-x.x.xx.jar包(本博客用mysql-connector-java-8.0.16.jar)
创建一个用户表用来储存id和password
不会创建的可以区百度一下
通过jsp写一个简单的用户登陆页面
代码如下:
<%@ page import="java.sql.*" 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>
<center>
<h1 style="color:red">登录</h1>
<form id="indexform" name="indexForm" action="logincheck.jsp" method="post">
<table border="0">
<tr>
<td>账号:</td>
<td><input type="text" name="username"></td>
</tr>
<tr>
<td>密码:</td>
<td><input type="password" name="password">
</td>
</tr>
</table>
<br>
<input type="submit" value="登录" style="color:#BC8F8F">
</form>
</center>
</body>
</html>
通过jsp对登录用户进行效验
代码:本代码包含登陆失败、用户名为空效验
<%@ page import="java.sql.*" 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>
<%
Class.forName("com.mysql.jdbc.Driver"); 加载数据库驱动
String url = "jdbc:MySQL://localhost:3306/my?&useSSL=false&serverTimezone=UTC"; //指向数据库table1
String username = "root"; //数据库用户名
String password = "88888888"; //数据库用户密码
Connection conn = DriverManager.getConnection(url, username, password); //连接数据库
String name=(String)request.getParameter("username");
String word=(String)request.getParameter("password");//取出login.jsp的值
if(name==""||name==null){
out.print("<script language='javaScript'> alert('请输入用户名');</script>");
response.setHeader("refresh", "0;url=login.jsp");
}else{
//下面是数据库操作 *代表所有值
String sql="select * from my where id="+name+"";//定义一个查询语句
Statement stmt = null;
ResultSet rs = null;
stmt = conn.createStatement();
rs=stmt.executeQuery(sql);//返回结果集
if(rs.next())
{
/* if(password.equals(rs.getString(2)))
{
} */
if(word.equals(rs.getObject("password"))){
//response.sendRedirect("loginsuccess.jsp");//如果想要登陆成功后跳转到另一个页面利用:response.sendRedirect("想要跳转的页面");
out.print("登陆成功");//作为测试
}
else{
out.print("<script language='javaScript'> alert('密码错误');</script>");
response.setHeader("refresh", "0;url=login.jsp");
}
}
else
{
out.print("<script language='javaScript'> alert('请输入用户名——else');</script>");
response.setHeader("refresh", "0;url=login.jsp");
}
}
%>
</body>
</html>