membuat native query pada hibernate dan return list object

Native Query pada Hibernate dan nge-return list object, ::

q> Teknologi yang dipake masih tetep zk + hibernate + spring
q> Class yang digunakan adalah org.hibernate.SQLQuery
q> Langsung ke coding bro
[sourcecode language="java"]
@SuppressWarnings("unchecked")
@Override
@Transactional(readOnly=true)
public List<Mstmenu> getListMenuByUser(String user){
String st = "select mm.* from MSTROLEACCESS mra " +
" join MSTMENU mm on mm.VMENUID = mra.VMENUID " +
"join MSTROLE mr on mr.VROLEID = mr.VROLEID " +
" where mr.USER = :user and mra.VSTATUS = 'A' " +
"order by mm.vparent,mm.norderer asc";

SQLQuery sq = getHibernateTemplate().getSessionFactory().getCurrentSession()
.createSQLQuery(st);
sq.setString("user", user);
sq.addEntity(Mstmenu.class);

List<Mstmenu> list = sq.list();
return list;
}
[/sourcecode]



q> Tinggal panggil method getListMenuByUser(String user), dengan parameter user dan akan nge-return List<Mstmenu>

q> Wow

Selamat ber-hibernate

sumber ::
http://www.tutorialspoint.com/hibernate/hibernate_native_sql.htm