级联查询在UEP中采用动态下拉的形式,cascadeid为关键字,注意jsp页面的id的相互嵌套关系,
数据库字段的数值的设置,和动态下拉SQL语句的书写。
<td align="center" width="10%">客户</td> <td width="20%"> <hy:drop id="customerId" name="dataWrap.query.customerId" upload="true" dropname="DILL.CUSTOMER" cssStyle="100%" cascadeid="contractId"/> </td> <td align="center" width="10%">合同</td> <td width="20%"> <hy:drop id="contractId" name="dataWrap.query.contractId" upload="true" dropname="DILL.CONTRACT" cssStyle="100%"/> </td>
- 系统表
select * from ep_sys_extend_property; select * from ep_sys_param_type; select * from ep_sys_param_value; select * from ep_sys_entity_sequence_no;