IntelijIDEA构建SpringBoot+MyBatisPlus+MySQL

目录

一、项目目录结构

二、pom.xml

三、resources目录下文件

1、application.properties

2、UserMapper.xml

3、index.html

四、java目录下内容

1、User.java

2、UserMapper.java

3、UserService.java

4、UserServiceImpl.java

5、UserController.java

五、测试

---

一、项目目录结构

二、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 https://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <groupId>com.example</groupId>
    <artifactId>mybt</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>mybt</name>
    <description>mybt</description>
    <properties>
        <java.version>1.8</java.version>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
        <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
        <spring-boot.version>2.7.6</spring-boot.version>
    </properties>
    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-devtools</artifactId>
            <scope>runtime</scope>
            <optional>true</optional>
        </dependency>
        <dependency>
            <groupId>com.mysql</groupId>
            <artifactId>mysql-connector-j</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.5.1</version>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <optional>true</optional>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>3.0.0</version>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.2.9</version>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
    </dependencies>
    <dependencyManagement>
        <dependencies>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-dependencies</artifactId>
                <version>${spring-boot.version}</version>
                <type>pom</type>
                <scope>import</scope>
            </dependency>
        </dependencies>
    </dependencyManagement>

    <build>
        <plugins>
            <plugin>
                <groupId>org.apache.maven.plugins</groupId>
                <artifactId>maven-compiler-plugin</artifactId>
                <version>3.8.1</version>
                <configuration>
                    <source>1.8</source>
                    <target>1.8</target>
                    <encoding>UTF-8</encoding>
                </configuration>
            </plugin>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
                <version>${spring-boot.version}</version>
                <configuration>
                    <mainClass>com.example.mybt.MybtApplication</mainClass>
                    <skip>true</skip>
                </configuration>
                <executions>
                    <execution>
                        <id>repackage</id>
                        <goals>
                            <goal>repackage</goal>
                        </goals>
                    </execution>
                </executions>
            </plugin>
        </plugins>
    </build>

</project>

三、resources目录下文件

1、application.properties

# application.properties 文件内容
server.port=8080

spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.url=jdbc:mysql:///mydb?serverTimezone=UTC&useSSL=false&CharacterEncoding=UTF-8
spring.datasource.username=root
spring.datasource.password=123456


mybatis-plus.mapper-locations=classpath:mapper/*/*Mapper.xml
mybatis-plus.type-aliases-package=com.example.mybt.entity
mybatis-plus.configuration.map-underscore-to-camel-case=true

2、UserMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "https://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.example.mybt.mapper.UserMapper">

</mapper>

3、index.html

<html>
<body>
<h1>hello word!!!</h1>
<p>this is a html page</p>
</body>
</html>

四、java目录下内容

1、User.java

package com.example.mybt.entity;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.Data;

/**
 * 项目：    mybt
 * 软件包：   com.example.mybt.entity
 * 修改日期   2023年06月01日
 * 修改人     XXX
 **/
@Data
@TableName("user")
public class User {
    @TableId(type = IdType.AUTO)
    private Integer id;
    @TableField("name")
    private String name;
    @TableField("password")
    private String password;
}

2、UserMapper.java

package com.example.mybt.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.mybt.entity.User;

/**
 * 项目：    mybt
 * 软件包：   com.example.mybt.mapper
 * 修改日期   2023年06月01日
 * 修改人     XXX
 **/
public interface UserMapper extends BaseMapper<User> {
}

3、UserService.java

package com.example.mybt.service;

import com.baomidou.mybatisplus.extension.service.IService;
import com.example.mybt.entity.User;

/**
 * 项目：    mybt
 * 软件包：   com.example.mybt.service
 * 修改日期   2023年06月01日
 * 修改人     XXX
 **/
public interface UserService extends IService<User> {
}

4、UserServiceImpl.java

package com.example.mybt.service.impl;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.example.mybt.entity.User;
import com.example.mybt.mapper.UserMapper;
import com.example.mybt.service.UserService;
import org.springframework.stereotype.Service;

/**
 * 项目：    mybt
 * 软件包：   com.example.mybt.service.impl
 * 修改日期   2023年06月01日
 * 修改人     XXX
 **/
@Service
public class UserServiceImpl extends ServiceImpl<UserMapper, User> implements UserService {
}

5、UserController.java

package com.example.mybt.controller;

import com.example.mybt.entity.User;
import com.example.mybt.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;

/**
 * 项目：    mybt
 * 软件包：   com.example.mybt.controller
 * 修改日期   2023年06月01日
 * 修改人     XXX
 **/
@RestController
@RequestMapping("user")
public class UserController {

    @Autowired
    private UserService userService;

    @RequestMapping("list")
    public List<User> getUsers(){
        return  userService.list();
    }


    //增加或者修改一条数据
    @RequestMapping("savaOrUpdate")
    public String insertOne(User user){
        boolean save = userService.saveOrUpdate(user);
        return ""+save;
    }

    //删除一条数据
    @RequestMapping("delete")
    public String deleteOne(Integer id){
        boolean b = userService.removeById(id);
        return ""+b;
    }

}

五、测试

浏览器地址栏       http://localhost:8080/user/list

小结：关键在 pom.xml 配置，springboot 和 mybatis-plus 大大减轻了代码量。