Ejemplo n.º 1
0
  /** 分享文件 */
  public void shareFile(String path, File file, User user, HttpSession httpSession) {
    // 分享时间
    SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd");
    String createDate = df.format(new Date());
    // 文件的location
    String location = path + "\\" + file.getName();
    // 文件的类型type
    String type = file.getType();
    // 文件的描述
    User u = (User) httpSession.getAttribute("u");
    String description = u.getStuNo() + "分享给我的文件";

    File fileShare = new File();
    fileShare.setUser(user);
    fileShare.setSize(file.getSize());
    fileShare.setPath(path);
    fileShare.setName(file.getName());
    fileShare.setType(type);
    fileShare.setPassword("");
    fileShare.setIsLock(0);
    fileShare.setIsShare(0);
    fileShare.setShareDownload(0);
    fileShare.setDescription(description);
    fileShare.setLocation(location);
    fileShare.setShareUrl("");
    fileShare.setCreateDate(createDate);

    sessionFactory.getCurrentSession().save(fileShare);

    // 更改被分享的文件属性,是否被分享
    String sql = "update File f set f.isShare=1 where f.id=" + file.getId();
    Query q = sessionFactory.getCurrentSession().createQuery(sql);
    q.executeUpdate();

    // 更改被分享的文件属性,被分享次数
    int shareNun = file.getShareDownload() + 1;
    String sqlS = "update File f set f.shareDownload=" + shareNun + "  where f.id=" + file.getId();
    Query qS = sessionFactory.getCurrentSession().createQuery(sqlS);
    qS.executeUpdate();

    // 分享文件后,网盘中的分享文件数量要更改
    // 得到网盘中的分享文件数量
    String sqlN = "select count(*) from File f where f.user.id=" + u.getId() + " and f.isShare=1";
    Query qN = sessionFactory.getCurrentSession().createQuery(sqlN);
    long shareNumL = (Long) qN.uniqueResult();
    int shareNum = (int) shareNumL;

    // 更新网盘分享文件的数量
    String sqlSD = "update Disk d set d.shareNumber=" + shareNum + " where d.user.id=" + u.getId();
    Query qSD = sessionFactory.getCurrentSession().createQuery(sqlSD);
    qSD.executeUpdate();
  }
Ejemplo n.º 2
0
 /** 分页加载所有文件; */
 @SuppressWarnings("unchecked")
 public ArrayList<FileBean> loadPageFile(PageBean pageBean, HttpSession httpSession) {
   User u = (User) httpSession.getAttribute("u");
   Query q =
       sessionFactory
           .getCurrentSession()
           .createQuery("from File file where file.user.id=" + u.getId());
   q.setFirstResult(pageBean.getStart());
   q.setMaxResults(pageBean.getRows());
   ArrayList<com.ligongcloud.model.File> files = (ArrayList<com.ligongcloud.model.File>) q.list();
   ArrayList<FileBean> fileBeans = FileUtil.formatFile(files);
   return fileBeans;
 }
Ejemplo n.º 3
0
  /** 返回满足条件的文件数量(方法思路同UserDao中的userCount) (注意:File数据库中的name字段有".",不要忘了查询时的单引号) */
  public Long fileCount(
      String name, String s_screateDate, String s_ecreateDate, HttpSession httpSession)
      throws Exception {

    User u = (User) httpSession.getAttribute("u");

    Long total;
    if (StringUtil.isNotEmpty(name)
        || StringUtil.isNotEmpty(s_screateDate)
        || StringUtil.isNotEmpty(s_ecreateDate)) {
      // 需要查询的个数
      StringBuffer sqlBuffer =
          new StringBuffer("select count(*) from File file where file.user.id=" + u.getId() + " ");

      if (StringUtil.isNotEmpty(name)) {
        sqlBuffer.append("and file.name = '" + name + "' ");
      }

      if (StringUtil.isEmpty(s_screateDate)) {
        s_screateDate = "2010-01-01";
      }

      if (StringUtil.isEmpty(s_ecreateDate)) {
        // 如果s_ejoindate为空,设s_ejoindate为当前系统时间
        SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd");
        s_ecreateDate = df.format(new Date());
      }

      SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd"); // 小写的mm表示的是分钟
      Date begin = sdf.parse(s_screateDate);
      Date end = sdf.parse(s_ecreateDate);

      sqlBuffer.append("and file.createDate > :beginTime and file.createDate <= :endTime");
      Query q =
          sessionFactory
              .getCurrentSession()
              .createQuery(sqlBuffer.toString())
              .setTimestamp("beginTime", begin)
              .setTimestamp("endTime", end);
      total = (Long) q.uniqueResult();
    } else {
      // 总个数
      Query q =
          sessionFactory
              .getCurrentSession()
              .createQuery("select count(*) from File file where file.user.id=" + u.getId());
      total = (Long) q.uniqueResult();
    }
    System.out.println(total);
    return total;
  }
Ejemplo n.º 4
0
 /** 加载指定userde的文件; */
 @SuppressWarnings("unchecked")
 public ArrayList<File> loadFileByUser(User user) {
   String sqlFile = "from File f where f.user.id = " + user.getId();
   Query qFile = sessionFactory.getCurrentSession().createQuery(sqlFile);
   ArrayList<com.ligongcloud.model.File> files =
       (ArrayList<com.ligongcloud.model.File>) qFile.list();
   return files;
 }
Ejemplo n.º 5
0
  /** 查询文件; */
  @SuppressWarnings("unchecked")
  public ArrayList<FileBean> searchFile(
      String name,
      String s_screateDate,
      String s_ecreateDate,
      PageBean pageBean,
      HttpSession httpSession)
      throws Exception {
    User u = (User) httpSession.getAttribute("u");

    StringBuffer sqlBuffer =
        new StringBuffer("from File file where file.user.id=" + u.getId() + " ");

    if (StringUtil.isNotEmpty(name)) {
      sqlBuffer.append("and file.name = '" + name + "' ");
    }

    if (StringUtil.isEmpty(s_screateDate)) {
      s_screateDate = "2010-01-01";
    }

    if (StringUtil.isEmpty(s_ecreateDate)) {
      // 如果s_ejoindate为空,设s_ejoindate为当前系统时间
      SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd");
      s_ecreateDate = df.format(new Date());
    }

    SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd"); // 小写的mm表示的是分钟
    Date begin = sdf.parse(s_screateDate);
    Date end = sdf.parse(s_ecreateDate);

    sqlBuffer.append("and file.createDate > :beginTime and file.createDate <= :endTime");
    Query q =
        sessionFactory
            .getCurrentSession()
            .createQuery(sqlBuffer.toString())
            .setTimestamp("beginTime", begin)
            .setTimestamp("endTime", end);
    q.setFirstResult(pageBean.getStart());
    q.setMaxResults(pageBean.getRows());

    ArrayList<File> files = (ArrayList<File>) q.list();
    ArrayList<FileBean> fileBeans = FileUtil.formatFile(files);
    return fileBeans;
  }