java中如何判断JSONObject是否存在某个Key

作者:想做一个小孩的杨先生 时间:2022-06-10 15:07:24 

判断JSONObject是否存在某个Key

JSONObject jsonObj = new JSONObject();
jsonObj.put("version", "1.0.0"); // 版本号
jsonObj.put("encoding", "UTF-8"); // 编码方式

判断jsonObject是否存在vesion属性

jsonObj.has("version"); ?// 返回true

检查json字符串中是否存在该key

初衷,是由于工作需要,两个单位需要接口数据对接,单位一需要发送json数据串到单位二,然而单位一发送的json数据中的字段不确定,听他们解释说,客户在系统上输那些字段,他们就会把那些字段带过来,然后那些客户不输入的字段,他们就会默认不带。单位一要求单位二,将这种检测出不带的字段默认值为空!

所以作为单位二,我们就需要想办法检测到单位一哪些字段没带过来。起初立马想到的办法就是用异常情况处理,因为程序本身测试的时候就报not found了,所以用异常处理情有可原吧。。。如果用异常的,想了一下只能捕捉到not found之后,在finally里将捕捉到的这个字段直接置空就ok了。

那么问题来了,对异常的情况试了一下,finally太多不好处理;所以就想了用另外一个方法,用json的一个containsKey()函数来判断json串中是否存在这个key,即是否存在这个字段;当然,还有其他函数也可以判断的,这个根据自己引入的json包了。

下面介绍我自己的情况

导入的jar包为:java中如何判断JSONObject是否存在某个Key

首先我导入的json包:

import net.sf.json.JSONArray;
import net.sf.json.JSONObject;

代码如下:

