sql.properties

网络硬盘

#用户登录
login=select id from f_user where username=? and userpwd=?
#用户查询此用户名下的文件信息、
searchfile=select id,filename,filetype,filesize,fileowner,TO_CHAR(fileuploadtime,'YYYY-MM-DD') from f_file where fileparent=?
#查询用户对应文件夹ID
searchID=select id from f_file where filename=?
#查询共享文件夹信息
searchfileID=select id,filename,filetype,filesize,fileowner,TO_CHAR(fileuploadtime,'YYYY-MM-DD') from f_file where fshare='1'
searchsharefile=select id,filename,filetype,filesize,fileowner,TO_CHAR(fileuploadtime,'YYYY-MM-DD') from f_file where fshare=?
#查询文件或文件夹路径
searchfilepath=select id,filename from f_file where isfolder=? and fileowner=? and fileparent=?
#查询用户对应文件夹的ID和filename
searchfname=select id,filename from f_file where fileparent=? and isfolder=?
#用户注册
insert=insert into f_user(id,username,userpwd,email) values(?,?,?,?)
#用户注册时同时插入文件信息
fileinsert=insert into f_file(id,filename,filepath,filetype,filesize,isfolder,fileowner,fshare,fileparent,fileuploadtime) values(?,?,?,?,?,?,?,?,?,sysdate)
#查询用户表中最大ID
usermaxcount=select max(id) from f_user
#删除用户表中用户信息
deleteuser=delete from f_user where id=?
#按文件名搜索
searchfilename=select id,filename,filetype,filesize,fileowner,TO_CHAR(fileuploadtime,'YYYY-MM-DD') from f_file where filename like ? and fshare='0' or filename in (select filename from f_file where fshare='1' and fileowner=? and filename like ?)
#按文件类型搜索
searchfiletype=select id,filename,filetype,filesize,fileowner,TO_CHAR(fileuploadtime,'YYYY-MM-DD') from f_file where filetype=? and fshare='0' or filetype in (select filetype from f_file where fshare='1' and fileowner=? and filetype= ?)
#按文件上传时间搜索
searchfileuploadtime=select id,filename,filetype,filesize,fileowner,TO_CHAR(fileuploadtime,'YYYY-MM-DD') from f_file where fileuploadtime like To_Date(?,'yyyy-mm-dd') and fshare='0' or fileuploadtime in (select fileuploadtime from f_file where fshare='1' and fileowner=? and fileuploadtime like To_Date(?,'yyyy-mm-dd'))
#按文件上传人搜索
searchfileowner=select id,filename,filetype,filesize,fileowner,TO_CHAR(fileuploadtime,'YYYY-MM-DD') from f_file where fileowner like ? and fshare='0'
#按文件夹搜索
searchfolder=select id,filename,filetype,filesize,fileowner,TO_CHAR(fileuploadtime,'YYYY-MM-DD') from f_file where isfolder='0' and filename like ? and fshare='0' or filename in (select filename from f_file where fshare='1' and fileowner=? and filename like ? and isfolder='0')
#文件夹数组
fileArray=id,filename,filetype,filesize,fileowner,fileuploadtime
#用户数组
userArray=id,username,userpwd,email
#文件定位
fileposition=select id,filename,filetype,filesize,fileowner,TO_CHAR(fileuploadtime,'YYYY-MM-DD') from f_file where fileparent=?
#文件移动
fileremove=update from f_file set fileparent=? where id=? 
#查询文件总数
filecount=select max(id) from f_file
#用户总人数
usercount=select max(id) from f_user
#查询文件容量
filecontent=select sum(filesize) from f_file where fileowner=?
#查找用户名是否存在
findusername=select id from f_user where username=?
#查询文件名
findfname=select filename from f_file where id=?
#查询用户信息
finduser=select id,username,userpwd,email from f_user where username=?
#更新用户信息
updateInfo=update f_user set userpwd=?,email=? where id=?
#查询用户密码
findpwd=select userpwd from f_user where username=?