SpringBoot中使用${sql}执行业务逻辑

1.控制层

@GetMapping("importData2")
public Result SqlPin() {

    dictService.SqlPin();
    return Result.ok();
}

2.业务层接口

3.业务层,随便拼接一个Sql

@Override
public void SqlPin() {
    StringBuilder builder = new StringBuilder();
    String sql = builder.append("insert into t_test (").append("id,").append("name) values(").append("365,'哈哈哈')").toString();
    dictMapper.SqlPin(sql);
}

4.mapper层

5.XML(尽量与mapper层级对应,注意配置文件必到mapper的类中,而不是目录)

6.SpringBoot配置文件

7.Postman 测试正常数据成功进来了