数据库数组字段:["roleId","schoolId","userName","name"]
1.存入数据库数据:
用String 类型接收前端传入的字段:
JSON.toJSONString(wsProAuthVo.getShowParams().split(","))
存到数据库就是:["roleId","schoolId","userName","name"]
2.取出数据:以list集合返回给前端
Integer length=wsProAuthDo.getShowParams().length();
//去除 "[" 和 "]"
String res=wsProAuthDo.getShowParams().substring(1,length-1);
List<String> authList=new ArrayList<>();
String[] st=res.split(",");
for (String item :st){
//有转义字符,需要去除
authList.add(item.substring(1,item.length()-1));
}