springboot 整合 mybatis + thymeleaf 登录注册
学习网址
springboot+jsp
https://blog.csdn.net/qq_40205116/article/details/102990708
springboot+数据库
https://blog.csdn.net/qq_40205116/article/details/103430435
项目整体结构
pom.xml
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>org.example</groupId>
<artifactId>task</artifactId>
<version>1.0-SNAPSHOT</version>
<properties>
<maven.compiler.source>16</maven.compiler.source>
<maven.compiler.target>16</maven.compiler.target>
</properties>
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.4.5</version>
<relativePath/>
</parent>
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<!--thymeleaf依赖-->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-thymeleaf</artifactId>
</dependency>
<!-- web -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<!-- 整合JSP -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-tomcat</artifactId>
</dependency>
<dependency>
<groupId>org.apache.tomcat.embed</groupId>
<artifactId>tomcat-embed-jasper</artifactId>
</dependency>
<!-- JSTL -->
<dependency>
<groupId>jstl</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.18.6</version>
<scope>provided</scope>
</dependency>
<!--springboot依赖-->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<!--mysql依赖-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<!--lombok-->
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.18.20</version>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.2.6</version>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.1.1</version>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
<exclusions>
<exclusion>
<groupId>org.junit.vintage</groupId>
<artifactId>junit-vintage-engine</artifactId>
</exclusion>
</exclusions>
</dependency>
</dependencies>
</project>
src/main/java/con/rainbow/entity/user.java
命名方式有点不规范,应该把类名改为User(U大写),懒得改了
package com.rainbow.entity;
import lombok.Data;
import lombok.NonNull;
@Data
public class user {
@NonNull()
private int id;
private String account;
private String password;
public user() {
}
}
src/main/java/con/rainbow/mapper/UserMapper.java
里面的函数要和resources/mapper/UserMapper.xml里的id相同
类似 这样的<select id=“findByAccount” parameterType=“String” resultType=“user”></select>
UserMapper.xml文件的namespace也一定是这个目录
<mapper namespace=“com.rainbow.mapper.UserMapper”>
package com.rainbow.mapper;
import com.rainbow.entity.user;
import org.apache.ibatis.annotations.Mapper;
@Mapper
public interface UserMapper {
//通过账号查找
public user findByAccount(String account);
//注册
public void insertAccount(user u);
}
src/main/java/con/rainbow/service/UserService.java
service的类口类和实现类都要写@Service不然会有问题,其中有一个类忘记写可以跑起来,但是功能跑不起来,不记得是那个类了
package com.rainbow.service;
import com.rainbow.entity.user;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Service;
@Service
public interface UserService {
//通过账号查找
public user findByAccount(String account);
//注册
public void insertAccount(user u);
}
src/main/java/con/rainbow/service/Impl/ImplUserService.java
上面接口的实现类
package com.rainbow.service.Impl;
import com.rainbow.entity.user;
import com.rainbow.mapper.UserMapper;
import com.rainbow.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
@Service
public class ImplUserService implements UserService {
@Autowired
private UserMapper userMapper;
@Override
public user findByAccount(String account) {
return userMapper.findByAccount(account);
}
@Override
public void insertAccount(user u) {
userMapper.insertAccount(u);
}
}
src/main/java/con/rainbow/controller/Usercontroller.java
Usercontroller应该写为UserController,懒得改了
稍微解释一下下面的代码:
当我输入http://localhost:8080/user/login请求的进入Login()函数,函数返回login根据配置文件加上前缀classpath:/templates/(ps,classpath就是resources目录),加上后缀.html
那就跳转到resources/login.html,login里的action是loginResult那就返回findByaccount函数,进行登录的判断。
其他的类推
package com.rainbow.controller;
import com.rainbow.service.UserService;
import com.rainbow.entity.user;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.ModelMap;
import org.springframework.web.bind.annotation.*;
import javax.net.ssl.HandshakeCompletedEvent;
@Controller
@RequestMapping("/user")
public class Usercontroller {
@Autowired
private UserService userService;
@RequestMapping("/login")
public String Login() {
return "login";
}
@RequestMapping("/loginResult")
public String findByaccount(user inputUser) {
user findUser = userService.findByAccount(inputUser.getAccount());
if(findUser.getPassword().equals(inputUser.getPassword())) return "loginSuccess";
else return "loginFail";
}
@RequestMapping("/register")
public String Register() {
return "register";
}
@PostMapping("/registerResult")
public String register(user insertuser) {
user findUser = userService.findByAccount(insertuser.getAccount());
if(findUser !=null) return "registerFail";
userService.insertAccount(insertuser);
return "registerSuccess";
}
}
src/main/java/con/rainbow/helloWorldApplication.java
@MapperScan(basePackages = “com.rainbow.mapper”)
这一定要写,因为mybatis扫描的是启动类同级的文件,显然不是
package com.rainbow;
import org.apache.ibatis.annotations.Mapper;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
@MapperScan(basePackages = "com.rainbow.mapper")
@SpringBootApplication
public class helloWorldApplication {
public static void main(String[] args) {
SpringApplication.run(helloWorldApplication.class, args);
}
}
src/main/resources/mapper/UserMapper.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="com.rainbow.mapper.UserMapper">
<!-- 根据账号查询-->
<select id="findByAccount" parameterType="String" resultType="user">
select *
from userinfo
where account = #{account}
</select>
<!-- 增加主键自增useGeneratedKeys="true" keyProperty="id"一定要写 -->
<insert id="insertAccount" parameterType="com.rainbow.entity.user" useGeneratedKeys="true" keyProperty="id">
insert into userinfo(account,password)
values (#{account}, #{password})
</insert>
</mapper>
src/main/resources/templates/login.html
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>登录</title>
</head>
<body>
<h1>登录</h1>
<!--loginResult不是user/loginResult-->
<form action="loginResult" method="post">
<!--name值对应后台Controller中接收的变量-->
<p>账号:<input type="text" name="account" placeholder="账号"></p>
<p>密码:<input type="password" name="password" placeholder="密码"></p>
<p><button type="submit">登录</button></p>
</form>
</body>
</html>
src/main/resources/templates/loginSuccess.html
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Title</title>
</head>
<body>
<p th:text = "'账号为' + ${user.account} + '的用户登录成功'"></p>
</body>
</html>
src/main/resources/templates/loginFail.html
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>loginFail</title>
</head>
<body>
登录失败!
</body>
</html>
src/main/resources/templates/register.html
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>注册</title>
</head>
<body>
<h1>注册</h1>
<form action="registerResult" method="post">
<!--name值对应后台Controller中接收的变量-->
<p>账号:<input type="text" name="account" placeholder="账号"></p>
<p>密码:<input type="password" name="password" placeholder="密码"></p>
<p><button type="submit">注册</button></p>
</form>
</body>
</html>
src/main/resources/templates/registerSuccess.html
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>registerSuccess</title>
</head>
<body>
<p th:text = "'账号为' + ${user.account} + '的用户注册成功'"></p>
</body>
</html>
src/main/resources/templates/registerFail.html
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>registerFail</title>
</head>
<body>
账号已存在!
<a href="register">返回</a>
</body>
</html>
src/main/resources/application.yml
server:
port: 8080
spring:
datasource:
url: jdbc:mysql://localhost:3306/hibernatedb?useUnicode=true&characterEncoding=UTF-8
username: root
password: 123456
driver-class-name: com.mysql.cj.jdbc.Driver
thymeleaf:
prefix: classpath:/templates/
suffix: .html
mode: HTML5
encodeing: UTF-8
mybatis:
mapper-locations: classpath:mapper/*.xml
type-aliases-package: com.rainbow.entity
体验
html中的thymeleaf对应的是javaBean不是其他的,当然要求这个函数方法传入javabean
//这是可以的,因为函数传入user
public String findByaccount(user inputUser) {
user findUser = userService.findByAccount(inputUser.getAccount());
if(findUser.getPassword().equals(inputUser.getPassword())) return "loginSuccess";
else return "loginFail";
}
//这是不可以的,显然登录流程是不对的
public String findByaccount(String account) {
user u = userService.findByAccount(account);
if(u != null) return "loginSuccess";
else return "loginFail";
}
//user是javabean的类
<body>
<p th:text = "'账号为' + ${user.account} + '的用户登录成功'"></p>
</body>