public List<DishHitsbb> getDishHitsCatebbList() {
		
		
		List<DishHitsbb> dhbl = new ArrayList<DishHitsbb>();

		StringBuilder sb = new StringBuilder();
		sb.append("select ");
		sb.append(" c.id,c.catename,'', 0, '',count(itemnum), count(a.time) ");
		sb.append(" from dishhits as a ");
		sb.append(" left join dish as b on a.dishid=b.id");
		sb.append(" left join cate as c on b.upper=c.id");
		sb.append(" left join billitem as d on d.dishid = b.id");
		sb.append(" where 1=1");
//		sb.append(" and catename = ?");
		sb.append(" group by c.id,c.catename");
		sb.append(" union");
		sb.append(" select");
		sb.append(" c.id,c.catename,dname, price, spec,count(itemnum), count(a.time)");
		sb.append(" from dishhits as a");
		sb.append(" left join dish as b on a.dishid=b.id");
		sb.append(" left join cate as c on b.upper=c.id");
		sb.append(" left join billitem as d on d.dishid = b.id");
		sb.append(" where 1=1");
	//	sb.append(" and catename = ?");
		sb.append(" group by c.id,c.catename,dname, price, spec");
		sb.append(" order by  c.id, count(a.time) desc");
		String sql = sb.toString();
		System.out.println(sql);

		try {
			conn = this.getConn();
			pstmt = conn.prepareStatement(sql);

			rs = pstmt.executeQuery();
			while(rs.next()){
				//c.id,c.catename,'', 0, '', count(a.time)
				DishHitsbb dh = new DishHitsbb();
				dh.setCateName(rs.getString(2));
				dh.setDishName(rs.getString(3));
				dh.setPrice(rs.getDouble(4));
				dh.setSpec(rs.getString(5));
				dh.setOrederNum(rs.getDouble(6));
				dh.setInPicNum(rs.getDouble(7));
				dhbl.add(dh);
			}
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}

		return dhbl;
	}