/**
* 9903接口解析json数据并且将数据进行入库
*
* @author syp
* @time 2019年7月3日11:49:02
*/
public String dateRepository(String jsonData) {
Log4jBean.logger.info("开始处理入库程序!");
ReadConfig.PullConfigXml();  //启动配置文件
DBUtils db = new DBUtils();  
JSONObject json=new JSONObject();
String jsonStr=jsonData.substring(44, jsonData.length());
JSONObject jsonObject = JSONObject.fromObject(jsonStr);
JSONObject jsonCard=jsonObject.getJSONObject("cardid_info")
JSONObject jsonObu = jsonObject.getJSONObject("obu_info");
JSONObject jsonUser=jsonObject.getJSONObject("user_info");
JSONObject jsonCar = jsonObject.getJSONObject("car_info");
//准备将所有json数据信息入开卡集合表ETC_OPEN_CARD_COLLECTION
JSONObject jsonAccno = jsonObject.getJSONObject("accno_info");
String allSql = "insert into ETC_OPEN_CARD_COLLECTION(ACCOUNTID,LINKMOBILE,ACCNO_USERNAME,CERTSN,POSID,GENTIME,TRX_SERNO,EMPLOYEEID,ORG_TRX_SERNO,CARD_ID,CARDTYPE,CARD_BRAND,CARD_MODEL,AGENCYID,CARD_USERID,VEHICLEID,ENABLETIME,EXPIRETIME,ISSUEDTYPE,CHANNELID,ISSUEDTIME,CARD_STATUS,STATUSCHANGETIME,CARD_OPERATION,OBU_ID,OBU_BRAND,OBU_MODEL,OBU_USERID,OBU_VEHICLEID,OBU_ENABLETIME,OBU_EXPIRETIME,REGISTEREDTYPE,REGISTEREDCHANNELID,REGISTEREDTIME,INSTALLTYPE,INSTALLCHANNELID,INSTALLTIME,OBU_STATUS,OBU_STATUSCHANGETIME,OBU_OPERATION,USER_ID,USERTYPE,USER_NAME,USERIDTYPE,USERIDNUM,USER_TEL,USER_ADDRESS,USER_REGISTEREDTYPE,USER_CHANNELID,USER_REGISTEREDTIME,DEPARTMENT,AGENTNAME,AGENTIDTYPE,AGENTIDNUM,USER_STATUS,USER_STATUSCHANGETIME,USER_OPERATION,CAR_ID,CAR_TYPE,CAR_USERID,OWNERNAME,OWNERIDTYPE,OWNERIDNUM,OWNERTEL,CAR_ADDRESS,CAR_CONTACT,CAR_REGISTEREDTYPE,CAR_CHANNELID,CAR_REGISTEREDTIME,VEHICLETYPE,VEHICLEMODEL,USECHARACTER,VIN,ENGINENUM,REGISTERDATE,ISSUEDATE,FILENUM,APPROVEDCOUNT,TOTALMASS,MAINTENANCEMASS,PERMITTEDWEIGHT,OUTSIDEDIMENSIONS,PERMITTEDTOWWEIGHT,TESTRECORD,WHEELCOUNT,AXLECOUNT,AXLEDISTANCE,AXISTYPE,CAR_OPERATION) values('"
+ (jsonAccno.containsKey("accountid")?jsonAccno.getString("accountid"):"")
+ "','"
+ (jsonAccno.containsKey("linkmobile")?jsonAccno.getString("linkmobile"):"")
+ "','"
+ (jsonAccno.containsKey("username")?jsonAccno.getString("username"):"")
+ "','"
+ (jsonAccno.containsKey("certsn")?jsonAccno.getString("certsn"):"")
+ "','"
+ (jsonAccno.containsKey("posid")?jsonAccno.getString("posid"):"")
+ "','"
+ (jsonAccno.containsKey("gentime")?jsonAccno.getString("gentime"):"")
+ "','"
+ (jsonAccno.containsKey("trx_serno")?jsonAccno.getString("trx_serno"):"")
+ "','"
+ (jsonAccno.containsKey("employeeid")?jsonAccno.getString("employeeid"):"")
+ "','"
+ (jsonAccno.containsKey("org_trx_serno")?jsonAccno.getString("org_trx_serno"):"")
+ "','"
+ (jsonCard.containsKey("id")?jsonCard.getString("id"):"")
+ "','"
+ (jsonCard.containsKey("cardType")?jsonCard.getString("cardType"):"")
+ "','"
+ (jsonCard.containsKey("brand")?jsonCard.getString("brand"):"")
+ "','"
+ (jsonCard.containsKey("model")?jsonCard.getString("model"):"")
+ "','"
+ (jsonCard.containsKey("agencyId")?jsonCard.getString("agencyId"):"")
+ "','"
+ (jsonCard.containsKey("userId")?jsonCard.getString("userId"):"")
+ "','"
+ (jsonCard.containsKey("vehicleId")?jsonCard.getString("vehicleId"):"")
+ "','"
+ (jsonCard.containsKey("enableTime")?jsonCard.getString("enableTime"):"")
+ "','"
+ (jsonCard.containsKey("expireTime")?jsonCard.getString("expireTime"):"")
+ "','"
+ (jsonCard.containsKey("issuedType")?jsonCard.getString("issuedType"):"")
+ "','"
+ (jsonCard.containsKey("channelId")?jsonCard.getString("channelId"):"")
+ "','"
+ (jsonCard.containsKey("issuedTime")?jsonCard.getString("issuedTime"):"")
+ "','"
+ (jsonCard.containsKey("status")?jsonCard.getString("status"):"")
+ "','"
+ (jsonCard.containsKey("statusChangeTime")?jsonCard.getString("statusChangeTime"):"")
+ "','"
+ (jsonCard.containsKey("operation")?jsonCard.getString("operation"):"")
+ "','"
+ (jsonObu.containsKey("id")?jsonObu.getString("id"):"")
+ "','"
+ (jsonObu.containsKey("brand")?jsonObu.getString("brand"):"")
+ "','"
+ (jsonObu.containsKey("model")?jsonObu.getString("model"):"")
+ "','"
+ (jsonObu.containsKey("userId")?jsonObu.getString("userId"):"")
+ "','"
+ (jsonObu.containsKey("vehicleId")?jsonObu.getString("vehicleId"):"")
+ "','"
+ (jsonObu.containsKey("enableTime")?jsonObu.getString("enableTime"):"")
+ "','"
+ (jsonObu.containsKey("expireTime")?jsonObu.getString("expireTime"):"")
+ "','"
+ (jsonObu.containsKey("registeredType")?jsonObu.getString("registeredType"):"")
+ "','"
+ (jsonObu.containsKey("registeredChannelId")?jsonObu.getString("registeredChannelId"):"")
+ "','"
+ (jsonObu.containsKey("registeredTime")?jsonObu.getString("registeredTime"):"")
+ "','"
+ (jsonObu.containsKey("installType")?jsonObu.getString("installType"):"")
+ "','"
+ (jsonObu.containsKey("installChannelId")?jsonObu.getString("installChannelId"):"")
+ "','"
+ (jsonObu.containsKey("installTime")?jsonObu.getString("installTime"):"")
+ "','"
+ (jsonObu.containsKey("status")?jsonObu.getString("status"):"")
+ "','"
+ (jsonObu.containsKey("statusChangeTime")?jsonObu.getString("statusChangeTime"):"")
+ "','"
+ (jsonObu.containsKey("operation")?jsonObu.getString("operation"):"")
+ "','"
+ (jsonUser.containsKey("id")?jsonUser.getString("id"):"")
+ "','"
+ (jsonUser.containsKey("userType")?jsonUser.getString("userType"):"")
+ "','"
+ (jsonUser.containsKey("userName")?jsonUser.getString("userName"):"")
+ "','"
+ (jsonUser.containsKey("userIdType")?jsonUser.getString("userIdType"):"")
+ "','"
+ (jsonUser.containsKey("userIdNum")?jsonUser.getString("userIdNum"):"")
+ "','"
+ (jsonUser.containsKey("tel")?jsonUser.getString("tel"):"")
+ "','"
+ (jsonUser.containsKey("address")?jsonUser.getString("address"):"")
+ "','"
+ (jsonUser.containsKey("registeredType")?jsonUser.getString("registeredType"):"")
+ "','"
+ (jsonUser.containsKey("channelId")?jsonUser.getString("channelId"):"")
+ "','"
+ (jsonUser.containsKey("registeredTime")?jsonUser.getString("registeredTime"):"")
+ "','"
+ (jsonUser.containsKey("department")?jsonUser.getString("department"):"")
+ "','"
+ (jsonUser.containsKey("agentName")?jsonUser.getString("agentName"):"")
+ "','"
+ (jsonUser.containsKey("agentIdType")?jsonUser.getString("agentIdType"):"")
+ "','"
+ (jsonUser.containsKey("agentIdNum")?jsonUser.getString("agentIdNum"):"")
+ "','"
+ (jsonUser.containsKey("status")?jsonUser.getString("status"):"")
+ "','"
+ (jsonUser.containsKey("statusChangeTime")?jsonUser.getString("statusChangeTime"):"")
+ "','"
+ (jsonUser.containsKey("operation")?jsonUser.getString("operation"):"")
+ "','"
+ (jsonCar.containsKey("id")?jsonCar.getString("id"):"")
+ "','"
+ (jsonCar.containsKey("type")?jsonCar.getString("type"):"")  
+ "','"
+ (jsonCar.containsKey("userId")?jsonCar.getString("userId"):"")  
+ "','"+
(jsonCar.containsKey("ownerName")?jsonCar.getString("ownerName"):"")  
+ "','"+
(jsonCar.containsKey("ownerIdType")?jsonCar.getString("ownerIdType"):"")  
+ "','"+
(jsonCar.containsKey("ownerIdNum")?jsonCar.getString("ownerIdNum"):"")  
+ "','"+
(jsonCar.containsKey("ownerTel")?jsonCar.getString("ownerTel"):"")  
+ "','"+
(jsonCar.containsKey("address")?jsonCar.getString("address"):"")  
+ "','"+
(jsonCar.containsKey("contact")?jsonCar.getString("contact"):"")  
+ "','"+
(jsonCar.containsKey("registeredType")?jsonCar.getString("registeredType"):"")  
+ "','"+
(jsonCar.containsKey("channelId")?jsonCar.getString("channelId"):"")  
+ "','"+
(jsonCar.containsKey("registeredTime")?jsonCar.getString("registeredTime"):"")  
+ "','"+
(jsonCar.containsKey("vehicleType")?jsonCar.getString("vehicleType"):"")  
+ "','"+
(jsonCar.containsKey("vehicleModel")?jsonCar.getString("vehicleModel"):"")  
+ "','"+
(jsonCar.containsKey("useCharacter")?jsonCar.getString("useCharacter"):"")  
+ "','"+
(jsonCar.containsKey("VIN")?jsonCar.getString("VIN"):"")  
+ "','"+
(jsonCar.containsKey("engineNum")?jsonCar.getString("engineNum"):"")  
+ "','"+
(jsonCar.containsKey("registerDate")?jsonCar.getString("registerDate"):"")  
+ "','"+
(jsonCar.containsKey("issueDate")?jsonCar.getString("issueDate"):"")  
+ "','"+
(jsonCar.containsKey("fileNum")?jsonCar.getString("fileNum"):"")  
+ "','"+
(jsonCar.containsKey("approvedCount")?jsonCar.getString("approvedCount"):"")
+ "','"+
(jsonCar.containsKey("totalMass")?jsonCar.getString("totalMass"):"")  
+ "','"+
(jsonCar.containsKey("maintenanceMass")?jsonCar.getString("maintenanceMass"):"")  
+ "','"+
(jsonCar.containsKey("permittedWeight")?jsonCar.getString("permittedWeight"):"")  
+ "','"+
(jsonCar.containsKey("outsideDimensions")?jsonCar.getString("outsideDimensions"):"")  
+ "','"+
(jsonCar.containsKey("permittedTowWeight")?jsonCar.getString("permittedTowWeight"):"")  
+ "','"+
(jsonCar.containsKey("testRecord")?jsonCar.getString("testRecord"):"")  
+ "','"+
(jsonCar.containsKey("wheelCount")?jsonCar.getString("wheelCount"):"")  
+ "','"+
(jsonCar.containsKey("axleCount")?jsonCar.getString("axleCount"):"")  
+ "','"+
(jsonCar.containsKey("axleDistance")?jsonCar.getString("axleDistance"):"")  
+ "','"+
(jsonCar.containsKey("axisType")?jsonCar.getString("axisType"):"")  
+ "','"+
(jsonCar.containsKey("operation")?jsonCar.getString("operation"):"")
+ "')";
int allParam = db.updateMethod(allSql, null);
if (allParam > 0) {
Log4jBean.logger.info("开卡集合数据写入开卡集合表成功!");
json.put("return_msg", "处理成功!");
json.put("return_code", "0");
} else {
Log4jBean.logger.error("开卡集合数据写入开卡集合表失败!");
json.put("return_msg", "处理失败!");
json.put("return_code", "-1");
}
return json.toString();
}

