今天用到几个Hibernate的命令(备查)

1)import  Session org.hibernate.SessionFactory.getCurrentSession() 

import Connection org.hibernate.Session.connection() throws HibernateException


conn=fileItemDao.getSessionFactory().getCurrentSession().connection();
 stm = conn.createStatement();
  rs=stm.executeQuery("select max(product_id) maxid from product");
  if(rs.next())

  {
    maxProductId=rs.getInt("maxid"); }

  closeStmRs();
  conn.close();

2)String productItemHql="select distinct item from ImportProductFileItem item  left join fetch item.resources ";
List<ImportProductFileItem>items=fileItemDao.getSession().createQuery(productItemHql).list(); ;

3)String generateProductSql="select count(*) itemNum from product where product_id>"+new Integer(this.maxPId).toString();
  int pdNum=(Integer) pd.getSession().createSQLQuery(generateProductSql).addScalar("itemNum",Hibernate.INTEGER).uniqueResult();