Mercurial > dive4elements > river
view backend/src/main/java/org/dive4elements/river/model/sinfo/CollisionType.java @ 8974:a275ddf7a3a1
Added some trim and lowercase in the where clauses of the selects of existing recordsets; added AnnotationType select
author | mschaefer |
---|---|
date | Tue, 03 Apr 2018 10:37:30 +0200 |
parents | 50416a0df385 |
children | 3dfcb6e1c4d6 |
line wrap: on
line source
/* Copyright (C) 2017 by Bundesanstalt für Gewässerkunde * Software engineering by * Björnsen Beratende Ingenieure GmbH * Dr. Schumacher Ingenieurbüro für Wasser und Umwelt * * This file is Free Software under the GNU AGPL (>=v3) * and comes with ABSOLUTELY NO WARRANTY! Check out the * documentation coming with Dive4Elements River for details. */ package org.dive4elements.river.model.sinfo; import java.io.Serializable; import java.util.ArrayList; 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.SequenceGenerator; import javax.persistence.Table; import org.dive4elements.river.backend.SessionHolder; import org.hibernate.Query; import org.hibernate.Session; @Entity @Table(name = "collision_type") public class CollisionType implements Serializable { /***** FIELDS *****/ private static final long serialVersionUID = -865783384903507910L; private Integer id; private String name; /***** CONSTRUCTORS *****/ public CollisionType() { } public CollisionType(final String name) { this.name = name; } /***** METHODS *****/ @Id @SequenceGenerator(name = "SEQUENCE_COLLISION_TYPE_ID_SEQ", sequenceName = "COLLISION_TYPE_ID_SEQ", allocationSize = 1) @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "SEQUENCE_COLLISION_TYPE_ID_SEQ") @Column(name = "id") public Integer getId() { return this.id; } public void setId(final Integer id) { this.id = id; } @Column(name = "name") public String getName() { return this.name; } public void setName(final String name) { this.name = name; } /** * Queries all collision types from the database, orders by name */ public static List<CollisionType> getTypes() { final Session session = SessionHolder.HOLDER.get(); final Query query = session.createQuery("FROM CollisionType ORDER BY name"); return new ArrayList<>(query.list()); } }