最新C#图书管理实验报告.doc

《最新C#图书管理实验报告.doc》由会员分享，可在线阅读，更多相关《最新C#图书管理实验报告.doc（58页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、Four short words sum up what has lifted most successful individuals above the crowd: a little bit more.-author-dateC#图书管理实验报告C#图书管理实验报告C#.NET课程设计报告 项目名称: C#实现图书管理系统 组 员: 杨朝文(10060042) 王小龙(10060041) 于 通(10060044) 组员分工:于通:FormRegistered.cs FormLogin.cs(和杨朝文) 王小龙: FormAddBook.cs FormDeleteBook.cs FormR

2、eturnBook.cs 杨朝文:FormUserBorrowInfo.cs FormBorrowBook.cs 等协助组员一起学习 一. 概述 随着科学技术的快速发展，给个个领域带来空前的方便，如，图书馆的书籍管理，利用C#.NET语言和数据库实现对图书馆的书籍管理，给学校师生阅览书籍带来很大的便利，同时也大大减少了图书管理员的工作量。二. 系统分析1. 需求分析为了方便对图书馆书籍的管理，利用C#.NET技术和简易的Access数据库来实现此目的。2. 可行性分析2.1. 前台功能分析阅览者可以注册账号，登陆图书管理系统，并且能查看自己的用户信息和修改信息，查询图书，借读图书，查看自己所借

3、读的所有信息。2.2. 后台功能分析管理员登陆图书管理系统后，可以查看所有用户信息并可进行删除，查看阅览者所借读的所以信息，实现阅览者归还书籍时操作，同时可以查询书籍，更新书籍，更新书籍类型和出版社等功能。3. 功能模块划分3.1系统总体模块图书管理系统前台后台个人信息图书查询借阅图书借阅信息查询全部类型查询用户信息借阅信息图书查询书籍归还图书更新添加图书类型添加出版社查询全部类型查询添加图书删除图书3.1系统总体模块图3.2.阅览者注册登陆 开始是否注册注册输入信息数据是否合法合法注册成功开始登陆输入用户和密码是否通过登陆验证登陆成功结束YNNNYY3.2用户注册流程图3.3前台借阅功能登陆

4、开始借阅图书是否符合条件借阅成功结束NY3.3前台借阅流程图3.4后台归还书籍功能管理员登陆开始输入阅览者ID是否存在阅览者ID输入书籍号归还成功结束NY3.4后台归还书籍流程图三. 数据库设计1.E-R图 adminadminPasswordAdminId1-0. 管理员表E-R图readerreaderIdreaderPasswordreaderNamereaderSexreaderAgereaderDeptreaderZYmaxNumber1-1.阅览者表E-R图publisherpublisherIdpublisherName1-2.出版社表E-R图bookbookIdbookName

5、bookWriterifborrowbookPricepublisherIdbookTypeId1-3.书籍表E-R图borrowreaderIdbookIdborrowTimereturnTimeout1-4.书籍借阅信息表E-R图2.各表的信息介绍 2-1.admin表字段名称数据类型是否为主键说明adminId文本是管理员IDadminPassword文本管理员密码2-2.book表字段名称数据类型是否为主键说明BookId文本是书籍IDBookName文本书籍名称BookWritter文本书籍作者Ifborrow文本是否被借阅BookPrice货币书籍价格BooktypeId文本是bo

6、oktype外键publisherId文本是publisher外键2-3.booktype表字段名称数据类型是否为主键说明BooktypeId文本是书籍类型IDBooktypeName文本书籍类型名称Flow文本书籍所在楼层数2-4.borrow表字段名称数据类型是否为主键说明readerId文本是读者IDbookId文本是书籍IDborrowTime日期/时间借阅时间returnTime日期/时间到期时间Out文本是否超期2-5.publisher表字段名称数据类型是否为主键说明PublisherId文本是出版社IDpublisherName文本出版社名称 2-6.reader表字段名称数据

7、类型是否为主键说明readerId文本是读者IDreaderPassword文本读者登录密码readerName文本读者姓名ReaderSex文本读者性别ReaderAge文本读者年龄ReaderDept文本读者所在的院系readerZY文本读者的专业Maxnumber文本读者最多只能借阅书籍的数量 2-7各表之间的关系2-7.各表之间关系图四.系统各模块的功能详细介绍1.登录和注册界面1-1.登录主要代码namespace BookMS public partial class FormLogin : Form public FormLogin() InitializeComponent()

