예제 #1
0
  /** Blog分页 */
  @Override
  @Transactional
  @SuppressWarnings({"rawtypes", "unchecked"})
  public PageConf findBlogPageList(
      int start, int limit, UserInfo userInfo, String type, Integer blogId) throws BlogException {
    try {
      String sql =
          " select temp_0.rowno from (select @rowno := @rowno + 1 as rowno , module.id as id from Blog as module "
              + " , (select @rowno := 0 ) as t_rowno ";
      // 通用查询匹配
      if (type != null) {

        // 找到blogId所在位置
        Long indexStart = 0L;
        if (type.equals("friend") && userInfo != null) {
          sql +=
              " and exists ( select friend.friend.id from Friend friend "
                  + " where friend.friend.id = module.userInfo.id and friend.userId = ? ) "
                  + " order by module.createTime desc ";
          System.out.println(sql);
          List<Object[]> countList = baseDao.findSql(sql, blogId);
          if (countList.iterator().hasNext()) {
            Object[] obj = countList.iterator().next();
            indexStart = (Long) obj[0];
          }
          System.out.println(indexStart);
        } else if (type.equals("my") && userInfo != null) {
          // 查询我自己的日志
          sql +=
              " where module.userId = ? order by module.createTime desc ) as temp_0 where temp_0.id = ? ";
          System.out.println(sql);
          List<Object[]> countList = baseDao.findSql(sql, userInfo.getId(), blogId);
          if (countList.iterator().hasNext()) {
            Object[] obj = countList.iterator().next();
            indexStart = ((Double) obj[0]).longValue();
          }
          System.out.println(indexStart);
        } else if (type.equals("all")) {
          //
          sql += " order by module.createTime desc ) as temp_0 where temp_0.id = ? ";
          System.out.println(sql);
          List<Object[]> countList = baseDao.findSql(sql, blogId);
          if (countList.iterator().hasNext()) {
            Object[] obj = countList.iterator().next();
            indexStart = ((Double) obj[0]).longValue();
          }
          System.out.println(indexStart);
        }
        // 再次进行分页查询
        // 分页是从0开始所以-1
        // 处理第一篇文章
        return findBlogPageList(indexStart.intValue() - 1, limit, userInfo, type);

      } else {
        return null;
      }
    } catch (Exception e) {
      throw new BlogException("Blog分页异常");
    }
  }
예제 #2
0
 /** Blog分页 */
 @Override
 @Transactional
 public PageConf findBlogPageList(int start, int limit, UserInfo userInfo, String type)
     throws BlogException {
   try {
     String hql =
         " select module from Blog module left join fetch module.userInfo left join fetch module.blogCategory ";
     // 通用查询匹配
     if (type != null) {
       if (type.equals("friend") && userInfo != null) {
         hql +=
             " where exists ( select friend.friend.id from Friend friend "
                 + " where friend.friend.id = module.userInfo.id and friend.userId = ? ) "
                 + " order by module.createTime desc ";
         return baseDao.findPage(start, limit, hql, userInfo.getId());
       } else if (type.equals("my") && userInfo != null) {
         // 查询我自己的日志
         hql += " where module.userInfo.id = ? order by module.createTime desc ";
         return baseDao.findPage(start, limit, hql, userInfo.getId());
       } else if (type.equals("all")) {
         //
         hql += " order by module.createTime desc ";
         return baseDao.findPage(start, limit, hql);
       } else {
         return null;
       }
     } else {
       return null;
     }
   } catch (Exception e) {
     throw new BlogException("Blog分页异常");
   }
 }
예제 #3
0
 /** Blog删除 */
 @Override
 @Transactional
 public void deleteBlogById(Integer id) throws BlogException {
   try {
     Blog blog = (Blog) baseDao.findById(Blog.class, id);
     baseDao.delete(blog);
   } catch (Exception e) {
     throw new BlogException("Blog删除异常");
   }
 }
예제 #4
0
 /** Blog按ID查询 */
 @Override
 @Transactional
 public Blog findBlogById(Integer id) throws BlogException {
   try {
     return (Blog) baseDao.findById(Blog.class, id);
   } catch (Exception e) {
     throw new BlogException("Blog按ID查询异常");
   }
 }
예제 #5
0
 /** 查询Blog全部 */
 @Override
 @Transactional
 public List<Blog> findAllBlog(Map map) throws BlogException {
   try {
     String hql = " select module from Blog module ";
     // 通用查询匹配
     Object[] values = CommonDaoUtil.commonQuery(map);
     hql += values[0].toString();
     // Object[]需要进行强制转换.
     return baseDao.find(hql, (Object[]) values[1]);
   } catch (Exception e) {
     throw new BlogException("查询Blog全部异常");
   }
 }
예제 #6
0
  /** Blog保存 */
  @Override
  @Transactional
  public void saveBlog(Blog blog) throws BlogException {
    try {
      blog.setCreateTime(new Date());
      blog.setCommentCount(0);
      blog.setReadCount(0);

      baseDao.save(blog);

      feedService.saveFeed(blog);
    } catch (Exception e) {
      throw new BlogException("Blog保存异常");
    }
  }