多谢各位大侠的回复!
我用的是jsp+servlet+javabean的方式做的。现在实现的功能是根据输入的查询条件在页面显示相关信息,在修改完“Good QTY”的值后将修改后的值传到Arraylist。由于查询的信息是通过多表关联的方式得到的,没有实体表,因此不知道怎么UPdate,下面是我写的sql,但是报错:
UPDATE (
SELECT /*+ BYPASS_UJVC */ trim(d.key_no)key_no,b.sp_katamei,b.kura_kjn,a.katamei,a.suryo,substr(a.taping_kbn,2)taping_kbn,a.gensankoku,a.suffix_katamei, a.label_ptn,a.naiso_maisu,a.daihyo_maisu,b.sbt_lvl,d.ssn_skkr_su,trim(e.dtcd)dtcd,
CASE
WHEN b.sbt_lvl='1' THEN '<R>Pb'
WHEN b.sbt_lvl='2' THEN '<R>FTPb'
WHEN b.sbt_lvl='3' THEN '<G>R-Pb'
WHEN b.sbt_lvl='4' THEN '<G>NoPb'
WHEN b.sbt_lvl='A' THEN '<G>'
WHEN b.sbt_lvl='B' THEN '<R>'
WHEN b.sbt_lvl=' ' THEN ' '
END sbt_desc
FROM ott0470@alpstest a,ott0070@alpstest b,ott0130@alpstest c,ost0090@alpstest d,ost0100@alpstest e
WHERE (b.sp_katamei||b.kura_kjn)=a.katamei
AND a.katamei=(c.katamei_body||c.katamei_kurakjn)
AND (c.katamei_body||c.katamei_kurakjn)= (d.katamei_body||d.katamei_kuraki)
AND (d.katamei_body||d.katamei_kuraki)=e.katamei
AND d.skkr_kotei_flow_rnbn=e.kotei_flow_rnbn
AND d.key_no=e.key_no
AND (c.ksbr_cd LIKE '7%' OR c.ksbr_cd LIKE 'J%')
) LabelData SET LabelData.ssn_skkr_su=1000
WHERE (LabelData.key_no = 'XYL388100K' or LabelData.key_no= '' or LabelData.key_no= '' or LabelData.key_no= '' or LabelData.key_no= '' or LabelData.key_no= '')
还请多指教