注意看下面两个链接
http://127.0.0.1/docs/docs/DocDspExt.jsp?id=40369
http://127.0.0.1/docs/docs/DocDsp.jsp?id=41353
DocDspExt.jsp地址的文档才会把附件存放到/WEAVER/ecology/filesystem目录下。
DocDsp.jsp地址的文档是网页形式的文档,直接插入到数据库,没有附件存放到服务器目录下,是查询不到附件的存放路径的。
SELECT
imagefileid,
imagefilename,
imagefiletype,
imagefile,
imagefileused,
filerealpath,
iszip,
isencrypt,
fileSize,
downloads,
miniimgpath,
imgsize,
isFTP,
FTPConfigId
FROM ImageFile
WHERE (imagefileid in
(SELECT imagefileid
FROM DocImageFile
WHERE (docid = 40369))
)
下面这个是DocImageFile表的查询语句
SELECT
id,
docid,
imagefileid,
imagefilename,
imagefiledesc,
imagefilewidth,
imagefileheight,
imagefielsize,
docfiletype,
versionId,
versionDetail,
isextfile,
hasUsedTemplet
FROM DocImageFile
WHERE (id = 41353)
下面这个是DocDetail表的查询语句
SELECT
id,
maincategory,
subcategory,
seccategory,
doctype,
doclangurage,
docapprovable,
docreplyable,
isreply,
replydocid,
docsubject,
doccontent,
docsharetype,
shareroleid,
docpublishtype,
itemid,
itemmaincategoryid,
hrmresid,
crmid,
projectid,
financeid,
financerefenceid1,
financerefenceid2,
doccreaterid,
docdepartmentid,
doccreatedate,
doccreatetime,
doclastmoduserid,
doclastmoddate,
doclastmodtime,
docapproveuserid,
docapprovedate,
docapprovetime,
docarchiveuserid,
docarchivedate,
docarchivetime,
docstatus,
parentids,
assetid,
ownerid,
keyword,
accessorycount,
replaydoccount,
usertype,
docno,
cancopy,
canremind,
countMark,
sumMark,
sumReadCount,
orderable,
docExtendName,
doccode,
docedition,
doceditionid,
ishistory,
maindoc,
approvetype,
readoptercanprint,
docvaliduserid,
docvaliddate,
docvalidtime,
docpubuserid,
docpubdate,
docpubtime,
docreopenuserid,
docreopendate,
docreopentime,
docinvaluserid,
docinvaldate,
docinvaltime,
doccanceluserid,
doccanceldate,
doccanceltime,
selectedpubmouldid,
checkOutStatus,
checkOutUserId,
checkOutUserType,
checkOutDate,
checkOutTime,
hasUsedTemplet,
invalidationdate,
docCreaterType,
docLastModUserType,
docApproveUserType,
docValidUserType,
docInvalUserType,
docArchiveUserType,
docCancelUserType,
docPubUserType,
docReopenUserType,
ownerType,
canPrintedNum,
hasPrintedNum,
approverequestid,
fromworkflow,
istop,
topdate,
toptime,
topstartdate,
topenddate,
invalidRequestId
FROM DocDetail
WHERE (docsubject = '消防设备维护保养合同')