SELECT a.agreement_code AS SOURCE_ID, (
SELECT x.org_name
FROM organization x, system_user y,system_user_post sp
WHERE y.sys_user_id = a.oper_id
AND y.sys_user_id = sp.sys_user_id
AND sp.org_id = x.org_id
AND x.lan_id = a.lan_id
) AS JSBSS_APPLYDEPTCODE, a.sign_person AS JSBSS_USERID, a.oper_phone AS JSBSS_USERTEL, (
SELECT xx.agreement_undertaker_org_code
FROM agreement_undertaker_org xx
WHERE xx.agreement_undertaker_org_id = b.agreement_undertaker_org
) AS APPLYDEPTCODE
, (
SELECT yy.agreement_undertaker_code
FROM agreement_undertaker yy
WHERE yy.agreement_undertaker_id = b.agreement_undertaker_id
) AS APPLYUSERID, a.lan_id AS BSS_APPLYRANGE, a.cust_id AS JSBSS_CUSTOMCODE, a.agreement_name AS CONTRACTNAME, to_char(a.accept_end_time, 'yyyy-mm-dd') AS THEORYPAYDATE_DAYS
, a.cust_name AS PARTBNAME, a.cust_name AS MANUNAME, a.sign_place AS CONSADDR, to_char(a.accept_begin_time, 'yyyy-mm-dd') AS SIGNDATE, to_char(a.accept_end_time, 'yyyy-mm-dd') AS ENDDATE
, (
SELECT aa.param_val
FROM dc_system_param aa
WHERE aa.param_code = 'URL_FOR_MSS_AGREEMENT'
)
|| 'servlet/GetAgreeInfoForMssServlet?msg_id='
|| nvl(b.msg_id, 'X108')
|| '&'
|| 'agreement_id='
|| a.agreement_id AS URL, b.msg_id AS MSGID, 'A018' AS PARTATYPE, 'contractfiles_162' AS Type, a.agreement_name
|| '.doc' AS name
, a.agreement_text, (
SELECT aa.mss_name
FROM agreement_mss aa
WHERE aa.mss_id = b.agreement_mss_name
) AS PARTANAME, a.agreement_id
FROM agreement a, agreement_mss_info b
WHERE
state = 'D'
AND agreement_kind = '15'
AND
a.agreement_id = b.agreement_id
并且agreement这个算是主表吧?里边是有字段的,我单独查的时候,就算没有数据,为什么连字段都不给我显示的?
请求各路大神了,我现在需要数据做测试,但是不知怎么插入数据,我是新手,以下是我要插入数据后做判断要修改的sql:String lockSql="update agreement a set a.state=? where a.agreement_id=?";
SELECT x.org_name
FROM organization x, system_user y,system_user_post sp
WHERE y.sys_user_id = a.oper_id
AND y.sys_user_id = sp.sys_user_id
AND sp.org_id = x.org_id
AND x.lan_id = a.lan_id
) AS JSBSS_APPLYDEPTCODE, a.sign_person AS JSBSS_USERID, a.oper_phone AS JSBSS_USERTEL, (
SELECT xx.agreement_undertaker_org_code
FROM agreement_undertaker_org xx
WHERE xx.agreement_undertaker_org_id = b.agreement_undertaker_org
) AS APPLYDEPTCODE
, (
SELECT yy.agreement_undertaker_code
FROM agreement_undertaker yy
WHERE yy.agreement_undertaker_id = b.agreement_undertaker_id
) AS APPLYUSERID, a.lan_id AS BSS_APPLYRANGE, a.cust_id AS JSBSS_CUSTOMCODE, a.agreement_name AS CONTRACTNAME, to_char(a.accept_end_time, 'yyyy-mm-dd') AS THEORYPAYDATE_DAYS
, a.cust_name AS PARTBNAME, a.cust_name AS MANUNAME, a.sign_place AS CONSADDR, to_char(a.accept_begin_time, 'yyyy-mm-dd') AS SIGNDATE, to_char(a.accept_end_time, 'yyyy-mm-dd') AS ENDDATE
, (
SELECT aa.param_val
FROM dc_system_param aa
WHERE aa.param_code = 'URL_FOR_MSS_AGREEMENT'
)
|| 'servlet/GetAgreeInfoForMssServlet?msg_id='
|| nvl(b.msg_id, 'X108')
|| '&'
|| 'agreement_id='
|| a.agreement_id AS URL, b.msg_id AS MSGID, 'A018' AS PARTATYPE, 'contractfiles_162' AS Type, a.agreement_name
|| '.doc' AS name
, a.agreement_text, (
SELECT aa.mss_name
FROM agreement_mss aa
WHERE aa.mss_id = b.agreement_mss_name
) AS PARTANAME, a.agreement_id
FROM agreement a, agreement_mss_info b
WHERE
state = 'D'
AND agreement_kind = '15'
AND
a.agreement_id = b.agreement_id
并且agreement这个算是主表吧?里边是有字段的,我单独查的时候,就算没有数据,为什么连字段都不给我显示的?
请求各路大神了,我现在需要数据做测试,但是不知怎么插入数据,我是新手,以下是我要插入数据后做判断要修改的sql:String lockSql="update agreement a set a.state=? where a.agreement_id=?";
你开的是个测试窗口。。你应该开个sql窗口。。这样就能查到agreement的值