如何后端流程中查询 x5sys 系统表中的数据？

qbyytec

如何后端流程中查询 x5sys 系统表中的数据？

public static void businessActivity1AfterAdvance() {
            String sql_task = "select t.* from sa_task t where t.sID = '"+taskID+"'";
               Table taskTable = SQL.select(sql_task, null, dataModel);
}

Caused by: java.sql.SQLException: 对象名 'sa_task' 无效。
        at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
        at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
        at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
        at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
        at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:418)
        at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:693)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        ... 41 more

jishuang

   String sql_task = "select t.* from SA_Task t where t.sID = '"+taskID+"'";
               Table taskTable = KSQL.select(sql_task, null, "/system/data",null);

qbyytec

sa_task  表名在SQL语句中区分大小写吗

又报错了

jishuang

String sql_task = "select t.* from SA_Task t where t= '"+taskID+"'";
               Table taskTable = KSQL.select(sql_task, null, "/system/data",null);

qbyytec

好的，结贴吧