您当前的位置: 首页 >  童心同萌 ar

addScalar

童心同萌 发布时间:2018-02-09 13:41:15 ,浏览量:4

	/**
	 * 根据输入内容匹配查询function
	 */
	@SuppressWarnings({ "deprecation", "unchecked", "rawtypes" })
	public List getFunctionDataAll(Page page,String searchAll) {
		int firstIndex = page.getFirst() - 1;
		StringBuffer sql=new StringBuffer("select function_code as functionCode,sum(weight) as weight,sum(cost) as cost from libraryfunction ");
		sql.append(" or function_code like '%"+searchAll+"%'")
			.append(" group by function_code order by function_code desc")
			.append(" limit "+firstIndex+","+page.getPageSize());
		List functionList = createSQLQuery(sql.toString().replaceFirst("or","where"))
			.addScalar("functionCode", Hibernate.STRING)
			.addScalar("weight",Hibernate.DOUBLE)
			.addScalar("cost",Hibernate.DOUBLE)
			.setResultTransformer(Transformers.aliasToBean(Function.class)).list();
		return functionList;
	}

 

 

 

关注
打赏
1688896170
查看更多评论

童心同萌

暂无认证

  • 4浏览

    0关注

    87博文

    0收益

  • 0浏览

    0点赞

    0打赏

    0留言

私信
关注
热门博文
立即登录/注册

微信扫码登录

0.0496s