Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Query two tables using hibernate

 
Romeo Ranjan
Ranch Hand
Posts: 95
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have SQL query


It extracts name,start_date and end_date from the pay table where name at the pay table and emp table are the same and the id=16940 and in the emp table the status must be employed.
How do I implement this SQL query using hibernate? My application uses hibernate, till now it was straightforward I have payDAO.java and empDAO.java that queries the pay table and emp table seperately. But I want to implement the above query in which the result is based on both the tables..How I am supposed to implement it..Can someone please throw some light on the problem or give some example?


Thanks.
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You can use a Criteria search or HQL. See here for examples.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic