Generate Spring Boot CRUD Code Instantly with EasyCode Plugin

1. Install EasyCode

Install the EasyCode plugin in IntelliJ IDEA, which can generate entity, controller, service, DAO, and mapper code directly from database tables without manual coding.

2. Create Database

-- ----------------------------
-- Table structure for user
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int(11) NOT NULL,
  `username` varchar(20) DEFAULT NULL,
  `sex` varchar(6) DEFAULT NULL,
  `birthday` date DEFAULT NULL,
  `address` varchar(20) DEFAULT NULL,
  `password` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET FOREIGN_KEY_CHECKS = 1;

3. Configure IDEA Database Connection

In a new Spring Boot project, open the Database tool window, add a new MySQL connection, fill in the database name, username, and password, then click OK.

4. Generate Code

Right‑click the desired table in the EasyCode panel, choose the target folder, select the code types to generate, and confirm. The generated files are displayed.

5. pom.xml Dependencies

<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter</artifactId>
</dependency>
...
<dependency>
    <groupId>org.projectlombok</groupId>
    <artifactId>lombok</artifactId>
    <optional>true</optional>
</dependency>
...
<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid</artifactId>
    <version>1.0.9</version>
    <optional>true</optional>
</dependency>
...
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.1.47</version>
</dependency>

6. application.yml Configuration

server:
  port: 8089
spring:
  datasource:
    url: jdbc:mysql://127.0.0.1:3306/database?useUnicode=true&characterEncoding=UTF-8
    username: root
    password: 123456
    type: com.alibaba.druid.pool.DruidDataSource
    driver-class-name: com.mysql.jdbc.Driver
mybatis:
  mapper-locations: classpath:/mapper/*Dao.xml
  typeAliasesPackage: com.vue.demo.entity

7. Run the Project

Add @Mapper to DAO interfaces and @MapperScan("com.vue.demo.dao") to the main application class, then start the Spring Boot application and test the generated endpoints.