多表同构造的Native sql查询

    /**     * 单店统计查询     * @param tableName		查询表名     * @param sellInfo		查询例子     * @param startTime		开始时间     * @param finishTime	结束时间     * @param sumBy 		按什么求和     * @param groupBy		按什么分组     * @return 数量 项目     */    public List queOneShopGrp(String tableName,SellInfo sellInfo,Date startTime,Date finishTime,String sumBy,String groupBy)    {    	Session session = this.getSession();    	StringBuffer sql = new StringBuffer();    	sql.append("select sum(S.");    	sql.append(sumBy);    	sql.append(") as sumMoney,S.");    	sql.append(groupBy);    	sql.append(" as foodName from ");    	sql.append(tableName);    	sql.append(" S where");    	if(sellInfo!=null)    	{    		sql.append(this.getExampleStringS(sellInfo));    	}    	sql.append(" S.sellTime between :startTime and :finishTime ");    	sql.append("group by S.");    	sql.append(groupBy);    	System.out.println(sql.toString());    	Query query = session.createSQLQuery(sql.toString())    		.addScalar("sumMoney", Hibernate.DOUBLE)    		.addScalar("foodName", Hibernate.STRING)			.setDate("startTime", startTime)			.setDate("finishTime", finishTime);    	return query.list();    }

    /**     * 生成根据例子类的where子句     * @param sellInfo     * @return     */    public String getExampleStringS(SellInfo sellInfo)    {    	StringBuffer sql = new StringBuffer();    	    	if(sellInfo.getUserName()!=null)    	{    		sql.append(" S.userName = '");    		sql.append(sellInfo.getUserName());    		sql.append("' and");    	}    	    	if(sellInfo.getFoodId()!=null)    	{    		sql.append(" S.foodId = '");    		sql.append(sellInfo.getFoodId());    		sql.append("' and");    	}    	    	if(sellInfo.getClassId()!=null)    	{    		sql.append(" S.classId = '");    		sql.append(sellInfo.getClassId());    		sql.append("' and");    	}    	    	if(sellInfo.getPosId()!=null)    	{    		sql.append(" S.posId = '");    		sql.append(sellInfo.getPosId());    		sql.append("' and");    	}    	//去掉最后一个and    	//return sql.substring(0, (sql.length()-3));    	return sql.toString();    }