对单个字段进行排序

1、实体类中添加属性

private String orderName;//排序的字段
private String orderMethod;//排序方式 如 asc desc

 2、前台添加方法

<!--要排序的字段-->

<td><a href="javascript:morder('longtime')">电影时长</a></td>
<td><a href="javascript:morder('price')">价格</a></td>
<td><a href="javascript:morder('years')">年代</a></td>

function morder(orderName){
　　var orderMethod = '${movieVO.orderMethod}';
　　orderMethod= orderMethod=='desc'?'asc':'desc';
　　location.href="/selects?orderName="+orderName+"&orderMethod="+orderMethod;
}

3、mybits中添加排序sql

<!-- 动态排序 -->
<if test="(orderName!=null and orderName!='' ) and (orderMethod!=null and orderMethod!='')">
　　order by ${orderName} ${orderMethod}
</if>