IDEA + Spring Boot + Security + MyBatis Plus+Mysql低代码快速开发平台

**IDEA + Spring Boot + Security + MyBatis Plus + Mysql低代码快速开发平台**

**前言**

随着软件开发的快速发展，需求的变化越来越快，传统的手工编码方式已经无法满足快速开发的需求。因此，低代码快速开发平台逐渐受到关注和推崇。基于此背景，本文将介绍如何使用IDEA + Spring Boot + Security + MyBatis Plus + Mysql搭建一个低代码快速开发平台。

**环境准备**

* IDEA2022.1* Java8* Spring Boot2.5.3* MyBatis Plus4.0.3* Mysql8.0**项目结构**

markdownmybatis-plus-low-code-platform├── pom.xml├── src│ ├── main│ │ ├── java│ │ │ └── com│ │ │ └── example│ │ │ └── mybatispluslowcodeplatform│ │ │ ├── MyBatisPlusLowCodePlatformApplication.java│ │ │ ├── SecurityConfig.java│ │ │ ├── UserMapper.java│ │ │ └── UserController.java│ │ ├── resources│ │ │ ├── application.properties│ │ │ ├── db.properties│ │ │ └── mapper│ │ │ └── user.xml│ └── test│ └── java│ └── com│ └── example│ └── mybatispluslowcodeplatform│ ├── MyBatisPlusLowCodePlatformApplicationTests.java│ └── UserControllerTest.java

**配置文件**

* `application.properties`：

propertiesspring.datasource.url=jdbc:mysql://localhost:3306/mybatis_plus_low_code_platformspring.datasource.username=rootspring.datasource.password=123456spring.datasource.driver-class-name=com.mysql.cj.jdbc.Drivermybatis-plus.mapper-locations=classpath:mapper/*.xml

* `db.properties`：

properties# Mysql database configurationmysql.url=jdbc:mysql://localhost:3306/mybatis_plus_low_code_platformmysql.username=rootmysql.password=123456mysql.driver-class-name=com.mysql.cj.jdbc.Driver# MyBatis Plus configurationmybatis-plus.mapper-locations=classpath:mapper/*.xml

**Spring Boot配置**

* `SecurityConfig.java`：

javaimport org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.security.config.annotation.web.builders.HttpSecurity;
import org.springframework.security.config.annotation.web.configuration.EnableWebSecurity;
import org.springframework.security.config.annotation.web.configuration.WebSecurityConfigurerAdapter;

@Configuration@EnableWebSecuritypublic class SecurityConfig extends WebSecurityConfigurerAdapter {

 @Override protected void configure(HttpSecurity  throws Exception {
  /> .antMatchers("/user/**").permitAll()
 .anyRequest().authenticated()
 .and()
 .csrf().disable();
 }
}

* `MyBatisPlusLowCodePlatformApplication.java`：

javaimport org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplicationpublic class MyBatisPlusLowCodePlatformApplication {

 public static void main(String[] args) {
 SpringApplication.run(MyBatisPlusLowCodePlatformApplication.class, args);
 }
}

**MyBatis Plus配置**

* `UserMapper.java`：

javaimport com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.extension.api.R;

public interface UserMapper extends BaseMapper {

}

* `user.xml`：

xml<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper3.0//EN"
 " /><mapper namespace="com.example.mybatispluslowcodeplatform.UserMapper">

 <resultMap id="BaseResultMap" type="com.example.mybatispluslowcodeplatform.User">
 <id column="id" jdbcType="INTEGER"/>
 <result column="name" jdbcType="VARCHAR"/>
 <result column="age" jdbcType="INTEGER"/>
 </resultMap>

</mapper>

**测试**

* `UserControllerTest.java`：

javaimport org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringRunner;

@RunWith(SpringRunner.class)
@SpringBootTestpublic class UserControllerTest {

 @Autowired private UserMapper userMapper;

 @Test public void testSelectOne() {
 User user = new User();
 user.setName("张三");
 user.setAge(18);
 userMapper.insert(user);

 User selectOne = userMapper.selectOne(new QueryWrapper().eq("name", "张三"));
 System.out.println(selectOne.getName());
 }
}

**总结**

本文介绍了如何使用IDEA + Spring Boot + Security + MyBatis Plus + Mysql搭建一个低代码快速开发平台。通过配置文件、Spring Boot配置和MyBatis Plus配置，实现了对用户数据的CRUD操作。测试类中演示了如何使用MyBatis Plus进行数据库操作。