在java语言编辑的时候,在一个Bean编辑一条SQL语句把以前的给更新。 比如:
sql = "UPDATE vhc_order_tb SET " +
" SALESDATE = OTHERSALESDATE, " +
" UPDATETIME = SYSDATE" +
" WHERE DEALERCODE = ?" +
" AND RTRIM(frameNo) = ?" +
" AND DESCDEALERCODE = ?" +
" AND OTHERSALESDATE IS NOT NULL";
这条语句打印出来的sql语句是:
UPDATE vhc_order_tb SET SALESDATE = OTHERSALESDATE,
UPDATETIME = SYSDATE
WHERE DEALERCODE = ?
AND RTRIM(frameNo) = ?
AND DESCDEALERCODE = ?
AND OTHERSALESDATE IS NOT NULL
现在我把java编辑的SQL语句 添加一个字段更新直 " DELIVERYENDDATE = SYSDATE, "+ 这样的:
为什么它运行打印出来的sql语句还是这样的:
UPDATE vhc_order_tb SET SALESDATE = OTHERSALESDATE,
UPDATETIME = SYSDATE
WHERE DEALERCODE = ?
AND RTRIM(frameNo) = ?
AND DESCDEALERCODE = ?
AND OTHERSALESDATE IS NOT NULL
sql = "UPDATE vhc_order_tb SET " +
" SALESDATE = OTHERSALESDATE, " +
" DELIVERYENDDATE = SYSDATE, "+
" UPDATETIME = SYSDATE" +
后面的where 语句是一样的