Hibernate的原生SQL查询

 折腾了我半天终于搞定了
参考了这个文章：http://doc.javanb.com/hibernate-reference-3-2-0-zh/ch16.html
final static String querySql = "select {enterprise.*}, {dict.*} ,{balancd.*}, {weightinfo.*}  "
   + "from weight_info weightinfo left outer join t_dict dict on {weightinfo}.productcode={dict}.code join "
   + "t_balancecode {balancd} on {weightinfo}.balancecode={balancd}.balancecode join t_enterprise enterprise "
   + "on {enterprise}.id={balancd}.enterpriseid where "
   + " {weightinfo}.operdate>TO_TIMESTAMP('2009-11-2 04:12:32.0', 'yyyy-mm-dd hh24:mi:ssxff')";
public List loadByQuerySql(final String querySql, final Map params) {
  try {
   return (List) getHibernateTemplate().execute(
     new HibernateCallback() {
      public Object doInHibernate(Session session)
        throws HibernateException, SQLException {
//       Connection c= session.connection();
       Query query = session.createSQLQuery(querySql)
         .addEntity("weightinfo",WeightInfo.class)
         .addEntity("dict",Dict.class)
         .addEntity("balancd",BalanceCode.class)
         .addEntity("enterprise",Enterprise.class);
       // fillParams(query,params);
       return query.list();
      }
     });
  } catch (HibernateException e) {
   e.printStackTrace();
  }
  return new ArrayList();
 }
如果不是全部参与的table都返回值，那么
public Object doInHibern