plsql 用法

1 参数设定

select t.ywlsh, t.deptid, t.deptname, t.reportername from tj_czw_yw twhere rownum < 10 and t.districtcode=&<name="工作站"  type="integer" list="select k.districtcode, k.name from t_sys_district k " description="yes" restricted="yes"  required="yes" >and t.deptid=&<name="部门" list="select k.orgid, k.name from t_sys_org k where k.districtcode=:工作站" description="yes" restricted="yes">/*order by t.ywlsh &<name="Descending sort order" checkbox="desc,asc">*/&<name="order by desc" list="ywlsh, deptid, reportername" prefix="order by ">

说明

name：名称type：类型list：取值范围（list="empno, ename, hiredate"）（list="1，empno, 2，ename, 3，hiredate"）required：yes  必填description：yes  单选显示名称restricted：yes 只可以选择，不可以填写checkbox:复选框prefix：前缀suffix：后缀