1 参数设定
select t.ywlsh, t.deptid, t.deptname, t.reportername from tj_czw_yw t
where 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:后缀