基于MVC的WEB文章系统-文章管理、公告管理模块

基于MVC的WEB文章系统---文章管理、公告管理模块模块开发卷宗1.标题软件系统名称和标识符名称：基于MVC的WEB文章系统标识符：WEB文章系统模块名称和标识符名称：文章管理公告管理标识符：文章标题ID号程序编制员签名彭宝修改完成日期2005-5-272.功能说明模块功能文章/公告的添加、删除、修改等功能。使用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否用户界面程序代码：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