/**
*
*/
package com.gb.soa.core.util;
import java.util.ArrayList;
import com.gb.soa.core.accountbalance.model.Join;
import com.gb.soa.core.accountbalance.model.JoinField;
import com.gb.soa.core.accountbalance.model.ShowField;
import com.gb.soa.core.accountbalance.model.Where;
import com.gb.soa.core.config.jni.json.JSONObject;
/**
* @author Ling-Feng.Wu
*
*/
public class JavaJsonQueryUtil {
/**
* json字符串转换成Join对象
* @param jsonString
* @return
*/
public static Join json2Join(String jsonString){
}
/**
* json字符串转换成Join对象
* @param jsonString
* @return
*/
public static Join json2Join(JSONObject jo){
Join join=new Join();
//
String joinType=ConfigJsonUtil.getJsonValues(jsonString, "joinType");
join.setJoinType(joinType);
String vjoinfields=ConfigJsonUtil.getJsonPropertyValue(jsonString, "joinfields");
if(null!=vjoinfields && vjoinfields.trim().length()>0 && vjoinfields.trim().startsWith("[") ){
String[] joinfields=JavaJsonUtil.getDTOArray(vjoinfields);
ArrayList<JoinField> joinlist=new ArrayList<JoinField>(joinfields.length);
for(int i=0;i<joinfields.length;i++){
JoinField jf=json2JoinField(joinfields[i]);
joinlist.add(jf);
}
join.setJoinfields(joinlist);
}
//
String jointablealias=ConfigJsonUtil.getJsonPropertyValue(jsonString, "jointablealias");
join.setJointablealias(jointablealias);
//
String jointablename=ConfigJsonUtil.getJsonPropertyValue(jsonString, "jointablename");
join.setJointablename(jointablename);
return join;
}
/**
* json字符串转换成JoinField对象
* @param jsonString
* @return
*/
public static JoinField json2JoinField(String jsonString){
JoinField joinfield=new JoinField();
//
String leftBracket=ConfigJsonUtil.getJsonPropertyValue(jsonString, "leftBracket");
joinfield.setLeftBracket(leftBracket);
//
String leftfield=ConfigJsonUtil.getJsonPropertyValue(jsonString, "leftfield");
joinfield.setLeftfield(leftfield);
//
String lefttable=ConfigJsonUtil.getJsonPropertyValue(jsonString, "lefttable");
joinfield.setLefttable(lefttable);
//
String operator=ConfigJsonUtil.getJsonPropertyValue(jsonString, "operator");
joinfield.setOperator(operator);
//
String rightBracket=ConfigJsonUtil.getJsonPropertyValue(jsonString, "rightBracket");
joinfield.setRightBracket(rightBracket);
//
String rightfield=ConfigJsonUtil.getJsonPropertyValue(jsonString, "rightfield");
joinfield.setRightfield(rightfield);
//
String righttable=ConfigJsonUtil.getJsonPropertyValue(jsonString, "righttable");
joinfield.setRighttable(righttable);
//
String righttablealias=ConfigJsonUtil.getJsonPropertyValue(jsonString, "righttablealias");
joinfield.setRighttablealias(righttablealias);
return joinfield;
}
/**
* json字符串转换成ShowField对象
* @param jsonString
* @return
*/
public static ShowField json2ShowField(String jsonString){
ShowField showfield=new ShowField();
String fieldname=ConfigJsonUtil.getJsonPropertyValue(jsonString, "fieldname");
showfield.setFieldname(fieldname);
//
String fieldoname=ConfigJsonUtil.getJsonPropertyValue(jsonString, "fieldoname");
showfield.setFieldoname(fieldoname);
//
String isorder=ConfigJsonUtil.getJsonPropertyValue(jsonString, "isorder");
showfield.setIsorder(isorder);
//
String isgroup=ConfigJsonUtil.getJsonPropertyValue(jsonString, "isgroup");
showfield.setIsgroup(isgroup);
//
String ordername=ConfigJsonUtil.getJsonPropertyValue(jsonString, "ordername");
showfield.setOrdername(ordername);
//
String isshow=ConfigJsonUtil.getJsonPropertyValue(jsonString, "isshow");
showfield.setIsshow(isshow);
return showfield;
}
/**
* json字符串转换成Where对象
* @param jsonString
* @return
*/
public static Where json2Where(String jsonString){
Where where=new Where();
String andor=ConfigJsonUtil.getJsonPropertyValue(jsonString, "andor");
where.setAndor(andor);
//
String leftBracket=ConfigJsonUtil.getJsonPropertyValue(jsonString, "leftBracket");
where.setLeftBracket(leftBracket);
//
String rightBracket=ConfigJsonUtil.getJsonPropertyValue(jsonString, "rightBracket");
where.setRightBracket(rightBracket);
//
String leftField=ConfigJsonUtil.getJsonPropertyValue(jsonString, "leftField");
where.setLeftField(leftField);
//
String leftTable=ConfigJsonUtil.getJsonPropertyValue(jsonString, "leftTable");
where.setLeftTable(leftTable);
//
String operator=ConfigJsonUtil.getJsonPropertyValue(jsonString, "operator");
where.setOperator(operator);
//
String param=ConfigJsonUtil.getJsonPropertyValue(jsonString, "param");
where.setParam(param);
//
String paramType=ConfigJsonUtil.getJsonPropertyValue(jsonString, "paramType");
where.setParamType(paramType);
//
String fieldType=ConfigJsonUtil.getJsonPropertyValue(jsonString, "fieldType");
where.setFieldType(fieldType);
return where;
}
}