/** 分享文件 */
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();
}
/** 分页加载所有文件; */
@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;
}
/** 返回满足条件的文件数量(方法思路同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;
}
/** 加载指定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;
}
/** 查询文件; */
@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;
}