Statement atmt = conn.createStatement();
ResultSet rs = atmt.executeQuery(querySQL);用上面的方式进行查询,SQL语句为下例的多表连接查询:
select distinct(i.SEQ_ID) id,i.VALUE_TEXT text
from ORDER h, INSTANCE i
where
h.TASKID = 10062
and
h.STATUSID = 10003
and
i.ORDERTYPEID = 10009
and
i.DATAID = 10092
and
i.SEQ_ID = h.SEQ_IDwhile(rs.next())为Flase
这样获取不到结果集,(实际是有结果的),但改为单表查询就能取到了,请教应该怎么取法,谢谢~
ResultSet rs = atmt.executeQuery(querySQL);用上面的方式进行查询,SQL语句为下例的多表连接查询:
select distinct(i.SEQ_ID) id,i.VALUE_TEXT text
from ORDER h, INSTANCE i
where
h.TASKID = 10062
and
h.STATUSID = 10003
and
i.ORDERTYPEID = 10009
and
i.DATAID = 10092
and
i.SEQ_ID = h.SEQ_IDwhile(rs.next())为Flase
这样获取不到结果集,(实际是有结果的),但改为单表查询就能取到了,请教应该怎么取法,谢谢~
i.DATAID 都是数值型吗?