public Integer add(WheelsBCD entity) {
   Integer generatedId = null;
   ResultSet resultSet = null;
   Connection connection = null;
   PreparedStatement preparedStatement = null;
   if (checkEntity(entity)) {
     try {
       connection = connectionPool.getConnection();
       preparedStatement =
           (PreparedStatement)
               connection.prepareStatement(addRequest, PreparedStatement.RETURN_GENERATED_KEYS);
       preparedStatement.setString(1, entity.getValue());
       preparedStatement.execute();
       resultSet = preparedStatement.getGeneratedKeys();
       if (resultSet.next()) {
         generatedId = resultSet.getInt(1);
       }
     } catch (SQLException ex) {
       generatedId = null;
     } finally {
       closeAll(resultSet, preparedStatement, connection);
     }
   }
   return generatedId;
 }
 private boolean checkEntity(WheelsBCD entity) {
   boolean checked = true;
   if (entity == null || entity.getValue() == null) {
     checked = false;
   }
   return checked;
 }