树形界面问题

棒棒糖

  sql = "select null as fParentID,1 as fLevel,false as fIsLeaves,fID,fName from "
            + TABLE_PROVINCE+" GROUP BY fID limit "+offset+","+limit;案例中这样的sql语法不能执行，group by语法用的不对不？


   switch (level) {
                        case 1:
                            sql = "select null as fParentID,1 as fLevel,'false' as fIsLeaves,fID,fPrjYear as fName from "
                            + TABLE_CBMP_TaskInfo+" GROUP BY fID limit "+offset+","+limit;
                            sqlWhere = "";
                            showTable = TABLE_CBMP_TaskInfo;
                            break;
                        case 2:
                            sql = "select fID as fParentID,2 as fLevel,'false' as fIsLeaves,"
                            +"concat_ws('-','"+parent+"',CONVERT(fID,char)) as fID,fPrjName as fName from "
                            + TABLE_CBMP_TaskInfo+" where fID = "+parent+" GROUP BY fID limit "+offset+","+limit;
                            sqlWhere = "where fID = "+parent;
                            showTable = TABLE_CBMP_TaskInfo;
                            break;
                        case 3:
                            sql = "select fID as fParentID,3 as fLevel,'true' as fIsLeaves,"
                            + "concat_ws('-','"+parent+"',CONVERT(fID,char)) as fID,fTaskName as fName from "
                            + TABLE_CBMP_TaskInfo+" where fID = "+parent+" GROUP BY fID limit "+offset+","+limit;
                            sqlWhere = "where fID = "+parent;
                            showTable = TABLE_CBMP_TaskInfo;
                            break;
                        }
        at java.lang.Thread.run(Thread.java:745)
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: select null as fParentID,1 as fLevel,'false' as fIsLeaves,fID,fPrjYear as fName from CBMP_TaskInfo GROUP BY fID limit 0,20, binds: []出错
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.data.SQL.select(Unknown Source)
        at com.justep.system.data.SQL.select(Unknown Source)
        at QualityManagement.queryCBMP_ProjectTaskTree(QualityManagement.java:48)
        ... 27 more
Caused by: java.sql.SQLException: ORA-00933: SQL 命令未正确结束我的报这错哦；

jishuang

这个是oracle数据库的标准报错，检查sql语句
把limit和offset去掉

棒棒糖

jishuang 发表于 2017-4-7 14:57
这个是oracle数据库的标准报错，检查sql语句
把limit和offset去掉

        at java.lang.Thread.run(Thread.java:745)
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: select null as fParentID,1 as fLevel,'false' as fIsLeaves,fPrjYear as fName from CBMP_TaskInfo GROUP BY fID, binds: []出错
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.data.SQL.select(Unknown Source)
        at com.justep.system.data.SQL.select(Unknown Source)
        at QualityManagement.queryCBMP_ProjectTaskTree(QualityManagement.java:50)
        ... 27 more
Caused by: java.sql.SQLException: ORA-00979: 不是 GROUP BY 表达式
去掉还是不行的，group by不对 按照你们平台提供的列子，你们的列子这样用group by不报错么



case 1:
                            sql = "select null as fParentID,1 as fLevel,'false' as fIsLeaves,fPrjYear as fName from "
                            + TABLE_CBMP_TaskInfo +" GROUP BY fID";

                            sqlWhere = "";
                            showTable = TABLE_CBMP_TaskInfo;

jishuang

报错就是sql的错误，把具体的sql打出来看看你最终拼的是什么，满足sql语法吗

棒棒糖

jishuang 发表于 2017-4-7 16:47
报错就是sql的错误，把具体的sql打出来看看你最终拼的是什么，满足sql语法吗 ...

数据库里有数据却取不出来

jishuang

确认action中返回的关系的名字跟data中的关系名一致吗？
行选择事件中加debugger调试看看这行数据是什么

棒棒糖

jishuang 发表于 2017-4-10 11:10
确认action中返回的关系的名字跟data中的关系名一致吗？
行选择事件中加debugger调试看看这行数据是什么 ...

一致

jishuang

行选择事件中加debugger调试看看这行数据是什么

棒棒糖

jishuang 发表于 2017-4-10 13:52
行选择事件中加debugger调试看看这行数据是什么

null

棒棒糖

棒棒糖 发表于 2017-4-10 13:54
null

.w,.js，.m，.java文件上边都发过了可以给看一下有啥问题