IDEA的插件Easycode试验

前提

IDEA + 插件Lombok + sql server 2016 +

安装插件EasyCode

新建springboot项目

pom.xml

<parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.1.5.RELEASE</version>
    </parent>

    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.18.6</version>
        </dependency>
        <dependency>
            <groupId>org.slf4j</groupId>
            <artifactId>slf4j-simple</artifactId>
            <version>1.7.25</version>
        </dependency>
    </dependencies>

MainApp.java

package com.ydfind.easycode;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RestController;
@SpringBootApplication
@RestController
public class MainApp {
    public static void main(String[] args) {
        SpringApplication.run(MainApp.class, args);
    }
    @GetMapping("/hello")
    public String hello() {
        return "hello world!";
    }
}

运行后：

数据库建表

CREATE TABLE [user] (
  id bigint IDENTITY(1,1) NOT NULL,
  name varchar(20) DEFAULT NULL,
  password varchar(20) DEFAULT NULL,
  CONSTRAINT op_user_pk PRIMARY KEY (id)
)

idea操作

spring-boot的sql server集成

参考：https://blog.csdn.net/sndayYU/article/details/104186820

pom.xml

<!--热部署-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-devtools</artifactId>
            <optional>true</optional> <!-- 这个需要为 true 热部署才有效 -->
        </dependency>

        <!-- sql server -->
        <dependency>
            <groupId>com.microsoft.sqlserver</groupId>
            <artifactId>mssql-jdbc</artifactId>
            <version>7.2.2.jre8</version>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.0.1</version>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>1.1.16</version>
        </dependency>

application.yml

server:
  port: 8081
  tomcat:
    uri-encoding: UTF-8

spring:
  datasource:
    minIdle: 1
    maxActive: 5
    initialSize: 1
    filters: stat,wall
    poolPreparedStatements: false
    type: com.alibaba.druid.pool.DruidDataSource
    maxPoolPreparedStatementPerConnectionSize: 20
    driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver
    connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000
    url: jdbc:sqlserver://localhost:1433;databaseName=tempdb
    username: sa
    password: 123456
 mybatis:
  mapper-locations: classpath:/mapper/*Dao.xml

idea添加数据源，等下会出现刚才新建的表，如下：

生成代码

dao类要加上@Mapper
xml文件所有dbo.user改为dbo.[user]

测试

数据库加入一条数据，再http://localhost:8081/user/selectOne?id=1，结果如下：

注意

1.yml配置文件里面要加上

mybatis:
  mapper-locations: classpath:/mapper/*Dao.xml

2.@MapperScan(“com.cmbchina.www.rec.dao”)可以忽略不写，因为默认@ComponentScan(当前位置)