2019-03-14 10:57

请问如果我要写动态sql，可以用#if判断是否存在，并判断她的值嘛，比如说#if(num && num =1),这样的用法可以嘛

jfinal分页查询动态SQL的高级处理应用实例，解决你繁琐的查询条件拼接问题！

2019-03-14 10:47

@天朝子民 请问如果我要写动态sql，可以用#if判断是否存在，并判断她的值嘛，比如说#if(num && num =1),这样的用法可以嘛

jfianl的sql语句这样写，是什么语法呢？

2019-03-14 10:26

2019-03-12 16:09

2019-02-20 21:13

2019-01-21 14:16

@要输就输给追求 好的，谢谢

jfinal的paginate方法可以带参数吗？

2019-01-21 14:16

@JFinal 好的，谢谢波总

jfinal的paginate方法可以带参数吗？

2019-01-19 14:11

@JFinal
波总您好，谢谢您的回答，上面已经改了sql语句，但是还是会报下面的错误

sql语句是这样的：
select *
FROM
(select *,
(select count(1) from organize_course oc where o.uid =oc.organize_uid) AS course_num,
(SELECT count(1) FROM organize_course oc WHERE o.uid =oc.organize_uid AND oc.status=1)as onsale_num,
(SELECT COUNT(1) FROM organize_member om WHERE o.uid =om.organize_uid AND member_role =2) AS stu_num,
(SELECT COUNT(1) FROM social_like sc WHERE o.uid =sc.target_uid ) AS fans_num
from organize o
ORDER BY #para(orderType) #para(orderMode)) as temp

下面的是报错信息：

com.jfinal.core.ActionHandler.error /organize/listOrganize?page=1&order_type=course_num&order_mode=DESC
com.jfinal.plugin.activerecord.ActiveRecordException: java.sql.SQLException: sql injection violation, syntax error: syntax error, error in :'nize o
?) as temp
',expect RPAREN, actual QUES o : select count(*) from
(select *,
(select count(1) from organize_course oc where o.uid =oc.organize_uid) AS course_num,
(SELECT count(1) FROM organize_course oc WHERE o.uid =oc.organize_uid AND oc.status=1)as onsale_num,
(SELECT COUNT(1) FROM organize_member om WHERE o.uid =om.organize_uid AND member_role =2) AS stu_num,
(SELECT COUNT(1) FROM social_like sc WHERE o.uid =sc.target_uid ) AS fans_num
from organize o
?) as temp

jfinal的paginate方法可以带参数吗？

2019-01-19 11:50

2019-01-19 11:37

2019-01-05 17:40

@JFinal generator.setGenerateDaoInModel(true);
generator.setGenerateDataDictionary(false);
generator.addExcludedTable(excludeTableName);我是有这三个的，是封装了吗

Jfinal的set方法是连续调用吗？

2019-01-05 17:31