Package com.alexnevsky.hotel.dao.exception

Examples of com.alexnevsky.hotel.dao.exception.DAOException

268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
    try {
      connection = this.daoFactory.getConnection();
      preparedStatement = prepareStatement(connection, SQL_DELETE, false, values);
      int affectedRows = preparedStatement.executeUpdate();
      if (affectedRows == 0) {
        throw new DAOException("Deleting CustomerAccount failed, no rows affected.");
      } else {
        customerAccount.setId(null);
      }
    } catch (SQLException e) {
      throw new DAOException(e);
    } finally {
      close(connection, preparedStatement);
    }
  }
View Full Code Here
332
333
334
335
336
337
338
339
340
341
342
      connection = this.daoFactory.getConnection();
      preparedStatement = prepareStatement(connection, sql, false, values);
      resultSet = preparedStatement.executeQuery();
      exist = resultSet.next();
    } catch (SQLException e) {
      throw new DAOException(e);
    } finally {
      close(connection, preparedStatement, resultSet);
    }

    return exist;
View Full Code Here
87
88
89
90
91
92
93
94
95
96
97
      resultSet = preparedStatement.executeQuery();
      if (resultSet.next()) {
        room = mapRoom(resultSet);
      }
    } catch (SQLException e) {
      throw new DAOException(e);
    } finally {
      close(connection, preparedStatement, resultSet);
    }

    return room;
View Full Code Here
117
118
119
120
121
122
123
124
125
126
127
      resultSet = preparedStatement.executeQuery();
      while (resultSet.next()) {
        rooms.add(mapRoom(resultSet));
      }
    } catch (SQLException e) {
      throw new DAOException(e);
    } finally {
      close(connection, preparedStatement, resultSet);
    }

    return rooms;
View Full Code Here
155
156
157
158
159
160
161
162
163
164
165
      resultSet = preparedStatement.executeQuery();
      while (resultSet.next()) {
        rooms.add(mapRoom(resultSet));
      }
    } catch (SQLException e) {
      throw new DAOException(e);
    } finally {
      close(connection, preparedStatement, resultSet);
    }

    return rooms;
View Full Code Here
87
88
89
90
91
92
93
94
95
96
97
      resultSet = preparedStatement.executeQuery();
      if (resultSet.next()) {
        customer = mapCustomer(resultSet);
      }
    } catch (SQLException e) {
      throw new DAOException(e);
    } finally {
      close(connection, preparedStatement, resultSet);
    }

    return customer;
View Full Code Here
117
118
119
120
121
122
123
124
125
126
127
      resultSet = preparedStatement.executeQuery();
      while (resultSet.next()) {
        users.add(mapCustomer(resultSet));
      }
    } catch (SQLException e) {
      throw new DAOException(e);
    } finally {
      close(connection, preparedStatement, resultSet);
    }

    return users;
View Full Code Here
85
86
87
88
89
90
91
92
93
94
95
      resultSet = preparedStatement.executeQuery();
      if (resultSet.next()) {
        form = mapForm(resultSet);
      }
    } catch (SQLException e) {
      throw new DAOException(e);
    } finally {
      close(connection, preparedStatement, resultSet);
    }

    return form;
View Full Code Here
117
118
119
120
121
122
123
124
125
126
127
128
129
    try {
      connection = this.daoFactory.getConnection();
      preparedStatement = prepareStatement(connection, SQL_INSERT, true, values);
      int affectedRows = preparedStatement.executeUpdate();
      if (affectedRows == 0) {
        throw new DAOException("Creating Form failed, no rows affected.");
      }
    } catch (SQLException e) {
      throw new DAOException(e);
    } finally {
      close(connection, preparedStatement);
    }
  }
View Full Code Here
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
    try {
      connection = this.daoFactory.getConnection();
      preparedStatement = prepareStatement(connection, SQL_DELETE, false, values);
      int affectedRows = preparedStatement.executeUpdate();
      if (affectedRows == 0) {
        throw new DAOException("Deleting Form failed, no rows affected.");
      } else {
        form.setId(null);
      }
    } catch (SQLException e) {
      throw new DAOException(e);
    } finally {
      close(connection, preparedStatement);
    }
  }
View Full Code Here
TOP

Related Classes of com.alexnevsky.hotel.dao.exception.DAOException

  • com.alexnevsky.hotel.dao.AdminDAO
  • com.alexnevsky.hotel.dao.CreditCardDAO
  • com.alexnevsky.hotel.dao.CustomerAccountDAO
  • com.alexnevsky.hotel.dao.CustomerDAO
  • com.alexnevsky.hotel.dao.FormDAO
  • com.alexnevsky.hotel.dao.OrderDAO
  • com.alexnevsky.hotel.dao.RoomDAO
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.