《C MySQL 圖書(shū)管理系統(tǒng).docx》由會(huì)員分享，可在線(xiàn)閱讀，更多相關(guān)《C MySQL 圖書(shū)管理系統(tǒng).docx（19頁(yè)珍藏版）》請(qǐng)?jiān)谘b配圖網(wǎng)上搜索。
1、C#面向?qū)ο蟪绦蛟O(shè)計(jì)課程設(shè)計(jì)圖書(shū)借閱管理系統(tǒng)源碼下載地址：http:/ 系：計(jì)算機(jī)學(xué)院專(zhuān) 業(yè)：計(jì)算機(jī)科學(xué)與技術(shù)年 級(jí)：2014級(jí)學(xué)生姓名：/ 學(xué) 號(hào)：/教 師：/日 期： 2017年6月6日開(kāi)發(fā)和運(yùn)行環(huán)境- 開(kāi)發(fā)環(huán)境：Windows 10-1703；- 開(kāi)發(fā)工具：Visual Studio 013 Update5；- 數(shù)據(jù)庫(kù)工具：Mysql 5.7 + NaviCat；- 運(yùn)行環(huán)境：Windows 10-1703；需求分析1.【角色】用戶(hù)通過(guò)【注冊(cè)】成為本系統(tǒng)的可訪問(wèn)成員，通過(guò)【登陸】進(jìn)入系統(tǒng)。用戶(hù)可以操作的功能有：-查看圖書(shū)館的所有圖書(shū)信息，圖書(shū)的是否可借閱信息；-搜索功能：通過(guò)輸入關(guān)鍵字，
2、來(lái)查找是否有自己需要的圖書(shū)；-借閱功能：未被其他用戶(hù)借閱的書(shū)籍可以直接借閱；-還書(shū)功能：若存在之前借閱的書(shū)籍，在未歸還的情況下，可以進(jìn)行還書(shū)操作，若未存在需要還的書(shū)籍，提示：未有需要?dú)w還的書(shū)籍；-個(gè)人信息：修改除了【用戶(hù)名】以外之前注冊(cè)的全部信息；-借閱信息：可以查看借閱歷史，曾經(jīng)的借書(shū)日期和還書(shū)日期，是否有未歸還的書(shū)等等；2.【角色】管理員通過(guò)【登陸】進(jìn)入用戶(hù)進(jìn)入不了的管理系統(tǒng)。管理員可以操作的功能有：-圖書(shū)信息修改：修改除了圖書(shū)名的現(xiàn)有的所有圖書(shū)信息；-添加圖書(shū)：添加新的圖書(shū)；-查看用戶(hù)信息：可以查看用戶(hù)表的部分用戶(hù)信息；3數(shù)據(jù)保存：需要長(zhǎng)期保存在數(shù)據(jù)庫(kù)的數(shù)據(jù)有：-圖書(shū)信息：圖書(shū)的基本信息
3、；-讀者信息：讀者的基本信息；-借閱信息：圖書(shū)的借閱信息；-帳號(hào)信息：圖書(shū)管理員和讀者的登錄帳號(hào)； 系統(tǒng)流程圖（不包含注冊(cè)功能）數(shù)據(jù)庫(kù)設(shè)計(jì)說(shuō)明- 管理員表：adminInfo；- 圖書(shū)信息表：bookInfo；- 借閱信息表：borrowed；- 用戶(hù)信息表：userInfo；adminInfo表列名數(shù)據(jù)類(lèi)型可否為空長(zhǎng)度說(shuō)明adminIdint否11管理員IDadminNamevarchar否255管理員用戶(hù)名adminPasswordvarchar否255管理員密碼bookInfo表列名數(shù)據(jù)類(lèi)型可否為空長(zhǎng)度說(shuō)明bookIdint否11圖書(shū)編號(hào)IDbookNamevarchar否255圖書(shū)名b
4、ookAuthorvarchar否255圖書(shū)作者bookPriceint否11圖書(shū)價(jià)格bookPressvarchar否255圖書(shū)出版社bookTypevarchar是255圖書(shū)類(lèi)型isBorrowedtinyint是11是否被借閱borrowIdint是11借閱人的IDBorrowedTimedatetime是0被借閱的時(shí)間borrowed表列名數(shù)據(jù)類(lèi)型可否為空長(zhǎng)度說(shuō)明borrowedIdint否11借閱信息IDuserIdint是11操作人IDuserNamevarchar是255操作人用戶(hù)名bookIdint是11圖書(shū)IDeditTimedatatime是0操作時(shí)間bookNamevar
5、char是255圖書(shū)名editvarchar是255操作名UserInfo表列名數(shù)據(jù)類(lèi)型可否為空長(zhǎng)度說(shuō)明userIdint否11用戶(hù)IDuserNamevarchar否255用戶(hù)名userPasswordvarchar否255用戶(hù)密碼userSexvarchar是255用戶(hù)性別模塊分析cs文件：主界面：主要顯示代碼 mainCenter.cs ：public mainCenter() InitializeComponent(); string sql = server=localhost;user id=root;password=123456;database=C#librarycenter
6、; /根據(jù)自己的設(shè)置 MySqlConnection conn = new MySqlConnection(sql); conn.Open();/打開(kāi)數(shù)據(jù)庫(kù)連接 MySqlDataAdapter data1 = new MySqlDataAdapter();/實(shí)例化sqldataadpter MySqlCommand cmd1 = new MySqlCommand(SELECT bookName as 圖書(shū)名,bookAuthor as 作者,bookPrice as 圖書(shū)價(jià)格,bookPress as 出版社,bookType as 圖書(shū)類(lèi)型,(CASE isBorrowed WHEN 0
7、THEN 未借閱 ELSE 已借閱 END) as借閱情況 FROM c#librarycenter.bookinfo, conn);/sql語(yǔ)句 data1.SelectCommand = cmd1;/設(shè)置為已實(shí)例化SqlDataAdapter的查詢(xún)命令 DataTable dt = new DataTable(); dt.Clear(); data1.Fill(dt);/把數(shù)據(jù)填充到datatable dataGridView1.DataSource = dt;/將數(shù)據(jù)集綁定datagridview,完成顯示 dataGridView1.AllowUserToAddRows = false
8、; / login login = new login(); label1.Text = 這里是SMART-LIBRARY！用戶(hù)： + login.username; / 查找功能：主要實(shí)現(xiàn)代碼：private void button1_Click(object sender, EventArgs e) String so = textBox1.Text; String sql = server=localhost;user id=root;password=123456;database=C#librarycenter; /根據(jù)自己的設(shè)置 MySqlConnection conn = new
9、 MySqlConnection(sql); conn.Open();/打開(kāi)數(shù)據(jù)庫(kù)連接 MySqlDataAdapter data1 = new MySqlDataAdapter();/實(shí)例化sqldataadpter MySqlCommand cmd1 = new MySqlCommand(SELECT bookName as 圖書(shū)名,bookAuthor as 作者,bookPrice as 圖書(shū)價(jià)格,bookPress as 出版社,bookType as 圖書(shū)類(lèi)型,(CASE isBorrowed WHEN 0 THEN 未借閱 ELSE 已借閱 END) as借閱情況 FROM c#
10、librarycenter.bookinfo where bookName like %+ so +% , conn);/sql語(yǔ)句 data1.SelectCommand = cmd1;/設(shè)置為已實(shí)例化SqlDataAdapter的查詢(xún)命令 /DataSet ds1 = new DataSet();/實(shí)例化dataset DataTable dt = new DataTable(); dt.Clear(); data1.Fill(dt);/把數(shù)據(jù)填充到datatable dataGridView1.DataSource = dt;/將數(shù)據(jù)集綁定datagridview,完成顯示 dataGr
11、idView1.AllowUserToAddRows = false; 借閱功能：主要實(shí)現(xiàn)代碼 - borrow.cs：private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) int r = this.dataGridView1.CurrentRow.Index; string h = this.dataGridView1.Rowsr.Cells1.Value.ToString(); string s = this.dataGridView1.Rowsr.Cells2.Val
12、ue.ToString(); / login login = new login(); String userId = ; DateTime dt = DateTime.Now; String borrowedTime = dt.ToString(yyyy-MM-dd HH:mm:ss); string sql = server=localhost;user id=root;password=123456;database=C#librarycenter; /根據(jù)自己的設(shè)置 MySqlConnection conn = new MySqlConnection(sql); String upda
13、teBorrow1 = select userId from userInfo where userName = +login.username+; MySqlCommand mysqlcommand = new MySqlCommand(updateBorrow1,conn); conn.Open(); MySqlDataReader mdr = mysqlcommand.ExecuteReader(); if (mdr.Read() userId = mdr.GetString(0).ToString(); mdr.Close(); String updateBorrow2 = updat
14、e bookInfo set isBorrowed = 1, borrowId = + userId + ,borrowedTime = + borrowedTime + where bookId = + h + ; / MySqlCommand mysqlcommand2 = new MySqlCommand(updateBorrow2, conn); int i = mysqlcommand2.ExecuteNonQuery(); if (i != -1) MessageBox.Show(login.username + rn恭喜你借 + rn這本書(shū) + 成功); else Message
15、Box.Show(系統(tǒng)出了點(diǎn)問(wèn)題，請(qǐng)聯(lián)系管理員！); /更新借閱表 String updateBorrow3 = insert into borrowed(userId,userName,bookId,editTime,bookName,edit) values( + userId + , + login.username + , + h + , + borrowedTime + , + s + ,借書(shū)); MySqlCommand mysqlcommand3 = new MySqlCommand(updateBorrow3, conn); mysqlcommand3.ExecuteNonQu
16、ery(); /刷新dataGridView1，重新綁定數(shù)據(jù)源 f5(); 歸還圖書(shū)功能：主要實(shí)現(xiàn)代碼 returnbook.cs：private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) int r = this.dataGridView1.CurrentRow.Index; string h = this.dataGridView1.Rowsr.Cells1.Value.ToString(); string s = this.dataGridView1.Rowsr.Cell
17、s2.Value.ToString(); DateTime dt = DateTime.Now; String returnedTime = dt.ToString(yyyy-MM-dd HH:mm:ss); String userId = ; string sql = server=localhost;user id=root;password=123456;database=C#librarycenter; /根據(jù)自己的設(shè)置 MySqlConnection conn = new MySqlConnection(sql); conn.Open(); / String updateBorrow
18、1 = update bookInfo set isBorrowed = 0,borrowId = null,borrowedTime = null where bookId = +h+; MySqlCommand mysqlcommand2 = new MySqlCommand(updateBorrow1, conn); int i = mysqlcommand2.ExecuteNonQuery(); if (i != -1) MessageBox.Show(login.username + rn rn這本書(shū)，還書(shū)成功); else MessageBox.Show(系統(tǒng)出了點(diǎn)問(wèn)題，請(qǐng)聯(lián)系管理
19、員！); /更新借閱表 String updateBorrow = select userId from userInfo where userName = + login.username + ; MySqlCommand mysqlcommand = new MySqlCommand(updateBorrow, conn); MySqlDataReader mdr = mysqlcommand.ExecuteReader(); if (mdr.Read() userId = mdr.GetString(0).ToString(); mdr.Close(); String updateBor
20、row2 = insert into borrowed(userId,userName,bookId,editTime,bookName,edit) values( + userId + , + login.username + , + h + , + returnedTime + , + s + ,還書(shū)); MySqlCommand mysqlcommand3 = new MySqlCommand(updateBorrow2, conn); mysqlcommand3.ExecuteNonQuery(); /刷新dataGridView1，重新綁定數(shù)據(jù)源 f5(); 修改個(gè)人信息：主要實(shí)現(xiàn)代
21、碼 editUser.cs：private void button1_Click(object sender, EventArgs e) login login = new login(); String pw = textBox1.Text; String npw = textBox2.Text; String un = login.username; String userPassword = ; String userId = ; if (male.Checked = true) ans = male; if (female.Checked = true) ans = female; S
22、tring sql = server=localhost;user id=root;password=123456;database=C#librarycenter; /根據(jù)自己的設(shè)置 MySqlConnection conn = new MySqlConnection(sql); conn.Open(); / String yanzheng = SELECT userPassword FROM userinfo where userName = +login.username+; MySqlCommand yz = new MySqlCommand(yanzheng,conn); MySql
23、DataReader mdr2 = yz.ExecuteReader(); if (mdr2.Read() userPassword = mdr2.GetString(0); mdr2.Close(); if (textBox2.Text.Trim() != ) if (pw = userPassword) / String editsql1 = select userId from userInfo where userName = + login.username + ; MySqlCommand cmd1 = new MySqlCommand(editsql1, conn); MySql
24、DataReader mdr = cmd1.ExecuteReader(); if (mdr.Read() userId = mdr.GetString(0); else mdr.Close(); / String editsql2 = update userInfo set userPassword = + npw + , userSex = + ans + where userId = + userId + ; MySqlCommand cmd2 = new MySqlCommand(editsql2, conn); int i = cmd2.ExecuteNonQuery(); if (
25、i = 1) MessageBox.Show(login.username + rn您的信息修改成功！rn請(qǐng)牢記您現(xiàn)在的密碼); else MessageBox.Show(修改失敗，請(qǐng)聯(lián)系管理員); else MessageBox.Show(你的原密碼輸入錯(cuò)誤，請(qǐng)重新輸入啊啊啊); else MessageBox.Show(新的密碼請(qǐng)不要填空！); 查詢(xún)借閱信息：主要實(shí)現(xiàn)代碼 borrowedinfo.cs：public borrowedinfo() InitializeComponent(); label1.Text = login.username + ,以下是您的借閱記錄：; Strin
26、g sql = server=localhost;user id=root;password=123456;database=C#librarycenter; /根據(jù)自己的設(shè)置 MySqlConnection conn = new MySqlConnection(sql); conn.Open();/打開(kāi)數(shù)據(jù)庫(kù)連接 String userId = ; MySqlCommand cmd = new MySqlCommand(select userId from borrowed where userName = + login.username +,conn); MySqlDataReader
27、mdr = cmd.ExecuteReader(); if (mdr.Read() userId = mdr.GetString(0); mdr.Close(); MySqlDataAdapter data1 = new MySqlDataAdapter();/實(shí)例化sqldataadpter MySqlCommand cmd1 = new MySqlCommand(select bookId as 圖書(shū)編號(hào),bookName as 圖書(shū)名,editTime as 操作時(shí)間,edit as 操作 from borrowed where userId = + userId +, conn);/s
28、ql語(yǔ)句 data1.SelectCommand = cmd1;/設(shè)置為已實(shí)例化SqlDataAdapter的查詢(xún)命令 /DataSet ds1 = new DataSet();/實(shí)例化dataset DataTable dt = new DataTable(); dt.Clear(); data1.Fill(dt);/把數(shù)據(jù)填充到datatable dataGridView1.DataSource = dt;/將數(shù)據(jù)集綁定datagridview,完成顯示 dataGridView1.AllowUserToAddRows = false; 后臺(tái)管理系統(tǒng)：主要實(shí)現(xiàn)代碼 adminCenter.
29、cs：private void 關(guān)于ToolStripMenuItem_Click(object sender, EventArgs e) MessageBox.Show(制作者：Matthew Hanrn完成時(shí)間：2017-6-4); private void 退出系統(tǒng)ToolStripMenuItem_Click(object sender, EventArgs e) System.Environment.Exit(0); private void 圖書(shū)管理ToolStripMenuItem_Click(object sender, EventArgs e) editMain editMa
30、in = new editMain(); editMain.FormBorderStyle = FormBorderStyle.None; editMain.Dock = DockStyle.Fill; editMain.TopLevel = false; this.panel1.Controls.Clear(); this.panel1.Controls.Add(editMain); editMain.Show(); private void 添加圖書(shū)ToolStripMenuItem_Click(object sender, EventArgs e) edit2 edit2 = new e
31、dit2(); edit2.Show(); private void 用戶(hù)管理ToolStripMenuItem_Click(object sender, EventArgs e) edit3 edit3 = new edit3(); edit3.FormBorderStyle = FormBorderStyle.None; edit3.Dock = DockStyle.Fill; edit3.TopLevel = false; this.panel1.Controls.Clear(); this.panel1.Controls.Add(edit3); edit3.Show(); 修改圖書(shū)信息
32、：主要實(shí)現(xiàn)代碼 editMain.cs & edit1.cs：public static string bookname; public static string bookauthor; public static string bookprice; public static string bookpress; public static string booktype;/說(shuō)明：這里用的是全局靜態(tài)變量，把表格獲取到的數(shù)據(jù)保存起來(lái)，進(jìn)行數(shù)據(jù)傳輸。private void dataGridView1_CellContentClick(object sender, DataGridViewCel
33、lEventArgs e) int r = this.dataGridView1.CurrentRow.Index; string bn = this.dataGridView1.Rowsr.Cells1.Value.ToString(); string ba = this.dataGridView1.Rowsr.Cells2.Value.ToString(); string bp1 = this.dataGridView1.Rowsr.Cells3.Value.ToString(); string bp2 = this.dataGridView1.Rowsr.Cells4.Value.ToS
34、tring(); string bt = this.dataGridView1.Rowsr.Cells5.Value.ToString(); / editMain editMain = new editMain(); editMain.bookname = bn.ToString(); editMain.bookauthor = ba.ToString(); editMain.bookprice = bp1.ToString(); editMain.bookpress = bp2.ToString(); editMain.booktype = bt.ToString(); / edit1 ed
35、it1 = new edit1(); edit1.Show(); /接下來(lái)是edit1.cs中的提交新的數(shù)據(jù)，update數(shù)據(jù)庫(kù)。public edit1() InitializeComponent(); editMain editMain = new editMain(); label6.Text = editMain.bookname; textBox1.Text = editMain.bookauthor; textBox2.Text = editMain.bookprice; textBox3.Text = editMain.bookpress; textBox4.Text = edi
36、tMain.booktype; private void button1_Click(object sender, EventArgs e) String bn = editMain.bookname; String ba = textBox1.Text; String bp1 = textBox2.Text; String bp2 = textBox3.Text; String bt = textBox4.Text; / String sql = server=localhost;user id=root;password=123456;database=C#librarycenter; /
37、根據(jù)自己的設(shè)置 MySqlConnection conn = new MySqlConnection(sql); conn.Open(); / String sql2 = update bookInfo set bookAuthor = + ba + , bookPrice = + bp1 + , bookPress = + bp2 + ,bookType = + bt + where bookName = + bn + ; MySqlCommand cmd = new MySqlCommand(sql2, conn); int i = cmd.ExecuteNonQuery(); if (i
38、 = 1) MessageBox.Show(圖書(shū)修改成功！); this.Hide(); 添加圖書(shū)：主要實(shí)現(xiàn)代碼 edit2.cs：private void button1_Click(object sender, EventArgs e) String bn = textBox5.Text; String ba = textBox1.Text; String bp1 = textBox2.Text; String bp2 = textBox3.Text; String bt = textBox4.Text; / String sql = server=localhost;user id=ro
39、ot;password=123456;database=C#librarycenter; /根據(jù)自己的設(shè)置 MySqlConnection conn = new MySqlConnection(sql); conn.Open(); String sql2 = insert into bookInfo(bookName,bookAuthor,bookPrice,bookPress,bookType,isBorrowed) values( + bn + , + ba + , + bp1 + , + bp2 + , + bt + ,0) ; MySqlCommand cmd = new MySqlC
40、ommand(sql2, conn); int i = cmd.ExecuteNonQuery(); if (i = 1) MessageBox.Show(圖書(shū)添加成功！); else MessageBox.Show(系統(tǒng)出錯(cuò)！); this.Hide(); 用戶(hù)管理：主要實(shí)現(xiàn)代碼 edit3.cs：public edit3() InitializeComponent(); String sql = server=localhost;user id=root;password=123456;database=C#librarycenter; /根據(jù)自己的設(shè)置 MySqlConnection c
41、onn = new MySqlConnection(sql); conn.Open();/打開(kāi)數(shù)據(jù)庫(kù)連接 MySqlDataAdapter data1 = new MySqlDataAdapter();/實(shí)例化sqldataadpter MySqlCommand cmd1 = new MySqlCommand(SELECT userId as 用戶(hù)ID,userName as 用戶(hù)名,(CASE userPassword WHEN null THEN * ELSE * END) as 用戶(hù)密碼,userSex as 用戶(hù)性別 FROM c#librarycenter.userInfo, con
42、n);/sql語(yǔ)句 data1.SelectCommand = cmd1;/設(shè)置為已實(shí)例化SqlDataAdapter的查詢(xún)命令 DataTable dt = new DataTable(); dt.Clear(); data1.Fill(dt);/把數(shù)據(jù)填充到datatable dataGridView1.DataSource = dt;/將數(shù)據(jù)集綁定datagridview,完成顯示 dataGridView1.AllowUserToAddRows = false; 總結(jié)這次的圖書(shū)管理系統(tǒng)，并未用到MVC設(shè)計(jì)模式，只是簡(jiǎn)單的面向?qū)ο笤O(shè)計(jì)，選的題目也是比較熟悉的，本系統(tǒng)提供兩種權(quán)限：用戶(hù)和管理員，其實(shí)應(yīng)該把【管理員】分成【圖書(shū)管理員】和【系統(tǒng)管理員】，提供不同的權(quán)限，【系統(tǒng)管理員】具有對(duì)所有用戶(hù)的操作權(quán)限，【圖書(shū)管理員】具有對(duì)所有圖書(shū)的操作權(quán)限。本次課題當(dāng)然還存在著許多不足，以后有機(jī)會(huì)的話(huà)，會(huì)加以改進(jìn)。姓名：/學(xué)號(hào)：/
C MySQL 圖書(shū)管理系統(tǒng).docx
