SQL select ID from property_value_set
1、现象
Select 语句单纯执行sql语句查询成功,controller断点Debut发现有字段值丢失,丢失字段为keyInfo、createBy、createTm。
2、问题
根源查询结果字段名与类属性名不完全一致。
3、解决
在Mapper.xml中采用as语句。as前为数据库字段名,后为类属性名,一一对应后前台即可获取全部字段值。
select ID as id,
CODE as code,
KEY_INFO as keyInfo,
VALUE as value,
REMARK as remark,
CREATE_BY as createBy,
CREATE_TM as createTm
from property_value_set