二、SpringBoot整合MybatisPlus

最新推荐文章于 2024-09-15 15:53:13 发布

远途123

最新推荐文章于 2024-09-15 15:53:13 发布

阅读量155

点赞数

分类专栏：笔记

本文链接：https://blog.youkuaiyun.com/qq_26440111/article/details/119327828

版权

笔记专栏收录该内容

29 篇文章

订阅专栏

本文介绍如何在Spring Boot项目中集成MyBatis Plus，包括配置数据库连接、定义Mapper接口及XML映射文件，实现用户登录验证等功能。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

上一项目基础上增加

		<!--数据库驱动-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>
        <!--mybatis-plus-->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.0.5</version>
        </dependency>

数据库配置

#数据库连接配置
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.url=jdbc:mysql://localhost:3306/springboot?useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
#配置日志
mybatis-plus.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl
#别名
mybatis-plus.type-aliases-package=com.jx.pojo
#xml文件位置
mybatis-plus.mapper-locations=classpath:mybatis_plus/*.xml

UserMapper.java

package com.jx.mapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.jx.pojo.User;
import org.apache.ibatis.annotations.Mapper;
import java.util.List;
@Mapper
public interface UserMapper extends BaseMapper<User>{
    List<User> getAllUser();//普通mybatisSQL查询
}

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.jx.mapper.UserMapper">
    <select id="getAllUser" resultType="User">
        SELECT * FROM user
    </select>
</mapper>

UserService.java

package com.jx.service;
import com.jx.mapper.UserMapper;
import com.jx.pojo.User;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
@Service("userService")
public class UserService {
    @Autowired
    private UserMapper userMapper;
  public List<User> getAllUser(){//使用普通接口
      return  userMapper.getAllUser();
    }
  public User getUserByUsernameAndPassword(User user){
        Map map = new HashMap<String,String>();
        map.put("username",user.getUsername());
        map.put("password",user.getPassword());
        List<User> users = userMapper.selectByMap(map);//使用mybatisPlus内置接口
            if(!users.isEmpty()){
                return users.get(0);
            }else {
                return null;
            }
    }
}

Controller.java

package com.jx.controller;

import com.jx.pojo.User;
import com.jx.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import javax.servlet.http.HttpSession;

//@RestController//返回字符串
@Controller
public class HelloController {
    @Autowired
   private UserService userService;
    @RequestMapping("/hello")
    public String hello(){
        return "hello,world";
    }
    @RequestMapping("/login")
    public String login(@RequestParam("username") String username,
                        @RequestParam("password") String password,
                        Model model,
                        HttpSession session){
        User user = new  User();
        user.setUsername(username);
        user.setPassword(password);
        user = userService.getUserByUsernameAndPassword(user);
        if (user!=null){
            System.out.println(user);
            session.setAttribute("loginUser",user);
            return "redirect:/main.html";
        }
        System.out.println(user);
        model.addAttribute("msg","用户名或密码错误");
        return "index";
    }
}