基于MVC的WEB文章系統(tǒng)-文章管理、公告管理模塊

基于MVC的WEB文章系統(tǒng)---文章管理、公告管理模塊模塊開發(fā)卷宗1.標(biāo)題軟件系統(tǒng)名稱和標(biāo)識符名稱：基于MVC的WEB文章系統(tǒng)標(biāo)識符：WEB文章系統(tǒng)模塊名稱和標(biāo)識符名稱：文章管理公告管理標(biāo)識符：文章標(biāo)題ID號程序編制員簽名彭寶修改完成日期2005-5-272.功能說明模塊功能文章/公告的添加、刪除、修改等功能。使用HTML在線文本編輯系統(tǒng)，實(shí)現(xiàn)了文檔的格式化功能。對文章實(shí)現(xiàn)了審核和推薦功能。文章/公告管理模塊[功能名稱]:文章添加[功能說明]:添加一篇新的文章。[數(shù)據(jù)結(jié)構(gòu)]:文章標(biāo)題：字符串 文章分類：整型 文章內(nèi)容：文本文章作者：字符串 添加時(shí)間：日期 是否推薦：整型關(guān)鍵字：整型[功能名稱]:文章修改[功能說明]:修改已經(jīng)添加的文章[數(shù)據(jù)結(jié)構(gòu)]: 文章標(biāo)題：字符串 文章分類：整型 文章內(nèi)容：文本文章作者：字符串 添加時(shí)間：日期 是否推薦：整型關(guān)鍵字：整型[功能名稱]:文章審核[功能說明]:審核沒有通過審核的文章。[數(shù)據(jù)結(jié)構(gòu)]: 文章標(biāo)題：字符串 文章分類：整型 文章內(nèi)容：文本文章作者：字符串 添加時(shí)間：日期 是否推薦：整型關(guān)鍵字：整型[功能名稱]:文章刪除[功能說明]:刪除所選擇的文章。[數(shù)據(jù)結(jié)構(gòu)]:文章標(biāo)題：字符串 文章分類：整型 文章內(nèi)容：文本文章作者：字符串 添加時(shí)間：日期 是否推薦：整型關(guān)鍵字：整型[功能名稱]:公告添加[功能說明]:添加一條新的公告。[數(shù)據(jù)結(jié)構(gòu)]:公告標(biāo)題：字符串 公告內(nèi)容：文本 添加時(shí)間：日期[功能名稱]:公告修改[功能說明]:修改所選擇的公告。[數(shù)據(jù)結(jié)構(gòu)]:公告標(biāo)題：字符串 公告內(nèi)容：文本 添加時(shí)間：日期[功能名稱]:公告刪除[功能說明]:刪除所選擇的公告[數(shù)據(jù)結(jié)構(gòu)]:公告標(biāo)題：字符串 公告內(nèi)容：文本3流程分析文章管理：公告管理：4數(shù)據(jù)字典文章表（article）字段名稱描述數(shù)據(jù)類型字段長度可否為空IdId號intauto_increment否Category文章分類Int否Title文章標(biāo)題varchar50否Content文章內(nèi)容Text否Hits點(diǎn)擊數(shù)Int否Author文章作者varchar20否AddTime添加時(shí)間datetime否Keyword關(guān)鍵字varchar30否IsRecommandation是否推薦Int否Editor編輯varchar20否Writefrom來自varchar30否公告表（bulletin）字段名稱描述數(shù)據(jù)類型字段長度可否為空IdId號intauto_increment否Title公告標(biāo)題varchar50否Content公告內(nèi)容varchar500否AddTime發(fā)布時(shí)間datetime否附件表（accessory）字段名稱描述數(shù)據(jù)類型字段長度可否為空IdId號intauto_increment否ArticalId所屬文章idInt否FileName文件名varchar50否RealName上傳文件名varchar50否用戶界面程序代碼：package.cumt.bean;*<p>Title:MySite3rd</p><p>Description:MoDuoPaoPao</p><p>Copyright:Copyright(c)2004</p><p>Company:CUMT</p>@authorSomeBody@version3.0importjava.sql.ResultSet;importjava.sql.Statement;importjava.sql.PreparedStatement;importjava.util.Collection;importjava.util.ArrayList;importjava.sql.Connection;importjava.sql.SQLException;import.cumt.util.DataBaseConn;publicclassAccessoryData{/***Thismethodreturnaaccessorybyid*@paramidint*@throwsException*@returnAccessory*/publicstaticAccessorygetAccessory(intid)throwsException{Accessoryaccessory=null;Connectionconn=null;PreparedStatementpstmt=null;ResultSetrs=null;try{conn=DataBaseConn.getConnection();pstmt=conn.prepareStatement("SELECT*FROMaccessoryWHEREid=?");pstmt.setInt(1,id);rs=pstmt.executeQuery();if(rs.next()){accessory=newAccessory();accessory.setId(id);accessory.setNewsId(rs.getInt(2));accessory.setFileName(rs.getString(3));accessory.setRealName(rs.getString(4));}else{thrownewException("Sorry:Notfoundthisaccessory");}}finally{if(rs!=null){rs.close();}if(pstmt!=null){pstmt.close();}if(conn!=null){conn.close();}}returnaccessory;}/***Thismethodreturnalloftheaccessory*@throwsException*@throwsSQLException*@returnCollection*/publicstaticCollectiongetAccessorys()throwsException,SQLException{Accessoryaccessory=null;Collectionaccessorys=newArrayList();Connectionconn=null;Statementstmt=null;ResultSetrs=null;try{conn=DataBaseConn.getConnection();stmt=conn.createStatement();rs=stmt.executeQuery("SELECT*FROMaccessory");while(rs.next()){accessory=newAccessory();accessory.setId(rs.getInt(1));accessory.setNewsId(rs.getInt(2));accessory.setFileName(rs.getString(3));accessory.setRealName(rs.getString(4));accessorys.add(accessory);}}finally{if(rs!=null){rs.close();}if(stmt!=null){stmt.close();}if(conn!=null){conn.close();}}returnaccessorys;}/***Thismethodaddaaccessoryintodatabase*@paramaccessoryAccessory*@throwsException*/publicstaticvoidaddAccessory(Accessoryaccessory)throwsException{Connectionconn=null;PreparedStatementpstmt=null;try{conn=DataBaseConn.getConnection();pstmt=conn.prepareStatement("INSERTINTOaccessory(NewsId,FileName,RealName)VALUES(?,?,?)");pstmt.setInt(1,accessory.getNewsId());pstmt.setString(2,accessory.getFileName());pstmt.setString(3,accessory.getRealName());pstmt.executeUpdate();}finally{if(pstmt!=null){pstmt.close();}if(conn!=null){conn.close();}}}/***Thismethodtodeleteaccessory*Whendeletenewswhiledeletetheaccessoryfromdatabase*problem:deletefilesfromcomputer*@paramnewsIdint*@throwsException*/publicstaticvoiddelAccessory(intnewsId)throwsException{Connectionconn=null;PreparedStatementpstmt=null;try{conn=DataBaseConn.getConnection();pstmt=conn.prepareStatement("DELETEFROMaccessoryWHERENewsId=?");pstmt.setInt(1,newsId);pstmt.executeUpdate();}finally{if(pstmt!=null){pstmt.close();}if(conn!=null){conn.close();}}}*Thismethodreturnaaccessorybynewsid*@paramnewsIdint*@throwsException*@returnAccessory*/publicstaticAccessorygetAccessoryByNewsId(intnewsId)throwsException{Accessoryaccessory=null;Connectionconn=null;PreparedStatementpstmt=null;ResultSetrs=null;try{conn=DataBaseConn.getConnection();pstmt=conn.prepareStatement("SELECT*FROMaccessoryWHERENewsId=?");pstmt.setInt(1,newsId);rs=pstmt.executeQuery();if(rs.next()){accessory=newAccessory();accessory.setId(rs.getInt(1));accessory.setNewsId(rs.getInt(2));accessory.setFileName(rs.getString(3));accessory.setRealName(rs.getString(4));}}finally{if(rs!=null){rs.close();}if(pstmt!=null){pstmt.close();}if(conn!=null){conn.close();}}returnaccessory;}}package.cumt.bean;*<p>Title:MySite3rd</p>*<p>Description:MoDuoPaoPao</p><p>Copyright:Copyright(c)2004</p><p>Company:CUMT</p>*@authornotattributable*@version3.0importjava.sql.Connection;importjava.sql.Statement;importjava.sql.PreparedStatement;importjava.sql.ResultSet;importjava.util.ArrayList;importjava.util.Collection;import.cumt.util.DataBaseConn;publicclassBulletinData{/***Thismethodgetabulletinbyid*@paramidint*@throwsException*@returnBulletin*/publicstaticBulletingetBulletin(intid)throwsException{Bulletinbu=newBulletin();Connectionconn=null;PreparedStatementpstmt=null;ResultSetrs=null;try{conn=DataBaseConn.getConnection();pstmt=conn.prepareStatement("SELECT*FROMbulletinWHEREid=?");pstmt.setInt(1,id);rs=pstmt.executeQuery();if(rs.next()){bu.setId(id);bu.setTitle(rs.getString("Title"));bu.setContent(rs.getString("Content"));bu.setAddTime(rs.getString("AddTime"));}else{thrownewException("Sorry:Thisbulletinnotfound!");}}finally{if(rs!=null){rs.close();}if(pstmt!=null){pstmt.close();}if(conn!=null){conn.close();}}returnbu;}/***Thismethodgetnumberbulletins*ifnumberequalszerothenreturnallbulletin*@paramnumberint*@throwsException*@returnCollection*/publicstaticCollectiongetBulletins(intnumber)throwsException{Collectionbus=newArrayList();Connectionconn=null;Statementstmt=null;ResultSetrs=null;Bulletinbu=null;Stringsql=null;try{conn=DataBaseConn.getConnection();stmt=conn.createStatement();if(number==0){sql="SELECT*FROMbulletinORDERBYidDESC";}else{sql="SELECT*FROMbulletinORDERBYidDESClimit0,"+number+"";}rs=stmt.executeQuery(sql);while(rs.next()){bu=newBulletin();bu.setId(rs.getInt(1));bu.setTitle(rs.getString(2));bu.setContent(rs.getString(3));bu.setAddTime(rs.getString(4));bus.add(bu);}}finally{if(rs!=null){rs.close();}if(stmt!=null){stmt.close();}if(conn!=null){conn.close();}}returnbus;}/***Thismethodtomodifythebulletin*@parambulletinBulletin*@throwsException*/publicstaticvoidupdateBulletin(Bulletinbulletin)throwsException{Connectionconn=null;PreparedStatementpstmt=null;try{conn=DataBaseConn.getConnection();pstmt=conn.prepareStatement("UPDATEbulletinSETTitle=?,Content=?WHEREid=?");pstmt.setString(1,bulletin.getTitle());pstmt.setString(2,bulletin.getContent());pstmt.setInt(3,bulletin.getId());pstmt.executeUpdate();}finally{if(pstmt!=null){pstmt.close();}if(conn!=null){conn.close();}}}/***Thismethodtodeleteabulletinbyid*@paramidint*@throwsException*/publicstaticvoiddelBulletin(intid)throwsException{Connectionconn=null;PreparedStatementpstmt=null;try{conn=DataBaseConn.getConnection();pstmt=conn.prepareStatement("DELETEFROMbulletinWHEREid=?");pstmt.setInt(1,id);pstmt.executeUpdate();}finally{if(pstmt!=null){pstmt.close();}if(conn!=null){conn.close();}}}/***Thismethodtoaddabulletin*@parambulletinBulletin*@throws