81,092
社区成员
发帖
与我相关
我的任务
分享
<select id="queryStudent" resultMap="common.StudentResult">
select * from Student
<dynamic prepend="where">
<isNotEmpty prepend="and" property="SNO">
SNO = #SNO#
</isNotEmpty>
<isNotEmpty prepend="and" property="SNAME">
SNAME = #SNAME#
</isNotEmpty>
<isNotEmpty prepend="and" property="SEX">
SEX = #SEX#
</isNotEmpty>
</dynamic>
<dynamic prepend="order by">
<isNotEmpty property="sortString">
$sortString$
</isNotEmpty>
<isEmpty property="sortString">
SNO
</isEmpty>
</dynamic>
</select>