package?cn.js.fan.module.cms;

import?java.io.*;
import?java.sql.*;

import?cn.js.fan.db.*;
import?cn.js.fan.util.*;
import?cn.js.fan.web.*;
import?com.redmoon.forum.*;
import?org.apache.log4j.*;

public?class?Attachment?implements?java.io.Serializable?{
????int?id;
????int?docId;
????String?name;
????String?fullPath;
????String?diskName;
????String?visualPath;

????public?static?final?int?TEMP_DOC_ID?=?-1;?

????String?connname;

????String?LOAD?=?“SELECT?doc_id?name?fullpath?diskname?visualpath?orders?page_numdownloadCountupload_datefile_size?FROM?document_attach?WHERE?id=?“;
????String?SAVE?=?“update?document_attach?set?doc_id=??name=??fullpath=??diskname=??visualpath=??orders=??page_num=?downloadCount=??WHERE?id=?“;
????Logger?logger?=?Logger.getLogger（Attachment.class.getName（））;

????public?Attachment（）?{
????????connname?=?Global.defaultDB;
????????if?（connname.equals（““））
????????????logger.info（“Attachment:DB?is?empty！“）;
????}

????public?Attachment（int?id）?{
????????connname?=?Global.defaultDB;
????????if?（connname.equals（““））
????????????logger.info（“Attachment:DB?is?empty！“）;
????????this.id?=?id;
????????loadFromDb（）;
????}

????public?Attachment（int?orders?int?docId?int?pageNum）?{
????????connname?=?Global.defaultDB;
????????if?（connname.equals（““））
????????????logger.info（“Attachment:DB?is?empty！“）;
????????this.orders?=?orders;
????????this.docId?=?docId;
????????this.pageNum?=?pageNum;
????????loadFromDbByOrders（）;
????}

????
????public?boolean?create（）?{
????????String?sql?=?“insert?into?document_attach?（idfullpathdoc_idnamedisknamevisualpathpage_numupload_datefile_size）?values?（?????????）“;
????????id?=?（int）?SequenceMgr.nextID（SequenceMgr.DOCUMENT_ATTACH）;
????????Conn?conn?=?new?Conn（connname）;
????????boolean?re?=?false;
????????try?{
????????????PreparedStatement?pstmt?=?conn.prepareStatement（sql）;
????????????pstmt.setLong（1?id）;
????????????pstmt.setString（2?fullPath）;
????????????pstmt.setLong（3?docId）;
????????????pstmt.setString（4?name）;
????????????pstmt.setString（5?diskName）;
????????????pstmt.setString（6?visualPath）;
????????????pstmt.setInt（7?pageNum）;
????????????pstmt.setString（8?DateUtil.toLongString（new?java.util.Date（）））;
????????????pstmt.setLong（9?size）;
????????????re?=?conn.executePreUpdate（）?==?1???true?:?false;
????????}?catch?（SQLException?e）?{
????????????Logger.getLogger（getClass（））.error（“create:“?+?e.getMessage（））;
????????}?finally?{
????????????if?（conn?!=?null）?{
????????????????conn.close（）;
????????????????conn?=?null;
????????????}
????????}
????????return?re;
????}


????public?boolean?del（）?{
????????String?sql?=?“delete?from?document_attach?where?id=?“;
????????Conn?conn?=?new?Conn（connname）;
????????boolean?re?=?false;
????????try?{
????????????PreparedStatement?pstmt?=?conn.prepareStatement（sql）;
????????????pstmt.setInt（1?id）;
????????????re?=?conn.executePreUpdate（）?==?1???true?:?false;
????????????pstmt.close（）;
????????????
????????????sql

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????3744??2010-03-25?15:24??cwbbs2.4_source\.classpath

?????文件????????291??2010-03-25?15:14??cwbbs2.4_source\.mymetadata

?????文件???????1008??2010-03-25?15:14??cwbbs2.4_source\.project

?????文件???????5551??2010-04-06?08:51??cwbbs2.4_source\src\cn\js\fan\module\cms\ad\AdDb.java

?????文件???????5997??2010-04-06?08:51??cwbbs2.4_source\src\cn\js\fan\module\cms\ad\AdRender.java

?????文件???????2006??2010-04-06?08:51??cwbbs2.4_source\src\cn\js\fan\module\cms\ad\AdTag.java

?????文件???????2148??2010-04-06?08:51??cwbbs2.4_source\src\cn\js\fan\module\cms\ad\AdTemplateImpl.java

?????文件??????10245??2010-04-06?08:51??cwbbs2.4_source\src\cn\js\fan\module\cms\Attachment.java

?????文件???????2266??2010-04-06?08:51??cwbbs2.4_source\src\cn\js\fan\module\cms\CMSMultiFileUploadBean.java

?????文件???????2385??2010-04-06?08:51??cwbbs2.4_source\src\cn\js\fan\module\cms\CMSSchedulerUnit.java

?????文件????????236??2010-04-06?08:51??cwbbs2.4_source\src\cn\js\fan\module\cms\CommentCache.java

?????文件???????3059??2010-04-06?08:51??cwbbs2.4_source\src\cn\js\fan\module\cms\CommentCheck.java

?????文件???????4070??2010-04-06?08:51??cwbbs2.4_source\src\cn\js\fan\module\cms\CommentDb.java

?????文件???????2896??2010-04-06?08:51??cwbbs2.4_source\src\cn\js\fan\module\cms\CommentMgr.java

?????文件???????3978??2010-04-06?08:51??cwbbs2.4_source\src\cn\js\fan\module\cms\Config.java

?????文件???????1329??2010-04-06?08:51??cwbbs2.4_source\src\cn\js\fan\module\cms\CVS\Entries

?????文件?????????33??2010-04-06?08:51??cwbbs2.4_source\src\cn\js\fan\module\cms\CVS\Repository

?????文件?????????38??2010-04-06?08:51??cwbbs2.4_source\src\cn\js\fan\module\cms\CVS\Root

?????文件??????15167??2010-04-06?08:51??cwbbs2.4_source\src\cn\js\fan\module\cms\Directory.java

?????文件??????46856??2010-04-06?08:51??cwbbs2.4_source\src\cn\js\fan\module\cms\DirectoryView.java

?????文件???????3000??2010-04-06?08:51??cwbbs2.4_source\src\cn\js\fan\module\cms\DirListItemTag.java

?????文件???????1174??2010-04-06?08:51??cwbbs2.4_source\src\cn\js\fan\module\cms\DirListTag.java

?????文件???????4780??2010-04-06?08:51??cwbbs2.4_source\src\cn\js\fan\module\cms\DocBlockIterator.java

?????文件???????9090??2010-04-06?08:51??cwbbs2.4_source\src\cn\js\fan\module\cms\DocCacheMgr.java

?????文件??????28030??2010-04-06?08:51??cwbbs2.4_source\src\cn\js\fan\module\cms\DocContent.java

?????文件???????6792??2010-04-06?08:51??cwbbs2.4_source\src\cn\js\fan\module\cms\DocContentCacheMgr.java

?????文件???????1002??2010-04-06?08:51??cwbbs2.4_source\src\cn\js\fan\module\cms\DocImage.java

?????文件???????4824??2010-04-06?08:51??cwbbs2.4_source\src\cn\js\fan\module\cms\DocListItemTag.java

?????文件???????2609??2010-04-06?08:51??cwbbs2.4_source\src\cn\js\fan\module\cms\DocListTag.java

?????文件????????326??2010-04-06?08:51??cwbbs2.4_source\src\cn\js\fan\module\cms\DocPollDb.java

............此處省略7323個文件信息