# 建立数据库disk
CREATE DATABASE IF NOT EXISTS disk DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
# 删除表t_directories
DROP TABLE IF EXISTS disk.t_directories;
# 建立表t_directories
CREATE TABLE IF NOT EXISTS disk.t_directories (
id int(11) NOT NULL auto_increment,
user varchar(20) NOT NULL,
path varchar(255) NOT NULL,
parent_path varchar(255) NOT NULL,
dir varchar(20) NOT NULL,
create_time datetime NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY user (user,path)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
# 删除表t_files
DROP TABLE IF EXISTS disk.t_files;
# 删除表t_files
CREATE TABLE IF NOT EXISTS disk.t_files (
id int(11) NOT NULL auto_increment,
user varchar(20) NOT NULL,
file varchar(255) NOT NULL,
path varchar(255) NOT NULL,
size bigint(11) NOT NULL,
upload_time datetime NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY file (file,path)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
# 删除表t_users
DROP TABLE IF EXISTS disk.t_users;
# 删除表t_users
CREATE TABLE IF NOT EXISTS disk.t_users (
user varchar(20) NOT NULL,
password_md5 varchar(50) NOT NULL,
xm varchar(10) default NULL,
email varchar(20) default NULL,
phone varchar(20) default NULL,
qq varchar(12) default NULL,
PRIMARY KEY (user)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
# 建立存储过程p_dir_info
DELIMITER $$
DROP PROCEDURE IF EXISTS disk.p_dir_info$$
CREATE DEFINER=root@localhost PROCEDURE disk.p_dir_info(in user varchar(20), in parent_path varchar(255))
BEGIN
select * from
(select d.user, d.path , d.parent_path, d.dir, d.create_time ,
(case isnull(sum(f.count)) when true then 0 else sum(f.count) end) as count,
(case isnull(sum(f.size)) when true then 0 else sum(f.size) end) as size
from t_directories d left join
(select path, count(file) as count, sum(size) as size from t_files group by path) f on instr(f.path, d.path) = 1
where d.user=user and d.parent_path=parent_path group by path) dir order by create_time;
END $$
DELIMITER ;
没有合适的资源?快使用搜索试试~ 我知道了~
温馨提示
J2EE实现网络硬盘,网络硬盘(简称网盘),是一种可以用户基于互联网登录网站的进行信息数据上传、下载、共享等操作的信息数据存储空间。也称为:网络磁盘、网络空间、网络U盘、网络优盘等等。免费的网络硬盘的可用空间较少,一般对文件大小、下载速度、存放时间等限制;付费的网盘能提供大容量空间,文件大小、下载速度、存放时间及格式都不限制;另外某些论坛以合作方式与网盘商加盟,亦能获得VIP功能。电子邮箱所提供的附件功能是最早的网络硬盘,随着空间的增大,附件功能分立成网络硬盘。
资源推荐
资源详情
资源评论
收起资源包目录
网盘源代码 JSP+SERVLET (134个子文件)
FileServiceImpl.class 4KB
DirectoryServiceImpl.class 3KB
Zip.class 3KB
User.class 2KB
Encrypter.class 2KB
UserInfo.class 2KB
DirInfo.class 2KB
BaseAction.class 2KB
UploadFile.class 2KB
File.class 2KB
Directory.class 1KB
RegisterAction.class 1KB
LoginAction.class 1KB
MyFormat.class 1KB
ValidationCodeAction.class 1KB
FileAction.class 1KB
UserServiceImpl.class 1KB
DirAction.class 1KB
ServiceManager.class 1KB
FileDAOImpl.class 1KB
DirectoryDAOImpl.class 1KB
AuthorizationInterceptor.class 1KB
DownloadFileAction.class 1KB
DownloadMoreFileAction.class 1000B
UploadAction.class 964B
CreateDirAction.class 928B
DiskAction.class 834B
DeleteAction.class 783B
MyFile.class 782B
UserDAOImpl.class 737B
ReloginAction.class 698B
Test1.class 642B
Test.class 557B
FileService.class 494B
DirectoryService.class 483B
FileDAO.class 442B
DirectoryDAO.class 390B
UserService.class 247B
UserDAO.class 241B
DAOSupport.class 105B
.classpath 3KB
style.css 877B
unknown.gif 616B
zip.gif 605B
folder.gif 211B
txt.gif 123B
ValidationCodeAction.java 4KB
FileServiceImpl.java 2KB
User.java 2KB
Zip.java 2KB
DirInfo.java 2KB
BaseAction.java 2KB
Encrypter.java 2KB
DirectoryServiceImpl.java 2KB
UserInfo.java 2KB
DownloadMoreFileAction.java 2KB
DownloadFileAction.java 2KB
Directory.java 1KB
FileDAOImpl.java 1KB
LoginAction.java 1KB
RegisterAction.java 1KB
UploadFile.java 1KB
AuthorizationInterceptor.java 1KB
File.java 1KB
Test.java 1KB
DirectoryDAOImpl.java 1KB
ServiceManager.java 941B
DirAction.java 938B
MyFormat.java 930B
DeleteAction.java 840B
FileAction.java 762B
UploadAction.java 739B
UserServiceImpl.java 738B
UserDAOImpl.java 728B
CreateDirAction.java 572B
DiskAction.java 471B
ReloginAction.java 446B
MyFile.java 430B
FileDAO.java 377B
FileService.java 363B
DirectoryService.java 331B
DirectoryDAO.java 292B
DAOSupport.java 257B
UserDAO.java 198B
UserService.java 185B
Test1.java 174B
prototype.js 121KB
common.js 11KB
main.jsp 3KB
register.jsp 2KB
login.jsp 1KB
create_dir.jsp 1KB
upload.jsp 1008B
test.jsp 551B
dir_result.jsp 539B
file_result.jsp 476B
upload_success.jsp 404B
create_dir_result.jsp 318B
index.jsp 161B
disk_result.jsp 140B
共 134 条
- 1
- 2
chenhuimaple163
- 粉丝: 0
- 资源: 1
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
- 1
- 2
- 3
- 4
- 5
- 6
前往页