rs = dbm.excuteQuery(sql);
result = result + "<select name='" + select_name + "'";
if (!(js.equals(""))) {
result = result + js;// javascript
}
result = result + ">";
if (!(default_item.equals(""))) {
result = result + "<option value='"
+ Constants.Box_Default_Value + "'>" + default_item
+ "</option>"; // 有无默认选项
}
while (rs.next()) {
code = rs.getString(1).trim();
value = rs.getString(2).trim();
result = result + "<option value='" + code + "'";
if ((!(selected_item.equals("")))
&& (selected_item.equals(code)))
result = result + " selected";// 是否有请求提交的选项.
result = result + ">" + value + " </option>";
}
result = result + "</select>";
rs.close();
return result;
}// end of try
catch (SQLException sqlEx) {
// Debug.printStackTrace(sqlEx);
// SysLog.log(sqlEx.getMessage());
throw new CSSException("DataDictError");
} catch (CSSException e) {
throw e;
}
}