// ----------------------------------------------------------------------------------------- // --getItemCode public String getItemCodeInESI() throws QueryException, ContainerException { AmsCabelInfoModel modelClass = (AmsCabelInfoModel) sqlProducer; SQLModel sqlModel = modelClass.getItemCodeInESIModel(); SimpleQuery sq = new SimpleQuery(sqlModel, conn); sq.executeQuery(); RowSet rs = sq.getSearchResult(); return rs.getRow(0).getStrValue(0); }
public boolean checkInESD() throws QueryException { boolean hasBeen; AmsCabelInfoModel modelClass = (AmsCabelInfoModel) sqlProducer; SQLModel sqlModel = modelClass.getCheckInESDModel(); SimpleQuery sq = new SimpleQuery(sqlModel, conn); sq.executeQuery(); hasBeen = sq.hasResult(); return hasBeen; }
public void updateInEII() throws DataHandleException { AmsCabelInfoModel modelClass = (AmsCabelInfoModel) sqlProducer; SQLModel sqlModel = modelClass.getUpdateInEIIModel(); DBOperator.updateRecord(sqlModel, conn); }