public OfferUser getOfferUser(int offerId, int userId) throws InvocationTargetException {
String sql =
"select offer_id as offerId, USER_ID as userId,status from offer_user "
+ " where offer_id = ? and USER_ID= ?";
OfferUser offerUser = null;
try {
this.pstmt = JDBCDataConnection.getConnection().prepareStatement(sql);
this.pstmt.setInt(1, offerId);
this.pstmt.setInt(2, userId);
ResultSet rs = this.pstmt.executeQuery();
Object[] obj =
ResultSetToModel.parseDataEntityBeans(rs, "com.offerme.server.database.model.OfferUser");
if (obj.length > 0) {
offerUser = (OfferUser) obj[0];
}
} catch (Exception e) {
String err = Log.getStackInfo(e);
myLog.error(err);
throw new InvocationTargetException(e, err);
} finally {
this.free();
}
return offerUser;
}
