Mercurial > dive4elements > river
view flys-backend/src/main/java/de/intevation/flys/model/HWSLine.java @ 5346:615e25b6440e
Fix HWSKind column name for the name of the kind
author | Andre Heinecke <aheinecke@intevation.de> |
---|---|
date | Wed, 20 Mar 2013 16:32:07 +0100 |
parents | 0a83a796f7cf |
children |
line wrap: on
line source
package de.intevation.flys.model; import com.vividsolutions.jts.geom.Geometry; import de.intevation.flys.model.HWSKind; import java.io.Serializable; import java.util.List; import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.GeneratedValue; import javax.persistence.GenerationType; import javax.persistence.Id; import javax.persistence.JoinColumn; import javax.persistence.OneToOne; import javax.persistence.Table; import javax.persistence.SequenceGenerator; import org.hibernate.Session; import org.hibernate.Query; import org.hibernate.annotations.Type; import de.intevation.flys.backend.SessionHolder; @Entity @Table(name = "hws_lines") public class HWSLine implements Serializable { private Integer id; private Integer ogrFid; private HWSKind kind; private FedState fedState; private River river; private Integer official; private Integer shoreSide; private String name; private String path; private String agency; private String range; private String source; private String status_date; private String description; private Geometry geom; @Id @SequenceGenerator( name = "SEQUENCE_HWS_LINES_ID_SEQ", sequenceName = "HWS_LINES_ID_SEQ", allocationSize = 1) @GeneratedValue( strategy = GenerationType.SEQUENCE, generator = "SEQUENCE_HWS_LINES_ID_SEQ") @Column(name = "id") public Integer getId() { return id; } public void setId(Integer id) { this.id = id; } @Column(name = "geom") @Type(type = "org.hibernatespatial.GeometryUserType") public Geometry getGeom() { return geom; } public void setGeom(Geometry geom) { this.geom = geom; } /** * Get ogrFid. * * @return ogrFid as Integer. */ @Column(name = "ogr_fid") public Integer getOgrFid() { return ogrFid; } /** * Set ogrFid. * * @param ogrFid the value to set. */ public void setOgrFid(Integer ogrFid) { this.ogrFid = ogrFid; } /** * Get official. * * @return official as Integer. */ @Column(name = "official") public Integer getofficial() { return official; } /** * Set official. * * @param official the value to set. */ public void setofficial(Integer official) { this.official = official; } /** * Get shoreSide. * * @return shoreSide as Integer. */ @Column(name = "shore_side") public Integer getShoreSide() { return shoreSide; } /** * Set shoreSide. * * @param shoreSide the value to set. */ public void setShoreSide(Integer shoreSide) { this.shoreSide = shoreSide; } /** * Get name. * * @return name as String. */ @Column(name = "name") public String getName() { return name; } /** * Set name. * * @param name the value to set. */ public void setName(String name) { this.name = name; } /** * Get path. * * @return path as String. */ @Column(name = "path") public String getPath() { return path; } /** * Set path. * * @param path the value to set. */ public void setPath(String path) { this.path = path; } /** * Get agency. * * @return agency as String. */ @Column(name = "agency") public String getAgency() { return agency; } /** * Set agency. * * @param agency the value to set. */ public void setAgency(String agency) { this.agency = agency; } /** * Get range. * * @return range as String. */ @Column(name = "range") public String getRange() { return range; } /** * Set range. * * @param range the value to set. */ public void setRange(String range) { this.range = range; } /** * Get source. * * @return source as String. */ @Column(name = "source") public String getSource() { return source; } /** * Set source. * * @param source the value to set. */ public void setSource(String source) { this.source = source; } /** * Get status_date. * * @return status_date as String. */ @Column(name = "status_date") public String getStatusDate() { return status_date; } /** * Set status_date. * * @param status_date the value to set. */ public void setStatusDate(String status_date) { this.status_date = status_date; } /** * Get description. * * @return description as String. */ @Column(name = "description") public String getDescription() { return description; } /** * Set description. * * @param description the value to set. */ public void setDescription(String description) { this.description = description; } /** * Get kind. * * @return kind as HWSKind. */ @OneToOne @JoinColumn(name = "kind_id") public HWSKind getKind() { return kind; } /** * Set kind. * * @param kind the value to set. */ public void setKind(HWSKind kind) { this.kind = kind; } /** * Get fedState. * * @return fedState as FedState. */ @OneToOne @JoinColumn(name = "fed_state_id") public FedState getFedState() { return fedState; } /** * Set fedState. * * @param fedState the value to set. */ public void setFedState(FedState fedState) { this.fedState = fedState; } /** * Get river. * * @return river as River. */ @OneToOne @JoinColumn(name = "river_id") public River getRiver() { return river; } /** * Set river. * * @param river the value to set. */ public void setRiver(River river) { this.river = river; } public static List<HWSLine> getLines(int riverId, String name) { Session session = SessionHolder.HOLDER.get(); Query query = session.createQuery( "from HWSLine where river.id =:river_id and name=:name"); query.setParameter("river_id", riverId); query.setParameter("name", name); return query.list(); } }