前言

Bootstrap-Table表格排序

<script th:inline="javascript">...$(function() {var options = {url: prefix + "/list",...sortName: "sort",sortOrder: "desc",...};$.table.init(options);});</script>

当表格中包含sortName和sortOrder属性时，sql语句会自动生成order by子句：

SELECT * FROM xxx order by sort desc LIMIT ?

多个字段排序

<script th:inline="javascript">...$(function() {var options = {url: prefix + "/list",...sortName: "sort desc,id asc",sortOrder: "",...};$.table.init(options);});</script>

当表格中包含sortName和sortOrder属性时，sql语句会自动生成order by子句：

SELECT * FROM xxx order by sort desc,id asc LIMIT ?