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