java 骆驼model转换_Spring-Java对象属性由驼峰(CamelCase)转成蛇式(SNAKE_CASE)

原由

由于Java语言偏向于使用驼峰式命名，如columnA，然而数据库(MySQL)表字段一般使用蛇式命名，如column_a，且前端一般也是使用数据库的字段格式进行交互。因此参数传递和返回就需要对驼峰和蛇式的参数进行转化。

解决方案

引入com.fasterxml.jackson.core包

...

com.fasterxml.jackson.core

jackson-core

2.11.2

...

返回结果处理

配置

# application.properties

spring.jackson.property-naming-strategy=SNAKE_CASE

数据类

...

@Data

@JsonInclude(JsonInclude.Include.NON_NULL)

public class TestDTO implements Serializable {

private static final long serialVersionUID = 1L;

private Integer id;

private String userName;

private Integer createTime;

}

Tips: JsonInclude注解可以过滤为null的数据

参数处理

注入ObjectMapper

@RestController

public class TestController {

@Autowired

private ObjectMapper objectMapper;

}

数据转换

@RestController

public class TestController {

@AutoWired

private TestService testService;

...

@GetMapping("/test")

public void index(@RequestParam Map params) {

TestForm testForm = objectMapper.convertValue(params, TestForm.class);

testService.index(testForm);

}

...

}

参数验证

...

@Service

@Validated

public class TestServiceImpl implements TestService {

private static final Logger logger = LoggerFactory.getLogger(TestServiceImpl.class);

@AutoWired

private final TestMapper testMapper;

@Override

public List index(@Valid TestForm params) {

List tests = testMapper.selectByParams(params);

return tests;

}

}