广州明生堂生物科技有限公司


ext combobox动态加载数据库数据(附前后台)

网络编程 ext combobox动态加载数据库数据(附前后台) 06-21
前台:

var provinceStore = new Ext.data.Store({
proxy: new Ext.data.HttpProxy({ url: basePath + "/stationManage/station_getProvinceJSON.action" }),
reader: new Ext.data.JsonReader(
{ root: "" },
["PROVINCEID", "PROVINCENAME"]
)
});


//选择省市
var provinceIDadd = new Ext.form.ComboBox({
anchor : '98%',
id:'provinceIDadd',
name : "provinceIDAdd1",
hiddenName : "provinceID",
displayField : "PROVINCENAME",
valueField : "PROVINCEID",
blankText : '请选择站点所属省份',
emptyText : '请选择站点所属省份',
fieldLabel : '站点所属省份',
allowBlank : false,
editable : false,
triggerAction : 'all',
store :provinceStore ,
forceSelection : true,
mode : 'local',
selectOnFocus : true
})
provinceStore.load();

后台action代码

public class StationAction extends BaseAction {

private List<Map<String, Object>> provinceList;
public void setProvinceList(List<Map<String, Object>> provinceList) {
this.provinceList = provinceList;
}

public List<Map<String, Object>> getProvinceList() {
return provinceList;
}
public String getProvinceJSON(){
String sql="SELECT PK_ID PROVINCEID,NAME PROVINCENAME FROM T_DICT_DISTRICT A WHERE A.DISTRICT_LEVEL=20";
provinceList= stationService.findBySQL(sql);
return "json_getProvinceList";
}
}

strtus xml配置

<result name="json_getProvinceList" type="json" >
<param name="root">provinceList</param>
</result>

加载静态数据的下拉选择框

var dataType=[['0','8列'],['1','38列'],['2','21列']];
var dataTypeStore = new Ext.data.SimpleStore({
fields: ['dataTypeID', 'dataTypeName'],
data : data
});

var dataTypedd = new Ext.form.ComboBox({
anchor : '98%',
id:'dataTypeadd',
name : "dataTypeAdd1",
hiddenName : "dataType",
displayField : "dataTypeName",
valueField : "dataTypeID",
blankText : '请选择数据格式',
emptyText : '请选择数据格式',
fieldLabel : '数据格式',
allowBlank : false,
editable : false,
triggerAction : 'all',
store :unitStore ,
forceSelection : true,
mode : 'local',
selectOnFocus : true
})

ext中store.load跟store.reload的区别示例介绍
reload:function(options){this.load(Ext.applyIf(options||{},this.lastOptions));},load:function(options){options=Ext.apply({},options);this.storeOptions(options);if(this.sortInfo&&this.remoteSort){varpn

Ext GridPanel加载完数据后进行操作示例代码
比如load数据之后选定某些行数据。this相当于当前的GridPanel,idxs相当于你要选中的行号this.store.on("load",function(store){this.getSelectionModel().selectRows(idxs);//this.se

ext前台接收action传过来的json数据示例
ext前台接收action传过来的json数据Ext.Ajax.request({method:'POST',//请求方式params:{dagl_code:dagl_code},url:lcwPath+"/daxt/lcgl.shtml?method=getJgBycode",//请求的url地址success:func


编辑:广州明生堂生物科技有限公司

标签:请选择,数据,示例,前台,省份