1、.洛 陽 理 工 學(xué) 院課 程 設(shè) 計 報 告專 業(yè) Word文檔.課 程 設(shè) 計 任 務(wù) 書圖書館管理系統(tǒng)設(shè)計題目：設(shè)計內(nèi)容與要求：1、 問題描述了解網(wǎng)上圖書館管理相關(guān)流程，實現(xiàn) B/S 模式的圖書館管理系統(tǒng)。2、基本要求（1）數(shù)據(jù)庫設(shè)計要符合范式要求。（2）能對圖書按照）等信息進(jìn)行添加、刪除、修改操作。（3）提供必要查詢功能，例如輸入圖書名稱，能查找出該圖書的相關(guān)信息，并展示圖書信息。（4）針對圖書館管理系統(tǒng)，鍛煉學(xué)生的分析、設(shè)計能力，培養(yǎng)學(xué)生對軟件文檔規(guī)范的書寫能力；（5）以圖書館管理業(yè)務(wù)為背景，通過調(diào)研、分析現(xiàn)有的管理模式和已有的管理軟件，建立系統(tǒng)模型；完成圖書館管理系統(tǒng)的軟件可行性分

2、析、項目開發(fā)計劃、需求規(guī)格說明、概要設(shè)計和詳細(xì)設(shè)計（結(jié)構(gòu)化設(shè)計方法和面向?qū)ο笤O(shè)計方法可任選（6）做好答辯工作 年 6 月 19 日課 程 設(shè) 計 評 語Word文檔.成績：指導(dǎo)教師：年 月 日Word文檔.目 錄第 1 章 需求分析 1.1 編寫目的 1.2 可行性分析 1.2.1 背景分析 1.2.2 經(jīng)濟(jì)可行性 1.1.3 技術(shù)可行性 1.3 功能需求分析 1.3.1 待開發(fā)系統(tǒng)概述 1.3.2 產(chǎn)品功能 1.4 系統(tǒng)性能分析 第 2 章 數(shù)據(jù)庫設(shè)計 111111112232.1 數(shù)據(jù)庫概念級設(shè)計（ E-R 圖） 32.1.1 實體圖 2.1.2 系統(tǒng) E-R 圖 2.2 數(shù)據(jù)庫邏輯級設(shè)計

3、 第 3 章 概要設(shè)計 3.1 系統(tǒng)功能設(shè)計 3.2 系統(tǒng)功能描述 第 4 章 詳細(xì)設(shè)計與實現(xiàn) 4.1 詳細(xì)設(shè)計概述 4.2 系統(tǒng)詳細(xì)設(shè)計 4.2.1 登陸頁面 4.2.2 圖書添加 4.2.3 借閱圖書 4.2.4 圖書查詢 4.2.5 修改密碼 第 5 章 總結(jié) 34466688881014171920Word文檔.第 1章 1.1 編寫目的1.2 可行性分析1.2.1 背景分析 1.2.2 經(jīng)濟(jì)可行性1.1.3 技術(shù)可行性1.3 功能需求分析1.3.1 待開發(fā)系統(tǒng)概述Word文檔.1.3.2 產(chǎn)品功能 1.4 系統(tǒng)性能分析 Word文檔.第2 章 2.1 數(shù)據(jù)庫概念級設(shè)計（E-R圖）2.

4、1.1 實體圖管理員圖 讀者數(shù)圖 Word文檔.圖2.1.2 系統(tǒng) E-R 圖1NMNMN圖 圖2.2 數(shù)據(jù)庫邏輯級設(shè)計表 否否否e否否否78否否無無否否表 12否否無無是否Word文檔.3456785否否否否否否無無無無無無否否否否否否表 12否否無無是是表 1234否否否否無無無無是是否否eWord文檔.第3 章 3.1 系統(tǒng)功能設(shè)計讀者檔案管理讀者類型管理圖書檔案管理管理員設(shè)置書類型管理圖書歸還圖 3.2 系統(tǒng)功能描述 Word文檔. Word文檔.第4章 4.1 詳細(xì)設(shè)計概述4.2 系統(tǒng)詳細(xì)設(shè)計4.2.1 登陸頁面圖 public partial class Login : Syste

