how to execute sql query in hibernate

i have to select the record from table users_roles and i am using hibernate. but i don't want to to make the separate class in java for that , so

i am thinking of using plain sql . can i do it or i have to make the java class for that . because i i just to extract the role like

select ro开发者_如何转开发le from user_roles where email = abc@cdf.com

any eaxmple of that would be fine

---

Within Hibernate, you have to use the SQL-like langauge HQL (Hibernate Query Language). This would look something like:

From user_roles where email = abc@cdf.com

And retrieve the whole mapped entity class for you.

edit: an alternative would be this: Using native queries in Hibernate

---

You can either use native queries as posted by user538603 or create an entity for that table; the second way would probably be better in the mid/long term, because you would fully exploit Hibernate (criteria and everything...). I would suggest native queries only if you mostly need to write queries you can't do in HQL (like certain types of unions, specific database functions and some more use cases), but in that case I would suggest you to use www.mybatis.org, which is more suited for massive use of native sql queries.