基于mvc的web文章系统---文章管理、公告管理模块

基于MVC的WEB文章系统文章管理、公告管理模块模块开发卷宗1标题软件系统名称和标识符名称基于MVC的WEB文章系统标识符WEB文章系统模块名称和标识符名称文章管理公告管理标识符文章标题ID号程序编制员签名彭宝修改完成日期20055272功能说明模块功能文章/公告的添加、删除、修改等功能。使用HTML在线文本编辑系统，实现了文档的格式化功能。对文章实现了审核和推荐功能。文章/公告管理模块功能名称文章添加功能说明添加一篇新的文章。数据结构文章标题字符串文章分类整型文章内容文本文章作者字符串添加时间日期是否推荐整型关键字整型功能名称文章修改功能说明修改已经添加的文章数据结构文章标题字符串文章分类整型文章内容文本文章作者字符串添加时间日期是否推荐整型关键字整型功能名称文章审核功能说明审核没有通过审核的文章。数据结构文章标题字符串文章分类整型文章内容文本文章作者字符串添加时间日期是否推荐整型关键字整型功能名称文章删除功能说明删除所选择的文章。数据结构文章标题字符串文章分类整型文章内容文本文章作者字符串添加时间日期是否推荐整型关键字整型功能名称公告添加功能说明添加一条新的公告。数据结构公告标题字符串公告内容文本添加时间日期功能名称公告修改功能说明修改所选择的公告。数据结构公告标题字符串公告内容文本添加时间日期功能名称公告删除功能说明删除所选择的公告数据结构公告标题字符串公告内容文本3流程分析文章管理公告管理4数据字典文章表（ARTICLE）字段名称描述数据类型字段长度可否为空IDID号INTAUTO_INCREMENT否CATEGORY文章分类INT否TITLE文章标题VARCHAR50否CONTENT文章内容TEXT否HITS点击数INT否AUTHOR文章作者VARCHAR20否ADDTIME添加时间DATETIME否KEYWORD关键字VARCHAR30否ISRECOMMANDATION是否推荐INT否EDITOR编辑VARCHAR20否WRITEFROM来自VARCHAR30否公告表（BULLETIN）字段名称描述数据类型字段长度可否为空IDID号INTAUTO_INCREMENT否TITLE公告标题VARCHAR50否CONTENT公告内容VARCHAR500否ADDTIME发布时间DATETIME否附件表（ACCESSORY）字段名称描述数据类型字段长度可否为空IDID号INTAUTO_INCREMENT否ARTICALID所属文章IDINT否FILENAME文件名VARCHAR50否REALNAME上传文件名VARCHAR50否用户界面程序代码PACKAGECNEDUCUMTBEANTITLEMYSITE3RDDESCRIPTIONMODUOPAOPAOCOPYRIGHTCOPYRIGHTC2004COMPANYCUMTAUTHORSOMEBODYVERSION30IMPORTJAVASQLRESULTSETIMPORTJAVASQLSTATEMENTIMPORTJAVASQLPREPAREDSTATEMENTIMPORTJAVAUTILCOLLECTIONIMPORTJAVAUTILARRAYLISTIMPORTJAVASQLCONNECTIONIMPORTJAVASQLSQLEXCEPTIONIMPORTCNEDUCUMTUTILDATABASECONNPUBLICCLASSACCESSORYDATA/THISMETHODRETURNAACCESSORYBYIDPARAMIDINTTHROWSEXCEPTIONRETURNACCESSORY/PUBLICSTATICACCESSORYGETACCESSORYINTIDTHROWSEXCEPTIONACCESSORYACCESSORYNULLCONNECTIONCONNNULLPREPAREDSTATEMENTPSTMTNULLRESULTSETRSNULLTRYCONNDATABASECONNGETCONNECTIONPSTMTCONNPREPARESTATEMENT“SELECTFROMACCESSORYWHEREID“PSTMTSETINT1,IDRSPSTMTEXECUTEQUERYIFRSNEXTACCESSORYNEWACCESSORYACCESSORYSETIDIDACCESSORYSETNEWSIDRSGETINT2ACCESSORYSETFILENAMERSGETSTRING3ACCESSORYSETREALNAMERSGETSTRING4ELSETHROWNEWEXCEPTION“SORRYNOTFOUNDTHISACCESSORY“FINALLYIFRSNULLRSCLOSEIFPSTMTNULLPSTMTCLOSEIFCONNNULLCONNCLOSERETURNACCESSORY/THISMETHODRETURNALLOFTHEACCESSORYTHROWSEXCEPTIONTHROWSSQLEXCEPTIONRETURNCOLLECTION/PUBLICSTATICCOLLECTIONGETACCESSORYSTHROWSEXCEPTION,SQLEXCEPTIONACCESSORYACCESSORYNULLCOLLECTIONACCESSORYSNEWARRAYLISTCONNECTIONCONNNULLSTATEMENTSTMTNULLRESULTSETRSNULLTRYCONNDATABASECONNGETCONNECTIONSTMTCONNCREATESTATEMENTRSSTMTEXECUTEQUERY“SELECTFROMACCESSORY“WHILERSNEXTACCESSORYNEWACCESSORYACCESSORYSETIDRSGETINT1ACCESSORYSETNEWSIDRSGETINT2ACCESSORYSETFILENAMERSGETSTRING3ACCESSORYSETREALNAMERSGETSTRING4ACCESSORYSADDACCESSORYFINALLYIFRSNULLRSCLOSEIFSTMTNULLSTMTCLOSEIFCONNNULLCONNCLOSERETURNACCESSORYS/THISMETHODADDAACCESSORYINTODATABASEPARAMACCESSORYACCESSORYTHROWSEXCEPTION/PUBLICSTATICVOIDADDACCESSORYACCESSORYACCESSORYTHROWSEXCEPTIONCONNECTIONCONNNULLPREPAREDSTATEMENTPSTMTNULLTRYCONNDATABASECONNGETCONNECTIONPSTMTCONNPREPARESTATEMENT“INSERTINTOACCESSORYNEWSID,FILENAME,REALNAMEVALUES,“PSTMTSETINT1,ACCESSORYGETNEWSIDPSTMTSETSTRING2,ACCESSORYGETFILENAMEPSTMTSETSTRING3,ACCESSORYGETREALNAMEPSTMTEXECUTEUPDATEFINALLYIFPSTMTNULLPSTMTCLOSEIFCONNNULLCONNCLOSE/THISMETHODTODELETEACCESSORYWHENDELETENEWSWHILEDELETETHEACCESSORYFROMDATABASEPROBLEMDELETEFILESFROMCOMPUTERPARAMNEWSIDINTTHROWSEXCEPTION/PUBLICSTATICVOIDDELACCESSORYINTNEWSIDTHROWSEXCEPTIONCONNECTIONCONNNULLPREPAREDSTATEMENTPSTMTNULLTRYCONNDATABASECONNGETCONNECTIONPSTMTCONNPREPARESTATEMENT“DELETEFROMACCESSORYWHERENEWSID“PSTMTSETINT1,NEWSIDPSTMTEXECUTEUPDATEFINALLYIFPSTMTNULLPSTMTCLOSEIFCONNNULLCONNCLOSETHISMETHODRETURNAACCESSORYBYNEWSIDPARAMNEWSIDINTTHROWSEXCEPTIONRETURNACCESSORY/PUBLICSTATICACCESSORYGETACCESSORYBYNEWSIDINTNEWSIDTHROWSEXCEPTIONACCESSORYACCESSORYNULLCONNECTIONCONNNULLPREPAREDSTATEMENTPSTMTNULLRESULTSETRSNULLTRYCONNDATABASECONNGETCONNECTIONPSTMTCONNPREPARESTATEMENT“SELECTFROMACCESSORYWHERENEWSID“PSTMTSETINT1,NEWSIDRSPSTMTEXECUTEQUERYIFRSNEXTACCESSORYNEWACCESSORYACCESSORYSETIDRSGETINT1ACCESSORYSETNEWSIDRSGETINT2ACCESSORYSETFILENAMERSGETSTRING3ACCESSORYSETREALNAMERSGETSTRING4FINALLYIFRSNULLRSCLOSEIFPSTMTNULLPSTMTCLOSEIFCONNNULLCONNCLOSERETURNACCESSORYPACKAGECNEDUCUMTBEANTITLEMYSITE3RDDESCRIPTIONMODUOPAOPAOCOPYRIGHTCOPYRIGHTC2004COMPANYCUMTAUTHORNOTATTRIBUTABLEVERSION30IMPORTJAVASQLCONNECTIONIMPORTJAVASQLSTATEMENTIMPORTJAVASQLPREPAREDSTATEMENTIMPORTJAVASQLRESULTSETIMPORTJAVAUTILARRAYLISTIMPORTJAVAUTILCOLLECTIONIMPORTCNEDUCUMTUTILDATABASECONNPUBLICCLASSBULLETINDATA/THISMETHODGETABULLETINBYIDPARAMIDINTTHROWSEXCEPTIONRETURNBULLETIN/PUBLICSTATICBULLETINGETBULLETININTIDTHROWSEXCEPTIONBULLETINBUNEWBULLETINCONNECTIONCONNNULLPREPAREDSTATEMENTPSTMTNULLRESULTSETRSNULLTRYCONNDATABASECONNGETCONNECTIONPSTMTCONNPREPARESTATEMENT“SELECTFROMBULLETINWHEREID“PSTMTSETINT1,IDRSPSTMTEXECUTEQUERYIFRSNEXTBUSETIDIDBUSETTITLERSGETSTRING“TITLE“BUSETCONTENTRSGETSTRING“CONTENT“BUSETADDTIMERSGETSTRING“ADDTIME“ELSETHROWNEWEXCEPTION“SORRYTHISBULLETINNOTFOUND“FINALLYIFRSNULLRSCLOSEIFPSTMTNULLPSTMTCLOSEIFCONNNULLCONNCLOSERETURNBU/THISMETHODGETNUMBERBULLETINSIFNUMBEREQUALSZEROTHENRETURNALLBULLETINPARAMNUMBERINTTHROWSEXCEPTIONRETURNCOLLECTION/PUBLICSTATICCOLLECTIONGETBULLETINSINTNUMBERTHROWSEXCEPTIONCOLLECTIONBUSNEWARRAYLISTCONNECTIONCONNNULLSTATEMENTSTMTNULLRESULTSETRSNULLBULLETINBUNULLSTRINGSQLNULLTRYCONNDATABASECONNGETCONNECTIONSTMTCONNCREATESTATEMENTIFNUMBER0SQL“SELECTFROMBULLETINORDERBYIDDESC“ELSESQL“SELECTFROMBULLETINORDERBYIDDESCLIMIT0,“NUMBER“RSSTMTEXECUTEQUERYSQLWHILERSNEXTBUNEWBULLETINBUSETIDRSGETINT1BUSETTITLERSGETSTRING2BUSETCONTENTRSGETSTRING3BUSETADDTIMERSGETSTRING4BUSADDBUFINALLYIFRSNULLRSCLOSEIFSTMTNULLSTMTCLOSEIFCONNNULLCONNCLOSERETURNBUS/THISMETHODTOMODIFYTHEBULLETINPARAMBULLETINBULLETINTHROWSEXCEPTION/PUBLICSTATICVOIDUPDATEBULLETINBULLETINBULLETINTHROWSEXCEPTIONCONNECTIONCONNNULLPREPAREDSTATEMENTPSTMTNULLTRYCONNDATABASECONNGETCONNECTIONPSTMTCONNPREPARESTATEMENT“UPDATEBULLETINSETTITLE,CONTENTWHEREID“PSTMTSETSTRING1,BULLETINGETTITLEPSTMTSETSTRING2,BULLETINGETCONTENTPSTMTSETINT3,BULLETINGETIDPSTMTEXECUTEUPDATEFINALLYIFPSTMTNULLPSTMTCLOSEIFCONNNULLCONNCLOSE/THISMETHODTODELETEABULLETINBYIDPARAMIDINTTHROWSEXCEPTION/PUBLICSTATICVOIDDELBULLETININTIDTHROWSEXCEPTIONCONNECTIONCONNNULLPREPAREDSTATEMENTPSTMTNULLTRYCONNDATABASECONNGETCONNECTIONPSTMTCONNPREPARESTATEMENT“DELETEFROMBULLETINWHEREID“PSTMTSETINT1,IDPSTMTEXECUTEUPDATEFINALLYIFPSTMTNULLPSTMTCLOSEIFCONNNULLCONNCLOSE/THISMETHODTOADDABULLETINPARAMBULLETINBULLETINTHROWSEXCEPTIONPUBLICSTATICVOIDADDBULLETINBULLETINBULLETINTHROWSEXCEPTIONCONNECTIONCONNNULLPREPAREDSTATEMENTPSTMTNULLTRYCONNDATABASECONNGETCONNECTIONPSTMTCONN