0.可排序字段:id,age,income
1.查询接口中,有一个orderBy参数
2.如果用户选择的age,那么就把orderBy参数的值设置成age
3.java中,伪代码如下(因为第4步中,我们会用$符号取值,在这里防止sql注入):
if(orderBy == "id"){
orderBy = "id";
}else if(orderBy == "age"){
orderBy = "age";
}else if(orderBy == "income"){
orderBy = "income";
}else{
return error...
}
4.sql中如下:
select xxx
from tableName
where xxx
order by ${orderBy}