ssm框架，数据库取数据遇到特殊符号，数字命名怎么取出数据供前后台使用

最新推荐文章于 2024-09-02 17:32:10 发布

行思坐忆，志凌云

最新推荐文章于 2024-09-02 17:32:10 发布

阅读量420

点赞数

CC 4.0 BY-SA版权

分类专栏： SSM框架

本文链接：https://blog.youkuaiyun.com/qq_38025219/article/details/82984209

SSM框架专栏收录该内容

8 篇文章

订阅专栏

本文介绍了一种将特定格式的JSON数据进行转换的方法，以便更好地适应应用程序的需求。通过一系列的字符串替换操作，实现了从原始JSON到目标JSON的转换，确保了数据能够正确地映射到实体类中。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

问题描述：
形如如下json数据：需要取出每一条数据供表格使用。

[{"WIND_SPEEDSTR": "<0.5", "WIND_SPEED": "0.00", "ALLRecordPer": "0.00", "0.00": "0.00", "22.50": "0.00", "45.00": "0.00", "67.50": "0.00", "90.00": "0.00", "112.50": "0.00", "135.00": "0.00", "157.50": "0.00", "180.00": "0.00", "202.50": "0.00", "225.00": "0.00", "247.50": "0.00", "270.00": "0.00", "292.50": "0.00", "315.00": "0.00", "337.50": "0.00"}, {"WIND_SPEEDSTR": "1.00", "WIND_SPEED": "1.00", "ALLRecordPer": "0.00", "0.00": "0.00", "22.50": "0.00", "45.00": "0.00", "67.50": "0.00", "90.00": "0.00", "112.50": "0.00", "135.00": "0.00", "157.50": "0.00", "180.00": "0.00", "202.50": "0.00", "225.00": "0.00", "247.50": "0.00", "270.00": "0.00", "292.50": "0.00", "315.00": "0.00", "337.50": "0.00"}]

需要转化成如下情况

[{"WIND_SPEEDSTR":"小于0.5","WIND_SPEED":"0.00","ALLRecordPer":"0.00","f1":"0.00","f2":"0.00","f3":"0.00","f4":"0.00","f5":"0.00","f6":"0.00","f7":"0.00","f8":"0.00","f9":"0.00","f10":"0.00","f11":"0.00","f12":"0.00","f13":"0.00","f14":"0.00","f15":"0.00","f16":"0.00"}]

原因如下：

public @ResponseBody
	String WindDistriButionReportresult(HttpServletResponse httpServletResponse,
			@RequestBody WindDistriButionReport windDistriButionReport) {
			}
ArrayList<WindDistriButionReportInfo> httpResult = HttpUtils.getInstanse()
					.jsonToArrayList1(baseUrl + WindDistriButionReport + WindDistriBution ,WindDistriButionReportInfo.class);

在实体WindDistriButionReport类中存放所需参数，WindDistriButionReportInfo之中存放对应数据库属性列的属性，如果属性不对应，则无法获取数据，所以就要进行如下操作

//在.jsonToArrayList1类中对获取的字符串进行替换处理
String Result = singleton.getHttpResult(url1).replaceAll("<", "小于").replaceAll(">", "大于")
				.replaceAll(", \"0.00\"", ", \"f1\"")
				.replaceAll(", \"22.50\"", ", \"f2\"")
				.replaceAll(", \"45.00\"", ", \"f3\"")
				.replaceAll(", \"67.50\"", ", \"f4\"")
				.replaceAll(", \"90.00\"", ", \"f5\"")
				.replaceAll(", \"112.50\"", ", \"f6\"")
				.replaceAll(", \"135.00\"", ", \"f7\"")
				.replaceAll(", \"157.50\"", ", \"f8\"")
				.replaceAll(", \"180.00\"", ", \"f9\"")
				.replaceAll(", \"202.50\"", ", \"f10\"")
				.replaceAll(", \"225.00\"", ", \"f11\"")
				.replaceAll(", \"247.50\"", ", \"f12\"")
				.replaceAll(", \"270.00\"", ", \"f13\"")
				.replaceAll(", \"292.50\"", ", \"f14\"")
				.replaceAll(", \"315.00\"", ", \"f15\"")
				.replaceAll(", \"337.50\"", ", \"f16\"")
				;