Server:解决PostgreSQL的json类型字段返回的值总是多包一层的对象

TommyLemon · TommyLemon · commit 0e227b0c0e9c · 2019-02-07T18:38:10.000+08:00
diff --git a/APIJSON-Java-Server/APIJSONBoot/src/main/java/apijson/demo/server/DemoSQLExecutor.java b/APIJSON-Java-Server/APIJSONBoot/src/main/java/apijson/demo/server/DemoSQLExecutor.java
@@ -30,8 +30,11 @@
 
 import javax.validation.constraints.NotNull;
 
+import org.postgresql.util.PGobject;
+
 import com.alibaba.fastjson.JSONObject;
 
+import zuo.biao.apijson.JSON;
 import zuo.biao.apijson.Log;
 import zuo.biao.apijson.server.AbstractSQLExecutor;
 import zuo.biao.apijson.server.SQLConfig;
@@ -136,7 +139,10 @@ else if (value instanceof Clob) {
 			}
 			value = sb.toString();
 		}
-		
+		else if (value instanceof PGobject) {
+			value = JSON.parse(((PGobject) value).getValue());
+		}
+
 		return value;
 	}
 

Original file line number	Diff line number	Diff line change
`@@ -30,8 +30,11 @@`
`30`	`30`
`31`	`31`	`import javax.validation.constraints.NotNull;`
`32`	`32`
	`33`	`+import org.postgresql.util.PGobject;`
	`34`	`+`
`33`	`35`	`import com.alibaba.fastjson.JSONObject;`
`34`	`36`
	`37`	`+import zuo.biao.apijson.JSON;`
`35`	`38`	`import zuo.biao.apijson.Log;`
`36`	`39`	`import zuo.biao.apijson.server.AbstractSQLExecutor;`
`37`	`40`	`import zuo.biao.apijson.server.SQLConfig;`
`@@ -136,7 +139,10 @@ else if (value instanceof Clob) {`
`136`	`139`	`}`
`137`	`140`	`value = sb.toString();`
`138`	`141`	`}`
`139`		`-`
	`142`	`+ else if (value instanceof PGobject) {`
	`143`	`+ value = JSON.parse(((PGobject) value).getValue());`
	`144`	`+ }`
	`145`	`+`
`140`	`146`	`return value;`
`141`	`147`	`}`
`142`	`148`