Mercurial > dive4elements > river
view flys-backend/src/main/java/de/intevation/flys/model/BedHeightType.java @ 5273:db196abd16ca
Use lookup table from bedd_height from database in importer.
author | Sascha L. Teichmann <teichmann@intevation.de> |
---|---|
date | Wed, 13 Mar 2013 16:39:08 +0100 |
parents | 3de4ac5ccee8 |
children | 3ddf5843ede3 |
line wrap: on
line source
package de.intevation.flys.model; import java.io.Serializable; import java.util.List; import javax.persistence.Entity; import javax.persistence.Id; import javax.persistence.Table; import javax.persistence.GeneratedValue; import javax.persistence.Column; import javax.persistence.SequenceGenerator; import javax.persistence.GenerationType; import org.apache.log4j.Logger; import org.hibernate.Query; import org.hibernate.Session; import de.intevation.flys.backend.SessionHolder; @Entity @Table(name = "bed_height_type") public class BedHeightType implements Serializable { private static Logger log = Logger.getLogger(BedHeightType.class); private Integer id; private String name; public BedHeightType() { } public BedHeightType(String name) { this.name = name; } @Id @SequenceGenerator( name = "SEQUENCE_BED_HEIGHT_TYPE_ID_SEQ", sequenceName = "BED_HEIGHT_TYPE_SEQ", allocationSize = 1) @GeneratedValue( strategy = GenerationType.SEQUENCE, generator = "SEQUENCE_BED_HEIGHT_TYPE_ID_SEQ") @Column(name = "id") public Integer getId() { return id; } public void setId(Integer id) { this.id = id; } @Column(name = "name") public String getName() { return name; } public void setName(String name) { this.name = name; } public static BedHeightType fetchBedHeightTypeForType(String type) { Session session = SessionHolder.HOLDER.get(); Query query = session.createQuery( "from BedHeightType where type=:type"); query.setParameter("type", type); List<Object> results = query.list(); return results.isEmpty() ? null : (BedHeightType)results.get(0); } } // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 :