javaweb課程設(shè)計(jì)-在線投稿系統(tǒng).doc

數(shù)據(jù)庫應(yīng)用系統(tǒng)課程設(shè)計(jì)報(bào)告題 目: 某期刊的在線投稿審稿管理系統(tǒng)的設(shè)計(jì)與實(shí)現(xiàn) 院系名稱：信息科學(xué)與工程學(xué)院 指導(dǎo)教師： 唐建國 教師職稱： 講師 2016年12 月目錄1引言32需求分析33小組分工54數(shù)據(jù)庫設(shè)計(jì)54.1ER圖54.2關(guān)系模式64.3物理結(jié)構(gòu)設(shè)計(jì)64.4Sql語句以及存儲過程85概要設(shè)計(jì)115.1詳細(xì)設(shè)計(jì)126測試分析197測試結(jié)果208心得體會211 引言隨著網(wǎng)絡(luò)普及程度的提高，人們的辦公觀念和方式都發(fā)生了重大的改變，基于網(wǎng)絡(luò)的無紙化辦公也越來越深入人心。一個(gè)好的在線投稿系統(tǒng)，也讓雜志社給讀者形成一個(gè)好的的印象。許多雜志社、報(bào)社的編輯部都已意識到實(shí)現(xiàn)網(wǎng)上辦公和在線處理稿件的重要性和緊迫性。 在線投稿和稿件處理系統(tǒng)有效地解決了傳統(tǒng)模式下投遞和送審的各種弊端，實(shí)現(xiàn)了作者的投稿、信息查詢、信息反饋的便捷處理和編輯部規(guī)范高效化辦公，從而節(jié)省了稿件處理的時(shí)間和流通費(fèi)用，提高了稿件投遞和投審的效率和安全性，同時(shí)也保證了雜志社所有的編輯能夠在相同的業(yè)務(wù)平臺進(jìn)行業(yè)務(wù)處理，適應(yīng)了集中管理的需要。通過規(guī)范流程、強(qiáng)化內(nèi)部管理，建立強(qiáng)大的數(shù)據(jù)庫，為數(shù)據(jù)分析、人員管理等提供強(qiáng)大的支持，為用戶、專家、編輯提供了安全的權(quán)限設(shè)置，使稿件分級處理，避免了處理流程的混亂，減低工作量、減少重復(fù)勞動(dòng)。 利用在線投稿與稿件處理系統(tǒng)，作者只要進(jìn)行注冊，即可進(jìn)行稿件的投遞與查閱，編輯部和專家可以將傳來的稿件存盤后即可在電腦上進(jìn)行編輯加工即在線編輯，既簡便又準(zhǔn)確，又提高期刊編輯出版的效率。 開發(fā)此系統(tǒng)是為了提高辦公效率，適應(yīng)信息網(wǎng)絡(luò)時(shí)代期刊發(fā)展的趨勢，也為了滿足人們對信息實(shí)時(shí)性、安全性及便捷性的需求2 需求分析報(bào)投稿管理系統(tǒng)是一個(gè)典型的數(shù)據(jù)庫開發(fā)應(yīng)用程序，由投稿管理、審稿管理、稿件管理、審稿人管理、系統(tǒng)管理等部分組成，規(guī)劃系統(tǒng)功能模塊如下： 投稿人模塊分為三小塊：（本人完成的投稿人模塊） 投遞稿件：主要是將自己的稿件進(jìn)行上傳，以及其他信息 查看投稿狀態(tài)：查閱自己投遞的稿件是否通過，以及稿費(fèi) 修改個(gè)人信息：主要是個(gè)人聯(lián)系方式的修改 該模塊主要功能是接收投稿人的基礎(chǔ)信息，以便完成后續(xù)投稿工作。包括投稿人的聯(lián)系方式，以及電話等等 審稿人模塊分為兩個(gè)模塊 審稿：主要功能是對投稿人提交的稿件進(jìn)行審核給出相應(yīng)的審核意見，期間審稿人可以跟管理員進(jìn)行相應(yīng)得會話以提高稿件的審核進(jìn)度，最后審稿人可以管理已經(jīng)審核的稿件修改個(gè)人信息：主要是個(gè)人聯(lián)系方式管理員模塊分為四個(gè)模塊：（本人完成分配稿件，管理版面費(fèi)，稿費(fèi)模塊） 分配稿件任務(wù)：管理員將上傳的稿件進(jìn)行分配給審稿人，讓審稿人進(jìn)行審查管理審稿人：主要是對審稿人的增加刪除的管理查看審查狀態(tài)：查看已經(jīng)審閱通過的稿件投稿管理系統(tǒng)審稿人管理員投稿人分配稿件任務(wù)管理審稿人查看審稿狀態(tài)管理版面費(fèi)，稿費(fèi)個(gè)人設(shè)置審稿投遞稿件查看投稿狀態(tài)修改個(gè)人信息管理版面費(fèi)，稿費(fèi)：看到已經(jīng)審閱過的稿件，輸入相應(yīng)的版面費(fèi)，稿費(fèi)3 小組分工本人完成的模塊包括：投稿人模塊的三個(gè)模塊，以及管理員模塊中的分配稿件，管理版面費(fèi)，稿費(fèi)模塊，引言，數(shù)據(jù)庫系統(tǒng)需求描述共同完成部分：存儲過程，er圖，數(shù)據(jù)庫的設(shè)計(jì)，觸發(fā)器，關(guān)系模式4 數(shù)據(jù)庫設(shè)計(jì)4.1 ER圖說明：投稿人與稿件是投稿關(guān)系，1：n，生成投稿時(shí)間，審稿費(fèi)，審稿費(fèi)狀態(tài)審稿人與稿件是審稿關(guān)系，m：n，生成審查狀態(tài)，是否通過，評語管理員與稿件是管理關(guān)系，m:n，生成發(fā)表時(shí)間，稿費(fèi)，稿費(fèi)狀態(tài)，版面費(fèi)，版面費(fèi)狀態(tài)4.2 關(guān)系模式關(guān)系模型：投稿人：（賬號，密碼，姓名，電話，地址，郵箱，銀行卡號）稿件： （編號，標(biāo)題，摘要，類型，字?jǐn)?shù)，投稿時(shí)間，審稿費(fèi)，審稿費(fèi)狀態(tài)，作者賬號）審稿人：（賬號，密碼，姓名，電話）管理員：（賬號，密碼，姓名，電話）審稿： （審稿人賬號，稿件編號，審查狀態(tài)，是否通過，評語）稿件管理：（管理員賬號，稿件編號，發(fā)表日期，稿費(fèi)，稿費(fèi)狀態(tài)，版面費(fèi)，版面費(fèi)狀態(tài)）4.3 物理結(jié)構(gòu)設(shè)計(jì)投稿人表：writer字段名稱字段類型是否為空字段描述備注writerIdintNot null投稿人登錄的賬號PKpasswordVarchar(30)Not null投稿人密碼nameVarchar(30)Not null投稿人姓名phoneNchar(11)Not null電話addressVarchar(100)Not null 通信地址emailVarchar(30)Not null郵箱cardIDVarchar(30)Not null銀行卡號稿件表：article字段名稱字段類型是否為空字段描述備注articleIdintNot null稿件編號PKtitleVarchar(50)Not null標(biāo)題abstractVarchar(1000)Not null摘要typeVarchar(50)Not null類型lengthintNot null字?jǐn)?shù)timeDatetimeNot null 投稿日期reviewfeefloatNot null審稿費(fèi)reviewfeeStatusVarchar(30)Not null審稿費(fèi)狀態(tài)writerIdintNot null投稿人idFK,對應(yīng)writer表的writerid審稿人：（賬號，密碼，姓名，電話）Reviewer字段名稱字段類型是否為空字段描述備注reviewerIDintNot null 審稿人賬號PKpasswordVarchar(30)Not null 密碼nameVarchar(30)Not null姓名phoneNchar(11)Not null電話管理員：（賬號，密碼，姓名，電話）Administrator字段名稱字段類型是否為空字段描述備注adminIDintNot null 管理員賬號PKpasswordVarchar(30)Not null 密碼nameVarchar(30)Not null姓名phoneNchar(11)Not null電話審稿： （審稿人賬號，稿件編號，審查狀態(tài)，是否通過，評語）Review字段名稱字段類型是否為空字段描述備注reviewerIDintNot null審稿人IDPK聯(lián)合主鍵FK Reviewer表的外鍵articleIDIntNot null稿件編號PK FKArticle表的外鍵reviewStatusVarchar(30)Not null審查狀態(tài)passedVarchar(30)記錄稿件是否通過commentsVarchar(1000)審稿人的評語稿件管理：（管理員賬號，稿件編號，發(fā)表日期，稿費(fèi)，稿費(fèi)狀態(tài)，版面費(fèi)，版面費(fèi)狀態(tài)）articleManagement字段名稱字段類型是否為空字段描述備注adminIDintNot null審稿人IDPK聯(lián)合主鍵 FK administrator表的外鍵articleIDintNot null已經(jīng)通過的稿件編號PK 聯(lián)合主鍵FK article表的外鍵datedatetimeNot null發(fā)表日期articleFeefloat稿費(fèi)articleFeeStatusVarchar(30)Not null稿費(fèi)發(fā)放狀態(tài)spaceFeefloat版面費(fèi)spaceFeeStatusVarchar(30)Not null版面費(fèi)是否收到4.4 Sql語句以及存儲過程create database onlineSubmission;use onlineSubmission;CREATE TABLE writer (writerIdintNot null primary key,passwordVarchar(30)Not null,nameVarchar(30)Not null,phoneNchar(11)Not null,addressVarchar(100)Not null ,emailVarchar(30)Not null,cardIDVarchar(30)Not null);CREATE TABLE article (articleIdintNot null primary key,titleVarchar(50)Not null,abstractVarchar(1000)Not null,typeVarchar(50)Not null,lengthintNot null,timedatetimeNot null ,reviewfeefloatNot null,reviewfeeStatusVarchar(30)Not null,writerIdintNot null ,foreign key(writerId) references writer(writerID);CREATE TABLE reviewer (reviewerIDintNot null primary key,passwordVarchar(30)Not null ,nameVarchar(30)Not null,phoneNchar(11)Not null,);CREATE TABLE administrator (adminIDintNot null primary key,passwordVarchar(30)Not null ,nameVarchar(30)Not null,phoneNchar(11)Not null);CREATE TABLE review (reviewerIDintNot null,articleIDintNot null,reviewStatusVarchar(30)Not null,passedVarchar(30),commentsVarchar(1000),primary key(reviewerID,articleID),foreign key(reviewerID) references reviewer(reviewerID),foreign key(articleID) references article(articleID);CREATE TABLE articleManagement (adminIDintNot null,articleIDintNot null,datedatetimeNot null,articleFeefloat,articleFeeStatusVarchar(30)Not null,spaceFeefloat,spaceFeeStatusVarchar(30)Not null,primary key(adminID,articleID),foreign key(adminID) references administrator(adminID),foreign key(articleID) references article(articleID)CREATE PROCEDURE getreviewerlist pageSize INT, pageIndex INTasSELECT reviewerid,password,name,phoneFROM ( SELECT TOP ( pageSize * pageIndex ) ROW_NUMBER() OVER ( ORDER BY reviewerid Asc ) AS rownum ,* FROM reviewer ) AS tempWHERE temp.rownum ( pageSize * ( pageIndex - 1 ) )ORDER BY temp.revieweridUSE onlineGO/* Object: StoredProcedure dbo.getArticleBywriterIDPage Script Date: 2017/1/2 16:42:34 */SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER PROCEDURE dbo.getArticleBywriterIDPage pageSize INT, pageIndex INT, writerid intasSELECT articleid,title,abstract,type,length,time,reviewfee,reviewfeestatus,writeridFROM ( SELECT TOP ( pageSize * pageIndex ) ROW_NUMBER() OVER ( ORDER BY articleID Asc ) AS rownum ,* FROM article where writerid = writerid ) AS tempWHERE temp.rownum ( pageSize * ( pageIndex - 1 ) )ORDER BY temp.articleidUSE onlineGO/* Object: StoredProcedure dbo.getreviewerlist Script Date: 2017/1/2 16:43:06 */SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER PROCEDURE dbo.getreviewerlist pageSize INT, pageIndex INTasSELECT reviewerid,password,name,phoneFROM ( SELECT TOP ( pageSize * pageIndex ) ROW_NUMBER() OVER ( ORDER BY reviewerid Asc ) AS rownum ,* FROM reviewer ) AS tempWHERE temp.rownum ( pageSize * ( pageIndex - 1 ) )ORDER BY temp.reviewerid5 概要設(shè)計(jì)該系統(tǒng)采取的是web開發(fā)模式，采用mvc架構(gòu)，具體環(huán)境如下：開發(fā)環(huán)境：MyEclipse 2015。開發(fā)語言：JSP+JAVA+servlet。后臺數(shù)據(jù)庫：mysql。開發(fā)環(huán)境運(yùn)行平臺：Windows10瀏覽器：FireFox。投稿人：管理員模塊：審稿人模塊：5.1 詳細(xì)設(shè)計(jì)投稿人：package com.online.web;import java.io.File;import java.io.FileOutputStream;import java.io.IOException;import java.io.InputStream;import java.sql.Date;import java.util.List;import java.util.UUID;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import mons.fileupload.FileItem;import mons.fileupload.FileUploadException;import mons.fileupload.disk.DiskFileItemFactory;import mons.fileupload.servlet.ServletFileUpload;public class upload extends HttpServlet /* * The doGet method of the servlet. * * This method is called when a form has its tag value method equals to get. * * param request the request send by the client to the server * param response the response send by the server to the client * throws ServletException if an error occurred * throws IOException if an error occurred */public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException String path = this.getServletContext().getRealPath(/WEB-INF/down); DiskFileItemFactory dis = new DiskFileItemFactory(); dis.setRepository(new File(this.getServletContext().getRealPath(/WEB-INF/temp); ServletFileUpload upload = new ServletFileUpload(dis); upload.setHeaderEncoding(UTF-8); List list = null;try list = upload.parseRequest(request); catch (FileUploadException e) / TODO Auto-generated catch blocke.printStackTrace(); for(FileItem item : list)if(item.isFormField()/fileitem中封裝的是普通輸入項(xiàng)的數(shù)據(jù)String name = item.getFieldName();String value = item.getString(UTF-8);if(name.equals(time)long i = System.currentTimeMillis(); Date d = new Date(i); java.sql.Timestamp st = new java.sql.Timestamp(d.getTime(); request.getSession(false).setAttribute(name+1, st);request.getSession().setAttribute(name, value);/value = new String(value.getBytes(iso8859-1),UTF-8);System.out.println(name + = + value);else/fileitem中封裝的是上傳文件String filename = item.getName(); /不同的瀏覽器提交的文件是不一樣 c:ab1.txt 1.txtSystem.out.println(filename);if(filename=null | filename.trim().equals()continue; long i = System.currentTimeMillis();filename = i+filename.substring(filename.lastIndexOf()+1);request.getSession().setAttribute(file, filename);InputStream in = item.getInputStream();/得到文件保存的名稱/得到文件的保存目錄FileOutputStream out = new FileOutputStream(path + + filename);System.out.print(path + + filename);byte buffer = new byte1024;int len = 0;while(len=in.read(buffer)0)out.write(buffer, 0, len); in.close();out.close();item.delete(); /刪除臨時(shí)文件 String length2 = (String) request.getSession().getAttribute(length); String money = Integer.parseInt(length2)/100+; request.setAttribute(message, money); request.getRequestDispatcher(/give.jsp).forward(request, response);/* * The doPost method of the servlet. * * This method is called when a form has its tag value method equals to post. * * param request the request send by the client to the server * param response the response send by the server to the client * throws ServletException if an error occurred * throws IOException if an error occurred */public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException doGet(request,response);管理員：package com.online.web.admin;import java.io.IOException;import java.util.List;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import com.online.dao.Page;import com.online.service.bussiness;public class allocate extends HttpServlet /* * The doGet method of the servlet. * * This method is called when a form has its tag value method equals to get. * * param request the request send by the client to the server * param response the response send by the server to the client * throws ServletException if an error occurred * throws IOException if an error occurred */public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException String page = request.getParameter(page);String page3 = request.getParameter(pageNum); bussiness b = new bussiness(); request.setAttribute(rer, b.getReviewer(); if(page=null) Page page2 = new Page();Page pagereal = b.getAllatricle(page2);request.setAttribute(page, pagereal);request.getRequestDispatcher(/admin/allocate.jsp).forward(request, response);return; if(page.equals(next)Page page2 = new Page();page2.setNext(page);page2.setPageNum(Integer.parseInt(page3);Page pagereal = b.getAllatricle(page2);request.setAttribute(page, pagereal);request.getRequestDispatcher(/admin/allocate.jsp).forward(request, response);return ;if(page.equals(last)Page page2 = new Page();page2.setLast(page);page2.setPageNum(Integer.parseInt(page3);Page pagereal = b.getAllatricle(page2);request.setAttribute(page, pagereal);request.getRequestDispatcher(/admin/allocate.jsp).forward(request, response);return ;if(page.equals(firstpage)Page page2 = new Page();page2.setFirstPageNum(page);page2.setPageNum(Integer.parseInt(page3);Page pagereal = b.getAllatricle(page2);request.setAttribute(page, pagereal);request.getRequestDispatcher(/admin/allocate.jsp).forward(request, response);return ;if(page.equals(lastpage)Page page2 = new Page();page2.setLastPageNum(page);page2.setPageNum(Integer.parseInt(page3);Page pagereal = b.getAllatricle(page2);request.setAttribute(page, pagereal);request.getRequestDispatcher(/admin/allocate.jsp).forward(request, response);return ;/* * The doPost method of the servlet. * * This method is called when a form has its tag value method equals to post. * * param request the request send by the client to the server * param response the response send by the server to the client * throws ServletException if an error occurred * throws IOException if an error occurred */public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException doGet(request,response);審稿人：package com.online.web.reviewer;import java.io.IOException;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import com.online.dao.ReviewDAO;import com.online.domain.Review;public class DealArticleServlet extends HttpServlet /* * */private static final long serialVersionUID = 1L;public void doGet(HttpServletRequest request, HttpServletResponse