grails 笔记

grails排序时,如果数据库中有空字段,会出错,提示不能转换属性

可能情况 order 字段:"desc" 能执行,但到后面页的时候(分页)会出错,说明在当前页面数据库字段有问题.

可能情况 order 字段:"asc"不能执行,说明第一面中,数据库中有字段为空或不合排序规则.

<div class="search">
            <g:form action="list" method="post">
                <g:message code="sysOperator.name.label"/>:
                <g:textField name="name" maxlength="45" value="${params?.name}" style="height: 16px;"/>
                <g:message code="sysOperator.organization.label"/>:
                <g:recursionSelect name="organization" selectedId="${params?.int('organization')}"
                                   rootInstance="${SysOrganization.get(0)}" noSelection="${['':'-请选择-']}"
                                   showRoot="${false}"/>
                <g:message code="sysOperator.status.label"/>:
                <g:select
                        from="${[message(code: 'sysOperator.status.true.label'),message(code: 'sysOperator.status.false.label')]}"
                        keys="${['0','1']}" name="status" value="${params?.status}" noSelection="['':'-请选择-']"/>
                <input type="submit" value="查询" class="button">
            </g:form>
        </div>

定义查询块