springmvc+hibernate 基础查询

来源:互联网 发布:mysql 查询最小的数据 编辑:程序博客网 时间:2024/06/13 04:48
@Repositorypublic class ContactPepoleDao extends HibernateBaseDaoImpl<EtlContactPepole, Integer> {//返回分页对象,正则条件查询public Pagination<Object> getAllContactPepole(Integer start,Integer limit,String name){String nameStr = name==null?"":" where name like '%"+name+"%'";String rowSql = "from EtlContactPepole"+nameStr;String countSql = "select count(contactId) "+rowSql;return this.findPageByHQL(rowSql, countSql, start, limit);}        //条件查询public EtlContactPepole findContactPepole(Integer contactId){String hql = "from EtlContactPepole where contactId="+contactId;return (EtlContactPepole)this.findByHQL(hql).get(0);}}

0 0