springboot项目,采用layui框架,因此需要传入json。但是我发现json里包含了一串不明意义不明出处的重复字节,和jdbctemlate有关,请教如何过滤掉。
获取json代码:
public List<Talent> getAllTalents() {
if (talentList.size() !=0)
talentList.clear();//初始化避免重复存储
String sql = "select * from candidate";
String countsql = "select count(*) from candidate";
int count = jdbcTemplate.queryForObject(countsql, Integer.class);
List<Map<String, Object>> list_maps = jdbcTemplate.queryForList(sql);
for (int i = 0; i < count; i++) {
talentList.add(new Talent((int) list_maps.get(i).get("id"), (String) list_maps.get(i).get("chineseName"), (String) list_maps.get(i).get("englishName"), (String) list_maps.get(i).get("mobile"), (String) list_maps.get(i).get("email"), (boolean) list_maps.get(i).get("gender"), (String) list_maps.get(i).get("mobile_city"), (String) list_maps.get(i).get("title")));
}
return talentList;
}
后台JSON数据:
{
"code": 0,
"msg": "查询成功",
"count": 20,
"data": [
{
"jdbcTemplate": {
"dataSource": null,
"exceptionTranslator": {
"fallbackTranslator": null
},
"lazyInit": true,
"ignoreWarnings": true,
"fetchSize": -1,
"maxRows": -1,
"queryTimeout": -1,
"skipResultsProcessing": false,
"skipUndeclaredResults": false,
"resultsMapCaseInsensitive": false
},
"id": 505,
"chineseName": "蒋X",
"englishName": null,
"mobile": "XXXXXXX",
"email": "XXX",
"gender": true,
"city": "",
"title": "亚太地区XXX"
},
{
"jdbcTemplate": {
"dataSource": null,
"exceptionTranslator": {
"fallbackTranslator": null
},
"lazyInit": true,
"ignoreWarnings": true,
"fetchSize": -1,
"maxRows": -1,
"queryTimeout": -1,
"skipResultsProcessing": false,
"skipUndeclaredResults": false,
"resultsMapCaseInsensitive": false
},
"id": 506,
"chineseName": "XXX",
"englishName": null,
"mobile": "XXX",
"email": "XXX",
"gender": false,
"city": "",
"title": null
}
]
}
可以采用正则表达式将对应的数据过滤掉
jackson的话,bean直接不要的属性加JsonIgnore