Package org.xulfaces.rubis.model

Examples of org.xulfaces.rubis.model.Region


          User user = new User();
          user.setId(new Integer(resultSet.getInt("ID")));
          user.setFirstname(resultSet.getString("FIRSTNAME"));
          user.setLastname(resultSet.getString("LASTNAME"));
          user.setNickname(resultSet.getString("NICKNAME"));
          Region region = new Region();
          region.setId(new Integer(resultSet.getInt("REGION_ID")));
          user.setRegion(region);
          users.add(user);
          i++;
        }
        while((resultSet.next()) && (i < rows));                                                               
View Full Code Here


    sqlBuffer.append("SELECT * FROM regions");
    ResultSet resultSet = null;
    try {
      resultSet = excecuteScrollableQuery(sqlBuffer.toString());
      while (resultSet.next()) {
        Region region = new Region();
        region.setId(new Integer(resultSet.getInt("ID")));
        region.setName(resultSet.getString("NAME"));
        regions.add(region);
      }
    } catch (SQLException e) {
      throw new RuntimeException(e);
    }
View Full Code Here

    return regions;
  }

  public Region loadRegion(Integer id) throws RegionNotFoundException {
   
    Region region = null;
    StringBuffer sqlBuffer = new StringBuffer();
    sqlBuffer.append("SELECT * FROM regions WHERE ID=");
    sqlBuffer.append(id);
    ResultSet resultSet = null;
    try {
      resultSet = excecuteQuery(sqlBuffer.toString());
      if(resultSet.next()) {
        region = new Region();
        region.setId(new Integer(resultSet.getInt("ID")));
        region.setName(resultSet.getString("NAME"));       
      }
    } catch (SQLException e) {
      throw new RegionNotFoundException("Region " + id + " not found",e);
    }
    finally {
View Full Code Here

    return null;
  }

  public String getAsString(FacesContext context, UIComponent component, Object value) {
    if(value instanceof Region){
      Region region = (Region) value;
      return region.getId().toString();
    }
    return null;
  }
View Full Code Here

TOP

Related Classes of org.xulfaces.rubis.model.Region

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.