jfinal分页sql问题

aaiqijs 发布于 2015/09/08 10:13
阅读 121
收藏 1

@JFinal 你好,想跟你请教个问题:select a.title,sr.user_id,sr.submission_type,sr.submission_time,sr.auditing_status,sr.auditing_time,fu.username,sr.auditing_integral
from submission_record as sr INNER JOIN article as a on sr.article_id = a.article_id INNER JOIN fast_user as fu on sr.auditing_user_id = fu.id
UNION
select a.title,sr.user_id,sr.submission_type,sr.submission_time,sr.auditing_status,sr.auditing_time,null,sr.auditing_integral
from submission_record as sr INNER JOIN article as a on sr.article_id = a.article_id  像这样的语句怎么调用jfinal的分页呢

加载中
0
JFinal
JFinal
   Db.paginate("select a.title,sr.user_id,sr.submission_type,sr.submission_time,sr.auditing_status,sr.auditing_time,fu.username", "from submission_record as sr INNER JOIN article as a on sr.article_id = ? INNER JOIN fast_user as fu on sr.auditing_user_id = ?
UNION
select a.title,sr.user_id,sr.submission_type,sr.submission_time,sr.auditing_status,sr.auditing_time,null,sr.auditing_integral

from submission_record as sr INNER JOIN article as a on sr.article_id = ?", a.article_id, fu.ida.article_id )

   JUST TO IT!!!

返回顶部
顶部