根据排序方式:
SQL:
<select id="query**" resultType="com.guoguo.brains.model.AnsModel">
// 查询语句
SELECT
id AS Id,
count AS Count,
FROM
t_answer
WHERE
brain_storm_id = #{Id}
//条件--根据orderStyle的值按评论数、点赞数、时间排序
<choose>
<when test="orderStyle=='commentStyle'">
order by count
desc
</when>
<when test="orderStyle=='likeStyle'">
order by like
desc
</when>
<otherwise>
order by tb_answer.create_time
</otherwise>
</choose>
</select>