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 测试正常数据成功进来了