SpringBoot+MyBatis实现登录案例 SpringBoot+MyBatis实现登录案例

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")/*javax.persistencepersistence-api1.0*/public class UserLogin {private String username; private String password; }

5.创建mapper。数据持久层UserLoginMapper接口

@Mapper@Repositorypublic interface UserLoginMapper { //定义增删改查方法 //查询所有public List queryAll(); //添加数据 public int add(UserLogin userLogin); //根据用户名查询 public UserLogin queryByUsername(String username); }

6.在resources下建UserLoginMapper.xml文件

select * from userlogin insert into userlogin values (#{username},#{password}) select * from userlogin where username=#{username}

7.编写UserLogService接口

public interface UserLonginService {public interface UserLoginServicesl {//查询所有public List queryAll(); //添加数据public int add(UserLogin userLogin); //根据用户名查询public UserLogin queryByUsername(String username); }}

8.编写控制层MyController

@Controllerpublic 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.前端页面