在工作中遇到了一个内容,就是需要把数据库中json类型的字段取出来,放到一个集合中。
数据库中某个字段转格式后
{
"LUCKDRAW": [{
"GOODS_ID": "02",
"GOODS_NUM": 1000,
"PRIZE_NUM": 5,
"GOODS": "商品"
}, {
"GOODS_ID": "03",
"GOODS_NUM": 1000,
"PRIZE_NUM": 5,
"GOOD": 商品",
},
//得到一个集合
List<ActivityDTO> activityList = activityMapper.listQuery(tId);
JSONObject welfare = JSONObject.parseObject(activityDTO.getAWelfare());
JSONArray luckDraw = welfare.getJSONArray("LUCKDRAW");
if(luckDraw != null && !luckDraw.isEmpty()){
List<ActivityRuleBO> activityRuleList = new ArrayList<>();
luckDraw.forEach(luck -> {
JSONObject luckInfo = (JSONObject) luck;
//将json类型封装到ActivityRuleBO实体类中,并加入一个集合中
ActivityRuleBO activityRule = luckInfo.toJavaObject(ActivityRuleBO.class);
activityRuleList.add(activityRule);
});
//将每个集合放入hashMap中
map.put(mapKey,activityRuleList);
}
jar包
io.jsonwebtoken
jjwt
0.9.0