代码均由MyBatis Generator自动生成
以下是mapper.xml文件中部分语句
select
<if test="distinct">
distinct
</if>
<include refid="Base_Column_List" />
from HOUSE
<if test="_parameter != null">
<include refid="Example_Where_Clause" />
</if>
<if test="orderByClause != null">
order by ${orderByClause}
</if>
//业务层代码
exp.setOrderByClause("BUILDING,UNIT,ROOM");//设置排序字段
测试结果:排序失败
检查数据库
发现字段为字符串类型的数值
所以更改设置排序条件为
exp.setOrderByClause("BUILDING*1,UNIT*1,ROOM*1");//方案一
exp.setOrderByClause("BUILDING+0,UNIT+0,ROOM+0");//方案二
//sql层面
SELECT * FROM HOUSE ORDER BY BUILDING*1,UNIT*1,ROOM*1
SELECT * FROM HOUSE ORDER BY BUILDING+0,UNIT+0,ROOM+0
排序成功,结果显示