SSH（CURD）

ssh的基础部分
控制层调用业务层，这里控制层就不写了
业务接口实现类如下：

   //模糊查询数据并分页
	@Override
	public PageVo findzb(ZBzk pc, PageVo page, User currentUser) {
		StringBuffer hql = new StringBuffer();
		List<Object> params = new ArrayList<Object>();
		hql.append(" from ZBzk t  ");
		hql.append(" where t.deleted = false ");
		//hql.append(" and t.bzfl = ''");
		 if (StringUtils.isNotBlank(pc.getBname())) {
	            hql.append(" and bname like ? ");
	            params.add("%" + StringUtils.trim(pc.getBname()) + "%");
	        }
	        if (StringUtils.isNotBlank(pc.getBversion())) {
	            hql.append(" and bversion like ? ");
	            params.add("%" + StringUtils.trim(pc.getBversion()) + "%");
	        }
	        if (StringUtils.isNotBlank(pc.getBstatus())){
	            hql.append(" and bstatus like ? ");
	            params.add("%" + StringUtils.trim(pc.getBstatus()) + "%");
	        }
	        if (StringUtils.isNotBlank(pc.getBzfl())) {
	            hql.append(" and bzfl like ? ");
	            params.add("%" + StringUtils.trim(pc.getBzfl()) + "%");
	        }
	        if (StringUtils.isNotBlank(pc.getBcen())) {
	            hql.append(" and bcen like ? ");
	            params.add("%" + StringUtils.trim(pc.getBcen()) + "%");
	        }
	        if (StringUtils.isNotEmpty(pc.getBretime())) {
	            hql.append(" and bretime = ? ");
	            params.add(pc.getBretime());
	           
	        }
	        if (StringUtils.isNotBlank(pc.getBtext())) {
	            hql.append(" and btext like ? ");
	            params.add("%" + StringUtils.trim(pc.getBtext()) + "%");
	        }else {
			hql.append(" order by t.id asc ");
		}
	      return this.findByPage(hql.toString(), page, params.toArray());
	}
	//根据id查询对象
	@Override
	public ZBzk get(Long id) {
		// TODO Auto-generated method stub
		return this.get(ZBzk.class,id);
	}
	//根据条件查询（这里根据前台二级目录的不同进行筛选）
	@Override
	public PageVo findgj(ZBzk pc, PageVo page, User currentUser) {
		StringBuffer hql = new StringBuffer();
		List<Object> params = new ArrayList<Object>();
		hql.append(" from ZBzk t  ");
		hql.append(" where t.deleted = false ");
		hql.append(" and t.bzfl = '国家标准'");
		if (StringUtils.isNotBlank(page.getSort()) && StringUtils.isNotBlank(page.getDir())) {
			hql.append(" order by t.");
			hql.append(page.getSort());
			hql.append(" ");
			hql.append(page.getDir());
		} else {
			hql.append(" order by t.id ");
		}
		return this.findByPage(hql.toString(), page, params.toArray());
	}
	//同上
	@Override
	public PageVo findhy(ZBzk pc, PageVo page, User currentUser) {
		StringBuffer hql = new StringBuffer();
		List<Object> params = new ArrayList<Object>();
		hql.append(" from ZBzk t  ");
		hql.append(" where t.deleted = false ");
		hql.append(" and t.bzfl = '行业标准'");
		if (StringUtils.isNotBlank(page.getSort()) && StringUtils.isNotBlank(page.getDir())) {
			hql.append(" order by t.");
			hql.append(page.getSort());
			hql.append(" ");
			hql.append(page.getDir());
		} else {
			hql.append(" order by t.id ");
		}
		return this.findByPage(hql.toString(), page, params.toArray());
	}
	//地方
	@Override
	public PageVo finddf(ZBzk pc, PageVo page, User currentUser) {
		StringBuffer hql = new StringBuffer();
		List<Object> params = new ArrayList<Object>();
		hql.append(" from ZBzk t  ");
		hql.append(" where t.deleted = false ");
		hql.append(" and t.bzfl = '地方标准'");
		if (StringUtils.isNotBlank(page.getSort()) && StringUtils.isNotBlank(page.getDir())) {
			hql.append(" order by t.");
			hql.append(page.getSort());
			hql.append(" ");
			hql.append(page.getDir());
		} else {
			hql.append(" order by t.id ");
		}
		return this.findByPage(hql.toString(), page, params.toArray());
	}
	//批量删除
	@Override
	public void deletZbzkByIds(String ids) {
		// TODO Auto-generated method stub
		Assert.isTrue(StringUtils.isNotBlank(ids));
		String tIds[] = StringUtils.split(ids, ",");
		for (int i = 0; i < tIds.length; i++) {
			if (StringUtils.isBlank(tIds[i])) {
				continue;
			}
			deletZById(Long.valueOf(StringUtils.trim(tIds[i])));
		}
		
	}
	//单条删除（直接删或者修改字段使其隐藏，根据自己业务需求）
	private void deletZById(Long id) {
		// TODO Auto-generated method stub
		//StringBuffer sql = new StringBuffer("delete from Z_BZK where id = " + id);
		StringBuffer sql = new StringBuffer("update Z_BZK z set z.is_deleted=1 where id = " + id);
        this.executeSQLUpdate(sql.toString());
	}

	//新增和修改调用的保存
	@Override
	public ZBzk save(ZBzk entity) {
		// TODO Auto-generated method stub
		this.merge(entity);
		return entity; 
	}

	

END