下面是报错信息:
把SQL拿到去运行 出来两条count数据
自己手动用mysql LIMIT 分页 丢到Jfinal 里查询 报如下错误
Caused by: java.sql.SQLException: sql injection violation, syntax error: not support token:STAR : SELECT * FROM(
SELECT
round(
sum(
CASE cause
WHEN '联系方式无效' THEN
1
WHEN '客户明确无需求' THEN
1
ELSE
0
END
) / + COUNT(*) * 100,
2
) AS efficient,
u.*,@rownum :=@rownum + 1 AS rownum
FROM
(SELECT @rownum := 0) r,
ws_information i
LEFT JOIN ws_users u ON u.id = i.promulgatorid
GROUP BY
i.promulgatorid
ORDER BY efficient DESC
) y LIMIT 0,10