Json格式类似于:[{“experimentalVariablesMa1”: 99 } , {“experimentalVariablesMa1”: 88}] 后端一般通过一个String类型参数进行接收
后端如何解析Json数据:
1.先将Json数据解析成数组
BizExperimentalFormula[] array = new Gson().fromJson(bizExperimentalBaseInfoList, BizExperimentalFormula[].class);
2.将数组解析成list对象
List<BizExperimentalFormula> recomFormulaList = Arrays.asList(array);
如何将解析的list对象存入数据库中呢?
1.通过for循环解析list对象存入数据库
for (int i = 0; i < recomFormulaList.size(); i++) {
BizExperimentalFormula bizExperimentalFormula = recomFormulaList.get(i);
bizExperimentalFormula.setExperimentalFormulaName(formulaName);
bizExperimentalFormulaService.save(bizExperimentalFormula); //存入数据库
}
2.在xml中写sql语句,通过foreach解析list对象存入数据库
直接将list对象作为方法的参数,调用方法
<insert id="addFormulaList">
insert into biz_water_mud_recom_formula
(Experimental_formula_name, experimental_formula_sort, Experimental_variables_name,
Experimental_variables_add_no,Experimental_variables_unit)
values
<foreach collection ="RecomFormulaList" item="list" index= "index" separator =",">
(
#{formulaName}, #{sort},#{list.experimentalVariablesName},
#{list.experimentalVariablesAddNo},#{list.experimentalVariablesUnit}
)
</foreach >
版权声明:本文为Blackjoker0原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。