8、; private void buttonLogin_Click(object sender, EventArgs e) OdbcConnection conn = new OdbcConnection(Properties.Settings.Default.ConnectionString); if (yanzhengshuru() if (comboBoxTypeName.Text.Trim() =管理员) try String sql = string.Format(select * from admin where adminId=0, textBoxUserName.Text.Tri

9、m(); OdbcCommand cmd = new OdbcCommand(sql, conn); conn.Open(); OdbcDataReader dr = cmd.ExecuteReader(); if (dr.Read() if (dr1.ToString().Trim() = textBoxUserPsd.Text.Trim() FormAdmin admin = new FormAdmin(); admin.Show(); 1-1. 登录界面1-2. 注册主要代码 private void buttonRegistered_Click(object sender, Event

10、Args e) OdbcConnection conn = new OdbcConnection(Properties.Settings.Default.ConnectionString); String sql = String.Format(insert into reader values (0,1,2,3,4,5,6,7),id,pw,name,sex,age,dept,major,max); OdbcCommand cmd = new OdbcCommand(sql,conn); if (id != & pw != & name != & sex != & age != & dept

11、 != & major != ) try conn.Open(); int n = cmd.ExecuteNonQuery(); if (n = 0) 1-2.注册界面2.后台主要功能介绍2-1.查看借阅信息主要代码private void FormSeeBorrowInfo_Load(object sender, EventArgs e) try String sql = string.Format(select readerId from borrow); OdbcCommand cmd = new OdbcCommand(sql,conn); conn.Open(); OdbcDataR

12、eader dr = cmd.ExecuteReader(); String readerid = ; while (dr.Read() readerid = (string)dr0; comboBoxUserId.Items.Add(readerid); dr.Close(); catch (OdbcException err) MessageBox.Show(err.Message,连接失败!); finally conn.Close(); private void buttonUserS_Click(object sender, EventArgs e) String rid = com

13、boBoxUserId.Text.Trim(); dt.Clear(); String sql = string.Format(select borrow.readerId ,readerName,borrow.bookId,bookName,borrowTime,returnTime,out from borrow,reader,book where book.bookId=borrow.bookId and borrow.readerId=reader.readerId and reader.readerId=0,rid); adapter = new OdbcDataAdapter(sq

14、l,conn); adapter.Fill(dt); dataGridViewBorrowInfo.DataSource = dt; private void buttonAllS_Click(object sender, EventArgs e) String sql = string.Format(select borrow.readerId ,readerName,borrow.bookId,bookName,borrowTime,returnTime,out from borrow,reader,book where book.bookId=borrow.bookId and borr

15、ow.readerId=reader.readerId); dt.Clear(); adapter = new OdbcDataAdapter(sql,conn); adapter.Fill(dt); dataGridViewBorrowInfo.DataSource = dt; 2-1.查看借阅信息2-2.书籍归还主要代码OdbcConnection conn = new OdbcConnection(Properties.Settings.Default.ConnectionString); OdbcDataAdapter adapter; DataTable dt = new DataT

16、able(); String rid = ; String bid = ; int maxNum; private void buttonSearch_Click(object sender, EventArgs e) dt.Clear(); rid = textBoxReaderId.Text.Trim(); String sql = string.Format(select borrow.readerId ,readerName,borrow.bookId,bookName,borrowTime,returnTime,out from borrow,reader,book where bo

17、ok.bookId=borrow.bookId and borrow.readerId=reader.readerId and reader.readerId=0,rid); adapter = new OdbcDataAdapter(sql,conn); adapter.Fill(dt); dataGridViewInfo.DataSource = dt; private void buttonOK_Click(object sender, EventArgs e) bid = textBoxBookId.Text.Trim(); try conn.Open(); String sql1 =

18、 string.Format(delete from borrow where readerId=0 and bookId=1, rid, bid); OdbcCommand cmd1 = new OdbcCommand(sql1, conn); int deleteN = cmd1.ExecuteNonQuery(); String sql2 = string.Format(update book set ifborrow=否 where bookId=0, bid); OdbcCommand cmd2 = new OdbcCommand(sql2, conn); int updateN =

19、 cmd2.ExecuteNonQuery(); String sql3 = string.Format(select maxnumber from reader where readerId=0, rid); OdbcCommand cmd3 = new OdbcCommand(sql3, conn); OdbcDataReader dr = cmd3.ExecuteReader(); while (dr.Read() maxNum = (int)dr0; String sql4 = string.Format(update reader set maxnumber=0 where read

20、erId=1, maxNum + 1, rid); OdbcCommand cmd4 = new OdbcCommand(sql4, conn); int updateM = cmd4.ExecuteNonQuery(); if (deleteN != 0 & updateN != 0 & updateM != 0) finally conn.Close(); 2-2.归还书籍3.前台主要功能介绍3-1.查看自己借阅信息 public FormUserBorrowInfo(String userId) InitializeComponent(); this.userId = userId; p

21、ublic String UserId get return userId; set this.userId = value; OdbcConnection conn = new OdbcConnection(Properties.Settings.Default.ConnectionString); OdbcDataAdapter adapter; DataTable dt = new DataTable(); private void buttonOK_Click(object sender, EventArgs e) if (textBoxUserId.Text.Trim() = Use

22、rId) String sql = string.Format(select borrow.readerId ,readerName,borrow.bookId,bookName,borrowTime,returnTime,out from borrow,reader,book where book.bookId=borrow.bookId and borrow.readerId=reader.readerId and reader.readerId=0,userId); adapter = new OdbcDataAdapter(sql,conn); adapter.Fill(dt); da

23、taGridViewBInfo.DataSource = dt; else MessageBox.Show(你输入的用户ID和登陆的用户ID不一致!n你没有权限查询他人借阅信息!,提示,MessageBoxButtons.OK,MessageBoxIcon.Information); 3-1.借阅信息3-2.借阅书籍主要代码private String userId; public FormBorrowBook() InitializeComponent(); public FormBorrowBook(String userId) InitializeComponent(); this.us

24、erId = userId; OdbcConnection conn = new OdbcConnection(Properties.Settings.Default.ConnectionString); OdbcDataAdapter adapter; DataTable dt = new DataTable(); int maxNum; private void FormBorrowBook_Load(object sender, EventArgs e) textBoxUserId.Text = userId; String sql = string.Format(select book

25、Id,bookName,bookWritter,booktype.booktypeName,bookPrice,booktype.flow,publisher.publisherName,ifborrow from book,booktype,publisher where book.booktypeId=booktype.booktypeId and book.publisherId=publisher.publisherId); try adapter = new OdbcDataAdapter(sql, conn); adapter.Fill(dt); dataGridViewAll.D

26、ataSource = dt; catch (OdbcException err) MessageBox.Show(err.Message, 查询失败); private void buttonBorrow_Click(object sender, EventArgs e) String uid = textBoxUserId.Text.Trim(); String bid = textBoxBookId.Text.Trim(); DateTime borrowTime = DateTime.Now; TimeSpan a = new TimeSpan(30,0,0,0); DateTime

27、returnTime = borrowTime + a; String ifout = NO; try String sql3 = string.Format(select ifborrow from book where bookId=0,bid); OdbcCommand cmd3 = new OdbcCommand(sql3,conn); conn.Open(); OdbcDataReader dr3 = cmd3.ExecuteReader(); String ifBorrow = ; while (dr3.Read() ifBorrow = (string)dr30; dr3.Clo

28、se(); String sql4 = string.Format(select maxnumber from reader where readerId=0,uid); OdbcCommand cmd4 = new OdbcCommand(sql4,conn); OdbcDataReader dr4 = cmd4.ExecuteReader(); while (dr4.Read() maxNum = (int)dr40; dr4.Close(); if (ifBorrow != 是 & maxNum 0) if (uid != & bid != ) /conn.Open(); String

29、sql1 = string.Format(insert into borrow values (0,1,2,3,4), uid, bid, borrowTime, returnTime, ifout); OdbcCommand cmd1 = new OdbcCommand(sql1, conn); int borrown = cmd1.ExecuteNonQuery(); String sql2 = string.Format(update book set ifborrow=是 where bookId=0, bid); OdbcCommand cmd2 = new OdbcCommand(

30、sql2, conn); int bookn = cmd2.ExecuteNonQuery(); String sql5 = string.Format(update reader set maxnumber=0 where readerId=1,maxNum-1,uid); OdbcCommand cmd5 = new OdbcCommand(sql5,conn); int MN = cmd5.ExecuteNonQuery(); if (borrown != 0 & bookn != 0 & MN != 0) MessageBox.Show(借书成功!); 3-2.借阅书籍五.总结对于学习一个学期的C#语言，总体感觉和Java差不多，但是由于项目实践经验少，研发的项目思路不清晰，不过组员能一起自己思考，研发出这简易的图书管理系统，对自己学以致用，感觉挺好的。此系统的完整源代码链接:-