view flys-backend/src/main/java/de/intevation/flys/model/RiverAxisKm.java @ 4573:b87073a05f9d

flys-client: Patch to render combobox options as clickable links. The way of passing data arguments to the links and further to the Artifact feeding service is somewhat hacked and should be refactored (later...).
author Christian Lins <christian.lins@intevation.de>
date Tue, 27 Nov 2012 12:50:10 +0100
parents 9df06b88c079
children
line wrap: on
line source
package de.intevation.flys.model;

import java.io.Serializable;
import java.math.BigDecimal;
import java.util.List;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.OneToOne;
import javax.persistence.Table;

import org.hibernate.Session;
import org.hibernate.Query;
import org.hibernate.annotations.Type;

import com.vividsolutions.jts.geom.Point;

import de.intevation.flys.backend.SessionHolder;


@Entity
@Table(name = "river_axes_km")
public class RiverAxisKm
implements   Serializable
{
    private Integer    id;
    private River      river;
    private BigDecimal km;
    private Point      geom;


    public RiverAxisKm() {
    }


    @Id
    @Column(name = "id")
    public Integer getId() {
        return id;
    }


    public void setId(Integer id) {
        this.id = id;
    }


    @OneToOne
    @JoinColumn(name = "river_id")
    public River getRiver() {
        return river;
    }


    public void setRiver(River river) {
        this.river = river;
    }


    @Column(name = "km")
    public BigDecimal getKm() {
        return km;
    }


    public void setKm(BigDecimal km) {
        this.km = km;
    }


    @Column(name = "geom")
    @Type(type = "org.hibernatespatial.GeometryUserType")
    public Point getGeom() {
        return geom;
    }


    public void setGeom(Point geom) {
        this.geom = geom;
    }


    /**
     * Returns a list of RiverAxisKm objects for a given river.
     *
     * @param riverid The ID of a river in the database.
     *
     * @return a list of RiverAxisKm objects.
     */
    public static List<RiverAxisKm> getRiverAxisKms(int riverid) {
        Session session = SessionHolder.HOLDER.get();

        Query query = session.createQuery(
            "from RiverAxisKm where river.id =:riverid");
        query.setParameter("riverid", riverid);

        List<RiverAxisKm> list = query.list();

        return list;
    }
}
// vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 :

http://dive4elements.wald.intevation.org