通过代码可以看出,每个字段都用containsKey()函数做了处理,这样就不用害怕单位一发过来的j'son串中哪个字段找不到的情况了;

最后经测试已成功入库。。

来源:https://blog.csdn.net/qq_41341640/article/details/109026144

标签:java,判断,JSONObject,Key
0
投稿

猜你喜欢

  • 基于jdk动态代理和cglib动态代理实现及区别说明

    2022-04-11 00:32:44
  • c#图像截取实例

    2022-02-21 07:49:58
  • c# winform取消右上角关闭按钮的实现方法

    2023-05-05 18:56:28
  • c# 如何实现自动更新程序

    2021-11-20 21:02:41
  • java简单实现多线程及线程池实例详解

    2023-05-12 05:47:04
  • java实现1M图片压缩优化到100kb实现示例

    2022-08-08 03:59:43
  • JAVA如何按字节截取字符串

    2023-11-25 13:31:41
  • 详解Spring MVC3返回JSON数据中文乱码问题解决

    2023-11-28 19:09:56
  • Mybatis关联查询结果集对象嵌套的具体使用

    2021-07-12 22:09:18
  • C#线程入门教程之单线程介绍

    2022-03-15 20:37:28
  • java类加载机制、类加载器、自定义类加载器的案例

    2023-02-06 07:35:33
  • Android 官推 kotlin-first 的图片加载库——Coil的使用入门

    2022-07-06 00:53:34
  • opencv 做人脸识别 opencv 人脸匹配分析

    2023-07-09 06:34:44
  • 详解Android中的ActivityThread和APP启动过程

    2021-08-20 22:51:25
  • Windows实现Flutter环境搭建及配置这一篇就够了

    2023-07-03 22:49:30
  • C# 如何在MVC3中取消备用控制器的选择

    2023-02-16 06:48:18
  • 详解SpringBoot注入数据的方式

    2022-05-09 06:34:24
  • java中struts2实现文件上传下载功能实例解析

    2022-03-31 06:47:38
  • SpringBoot项目中使用Mockito的示例代码

    2023-09-25 22:31:14
  • Java读取、写入文件如何解决乱码问题

    2023-08-26 11:16:00
  • asp之家 软件编程 m.aspxhome.com