Tapestry 实现条件查询

举例：对供应商的级别进行条件查询

 

HTML：

 

1. <TR>
2.     <TD width="70" class="tittle_right">
3.         供应商类别 
4.     </TD>
5.         <td align="left" bgcolor="#E5F4FF">
6.                  <select class="INPUT" jwcid="@PropertySelection"value="ognl:queryApplierModel.rank"
7.                               model="ognl:rankModel" size="1">
8.                  </select>                    
9.    </TD>
10. </TR>

JAVA:

 

1.     public IPropertySelectionModel getrankModel() {
2.         return getApplierDAO().getRankModel(false);
3.     }

 

DAO:

 

 

1.     public IPropertySelectionModel getRankModel(boolean isNull); 

 

DAOImpl:

 

 

1.     public IPropertySelectionModel getRankModel(boolean isNull){
2.     List _locales = new ArrayList();
3.     List _labels = new ArrayList();
5.     if (isNull) {
6.         _locales.add("");
7.         _labels.add("");
8.     }
9.         _locales.add("A");
10.     _labels.add("A");
12.         _locales.add("B");
13.         _labels.add("B");
15.         _locales.add("C");
16.         _labels.add("C");
17.         
18.     IPropertySelectionModel listModel = new ListModel(_locales, _labels);
19.                  return listModel;
20.     }

 

Cond.xml:

 

      要查询的字段

 

1. <?xml version="1.0" encoding="GB2312"?>
2. <ConditionMappings>
3.     <Condition operation="like" hbmField="applierHBM.rank" type="String" FirstModleField="rank" SecondModleField="" />
4. </ConditionMappings>

 

table.xml:

 

     根据字段，查询后，显示的内容

1. <?xml version="1.0" encoding="GBK"?>
2. <TableClass tableclass="ApplierList">       
3.     <ExpressionTableColumnEdit>
4.         <ColumnName>userid</ColumnName>
5.         <DisplayName>用户名</DisplayName>
6.         <Expression>userid</Expression>
7.         <Sortable>true</Sortable>
8.     </ExpressionTableColumnEdit>
9.     <ExpressionTableColumn>
10.         <ColumnName>suppliername</ColumnName>
11.         <DisplayName>供应商名称</DisplayName>
12.         <Expression>suppliername</Expression>
13.         <Sortable>true</Sortable>
14.     </ExpressionTableColumn>    
15.     <ExpressionTableColumn>
16.         <ColumnName>rank</ColumnName>
17.         <DisplayName>供应商类型</DisplayName>
18.         <Expression>rank</Expression>
19.         <Sortable>true</Sortable>
20.     </ExpressionTableColumn>    
21.     <ExpressionTableColumn>
22.         <ColumnName>checked1</ColumnName>
23.         <DisplayName>审批</DisplayName>
24.         <Expression>checked1?"是":"否"</Expression>
25.         <Sortable>true</Sortable>
26.     </ExpressionTableColumn>
27.     <SimpleTableColumn>
28.         <ColumnName>delete</ColumnName>
29.         <DisplayName>操作</DisplayName>
30.         <Sortable>false</Sortable>
31.     </SimpleTableColumn>
32.     
33. </TableClass>