Hibernate Queries

Reference :http://www.hibernate.org/hib_docs/reference/en/html/index.html
Reference for Xdoclet : http://www.warfrog.com/hibernatetutorial/
Examples to use Criteria
........................
for (Iterator iter = session.createCriteria(SpecialEditionCD.class).list().iterator(); iter.hasNext();) {
SpecialEditionCD secds = (SpecialEditionCD) iter.next();
System.out.println(secds.getTitle()+" : "+secds.getNewFetures());
}


for (Iterator iter = session.createCriteria(InternationalCD.class).add(Restrictions.ilike("languages", "Te%")).list().iterator(); iter.hasNext();) {
InternationalCD secds = (InternationalCD) iter.next();
System.out.println(secds.getTitle()+" : "+secds.getArtist());
}


Query query = session.createQuery("select c.purchaseDate,c.cost from CD c,SpecialEditionCD s where c.id= s.id and c.id = 1");
List li = query.list();