结果集的问题,各位大虾帮帮忙
SQLStr = "select ";
SQLStr += " (select outdpot from PRODORDER where listcode=PRODORDERLIST.ordercode)OutDpot, ";
SQLStr += " (select indpot from PRODORDER where listcode=PRODORDERLIST.ordercode)InDpot , ";
SQLStr += " ProdCode,ProdNum,prodprice ";
SQLStr += " from PRODORDERLIST ";
SQLStr += " where ordercode='"+OrderCode+"'";
rs1=jdbc.query(SQLStr);//有多条记录
while(rs1.next())
{
OutDpotCode = rs1.getString("OutDpot");
InDpotCode = rs1.getString("InDpot");
ProdCode = rs1.getString("ProdCode");
ProdNum = mf.ObjToInt(rs1.getString("ProdNum"));
ProdPrice = mf.ObjToDub(rs1.getString("prodprice"));
//更新出库库存
if (ErrMsg == null)
{
SQLStr = "update PRODDPOT set PRODNUM = PRODNUM - " + ProdNum + ", UPDATEDATE = SYSDATE ";
SQLStr += " where DPOTCODE = '" + OutDpotCode + "' ";
SQLStr += " and DPOTSECT = '" + SelDpotSect + "' ";
SQLStr += " and PRODCODE = '" + ProdCode + "'";
if (jdbc.update(SQLStr)!=1) ErrMsg = "*更新数据库错误!";
}
}
我上面的SQL里有多条记录,但是运行了if (jdbc.update(SQLStr)!=1) ErrMsg = "*更新数据库错误!" 这句后,while运行了一次就退出了,修改的语句也没有错,这是什么原因,是不是结果集受到了影响,各位大虾帮帮忙啊!