1. IBatis通过以下语句查询出来的List,内含一个个map对象. select * from ( select v.BIZCODE as process_type, v.BIZID as process_id, v.INITORGID as corp_code, t.nodeid as node_code, t.nodename as node_name, nvl(v.INITSTAFFID,' ') as applicant, (case when t.createddatetime is null then ' ' when t.createddatetime is not null then to_char(t.createddatetime,'yyyy-mm-dd') end ) as app_date, nvl(t.executorid,' ') as audit_person, (case when t.donedatetime is null then ' ' when t.donedatetime is not null then to_char(t.donedatetime,'yyyy-mm-dd') end ) as audit_date, nvl(t.ownerid,' ') as ownername, tf.id_num as id_num from v_process_task v, task t, tf_payout_list tf where v.STATUS = #status# and (v.BIZCODE = #tobaccopay02# or v.BIZCODE = #unagrpayout#) and v.MPID = t.mpid and v.INITORGID = '114201' and t.flag = #flag# and tf.payout_id = v.BIZID and to_char(t.donedatetime,'yyyyMMdd')<!--[CDATA[ > ]]-->'20100901' ) a where not exists (SELECT 1 FROM OUT_SEND_TO_ISO_LOG OUT WHERE OUT.SEND_BIZID = a.PROCESS_ID) 你的当前访问异常,请进行认证后继续阅读剩余内容。 提交