Ejemplo n.º 1
0
  public List<Address2> retrieveFromId(String userId) {

    List<Address> listUser =
        (List<Address>)
            hibernateTemplate.findByNamedQueryAndNamedParam(
                "Address.findByUserId", "userId", userId);

    List<Address2> listUser2 = new ArrayList<Address2>();

    for (int i = 0; i < listUser.size(); i++) {
      Address2 add = new Address2();
      add.setAddressId(listUser.get(i).getAddressId());
      add.setAddressLine1(listUser.get(i).getAddressLine1());
      add.setAddressLine2(listUser.get(i).getAddressLine2());
      add.setCityId(listUser.get(i).getCityId());
      add.setCountryId(listUser.get(i).getCountryId());
      add.setCreatedDate(listUser.get(i).getCreatedDate());
      add.setIsActive(listUser.get(i).getIsActive());
      add.setName(listUser.get(i).getName());
      add.setPhone(listUser.get(i).getPhone());
      add.setPostalCode(listUser.get(i).getPostalCode());
      add.setUpdatedDate(listUser.get(i).getUpdatedDate());
      add.setUserId(listUser.get(i).getUserId());
      add.setStateId(listUser.get(i).getStateId());
      listUser2.add(add);
    }

    /*
     *Method for fetching CityName using cityId
     */
    for (int i = 0; i < listUser.size(); i++) {
      List<?> cityList =
          (List<?>)
              hibernateTemplate.findByNamedQueryAndNamedParam(
                  "City.findByCityId", "cityId", listUser.get(i).getCityId());
      if (cityList.size() > 0) {
        City city = (City) cityList.get(0);
        String cityName = city.getCityName();
        (listUser2.get(i)).setCityName(cityName);
      }
    }
    /*
     * Method for fetching StateName using stateId
     */
    for (int i = 0; i < listUser.size(); i++) {
      List<?> stateList =
          (List<?>)
              hibernateTemplate.findByNamedQueryAndNamedParam(
                  "State.findByStateId", "stateId", listUser.get(i).getStateId());
      if (stateList.size() > 0) {
        State state = (State) stateList.get(0);
        String stateName = state.getStateName();
        (listUser2.get(i)).setStateName(stateName);
      }
    }

    return listUser2;
  }
Ejemplo n.º 2
0
 public Address getAddressById(Integer addressId) {
   List addressList =
       (List<Address>)
           hibernateTemplate.findByNamedQueryAndNamedParam(
               "Address.findByAddressId", "addressId", addressId);
   Address address = (Address) addressList.get(0);
   return address;
 }
Ejemplo n.º 3
0
 public Integer getCityIdByName(String cityName) {
   // TODO Auto-generated method stub
   List cityId =
       (List<City>)
           hibernateTemplate.findByNamedQueryAndNamedParam(
               "City.findByCityName", "name", cityName);
   if (cityId != null) {
     return ((City) cityId.get(0)).getCityId();
   }
   return 0;
 }
Ejemplo n.º 4
0
  /** {@inheritDoc} */
  @SuppressWarnings("unchecked")
  public List<T> findByNamedQuery(String queryName, Map<String, Object> queryParams) {
    String[] params = new String[queryParams.size()];
    Object[] values = new Object[queryParams.size()];

    int index = 0;
    for (String s : queryParams.keySet()) {
      params[index] = s;
      values[index++] = queryParams.get(s);
    }

    return hibernateTemplate.findByNamedQueryAndNamedParam(queryName, params, values);
  }
Ejemplo n.º 5
0
 public String getStateName(int id) {
   String stateName = null;
   State state = null;
   List result =
       hibernateTemplate.findByNamedQueryAndNamedParam("State.findByStateId", "stateId", id);
   if (result != null && result.size() > 0) {
     state = (State) result.get(0);
   }
   if (state != null) {
     stateName = state.getStateName();
   }
   return stateName;
 }
Ejemplo n.º 6
0
 public String getCityName(int id) {
   String cityName = null;
   City city = null;
   List result =
       hibernateTemplate.findByNamedQueryAndNamedParam("City.findByCityId", "cityId", id);
   if (result != null && result.size() > 0) {
     city = (City) result.get(0);
   }
   if (city != null) {
     cityName = city.getCityName();
   }
   return cityName;
 }