irpas技术客

【基础】json怎么存入数据库和响应_Niddles_json报文存入数据库

irpas 2090

加粗样式

内部是[],{},数组和对象相互嵌套

嵌套json

[ {“k1”:“1”},{“k2”:1}.{“k3”:true} ] { “k1” : [“广州”,“北京”,“上海”] “k2” : [“深圳”,“北京”,“上海”] }

数组的元素是对象 “order” : [ { “goodsId” : “1001”, “name” : “苹果手机”, “number” : 1 }, { “goodsId” : “1002”, “name” : “华为手机”, “number” : 2 }, { “goodsId” : “1003”, “name” : “小米手机”, “number” : 1 }, { “goodsId” : “1004”, “name” : “天音手机”, “number” : 3 }, { “goodsId” : “1002”, “name” : “华为手机”, “number” : 1 } ]

外面是对象 里面是数组 数组里面有五个对象 { “orderId” : “2021-01-20-1001”, “order” : [ { “goodsId” : “1001”, “name” : “苹果手机”, “number” : 1 }, { “goodsId” : “1002”, “name” : “华为手机”, “number” : 2 }, { “goodsId” : “1003”, “name” : “小米手机”, “number” : 1 }, { “goodsId” : “1004”, “name” : “天音手机”, “number” : 3 }, { “goodsId” : “1002”, “name” : “华为手机”, “number” : 1 } ] }

外面是对象 里面是数组嵌套对象 { “stock” : [ { “goodsId” : “1001”, “name” : “苹果手机”, “number” : 2 }, { “goodsId” : “1002”, “name” : “华为手机”, “number” : 5 }, { “goodsId” : “1003”, “name” : “小米手机”, “number” : 3 }, { “goodsId” : “1004”, “name” : “天音手机”, “number” : 12 } ], “order” : [ { “goodsId” : “1001”, “name” : “苹果手机”, “number” : 1 }, { “goodsId” : “1002”, “name” : “华为手机”, “number” : 2 }, { “goodsId” : “1003”, “name” : “小米手机”, “number” : 1 }, { “goodsId” : “1004”, “name” : “天音手机”, “number” : 3 }, { “goodsId” : “1002”, “name” : “华为手机”, “number” : 1 } ] }

对象转json list转json map转json

JSON.toJsonString

JSON.ParseObject(Map,Object) TypeRefer JSON.ParseArray(list)

注解

@JSONType @JSONField

json数据可以依据嵌套情况用map或者实体类接收。

//@RequestBody HashMap<String,HashMap<String,Object>> jsonOrder public Response orderSave(@RequestBody Orders orders){

然后根据map循环或者实体类放进数据库

<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="pri.test.Dao.OrderSaveMapper"> <insert id="ordersSave" > insert into test_order (order_Id,goods_Id,name,number) values <foreach collection="order" item="order" separator=","> (#{orderId},#{order.goodsId},#{order.name},#{order.number}) </foreach> </insert> </mapper> package pri.test.Entity; import lombok.*; import java.util.List; @NoArgsConstructor @AllArgsConstructor @ToString @Getter @Setter public class Orders { protected String orderId ; protected List<Order> order; }


1.本站遵循行业规范,任何转载的稿件都会明确标注作者和来源;2.本站的原创文章,会注明原创字样,如未注明都非原创,如有侵权请联系删除!;3.作者投稿可能会经我们编辑修改或补充;4.本站不提供任何储存功能只提供收集或者投稿人的网盘链接。

标签: #json报文存入数据库 #加粗样式内部是 #k21k3truek1 #广州 #北京 #上海k2