Пример #1
0
  public int create(Building building) {

    String insert =
        "INSERT INTO building("
            + "name, "
            + "organization_id, "
            + "email, "
            + "address_1, "
            + "address_2, "
            + "state, "
            + "zip, "
            + "phone, "
            + "total_units, "
            + "created_by, "
            + "created_date)"
            + "VALUES (:name, :organizationId, :email, :address1, :address2, :state, :zip, :phone, :totalUnits,:createdBy, now()) RETURNING id";

    MapSqlParameterSource params = new MapSqlParameterSource();
    params.addValue("name", building.getName());
    params.addValue("organizationId", building.getOrganizationId());
    params.addValue("email", building.getEmail());
    params.addValue("address1", building.getAddress1());
    params.addValue("address2", building.getAddress2());
    params.addValue("state", building.getState());
    params.addValue("zip", building.getZip());
    params.addValue("phone", building.getPhone());
    params.addValue("totalUnits", building.getTotalUnits());
    params.addValue("createdBy", building.getCreatedBy());

    int id = namedParameterJdbcTemplate.queryForObject(insert, params, Integer.class);
    return id;
  }
Пример #2
0
  public void update(Building building) {

    String query =
        "UPDATE building SET "
            + "name =:name, "
            + "organization_id = :organizationId, "
            + "email =:email, "
            + "address_1= :address1, "
            + "address_2 = :address2, "
            + "state=:state, "
            + "zip=:zip, "
            + "phone=:phone, "
            + "total_units=:totalUnits,"
            + "last_modified_by =:modifiedBy, "
            + "last_modified_date=now() "
            + "WHERE id=:id";

    MapSqlParameterSource params = new MapSqlParameterSource();
    params.addValue("name", building.getName());
    params.addValue("organizationId", building.getOrganizationId());
    params.addValue("email", building.getEmail());
    params.addValue("address1", building.getAddress1());
    params.addValue("address2", building.getAddress2());
    params.addValue("state", building.getState());
    params.addValue("zip", building.getZip());
    params.addValue("phone", building.getPhone());
    params.addValue("totalUnits", building.getTotalUnits());
    params.addValue("modifiedBy", building.getLastModifiedBy());
    params.addValue("id", building.getId());

    namedParameterJdbcTemplate.update(query, params);
  }