Mybatis实现动态排序
注意事项:使用这样连续拼接两个注入参数时,只能用${},不能用#{}。
SELECT
name , sex , age , user_grade as userGrade
FROM user
<if test="orderField !=null and orderField != '' ">
order by ${orderField} ${sort}
</if>
防注入
if (null == tsSymptomKgm.getOrderField() ){
tsSymptomKgm.setOrderField("property_07");
}
if ("descending".equals( tsSymptomKgm.getSort() ) ){
tsSymptomKgm.setSort("desc");
}else if ("ascending".equals( tsSymptomKgm.getSort() )){
tsSymptomKgm.setSort("asc");
}else {
tsSymptomKgm.setSort("desc");
}