/** * 包名:com.artfess.platform.bpm.model * 文件名:SqlBuilderModel.java * 作者:User-mailto:liyj@jee-soft.cn * 日期2014-7-16-下午5:53:46 * 2014广州宏天软件有限公司版权所有 * */ package com.artfess.base.sqlbuilder; import com.fasterxml.jackson.databind.node.ArrayNode; /** *
 * 描述:
 * 返回字段的JsonNode,每个JSONObject:{"field":"字段名字","comment":"列名","AggFuncOp":"合计函数(sum,max,min..可以为空)"}
 * 条件字段的JsonNode,每个JSONObject:{"field":"字段名字","op":"QueryOP.op","dbType":"字段数据类型,eg:Column.COLUMN_TYPE_VARCHAR","value":"Object(因为between之类的会有两个值,多值用JSONObject装载)","isScript":"1/0"}
 * 排序字段的JsonNode,每个JSONObject:{"field":"字段名字","sortType":"排序方式(asc,desc)"}
 * 构建组:x5-bpmx-platform
 * 作者:lyj
 * 邮箱:liyj@jee-soft.cn
 * 日期:2014-7-16-下午5:53:46
 * 版权:广州宏天软件有限公司版权所有
 * 
*/ public class SqlBuilderModel { /** * 数据库类型 */ private String dbType = ""; // String fromName, JsonNode resultField, JsonNode conditionField, // JsonNode sortField // 数据来源的名字,可以是table名字或者view的名字 private String fromName; // 返回字段的JsonNode,每个JSONObject:{"field":"字段名字","comment":"列名","AggFuncOp":"合计函数(sum,max,min..可以为空)"} private ArrayNode resultField; // 条件字段的JsonNode,每个JSONObject:{"field":"字段名字","op":"QueryOP,运算符","dbType":"字段数据类型,eg:Column.COLUMN_TYPE_VARCHAR","value":"Object(因为between之类的会有两个值,多值用JSONObject装载)","isScript":"1/0"} private ArrayNode conditionField; // 排序字段的ArrayNode,每个JSONObject:{"field":"字段名字","sortType":"排序方式(asc,desc)"} private ArrayNode sortField; /** * dbType * * @return the dbType * @since 1.0.0 */ public String getDbType() { return dbType; } /** * @param dbType * the dbType to set */ public void setDbType(String dbType) { this.dbType = dbType; } /** * fromName * * @return the fromName * @since 1.0.0 */ public String getFromName() { return fromName; } /** * @param fromName * the fromName to set */ public void setFromName(String fromName) { this.fromName = fromName; } /** * resultField * * @return the resultField * @since 1.0.0 */ public ArrayNode getResultField() { return resultField; } /** * @param resultField * the resultField to set */ public void setResultField(ArrayNode resultField) { this.resultField = resultField; } /** * conditionField * * @return the conditionField * @since 1.0.0 */ public ArrayNode getConditionField() { return conditionField; } /** * @param conditionField * the conditionField to set */ public void setConditionField(ArrayNode conditionField) { this.conditionField = conditionField; } /** * sortField * * @return the sortField * @since 1.0.0 */ public ArrayNode getSortField() { return sortField; } /** * @param sortField * the sortField to set */ public void setSortField(ArrayNode sortField) { this.sortField = sortField; } }