等于查询

数值型

Dto类中定义数值类型的字段privateIntegerstate;Mapper.java文件中增加查询条件List<SysMenuRoleParam>readAll(@Param("condition")SysMenuRoleParamcondition);Mapper.xml文件中增加查询条件test="condition.state != null ">and a.state = ${condition.state}

字符串

Dto类中定义字符串类型的字段privateStringdescr;Mapper.java文件中增加查询条件List<SysMenuRoleParam>readAll(@Param("condition")SysMenuRoleParamcondition);Mapper.xml文件中增加查询条件test="condition.descr != null and condition.descr != ">and a.descr = ${condition.descr}

不等于查询

数值型

Dto类中定义数值类型的字段privateIntegerneqState;Mapper.java文件中增加查询条件List<SysMenuRoleParam>readAll(@Param("condition")SysMenuRoleParamcondition);Mapper.xml文件中增加查询条件test="condition.neqState != null ">and a.state != ${condition.neqState}

字符串

Dto类中定义字符串类型的字段privateStringneqDescr;Mapper.java文件中增加查询条件List<SysMenuRoleParam>readAll(@Param("condition")SysMenuRoleParamcondition);Mapper.xml文件中增加查询条件test="condition.neqDescr != null and condition.neqDescr != ">and a.descr != ${condition.neqDescr}

包含查询

Dto类中定义字符串类型的字段privateStringdescr;Mapper.java文件中增加查询条件List<SysMenuRoleParam>readAll(@Param("condition")SysMenuRoleParamcondition);Mapper.xml文件中增加查询条件test="condition.descr != null and condition.descr != ">and a.descr like %${condition.descr}%

以…开始查询

Dto类中定义字符串类型的字段privateStringdescr;Mapper.java文件中增加查询条件List<SysMenuRoleParam>readAll(@Param("condition")SysMenuRoleParamcondition);Mapper.xml文件中增加查询条件test="condition.descr != null and condition.descr != ">and a.descr like ${condition.descr}%

以…结束查询

Dto类中定义字符串类型的字段privateStringdescr;Mapper.java文件中增加查询条件List<SysMenuRoleParam>readAll(@Param("condition")SysMenuRoleParamcondition);Mapper.xml文件中增加查询条件test="condition.descr != null and condition.descr != ">and a.descr like %${condition.descr}

时间范围查询

Dto类中定义两个字符串类型的字段privateStringstartStr;privateStringendStr;Mapper.java文件中增加查询条件List<SysMenuRoleParam>readAll(@Param("condition")SysMenuRoleParamcondition);Mapper.xml文件中增加查询条件test="condition.startStr != null and condition.startStr != ">