springboot+mybatis-plus+mysql 自动生成数据库表搭建项目

2020-12-26

第一步创建springboot项目

第二步添加maven依赖

<properties>
    <java.version>1.8</java.version>
    <skipTests>true</skipTests>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    <project.reporting.outputEncoding>UTF-8
    </project.reporting.outputEncoding>
    <spring-boot.version>2.3.7.RELEASE</spring-boot.version>
</properties>

<properties>
    <java.version>1.8</java.version>
    <skipTests>true</skipTests>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    <project.reporting.outputEncoding>UTF-8
    </project.reporting.outputEncoding>
    <spring-boot.version>2.3.7.RELEASE</spring-boot.version>
</properties>

<dependencies>
    <dependency>
        <groupId>com.baomidou</groupId>
        <artifactId>mybatis-plus-boot-starter</artifactId>
        <version>3.3.2</version>
    </dependency>
    <!--创建表的插件-->
    <dependency>
        <groupId>com.gitee.sunchenbin.mybatis.actable</groupId>
        <artifactId>mybatis-enhance-actable</artifactId>
        <version>1.1.1.RELEASE</version>
    </dependency>
    <!--druid数据源-->
    <dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>druid-spring-boot-starter</artifactId>
        <version>1.1.22</version>
    </dependency>
    <dependency>
        <groupId>org.projectlombok</groupId>
        <artifactId>lombok</artifactId>
        <version>1.18.4</version>
    </dependency>
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <scope>runtime</scope>
    </dependency>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-web</artifactId>
    </dependency>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-configuration-processor</artifactId>
        <optional>true</optional>
    </dependency>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter</artifactId>
    </dependency>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-test</artifactId>
        <scope>test</scope>
        <exclusions>
            <exclusion>
                <groupId>org.junit.vintage</groupId>
                <artifactId>junit-vintage-engine</artifactId>
            </exclusion>
        </exclusions>
    </dependency>
    <dependency>
        <groupId>org.aspectj</groupId>
        <artifactId>aspectjrt</artifactId>
        <version>1.9.5</version>
    </dependency>
    <dependency>
        <groupId>org.aspectj</groupId>
        <artifactId>aspectjweaver</artifactId>
        <version>1.9.5</version>
    </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>2.3.7.RELEASE</version>
            <configuration>
                <mainClass>com.aicheng.wang.AichengApplication</mainClass>
            </configuration>
            <executions>
                <execution>
                    <id>repackage</id>
                    <goals>
                        <goal>repackage</goal>
                    </goals>
                </execution>
            </executions>
        </plugin>
    </plugins>
</build>

第三步修改application.yml文件

# 应用名称
spring:
  application:
    name: aicheng
  datasource:
    type: com.alibaba.druid.pool.DruidDataSource
    druid:
      driver-class-name: com.mysql.cj.jdbc.Driver
      url: jdbc:mysql://localhost:3306/aicheng?useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8
      username: root
      password: 123456

  servlet:
    multipart:
      max-file-size: 20MB
      max-request-size: 20MB
mybatis:
  table:
    auto: update
    #create        系统启动后，会将所有的表删除掉，然后根据model中配置的结构重新建表，该操作会破坏原有数据。
    #update        系统会自动判断哪些表是新建的，哪些字段要修改类型等，哪些字段要删除，哪些字段要新增，该操作不会破坏原有数据。
    #none     系统不做任何处理。
    #add      新增表/新增字段/新增索引/新增唯一约束的功能，不做做修改和删除 (只在版本1.0.9.RELEASE及以上支持)。
  model:
    pack: com.aicheng.wang.model #扫描用于创建表的对象的包名，多个包用“,”隔开
  database:
    type: mysql #数据库类型 目前只支持mysql


mybatis-plus:
  mapper-locations:          classpath*:/mapper/**/*.xml,classpath*:com/gitee/sunchenbin/mybatis/actable/mapping/*/*.xml


logging:
  level:
    com.aicheng.wang: debug
task:
  pool:
    core-pool-size: 100
    max-pool-size: 300
    queue-capacity: 1000
    keep-alive-seconds: 30

第四步修改AichengApplication主类，添加注解

@SpringBootApplication
@EnableScheduling
@ServletComponentScan
@MapperScan({"com.gitee.sunchenbin.mybatis.actable.dao.*","com.aicheng.wang.dao.*"})
@ComponentScan({"com.gitee.sunchenbin.mybatis.actable.manager.*","com.aicheng.wang.*"})

第五步运行测试

1、创建实体、搭建controller、service、dao以及初始化信息

@Data
@AllArgsConstructor
@NoArgsConstructor
@Table(name = "user")//设置表名
public class User implements Serializable {

    private static final long serialVersionUID = -2844298606992176132L;

    @TableId(type = IdType.AUTO)//mybatis-plus主键注解
    @IsAutoIncrement   //自增
    @IsKey             //actable主键注解
    @Column(comment = "用户ID")//对应数据库字段，不配置name会直接采用属性名作为字段名comment是注解
    private int id;
    @Column(comment = "用户名")
    private String username;
    @Column(comment = "密码")
    private String password;
}

@Controller
@RequestMapping("/user")
public class UserController {
    @Autowired
    private UserService userService;

    @PostMapping("/list")
    @ResponseBody
    public List<User> list(int id) {
        System.out.println(id);
        return userService.list();
    }


}

public interface UserService extends IService<User> {
    List<User> findList(int id);


}

@Service("userService")
public class UserServiceImpl extends ServiceImpl<UserDao, User> implements UserService {
    @Autowired
    private UserDao userDao;


    @Override
    public List<User> findList(int id) {
        QueryWrapper<User> queryWrapper = new QueryWrapper<>();
        List<User> users = userDao.selectList(queryWrapper);
        return users;
    }
}

@Mapper
@Repository
public interface UserDao extends BaseMapper<User> {

}

@Component
public class InitUtil {

    @Autowired
    private UserService userService;

    @PostConstruct
    public void addUser() {
        User user= new User();
        user.setUsername("1");
        user.setPassword("5665");
        userService.save(user);
    }


}

2、初始化用户数据

@Component
public class InitUtil {

    @Autowired
    private UserService userService;

    @PostConstruct
    public void addUser() {
        User user= new User();
        user.setUsername("1");
        user.setPassword("5665");
        userService.save(user);
    }


}