这是什么问题,高手来看看.
我在ejb中用sql语句更新数据库.代码如下:
private static final String UPDATEORDERNO_SQL =
"update snd_orderno_tb orderno "
+ " set orderno.divdate =sysdate,"
+ " orderno.UPDATECOUNT = ?,"
+ " orderno.INVOICENO = ?"
+ " where orderno.dealerCode = ?"
+ " and orderno.orderNo = ?"
+ " and orderno.sfx = ?"
+ " and orderno.model = ?"
+ " and orderno.color = ?";
stmt.setLong(1, updateCount);
stmt.setString(2, oData.getInvoiceSeq());
stmt.setString(3, oData.DEALERCODE);
stmt.setString(4, oData.ORDERNO);
stmt.setString(5, oData.SFX);
stmt.setString(6, oData.MODEL);
stmt.setString(7, oData.COLOR);
stmt.execute() ;
conn.commit();
这段代码看起来没有问题,可是执行完后数据库根本没有更新.我按照检索条件自己组合成一个完整的sql语句,放到sql*plus中执行可以正确更新.就是在代码中不行,这是什么问题.高手来指点一下.