6.SpringBoot整合mybatis实现登录

曾经终败给现在 2022-05-23 13:49 106阅读 0赞

## **注意：由于内容有点多，在看本文章前，一定要按照下面菜单中的教程，一步一步来** ##

**[\-->SpringBoot企业级开发精讲系列教程][--_SpringBoot]**

本章带大家使用springboot + mybaits整合，实现一个简单的登录实例

**准备：**

1.安装mysql

2.创建springboot数据库

3.创建s\_user表

DROP TABLE IF EXISTS `s_user`;
    CREATE TABLE `s_user` (
      `_id` int(11) NOT NULL AUTO_INCREMENT,
      `nickname` varchar(30) DEFAULT NULL,
      `password` varchar(30) DEFAULT NULL,
      `create_time` bigint(20) DEFAULT NULL,
      PRIMARY KEY (`_id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

这里创建用户表user，加前戳s\_其意义是区分系统表和具体事务表，在此项目中使用到的前戳有：

<table> 
 <tbody> 
  <tr> 
   <th style="width:110px;">前戳</th> 
   <th style="width:161px;">全称</th> 
   <th style="width:459px;">描述</th> 
  </tr> 
 </tbody> 
 <tbody> 
  <tr> 
   <td style="width:110px;">s_</td> 
   <td style="width:161px;">system</td> 
   <td style="width:459px;">系统表前戳</td> 
  </tr> 
  <tr> 
   <td style="width:110px;">b_</td> 
   <td style="width:161px;">business</td> 
   <td style="width:459px;">事务表前戳</td> 
  </tr> 
 </tbody> 
</table>

**1.创建User数据库表映射实体类**

@Data
    public class User {
        private int _id;
        private String nickname;
        private String password;
        private long create_time;
    }

注意字段名和变量名保持一致

**2.创建UserDao类**

@Mapper
    public interface UserDao {
        User login(@Param("nickname") String nickname, @Param("password")String password);
    }

**3.创建service**

@Slf4j
    @Service
    public class UserService {
    
        @Autowired
        private UserDao mUserDao;
        
        public LoginRPTO login(LoginRQTO login){
            User user = mUserDao.login(login.getNickname(),login.getPassword());
            if(user == null){
                return null;
            }
            LoginRPTO rpto = new LoginRPTO();
            rpto.setUser_id(user.get_id());
            rpto.setNickname(login.getNickname());
            return rpto;
        }
    }

**4.修改UserController**

@Controller
    @RequestMapping("/user")
    public class UserController {
    
        @Autowired
        private UserService mUserService;
    
        @ResponseBody
        @RequestMapping(value = "/login",method = RequestMethod.POST)
        public RPTO login(@RequestBody @Valid LoginRQTO login) {
            LoginRPTO rpto = mUserService.login(login);
            if(rpto == null){
                return new RPTO<>("用户名密码错误");
            }
            return new RPTO<>(ActionCode.SUCCESS,rpto);
        }
    }

**5.在resource目录下创建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.fcibook.springboot.dao.UserDao">
        <select id="login" resultType="com.fcibook.springboot.core.system.User">
            SELECT * FROM s_user WHERE nickname = #{nickname} and password = #{password}
        </select>
    </mapper>

**6.修改application.properties**

server.port=8080
    
    #日志配置
    logging.level.root=warn
    logging.level.com.fcibook.springboot=DEBUG
    #springframework.web日志以DEBUG级别输出
    logging.level.org.springframework.web=warn
    #hibernate日志以ERROR级别输出
    logging.level.org.hibernate=warn
    logging.file=/logs/my.log
    logging.pattern.console=%d{yyyy/MM/dd-HH:mm:ss} [%thread] %-5level %logger- %msg%n
    logging.pattern.file=%d{yyyy/MM/dd-HH:mm} [%thread] %-5level %logger- %msg%n
    
    #数据库配置
    spring.datasource.driverClassName = com.mysql.jdbc.Driver
    spring.datasource.url=jdbc:mysql://localhost:3306/springboot?useUnicode=true&characterEncoding=utf-8
    spring.datasource.username=root
    spring.datasource.password=123456
    
    #配置.xml文件路径
    mybatis.mapper-locations=classpath:mapper/*.xml
    #配置模型路径
    mybatis.type-aliases-package=com.fcibook.springboot.dao

**7.运行，测试**

在数据库中，手动添加一条记录

![70][]

然后打开网址

http://localhost:8080/login.html

![70 1][]

登录测试成功!

但是值得一提的是mybatis有多种方法来操作数据库，我们访问mybatis官网

http://www.mybatis.org/mybatis-3/zh/getting-started.html

看到如下文档解释：

![70 2][]

\----------------------------------------------------------------------

[源码下载][Link 1]

[--_SpringBoot]: https://blog.csdn.net/cc_want/article/details/80567149
[70]: /images/20220523/f1861de351b64ce7ad79b391465b768a.png
[70 1]: /images/20220523/1b0b41ba70a44717bd6f43fcbb4ada01.png
[70 2]: /images/20220523/214ad32e128d4534b4b3ab5007518e38.png
[Link 1]: https://download.csdn.net/download/cc_want/10470388