SpringBoot+MyBatis实现登录案例
程序员文章站
2022-04-06 22:32:42
1.创建一个springboot项目2.创建表create database login; use login; create table userlogin(username varchar(49...
1.创建一个springboot项目
2.创建表
create database login; use login; create table userlogin( username varchar(49), password varchar(49) )
3.idea连接mysql
4. 创建实体类userlogin
@data @allargsconstructor @noargsconstructor @table(name = "userlogin")/* <dependency> <groupid>javax.persistence</groupid> <artifactid>persistence-api</artifactid> <version>1.0</version> </dependency> */ public class userlogin { private string username; private string password; }
5.创建mapper。数据持久层userloginmapper接口
@mapper @repository public interface userloginmapper { //定义增删改查方法 //查询所有 public list<userlogin> queryall(); //添加数据 public int add(userlogin userlogin); //根据用户名查询 public userlogin querybyusername(string username); }
6.在resources下建userloginmapper.xml文件
<?xml version="1.0" encoding="utf-8"?> <!doctype mapper public "-//mybatis.org//dtd mapper 3.0//en" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="自己的mapper接口"> <select id="queryall" resulttype="自己的实体类接口"> select * from userlogin </select> <insert id="add" parametertype="自己的实体类接口"> insert into userlogin values (#{username},#{password}) </insert> <select id="querybyusername" resulttype="自己的实体类接口"> select * from userlogin where username=#{username} </select> </mapper>
7.编写userlogservice接口
public interface userlonginservice { public interface userloginservicesl { //查询所有 public list<userlogin> queryall(); //添加数据 public int add(userlogin userlogin); //根据用户名查询 public userlogin querybyusername(string username); } }
8.编写控制层mycontroller
@controller public class mycontroller { //controller层调用service层 //创建一个service层对象 @autowired userloginservicesimpl userloginservices; //登录 @requestmapping("/tologin") public string tologin() { return "login"; } @requestmapping("/loginsuccess") public string loginsuccess(model model, userlogin userlogin) { //查询用户名是否存在 userlogin userlogin1 = userloginservices.querybyusername(userlogin.getusername()); if (userlogin1 != null) { //如果用户名存在 if (userlogin1.getpassword().equals(userlogin.getpassword())) { system.out.println(userlogin1.tostring()); return "success"; } else { model.addattribute("data", "密码不正确"); return "login"; } } else { //用户名不存在,直接返回到登录页面 model.addattribute("data", "该用户不存在,请先注册"); return "login"; } } //注册 @requestmapping("/toregister") public string toregister() { return "register"; } @requestmapping("/toregistersuccess") public string toregistersuccess(model model,userlogin userlogin) { //添加一条记录到数据库中 int add = userloginservices.add(userlogin); system.out.println("插入数据成功"); model.addattribute("data","注册成功,请登录"); return "login"; } }
9.前端页面
10.login.html 登录的页面
<!doctype html> <html lang="en" xmlns:th="http://www.thymeleaf.org"> <head> <meta charset="utf-8"> <title>login</title> </head> <body background="back.jpg"> <div align="center"> <br><br><h2>登录界面</h2><br><br> <span th:text="${data}" style="text-color:red;font-size: 10px"></span> <form method="get" action="/loginsuccess"> 用户名:<input type="text" name="username" placeholder="请输入用户名" required/><br><br> 密码:<input type="text" name="password" placeholder="请输入密码" required/><br><br> <input type="submit" value="登录"> </form> <br> <form method="get" action="/toregister"> <input type="submit" value="注册"> </form> </div> </body> </html>
11.注册界面
<!doctype html> <html lang="en" xmlns:th="http://www.thymeleaf.org"> <head> <meta charset="utf-8"> <title>register</title> </head> <body background="back.jpg" > <div align="center"> <br><br><h1>注册界面</h1><br><br> <form method="get" action="/toregistersuccess"> 用户名:<input type="text" name="username" placeholder="请输入用户名" required/><br><br> 密码:<input type="text" name="password" placeholder="请输入密码" required/><br><br> 确认密码:<input type="text" name="password2" placeholder="请输入密码" required/><br><br> <input type="submit" value="注册"> </form> </div> </body> </html>
success.html:成功页面
以上就是springboot+mybatis登录案例的详细内容,更多关于springboot mybatis登录的资料请关注其它相关文章!