总结的DAO中常见的操作方法

//创建public Long createObject(Object obj) throws Exception(){return (Long)getHibernateTemplate().save(obj);}//查询一个对象public Object getObject(String name,String pk) throws Exception(){String queryStr = "from users as u where u.id = ? and u.name = ?";return (Object)getHibernateTemplate().find(queryStr,new String[]{pk,name}).get(0);}//修改一个对象public void updateObject(Object obj) throws Exception(){getHibernateTemplate().saveorupdate(obj);}//修改一个对象2public void updateObject2(Long pk,String newName) throws Exception(){Object obj = (Object)getHibernateTemplate().get(Object.class,pk)obj.setName(newName);getHibernateTemplate().saveorupdate(obj);}//查询一个对象的属性public String getObjectName(Long pk) throws Exception{Object obj = (Object)getHibernateTemplate().get(Object.class,pk);return obj.name;}//查询此属性的对象数量public Long countObject(String name) throws Exception{String queryStr = "select count(*) from users u where u.name = " + name;Query query = getHibernateTemplate().getSessionFactory.getCurrentSession().createQuery(queryStr);return Long.parseLong(query.uniqueResult().toString());}//查询所有对象public List<Object> hasObject(String name) throws Exception{String queryStr = "from users as u where u.name = ? order by u.pk desc";List<Object> objs = getHibernateTemplate().find(queryStr,name);return objs;}//查询所有对象方式2public List<Object> hasObject2(String name) throws Exception{String queryStr = "from users as u where u.name = ? order by u.pk desc";Query query = getHibernateTemplate().getSessionFactory.getCurrentSession.createQuery(queryStr);return query.list();}//查询所有对象__分页public List<Object> hasObject(String name,int pageindex,int pagesize) throws Exception{String queryStr = "from users as u where u.name = ? order by u.pk desc";Query query = getHibernateTemplate().getSessionFactory().getCurrentSession().createQuery(queryStr);query.setFirstResult((pageindex-1)*pagesize);query.setMaxResult(pagesize);return query.list();}//删除一个对象public void deleteObject(long pk){Object obj = getHibernateTemplate().get(Object.class,pk);if(null == obj) return;getHibernateTemplate().delete(obj);}//setParameter案例private void changeIsdelete(long msgid,int isdelete)throws Exception { String queryString = "update CtMmsMessage model set model.isdelete=?, model.updatetime=? where model.pk=?"; Query query = getHibernateTemplate().getSessionFactory().getCurrentSession().createQuery(queryString); query.setParameter(0, isdelete); query.setParameter(1, new Date()); query.setParameter(2, msgid); query.executeUpdate();}//addScalar案例public List<MmsDestSendResult> getMmsSendResultDetail(long msgid,int pageindex,int pagesize)throws Exception { String queryString = "select r.destphone destphone,m.crttime submittime,r.addtime sendtime,r.result result," + "(select min(w.name) from ct_mms_whitelist w where w.mobile=r.destphone and w.numspnumguid=m.spnid) destname from " + "(select t.msgid,t.destphone,t.addtime,1 result from ct_mms_a t where t.msgid=:msgid union all " + "select t.msgid,t.destphone,t.addtime,1 result from ct_mms_b t,ct_mms_statereport s where t.aimsgid=s.nmsgid(+) and s.nmsgid is null and t.msgid=:msgid union all " + "select t.msgid,t.destphone,t.addtime,0 result from ct_mms_b t,ct_mms_statereport s where t.aimsgid=s.nmsgid and s.sstat like 'DELIVRD%' and t.msgid=:msgid union all " + "select t.msgid,t.destphone,t.addtime,3 result from ct_mms_c t where t.msgid=:msgid union all " + "select t.msgid,t.destphone,t.addtime,3 result from ct_mms_b t,ct_mms_statereport s where t.aimsgid=s.nmsgid and s.sstat not like 'DELIVRD%' and s.sstat not like 'INVALID%' and t.msgid=:msgid union all " + "select t.msgid,t.destphone,t.addtime,2 result from ct_mms_b t,ct_mms_statereport s where t.aimsgid=s.nmsgid and s.sstat like 'INVALID%' and t.msgid=:msgid" + ") r,ct_mms_message m where r.msgid=m.pk order by r.result,r.destphone"; Query query = getHibernateTemplate().getSessionFactory().getCurrentSession().createSQLQuery(queryString) .addScalar("destphone") .addScalar("destname") .addScalar("submittime") .addScalar("sendtime") .addScalar("result",Hibernate.INTEGER); query.setParameter("msgid",msgid); query.setResultTransformer(Transformers.aliasToBean(MmsDestSendResult.class)); query.setFirstResult((pageindex-1)*pagesize); //pageindex is 1-based query.setMaxResults(pagesize); return query.list();}