#\u7528\u6237\u767b\u5f55
login=select id from f_user where username=? and userpwd=?
#\u7528\u6237\u67e5\u8be2\u6b64\u7528\u6237\u540d\u4e0b\u7684\u6587\u4ef6\u4fe1\u606f\u3001
searchfile=select id,filename,filetype,filesize,fileowner,TO_CHAR(fileuploadtime,'YYYY-MM-DD') from f_file where fileparent=?
#\u67e5\u8be2\u7528\u6237\u5bf9\u5e94\u6587\u4ef6\u5939ID
searchID=select id from f_file where filename=?
#\u67e5\u8be2\u5171\u4eab\u6587\u4ef6\u5939\u4fe1\u606f
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=?
#\u67e5\u8be2\u6587\u4ef6\u6216\u6587\u4ef6\u5939\u8def\u5f84
searchfilepath=select id,filename from f_file where isfolder=? and fileowner=? and fileparent=?
#\u67e5\u8be2\u7528\u6237\u5bf9\u5e94\u6587\u4ef6\u5939\u7684ID\u548cfilename
searchfname=select id,filename from f_file where fileparent=? and isfolder=?
#\u7528\u6237\u6ce8\u518c
insert=insert into f_user(id,username,userpwd,email) values(?,?,?,?)
#\u7528\u6237\u6ce8\u518c\u65f6\u540c\u65f6\u63d2\u5165\u6587\u4ef6\u4fe1\u606f
fileinsert=insert into f_file(id,filename,filepath,filetype,filesize,isfolder,fileowner,fshare,fileparent,fileuploadtime) values(?,?,?,?,?,?,?,?,?,sysdate)
#\u67e5\u8be2\u7528\u6237\u8868\u4e2d\u6700\u5927ID
usermaxcount=select max(id) from f_user
#\u5220\u9664\u7528\u6237\u8868\u4e2d\u7528\u6237\u4fe1\u606f
deleteuser=delete from f_user where id=?
#\u6309\u6587\u4ef6\u540d\u641c\u7d22
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 ?)
#\u6309\u6587\u4ef6\u7c7b\u578b\u641c\u7d22
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= ?)
#\u6309\u6587\u4ef6\u4e0a\u4f20\u65f6\u95f4\u641c\u7d22
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'))
#\u6309\u6587\u4ef6\u4e0a\u4f20\u4eba\u641c\u7d22
searchfileowner=select id,filename,filetype,filesize,fileowner,TO_CHAR(fileuploadtime,'YYYY-MM-DD') from f_file where fileowner like ? and fshare='0'
#\u6309\u6587\u4ef6\u5939\u641c\u7d22
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')
#\u6587\u4ef6\u5939\u6570\u7ec4
fileArray=id,filename,filetype,filesize,fileowner,fileuploadtime
#\u7528\u6237\u6570\u7ec4
userArray=id,username,userpwd,email
#\u6587\u4ef6\u5b9a\u4f4d
fileposition=select id,filename,filetype,filesize,fileowner,TO_CHAR(fileuploadtime,'YYYY-MM-DD') from f_file where fileparent=?
#\u6587\u4ef6\u79fb\u52a8
fileremove=update from f_file set fileparent=? where id=? 
#\u67e5\u8be2\u6587\u4ef6\u603b\u6570
filecount=select max(id) from f_file
#\u7528\u6237\u603b\u4eba\u6570
usercount=select max(id) from f_user
#\u67e5\u8be2\u6587\u4ef6\u5bb9\u91cf
filecontent=select sum(filesize) from f_file where fileowner=?
#\u67e5\u627e\u7528\u6237\u540d\u662f\u5426\u5b58\u5728
findusername=select id from f_user where username=?
#\u67e5\u8be2\u6587\u4ef6\u540d
findfname=select filename from f_file where id=?
#\u67e5\u8be2\u7528\u6237\u4fe1\u606f
finduser=select id,username,userpwd,email from f_user where username=?
#\u66f4\u65b0\u7528\u6237\u4fe1\u606f
updateInfo=update f_user set userpwd=?,email=? where id=?
#\u67e5\u8be2\u7528\u6237\u5bc6\u7801
findpwd=select userpwd from f_user where username=?