function?sqlSearch(){??
????var?sqlStatement?=?$.trim($("#sqlStatementId").val());??
????if(sqlStatement?==?null?||?sqlStatement?==?""){??
????????return?false;??
????}??
??????
????var?type?=?"POST";??
????var?url?=?"sqlExecCtrl.action?cmd=getColumnNameList";??
????var?param?=?"sqlStatement="?+?$("#sqlStatementId").val();??
??????????
????ajaxExtend(type,url,param,function(data){??
????????var?options?=?$("#sqlResultDisplay").datagrid("options");???????????????????//取出當(dāng)前datagrid的配置?????
????????options.columns?=?eval(data.columns);???????????????????????????????????????????????//添加服務(wù)器端返回的columns配置信息?????
????????options.queryParams?=?getQueryParams("sqlConditionId");?????????????//添加查詢參數(shù)??
????????$("#sqlResultDisplay").datagrid(options)?;????????????????????????????????????????
????????$("#sqlResultDisplay").datagrid("load")?;???????????????????????????????????????????//獲取當(dāng)前頁信息??
????});??
}??
??
/**?
?*?根據(jù)指定條件請求系統(tǒng)資源?
?*1、?異步?
?*2、返回格式為json?
?*?
?*?@param?type??????????//請求方式?
?*?@param?url???????????????//請求url?
?*?@param?param?????//請求參數(shù)?
?*?@param?callback??????//回調(diào)函數(shù)?
?*/??
function?ajaxExtend(type,url,param,callback){??
????ajaxExtendBase(type,url,param,true,callback);??
}??
??
/**?
?*?ajax請求基礎(chǔ)方法?
?*?@param?type?
?*?@param?url?
?*?@param?param?
?*?@param?async?
?*?@param?callback?
?*/??
function?ajaxExtendBase(type,url,param,async,callback){??
????$.ajax({??
???????????type:?type,??
???????????url:?url,??
???????????data:param,??
???????????async?:?async,??
???????????dataType:"json",??
???????????success:function(result){??
???????????????if(result.success){??????????????????????????????????????????//只有sql正確能獲取相關(guān)列名后才再請求列表資源??
????????????????????callback(result.data);??????????????????????????????????//獲取當(dāng)前頁信息??
???????????????}??
???????????????else{??
???????????????????dealWithException(result.exception);??
???????????????}??
???????????}??
????});??
}??
??
??
/**?
?*?將指定form參數(shù)轉(zhuǎn)換為json對象?
?*/??
function?getQueryParams(conditionFormId){??
?var?searchCondition?=?getJqueryObjById(conditionFormId).serialize();??
?var?obj?=?{};??
????var?pairs?=?searchCondition.split('&');??
????var?name,value;??
??????
????$.each(pairs,?function(i,pair)?{??
?????pair?=?pair.split('=');??
?????name?=?decodeURIComponent(pair[0]);??
?????value?=?decodeURIComponent(pair[1]);??
???????
?????obj[name]?=??!obj[name]???value?:[].concat(obj[name]).concat(value);??????????????//若有多個同名稱的參數(shù)，則拼接??
????});??
??????
????return?obj;??
}