SpringBoot+MyBatis-Plus查询人员信息

我不是女神ヾ 2024-03-26 13:39 14阅读 0赞

> 需求：前端到后端查询出一个sql显示，用springboot、mybatis-plus、mysql

#### 文章目录 ####

*  一.项目目录
 *  二、实现效果
 *  三、部分代码
 *  四.完整代码

--------------------

## 一.项目目录 ##

![在这里插入图片描述][f80213749df5476fb182c0476ef0327b.png]

## 二、实现效果 ##

![在这里插入图片描述][8325542a1b04437d8d50078137bb5ed5.png]

## 三、部分代码 ##

> POM文件

<?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 https://maven.apache.org/xsd/maven-4.0.0.xsd">
        <modelVersion>4.0.0</modelVersion>
        <parent>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-parent</artifactId>
            <version>2.1.8.RELEASE</version>
            <relativePath/> 
        </parent>
        <groupId>com.example</groupId>
        <artifactId>springbootdemo</artifactId>
        <version>0.0.1-SNAPSHOT</version>
        <name>springbootdemo</name>
        <description>Demo project for Spring Boot</description>
        <properties>
            <java.version>1.8</java.version>
        </properties>
        <dependencies>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-web</artifactId>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-data-jdbc</artifactId>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-test</artifactId>
                <scope>test</scope>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-aop</artifactId>
            </dependency>
            <dependency>
                <groupId>com.baomidou</groupId>
                <artifactId>mybatis-plus-boot-starter</artifactId>
                <version>3.1.2</version>
            </dependency>
    
            <dependency>
                <groupId>org.mybatis.spring.boot</groupId>
                <artifactId>mybatis-spring-boot-starter</artifactId>
                <version>2.2.0</version>
            </dependency>
    
            <dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>fastjson</artifactId>
                <version>1.2.58</version>
            </dependency>
            <dependency>
                <groupId>org.projectlombok</groupId>
                <artifactId>lombok</artifactId>
                <optional>true</optional>
            </dependency>
            
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-tomcat</artifactId>
                <scope>provided</scope>
            </dependency>
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>5.1.32</version>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-thymeleaf</artifactId>
            </dependency>
    
        </dependencies>
    
        <build>
            <plugins>
                <plugin>
                    <groupId>org.springframework.boot</groupId>
                    <artifactId>spring-boot-maven-plugin</artifactId>
                </plugin>
            </plugins>
        </build>
    
    </project>

> Controller层

package com.example.springbootdemo.controller;
    
    import com.example.springbootdemo.pojo.Person;
    import com.example.springbootdemo.service.PersonService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Controller;
    import org.springframework.ui.ModelMap;
    import org.springframework.web.bind.annotation.GetMapping;
    
    import java.util.List;
    
    @Controller
    public class PersonController {
        
    
    
        @Autowired
        private PersonService personService;
        
        /**
         * 查询所有人员信息
         * @param model
         * @return
         */
        @GetMapping("/queryAll")
        public String queryAll(ModelMap model){
        
            List<Person> persons =personService.queryAll();
            model.addAttribute("persons",persons);
            return "person.html";
        }
    }

> Service层

package com.example.springbootdemo.service;
    
    import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
    import com.example.springbootdemo.mapper.PersonMapper;
    import com.example.springbootdemo.pojo.Person;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    
    import java.util.List;
    
    @Service
    public class PersonServiceImpl implements PersonService{
        
    
        @Autowired
        private PersonMapper personMapper;
    
    
        /**
         * 查询所有人员
         * @return
         */
        @Override
        public List<Person> queryAll() {
        
            QueryWrapper<Person> queryWrapper=new QueryWrapper<>();
            List<Person> persons = personMapper.selectList(queryWrapper);
            return persons;
        }
    }

> Mapper层

package com.example.springbootdemo.mapper;
    
    import com.baomidou.mybatisplus.core.mapper.BaseMapper;
    import com.example.springbootdemo.pojo.Person;
    import org.apache.ibatis.annotations.Mapper;
    @Mapper
    public interface PersonMapper extends BaseMapper<Person> {
        
    }

> MySQL数据库文件

SET NAMES utf8mb4;
    SET FOREIGN_KEY_CHECKS = 0;
    
    -- ----------------------------
    -- Table structure for person
    -- ----------------------------
    DROP TABLE IF EXISTS `person`;
    CREATE TABLE `person`  (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
      `age` int(11) NULL DEFAULT NULL,
      `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Records of person
    -- ----------------------------
    INSERT INTO `person` VALUES (1, '王昭君', 1, '杭州');
    INSERT INTO `person` VALUES (2, '白起', 2, '上海');
    
    SET FOREIGN_KEY_CHECKS = 1;

## 四.完整代码 ##

> Gitee:https://gitee.com/yangxumin/springbootdemo

[f80213749df5476fb182c0476ef0327b.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/26/ff3d096c3379466789746f6b26ac1b85.png
[8325542a1b04437d8d50078137bb5ed5.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/26/8b332b57d60b45f284186911a7c7ce92.png