ksql.select能正确的执行sql，但是取不json对象

zyygod

jishuang 发表于 2018-7-31 17:23
看平台运行ksql最终执行的sql
不是看你自己拼的sql到数据库中查的

--> sql:SELECT  a.ID AS a, a.DEP_ID AS DEP_ID, a.PERSON_ID AS PERSON_ID, a.NAME AS NAME, a.SEX AS SEX, a.POST AS POST, a.QJJB AS QJJB, a.TYPE AS TYPE, a.BEGIN_TIME AS BEGIN_TIME, a.END_TIME_PLAN AS END_TIME_PLAN, a.DAYS_PLAN AS DAYS_PLAN, a.WORK_AGE AS WORK_AGE, a.ANNUAL_DAYS AS ANNUAL_DAYS, a.COMPLETED_DAYS AS COMPLETED_DAYS, a.REMAINDER AS REMAINDER, a.PERSONAL AS PERSONAL, a.SICK AS SICK, a.MARRY AS MARRY, a.MATERNITY AS MATERNITY, a.FAMILY AS FAMILY, a.REASON AS REASON, a.APPLY_TIME AS APPLY_TIME, a.END_TIME AS END_TIME, a.REAL_DAYS AS REAL_DAYS, a.STATUS AS STATUS, a.REMARK AS REMARK, a.SIGN AS SIGN, a.VACATION AS VACATION, a.BZ1 AS BZ1, a.BZ2 AS BZ2, a.BZ3 AS BZ3, a.BZ4 AS BZ4, a.BZ5 AS BZ5, a.YWH AS YWH FROM QXJJBXXB a  WHERE a.NAME = ?
--> binds:[黄朝奎]

zyygod

jishuang 发表于 2018-7-31 17:23
看平台运行ksql最终执行的sql
不是看你自己拼的sql到数据库中查的

jishuang

你的where条件拼的不是a.PERSON_ID吗？sql语句怎么是name？

zyygod

jishuang 发表于 2018-7-31 17:29
你的where条件拼的不是a.PERSON_ID吗？sql语句怎么是name？

找不到原因我只能换了一个字段试了一下，用PERSON_ID是一样的。

zyygod

jishuang 发表于 2018-7-31 17:29
你的where条件拼的不是a.PERSON_ID吗？sql语句怎么是name？

1.                 String ksql = "Select a.* from QXJJBXXB a where a.NAME ='" + CJRNAME + "'";
   
2.                 System.out.println(ksql);
   
3.                 Table table = KSQL.select(ksql, null, "/app/dataSource/oa_ywk/data", null);
   
4.                 System.out.println(new com.justep.system.transform.Table2Row().transform(table,null).asXML());
   
5. return table;

复制代码

jishuang

确认连的数据库，跟看的数据库是同一个?

zyygod

jishuang 发表于 2018-7-31 17:38
确认连的数据库，跟看的数据库是同一个?

是一样的，上面是数据源配置跟数据库的配置。

jishuang

不加where条件看看能否查出数据