Hibernate.gethibernatetemplate 实现增、删、改、查 方法

1. 1. find(String hql);  //普通查询

      示例：this.gethibernateTemplate().find("from User");

    

   2. find(String hql,Object value);//一个查询条件

      示例：this.gethibernateTemplate().find("from User u where u.name=?","test");

    

   3. find(String hql,Object[] values);// 多个查询条件

      示例：this.gethibernateTemplate().find("from User u where u.name=? and u.pwd=?",new String[]{"test","123"});

    

   4. findByExample(Object exampleEntity,int firstResult, int maxResults)//分页使用

      示例：

      User user= new User(); u.setActive("Active");

      List list=this.getHibernateTemplate().findByExample(user,firstResult,maxResults);  

      查询结果：状态为Active的用户（对象从0到20 计数）  

    

   5. findByNamedParam(String hql,String paramName,Object value); //一个查询条件

      示例：

      hql="from User u where u.name=:parName ";

      paramName= "parName";

      value="bb"

      List list = this.getHibernateTemplate.findByNamedParam(hql,paramName,value);

      查询结果：姓名为bb的用户

    

   6. findByNamedParam(String queryString , String[] paramName , Object[] value) //多个查询条件

      示例：

      hql="from User u where u.name=:myname and u.pwd =:mypwd ";

      String[] paramName= new String[]{"myname","mypwd"};

      Sring[] value=new Strign[]{"bb","123"};

      List list = this.getHibernateTemplate.findByNamedParam(hql,paramName,value);

      查询结果：姓名为bb密码为123的用户

    

   7.分页HQL示例

      public List excuteHqlPage(final String hqlStr, final int startRow,final int rowCount) throws DaoException {

      List<Object[]> list;

      try {

          list = getHibernateTemplate().executeFind(new HibernateCallback() {

          public Object doInHibernate(Session session)

          throws HibernateException, SQLException {

          org.hibernate.Query query = (org.hibernate.Query) session.createQuery(hqlStr);

          query.setFirstResult(startRow);// 定义从第几条开始查询

          query.setMaxResults(rowCount);// 定义返回的记录数

          List list = query.list();

          return list;

        }

       });

      } catch (Exception e) {

      throw new DaoException(DaoException.ERRORCODE_EXCUTEHQL);

      }

   return list;

   }

    

   8. 根据HQL/SQL 查询

      public List queryByHql(final String hql, final Object[] prams,final String sql) {

        return (List)  getHibernateTemplate().execute(new HibernateCallback(){

          public Object doInHibernate(Session session)

            throws HibernateException, SQLException {

               if(hql!=null && hql.length()>0){

              Query query=session.createQuery(hql);

              if(prams!=null && prams.length>0){

              for(int i=0;i<prams.length;i++){

              query.setParameter(i,prams[i]);

            }

         }

        return query.list();

      }else{

      SQLQuery sqlquery=session.createSQLQuery(sql);

      return sqlquery.list();

    }

   }

   });

   }

    

   9. 保存/更新

      public String saveOrUpdateObject(ISuperVO vo) throws DaoException {

        try {

            String id = null;

            if (StringUtil.isEmpty(vo.getPid())) {

               getHibernateTemplate().save(vo);

           } else {

              getHibernateTemplate().merge(vo);

          }

           id = vo.getPid();

           return id;

        } catch (Exception e) {

             e.printStackTrace();

   }

   }

    

   10. getHibernateTemplate().delete(vo);  //删除

    

   11. 根据条件删除

      public Integer deleteObjectsByWherePart(final Class voClass,final String wherePart, final Object[] parmaters)throws DaoException {

      try {

          Integer count = (Integer) getHibernateTemplate().execute( new HibernateCallback() {

         public Object doInHibernate(Session session)throws HibernateException, SQLException {

         Integer coun = null;

         String hql = "delete from " + voClass.getName()+ " where 1=1 ";

         if (wherePart != null && wherePart.trim().length() > 0) {

             hql = hql + " and " + wherePart;

         }

         Query query = session.createQuery(hql);

         Object obj = null;

         if (parmaters != null && parmaters.length > 0) {

             for (int i = 0; i < parmaters.length; i++) {

                obj = parmaters[i];

               query.setParameter(i, obj);

            }

          }

         coun = query.executeUpdate();

         return coun;

        }

       });

       return count;

      } catch (Exception e) {

      e.printStackTrace();

   }

   }