IDEA懒人插件 EasyCode

骑猪看日落 2023-07-13 15:12 26阅读 0赞

>  *  IDEA插件：[https://yuanyu.blog.csdn.net/article/details/104656085][https_yuanyu.blog.csdn.net_article_details_104656085]
>  *  MyBatis-Plus【入门】：[https://blog.csdn.net/qq\_40794973/article/details/90738854][https_blog.csdn.net_qq_40794973_article_details_90738854]

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

# 1 IDEA安装EasyCode插件  #

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwNzk0OTcz_size_16_color_FFFFFF_t_70][]

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

# 2 创建数据库 #

docker run \
    --name easycode_db \
    -e MYSQL_ROOT_HOST=%.%.%.% \
    -e MYSQL_ROOT_PASSWORD=123456 \
    -p 6033:3306  \
    -di mysql:8.0.18

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

# 3 IDEA创建SpringBoot项目并连接数据库 #

jdbc:mysql://ip地址:6033/?serverTimezone=UTC

-- 创建数据库
    CREATE DATABASE easycode_db;
    USE easycode_db;
    -- 创建测试表
    CREATE TABLE `user`
    (
        `id`       INT(10) UNSIGNED AUTO_INCREMENT COMMENT '主键ID',
        `username` VARCHAR(20) NOT NULL COMMENT '用户名',
        `password` VARCHAR(64) NOT NULL COMMENT '密码',
        `name`     VARCHAR(20) COMMENT '姓名',
        `age`      TINYINT UNSIGNED COMMENT '年龄',
        `email`    VARCHAR(50) COMMENT '邮箱',
        PRIMARY KEY `id` (`id`),
        UNIQUE KEY `uk_user_username` (`username`)
    );
    -- 插入测试数据
    INSERT INTO `user` (`id`, `username`, `password`, `name`, `age`, `email`)
    VALUES ('1', 'zhangsan', '123456', '张三', '18', 'zhangsan@bug.cn'),
           ('2', 'lisi', '123456', '李四', '20', 'lisi@bug.cn'),
           ('3', 'wangwu', '123456', '王五', '28', 'wangwu@bug.cn'),
           ('4', 'zhaoliu', '123456', '赵六', '21', 'zhaoliu@bug.cn'),
           ('5', 'sunqi', '123456', '孙七', '24', 'sunqi@bug.cn');

<dependencyManagement>
        <dependencies>
            
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-dependencies</artifactId>
                <version>2.3.0.RELEASE</version>
                <type>pom</type>
                <scope>import</scope>
            </dependency>
        </dependencies>
    </dependencyManagement>
    <properties>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
        <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
        <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-test</artifactId>
        </dependency>
        
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.18</version>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>1.1.22</version>
        </dependency>
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.3.1</version>
        </dependency>
        
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
        </dependency>
    </dependencies>

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

# 4 生成代码 #

## 4.1 右键生成代码 ##

## ![20200520082444389.png][] ##

## 4.2 选择代码放置的位置 ##

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwNzk0OTcz_size_16_color_FFFFFF_t_70 1][]

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

# 5 运行项目 #

## 5.1 修改配置文件 ##

> application.yml

spring:
      datasource:
        url: jdbc:mysql://ip地址:6033/easycode_db?serverTimezone=UTC&characterEncoding=utf-8&useSSL=false&allowPublicKeyRetrieval=true
        username: root
        password: 123456
        driver-class-name: com.mysql.cj.jdbc.Driver
        type: com.alibaba.druid.pool.DruidDataSource
    logging:
      level:
        cn.yuanyu: debug

## 5.2 修改生成的Mapper ##

public interface UserMapper extends BaseMapper<User> {
    }

@Data
    public class User {
        /**
        * 主键ID
        */
        @TableId(type = IdType.AUTO)
        private Long id;

##  5.3 修改启动类  ##

@SpringBootApplication
    @MapperScan("cn.yuanyu.dao")
    public class EasycodeApplication {
        public static void main(String[] args) {
            new SpringApplicationBuilder(EasycodeApplication.class)
                    .web(WebApplicationType.SERVLET)
                    .run(args);
        }
    }

>  *  [https://www.pianshen.com/article/157753432/][https_www.pianshen.com_article_157753432]
>  *  [https://mp.weixin.qq.com/s/Eq10uFvbBkqnf4E7l788CQ][https_mp.weixin.qq.com_s_Eq10uFvbBkqnf4E7l788CQ]

[https_yuanyu.blog.csdn.net_article_details_104656085]: https://yuanyu.blog.csdn.net/article/details/104656085
[https_blog.csdn.net_qq_40794973_article_details_90738854]: https://blog.csdn.net/qq_40794973/article/details/90738854
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwNzk0OTcz_size_16_color_FFFFFF_t_70]: /images/20230529/a5c01c4583c54a90b256add10fcb48c7.png
[20200520082444389.png]: /images/20230529/e68de071f47f4e858e11afcab1fbade1.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwNzk0OTcz_size_16_color_FFFFFF_t_70 1]: /images/20230529/93fca9a99d134b5ea1e2cf79ebb21fde.png
[https_www.pianshen.com_article_157753432]: https://www.pianshen.com/article/157753432/
[https_mp.weixin.qq.com_s_Eq10uFvbBkqnf4E7l788CQ]: https://mp.weixin.qq.com/s/Eq10uFvbBkqnf4E7l788CQ