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

		StringBuilder sb = new StringBuilder();
//		sb.append(" select ");
//		sb.append(" dname, price, spec, 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(" where 1=1");
//		sb.append(" group by dname, price, spec");
//		sb.append(" union");
		sb.append(" select ");
		sb.append(" dname, price, spec, 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(" where 1=1");
		sb.append(" group by dname, price, spec");
		sb.append(" order by 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()){
				//dname, price, spec, count(a.time)
				DishHitsbb dh = new DishHitsbb();
				dh.setDishName(rs.getString(1));
				dh.setPrice(rs.getDouble(2));
				dh.setSpec(rs.getString(3));
				dh.setInPicNum(rs.getDouble(4));
				dhbl.add(dh);
			}
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		return dhbl;
	}