Total members 11854 |It is currently Fri Jul 30, 2021 3:10 pm Login / Join Codemiles

Java

C/C++

PHP

C#

HTML

CSS

ASP

Javascript

JQuery

AJAX

XSD

Python

Matlab

R Scripts

Weka





This example show you how to create a named query within entity class using following annotations :
    @NamedQueries
    @NamedQuery


Entity class :
Code:

package com
.codemiles.jpa;
import java.util.Collection;
import java.util.Date;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.Table;
import javax.persistence.OneToMany;


@
Entity
@NamedQueries({
    @
NamedQuery(name="FinlAllTopics",
                
query="SELECT e FROM Topic e")})
@
Table(name="TOPIC")
public class 
Topic implements java.io.Serializable{
    
/**
     * 
     */
    
private static final long serialVersionUID 1L;
    @
Id
    
private int Id;
    private 
String title;
    private 
Date creationDate;
    private 
Date modifedDate;
    private 
String content;
    @
OneToMany(mappedBy="topic")
    private 
Collection<Commentcomments;

    public 
int getId() {
        return 
Id;
    }
    public 
void setId(int id) {
        
Id id;
    }
    
    @
Column(name="TITLE")
    public 
String getTitle() {
        return 
title;
    }
    public 
void setTitle(String title) {
        
this.title title;
    }
    
    @
Column(name="CREATION_DATE")
    public 
Date getCreationDate() {
        return 
creationDate;
    }
    public 
void setCreationDate(Date creationDate) {
        
this.creationDate creationDate;
    }
    
    @
Column(name="MODIFED_DATE")
    public 
Date getModifedDate() {
        return 
modifedDate;
    }
    public 
void setModifedDate(Date modifedDate) {
        
this.modifedDate modifedDate;
    }
    
    @
Column(name="CONTENT")
    public 
String getContent() {
        return 
content;
    }
    public 
void setContent(String content) {
        
this.content content;
    }
    public 
void setComments(Collection<Commentcomments) {
    
this.comments comments;
    }
    public 
Collection<CommentgetComments() {
    return 
comments;
    }
}
 




_________________
M. S. Rakha, Ph.D.
Queen's University
Canada


Author:
Mastermind
User avatar Posts: 2715
Have thanks: 74 time
Post new topic Reply to topic  [ 1 post ] 

  Related Posts  to : create a named query within entity class
 create named query     -  
 Named Native Query     -  
 JPA entity class example     -  
 @EntityListeners in your entity class     -  
 Create auto numbered column in mysql query     -  
 Create object instance from class Name by reflection     -  
 How are Java source code files named     -  
 Get all objects for an entity     -  
 Find entity by id     -  
 cmp entity beans     -  



Topic Tags

Java JPA






Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
All copyrights reserved to codemiles.com 2007-2011
mileX v1.0 designed by codemiles team
Codemiles.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com