Duvida select max com jpa
30/12/2009
0
Como seria isto?
Eu tentei assim mas nao funciona.Alguem poderia me dar uma luz?
view plaincopy to clipboardprint? //Encontrar ultimo código da Racas por CódEspecie public Integer getLastIdByIdEspecies(Integer idEspecies) { Object id = pesq("Select MAX(ra.idRacas) FROM RacasPK ra WHERE ra.idEspecies = " + idEspecies).getSingleResult(); int idtoReturn = 1; if (id != null) { idtoReturn = ((Integer) id) + 1; } else { } return idtoReturn; } } //Encontrar ultimo código da Racas por CódEspecie public Integer getLastIdByIdEspecies(Integer idEspecies) { Object id = pesq("Select MAX(ra.idRacas) FROM RacasPK ra WHERE ra.idEspecies = " + idEspecies).getSingleResult(); int idtoReturn = 1; if (id != null) { idtoReturn = ((Integer) id) + 1; } else { } return idtoReturn; } }
view plaincopy to clipboardprint?public class Especies implements Serializable { private static final long serialVersionUID = 1L; @Id @GeneratedValue(strategy = GenerationType.IDENTITY) @Basic(optional = false) @Column(name = "idEspecies") private Integer idEspecies; @Basic(optional = false) @Column(name = "Descricao") private String descricao; @OneToMany(cascade = CascadeType.ALL, mappedBy = "especies") private Collection<Racas> racasCollection; public Especies() { } public class Especies implements Serializable { private static final long serialVersionUID = 1L; @Id @GeneratedValue(strategy = GenerationType.IDENTITY) @Basic(optional = false) @Column(name = "idEspecies") private Integer idEspecies; @Basic(optional = false) @Column(name = "Descricao") private String descricao; @OneToMany(cascade = CascadeType.ALL, mappedBy = "especies") private Collection<Racas> racasCollection; public Especies() { }
view plaincopy to clipboardprint?public class Racas implements Serializable { private static final long serialVersionUID = 1L; @EmbeddedId protected RacasPK racasPK; @Basic(optional = false) @Column(name = "Descricao") private String descricao; @OneToMany(cascade = CascadeType.ALL, mappedBy = "racas") private Collection<Animais> animaisCollection; @JoinColumn(name = "idEspecies", referencedColumnName = "idEspecies", insertable = false, updatable = false) @ManyToOne(optional = false) private Especies especies; public Racas() { } public class Racas implements Serializable { private static final long serialVersionUID = 1L; @EmbeddedId protected RacasPK racasPK; @Basic(optional = false) @Column(name = "Descricao") private String descricao; @OneToMany(cascade = CascadeType.ALL, mappedBy = "racas") private Collection<Animais> animaisCollection; @JoinColumn(name = "idEspecies", referencedColumnName = "idEspecies", insertable = false, updatable = false) @ManyToOne(optional = false) private Especies especies; public Racas() { }
view plaincopy to clipboardprint?@Embeddable public class RacasPK implements Serializable { @Basic(optional = false) @Column(name = "idRacas") private int idRacas; @Basic(optional = false) @Column(name = "idEspecies") private int idEspecies; public RacasPK() { } public RacasPK(int idRacas, int idEspecies) { this.idRacas = idRacas; this.idEspecies = idEspecies; }
Andrei Hirata
Posts
24/01/2010
Guilherme Bahia
04/02/2010
Luciana Silveira
Clique aqui para fazer login e interagir na Comunidade :)