JSP动态加载select option

=========================== ajax +struts2 动态加载 select option ==============================

1、jsp定义：
为jsp界面的select添加id，例如：部门、员工状态的下拉框
<tr>
<td width="20%" height="30px;" align="right">所在部门：</td>
<td width="30%">
<select id="depttype" name="employeeBean.deptcd"></select>
</td>
<td width="20%" height="30px;" align="right">状态：</td>
<td width="30%">
<select id="empstate" name="employeeBean.status"></select>
</td>
</tr>

2、调用js函数，利用ajax调用action处理数据，参数采用数组的方式传递（select的ID）
//动态加载select option
var eunm = Array();
eunm.push('depttype');
eunm.push('empstate');
utilqueryEnums(eunm.join(">"));

3、js函数定义

/**
* 动态加载select
* @param obj selectID数组
* @return
*/
function utilqueryEnums(obj){
var option = {
url :"utilqueryEnums.action?data="+obj,
type :"get",
dataType :"json",
timeout :20000,
error: function(XMLHttpRequest, textStatus, errorThrown) {
alert(XMLHttpRequest.status);
alert(XMLHttpRequest.readyState);
alert(textStatus);
},
success :function(json){
if(obj.length > 1){
obj = obj.split('>');
for(var i = 0;i<obj.length;i++){
if(null != obj[i] || "" != obj[i] || "undefined" != obj[i] ){
document.getElementById(obj[i]).options.length=0;
var datas = json.message;
//将字符串转换为对象，js内置方法
datas = eval(datas);
document.getElementById(obj[i]).options.add(new Option("",""));
var selectObj = document.getElementById(obj[i]);
var data = datas[i];
for( var y = 0; y < data.length; y++) {
selectObj.options.add(new Option(data[y].paraname,data[y].paraid));
}
}
}
}else{
document.getElementById(obj).options.length=0;
var datas = json.message;
//将字符串转换为对象，js内置方法
datas = eval(datas);
document.getElementById(obj).options.add(new Option("",""));
for ( var i = 0; i < datas.length; i++) {
document.getElementById(obj).options.add(new Option(datas[i].paraname,datas[i].paraid));
}
}
}
};
$("form").ajaxSubmit(option);
}

4、后台action数据处理
---------------------------- service ： ----------------------------
public interface IEnumerationService {
public List<Enumeration> queryEnumByParakind(String parakind);
}

---------------------------- serviceimpl: ----------------------------
@Service
public class EnumerationServiceImpl implements IEnumerationService{
@Autowired
private IBaseDao baseDao;

public List<Enumeration> queryEnumByParakind(String parakind) {
String hql = "from Enumeration e where e.parakind = ?";
List<Enumeration> enums = baseDao.queryEntitys(hql,new Object[]{parakind});
return enums;
}
}

---------------------------- action :-------------------------------------
public class EnumerationAction extends ActionSupport{

/**
*
*/
private static final long serialVersionUID = -5708391673823472363L;

@Autowired
private IEnumerationService enumerationservice;
private String message = "";
private String data;

public String queryEnums() throws JSONException{
String[] str = data.split(">");
List list1 = new ArrayList();
List<Enumeration> list = null;
if(str.length > 1){
for (int i = 0; i < str.length; i++) {
list = enumerationservice.queryEnumByParakind(str[i]);
list1.add(list);
}
message = JSONUtil.serialize(list1);
}else{
list = enumerationservice.queryEnumByParakind(str[0]);
message = JSONUtil.serialize(list);
}
return SUCCESS;
}

public String getMessage() {
return message;
}

public void setMessage(String message) {
this.message = message;
}

public String getData() {
return data;
}

public void setData(String data) {
this.data = data;
}
}


5、数据字典设计
create table ENUMERATION
(
ENUMERATIONKY NUMBER not null,
PARAKIND VARCHAR2(30),
PARAID VARCHAR2(20),
PARANAME VARCHAR2(30)
)

6、测试数据
insert into enumeration (ENUMERATIONKY, PARAKIND, PARAID, PARANAME, ROWID)
values (6, 'depttype', '900051', '总经理办公室', 'AAAMomAAEAAAAFsAAA');

insert into enumeration (ENUMERATIONKY, PARAKIND, PARAID, PARANAME, ROWID)
values (7, 'depttype', '900052', '市场部', 'AAAMomAAEAAAAFsAAB');

insert into enumeration (ENUMERATIONKY, PARAKIND, PARAID, PARANAME, ROWID)
values (8, 'depttype', '900053', '财务部', 'AAAMomAAEAAAAFsAAC');

insert into enumeration (ENUMERATIONKY, PARAKIND, PARAID, PARANAME, ROWID)
values (9, 'depttype', '900054', '人力资源部', 'AAAMomAAEAAAAFsAAD');

insert into enumeration (ENUMERATIONKY, PARAKIND, PARAID, PARANAME, ROWID)
values (10, 'depttype', '900055', '保安部', 'AAAMomAAEAAAAFsAAE');

insert into enumeration (ENUMERATIONKY, PARAKIND, PARAID, PARANAME, ROWID)
values (11, 'depttype', '900056', '后勤部', 'AAAMomAAEAAAAFsAAF');

insert into enumeration (ENUMERATIONKY, PARAKIND, PARAID, PARANAME, ROWID)
values (1, 'empstate', '900001', '在职', 'AAAMomAAEAAAAFsAAG');

insert into enumeration (ENUMERATIONKY, PARAKIND, PARAID, PARANAME, ROWID)
values (2, 'empstate', '900002', '离职', 'AAAMomAAEAAAAFsAAH');