5、m.Web.UI.PageWord文檔.OperatorClass operatorclass = new OperatorClass();AdminManage adminmanage = new AdminManage();ReaderManage readermanage = new ReaderManage();protected void Page_Load(object sender, EventArgs e)protected void btnLogin_Click(object sender, EventArgs e)if (txtAdmin.Text = string.Emp

6、ty)Response.Write(alert(管理員名?稱?不?能為a空?！?);return;elseDataSet adminds = null;DataSet readerds = null;adminmanage.Name = txtAdmin.Text;adminmanage.Pwd = txtPwd.Text;adminds = adminmanage.Login(adminmanage);readermanage.ID=txtPwd.Text;readermanage.Name=txtAdmin.Text;readerds=readermanage.ReaderLogin(re

7、adermanage);if (adminds.Tables0.Rows.Count 0 & txtCode.Text =Request.CookiesCheckCode.Value)SessionName = txtAdmin.Text;Response.Redirect(Default.aspx);else if (readerds.Tables0.Rows.Count 0 & txtCode.Text =Request.CookiesCheckCode.Value)SessionName = txtAdmin.Text;Sessionreadid = txtPwd.Text;Sessio

8、nrole = Reader;Response.Redirect(Default.aspx);elseResponse.Write(alert(登錄名或密碼不正確);Word文檔.protected void btnCancel_Click(object sender, EventArgs e)txtAdmin.Text = txtPwd.Text = txtCode.Text = string.Empty;4.2.2 圖書添加 圖 public partial class BookManage_AddBook : System.Web.UI.PageValidateClass validat

9、e=new ValidateClass();BookcaseManage bookcasemanage = new BookcaseManage();BTypeManage btypemanage = new BTypeManage();BookManagebookmanage = new BookManage();protected void Page_Load(object sender, EventArgs e)this.Title = 添加修改圖書 信息頁面;Word文檔.if (!IsPostBack)DataSet bcaseds = bookcasemanage.GetAllBC

10、ase(tb_bookcase);ddlBCase.DataSource = bcaseds;ddlBCase.DataTextField = name;ddlBCase.DataBind();DataSet btypeds = btypemanage.GetAllBType(tb_booktype);ddlBType.DataSource = btypeds;ddlBType.DataTextField = typename;ddlBType.DataBind();if (Requestbookcode = null)btnAdd.Enabled = true;txtInTime.Text

11、= DateTime.Now.ToShortDateString();elsebtnSave.Enabled = true;txtBCode.ReadOnly = txtBName.ReadOnly = true;txtBCode.Text = Requestbookcode.ToString();bookmanage.BookCode = txtBCode.Text;DataSet bookds = bookmanage.FindBookByCode(bookmanage,tb_bookinfo);txtBName.Text = bookds.Tables0.Rows01.ToString(

12、);ddlBType.SelectedValue = bookds.Tables0.Rows02.ToString();txtAuthor.Text = bookds.Tables0.Rows03.ToString();txtTranslator.Text = bookds.Tables0.Rows04.ToString();txtPub.Text = bookds.Tables0.Rows05.ToString();txtPrice.Text = bookds.Tables0.Rows06.ToString();txtPage.Text = bookds.Tables0.Rows07.ToS

13、tring();ddlBCase.SelectedValue = bookds.Tables0.Rows08.ToString();txtStorage.Text = bookds.Tables0.Rows09.ToString();txtInTime.Text = bookds.Tables0.Rows010.ToString();txtOper.Text = bookds.Tables0.Rows011.ToString();protected void btnAdd_Click(object sender, EventArgs e)ValidateFun();bookmanage.Boo

14、kCode = txtBCode.Text;if (bookmanage.FindBookByCode(bookmanage, tb_bookinfo).Tables0.Rows.Count 0)Word文檔.bookmanage.BookName = txtBName.Text;bookmanage.Type = ddlBType.SelectedValue;bookmanage.Author = txtAuthor.Text;bookmanage.Translator = txtTranslator.Text;bookmanage.PubName = txtPub.Text;bookman

15、age.Price = Convert.ToDecimal(txtPrice.Text);bookmanage.Page = Convert.ToInt32(txtPage.Text);bookmanage.Bcase = ddlBCase.SelectedValue;bookmanage.Storage = Convert.ToInt32(txtStorage.Text) +Convert.ToInt32(bookmanage.FindBookByCode(bookmanage,tb_bookinfo).Tables0.Rows09.ToString();bookmanage.InTime

16、= Convert.ToDateTime(txtInTime.Text);bookmanage.Oper = txtOper.Text;bookmanage.UpdateBook(bookmanage);elsebookmanage.BookName = txtBName.Text;bookmanage.Type = ddlBType.SelectedValue;bookmanage.Author = txtAuthor.Text;bookmanage.Translator = txtTranslator.Text;bookmanage.PubName = txtPub.Text;bookma

17、nage.Price = Convert.ToDecimal(txtPrice.Text);bookmanage.Page = Convert.ToInt32(txtPage.Text);bookmanage.Bcase = ddlBCase.SelectedValue;bookmanage.Storage = Convert.ToInt32(txtStorage.Text);bookmanage.InTime = Convert.ToDateTime(txtInTime.Text);bookmanage.Oper = txtOper.Text;bookmanage.AddBook(bookm

18、anage);Response.Redirect(BookManage.aspx);protected void btnSave_Click(object sender, EventArgs e)ValidateFun();bookmanage.BookCode = txtBCode.Text;bookmanage.BookName = txtBName.Text;bookmanage.Type = ddlBType.SelectedValue;bookmanage.Author = txtAuthor.Text;bookmanage.Translator = txtTranslator.Te

19、xt;bookmanage.PubName = txtPub.Text;bookmanage.Price = Convert.ToDecimal(txtPrice.Text);bookmanage.Page = Convert.ToInt32(txtPage.Text);bookmanage.Bcase = ddlBCase.SelectedValue;Word文檔.bookmanage.Storage = Convert.ToInt32(txtStorage.Text);bookmanage.InTime = Convert.ToDateTime(txtInTime.Text);bookma

20、nage.Oper = txtOper.Text;bookmanage.UpdateBook(bookmanage);Response.Redirect(BookManage.aspx);protected void btnCancel_Click(object sender, EventArgs e)txtInTime.Text = DateTime.Now.ToShortDateString();txtBName.Text = txtAuthor.Text = txtTranslator.Text = txtPub.Text = txtPrice.Text =txtPage.Text =

21、txtStorage.Text = txtOper.Text = string.Empty;protected void ValidateFun()if (txtBCode.Text = )Response.Write(alert(圖書條形碼不能為空！?);location=javascript:history.go(-1););return;if (txtBName.Text = )Response.Write(alert(圖書名稱不能為空！?);location=javascript:history.go(-1););return;if (!validate.validateNum(txt

22、Price.Text)Response.Write(alert(圖書價格輸入有誤！);location=javascript:history.go(-1););return;if (!validate.validateNum(txtPage.Text)Response.Write(alert(圖書頁碼輸入有誤！);location=javascript:history.go(-1););return;if (!validate.validateNum(txtStorage.Text)Response.Write(alert(圖書庫存量輸入有誤！);location=javascript:his

23、tory.go(-1););return;Word文檔.4.2.3借閱圖書圖 public partial class BookBRManage_BorrowBook : System.Web.UI.PageReaderManage readermanage = new ReaderManage();RTypeManage rtypemanage = new RTypeManage();BookManage bookmanage = new BookManage();BTypeManage btypemanage = new BTypeManage();BorrowandBackManage

24、borrowandbackmanage = new BorrowandBackManage();protected void Page_Load(object sender, EventArgs e)this.Title = 圖書借閱頁面;if (!IsPostBack)if (Sessionrole = Reader)txtReaderID.Text = Sessionreadid.ToString();gvBInfoBind();protected void btnSure_Click(object sender, EventArgs e)Word文檔.if (txtReaderID.Te

25、xt = )Response.Write(alert(讀者編號不能為空！);elsereadermanage.ID = txtReaderID.Text;DataSet readerds = readermanage.FindReaderByCode(readermanage, tb_reader);if (readerds.Tables0.Rows.Count 0)txtReader.Text = readerds.Tables0.Rows01.ToString();txtSex.Text = readerds.Tables0.Rows02.ToString();txtPaperType.T

26、ext = readerds.Tables0.Rows05.ToString();txtPaperNum.Text = readerds.Tables0.Rows06.ToString();txtRType.Text = readerds.Tables0.Rows03.ToString();elseResponse.Write(alert(該讀者不存在！);return;rtypemanage.Name = txtRType.Text;DataSet rtypeds = rtypemanage.FindRTypeByName(rtypemanage, tb_readertype);txtBNu

27、m.Text = rtypeds.Tables0.Rows02.ToString();gvBRBookBind();Sessionreaderid = txtReaderID.Text;protected void gvBookInfo_PageIndexChanging(object sender, GridViewPageEventArgs e)gvBookInfo.PageIndex = e.NewPageIndex;gvBInfoBind();protected void gvBorrowBook_PageIndexChanging(object sender, GridViewPag

28、eEventArgs e)gvBorrowBook.PageIndex = e.NewPageIndex;gvBRBookBind();protected void gvBookInfo_RowUpdating(object sender, GridViewUpdateEventArgs e)if (Sessionreaderid = null)Word文檔.Response.Write(alert(請輸入讀者編號！);elsereadermanage.ID = Sessionreaderid.ToString();DataSet readerds = readermanage.FindRea

29、derByCode(readermanage, tb_reader);if (Convert.ToInt32(readerds.Tables0.Rows013.ToString() =Convert.ToInt32(txtBNum.Text)Response.Write(alert(您最多可以借 + txtBNum.Text + elseborrowandbackmanage.ID = borrowandbackmanage.GetBorrowBookID();borrowandbackmanage.ReadID = Sessionreaderid.ToString();borrowandba

30、ckmanage.BookCode =gvBookInfo.DataKeyse.RowIndex.Value.ToString();borrowandbackmanage.BorrowTime =Convert.ToDateTime(DateTime.Now.ToShortDateString();btypemanage.TypeName = gvBookInfo.Rowse.RowIndex.Cells2.Text;int days = Convert.ToInt32(btypemanage.FindBTypeByName(btypemanage,tb_booktype).Tables0.R

31、ows02.ToString();TimeSpan tspan = TimeSpan.FromDays(double)days);borrowandbackmanage.YGBackTime = borrowandbackmanage.BorrowTime + tspan;borrowandbackmanage.BorrowOper = SessionName.ToString();borrowandbackmanage.AddBorrow(borrowandbackmanage);gvBRBookBind();bookmanage.BookCode = gvBookInfo.DataKeys

32、e.RowIndex.Value.ToString();DataSet bookds = bookmanage.FindBookByCode(bookmanage, tb_bookinfo);bookmanage.BorrowNum = Convert.ToInt32(bookds.Tables0.Rows012.ToString()+ 1;bookmanage.UpdateBorrowNum(bookmanage);readermanage.BorrowNum =Convert.ToInt32(readerds.Tables0.Rows012.ToString() + 1;readerman

33、age.Num = Convert.ToInt32(readerds.Tables0.Rows013.ToString() +1;readermanage.UpdateBorrowNum(readermanage);protected void gvBInfoBind()Word文檔.DataSet bookds = bookmanage.GetAllBook(tb_bookinfo);gvBookInfo.DataSource = bookds;gvBookInfo.DataKeyNames = new string bookcode ;gvBookInfo.DataBind();prote

34、cted void gvBRBookBind()borrowandbackmanage.ReadID = txtReaderID.Text;DataSet brinfods = borrowandbackmanage.FindBoBaBookByRID(borrowandbackmanage,view_BookBRInfo);gvBorrowBook.DataSource = brinfods;gvBorrowBook.DataBind();4.2.4 圖書查詢圖 public partial class SysQuery_BookQuery : System.Web.UI.PageBookM

35、anage bookmanage = new BookManage();protected void Page_Load(object sender, EventArgs e)Word文檔.this.Title = 圖書檔案查詢頁面;if (!IsPostBack)gvBind();protected void btnQuery_Click(object sender, EventArgs e)gvBind();protected void gvBookInfo_PageIndexChanging(object sender, GridViewPageEventArgs e)gvBookInf

36、o.PageIndex = e.NewPageIndex;gvBind();protected void gvBind()DataSet ds = null;int intCondition = ddlCondition.SelectedIndex;if (txtCondition.Text = )ds = bookmanage.GetAllBook(tb_bookinfo);elseswitch (intCondition)case 0:bookmanage.BookCode = txtCondition.Text;ds = bookmanage.FindBookByCode(bookmanage, tb_bookinfo);break;case 1:bookmanage.BookName = txtCondition.Text;ds = bookmanage.FindBookByName(bookmanage, tb_bookinfo