/** * Query operation using SQL statement * @param SQL * @return * /public List querywithsql (final String sql) { list List = Hibernatetemplate.executefind (new Hibernatecallback () {public Object Doinhibernate (Session session) throws Hibernateexception, SQLException { query query = session.createsqlquery (SQL); List List = Query.list (); return list; } }); return list; }
Call the above querywithsql to return the results of the query.
But
List<student> list=querywithsql ("select * from Stuendt where age>15");
If you directly
List.get (0). GetName ();
Will report Ljava.lang.Object cannot be converted to student exception.
Follow the example below:
List models=utildao.querywithsql (SQL); for (int i = 0; i < models.size (); i++) { object[] obj = (object[]) models.ge T (i); System.out.println (Obj[0]); System.out.println (obj[1]); System.out.println (obj[2]);}
There's the result you want.
Resources
http://blog.csdn.net/woshisap/article/details/6743404
http://blog.csdn.net/goodleiwei/article/details/7059567
hibernatetemplate querying native SQL and Ljava.lang.object cannot is cast to