mybatis sql复杂查询问题

... 目测是查询 weishangqiang_content 表 然后 按照创建时间排序

这是个select标签 id已经把功能写很明白了select By WeishangqiangId In Order CreateTime Asc

这么断开还看不懂吗？

SELECT

id AS "id",

wechat_user_id AS "wechat_user_id",

weishangqiang_id AS "weishangqiang_id",

type AS "type",

own_screen_id AS "own_screen_id",

dashang_id AS "dashang_id",

dashang_tar_id AS "dashang_tar_id",

img_url AS "img_url",

content AS "content",

create_time AS "create_time",

theme_id AS "theme_id",

video_url AS "video_url",

to_wechat_user_id AS "to_wechat_user_id",

admin as "admin",

order_id as "order_id"

FROM

weishangqiang_content

WHERE

weishangqiang_id = #{weishangqiangId,jdbcType=INTEGER}

and create_time > str_to_date(#{lastTime,jdbcType=VARCHAR},'%Y-%m-%d %T')

ORDER BY

${sortName} ${sortOrder}

可以将 传入参数时 sortName为create_time  sortOrder可以为ASC（升序），DESC（降序）排序

SELECT   xxxx   FROM   weishangqiang_content    WHERE    weishangqiang_id=?(数据库里面的类型是integer) AND    create_time>?(数据库里面的varchar类型的时间格式换成：年-月-日 时：分：秒) ORDER BY ？（升序/降序）

其中？部分为外界传递的参数。