C#圖書館管理系統(tǒng)

1、目錄1、緒論12、數(shù)據(jù)庫設計12.1數(shù)據(jù)庫分析12.1創(chuàng)建數(shù)據(jù)庫43、界面設計43.1登陸界面43.2圖書管理系統(tǒng)界面83.3圖書信息界面93.4圖書歸還界面113.5圖書借閱界面133.6用戶信息界面153.7管理員界面163.8注冊界面183.9添加圖書界面194、系統(tǒng)測試214.1登陸功能214.2借閱圖書功能224.3歸還圖書庫功能224.4圖書信息功能234.5管理員登陸功能234.6添加圖書功能244.7用戶信息245、連接數(shù)據(jù)庫245.1連接數(shù)據(jù)庫255.2操作數(shù)據(jù)庫中的數(shù)據(jù)256、總結271、緒論2、數(shù)據(jù)庫設計2.1數(shù)據(jù)庫分析本系統(tǒng)利用VisualStudio2010處理數(shù)據(jù)庫

2、的功能，實現(xiàn)對圖書館信息的管理。主要功能為管理有關用戶、管理員、書籍和借閱的信息等。本系統(tǒng)的結構分為用戶信息管理模塊、書籍信息管理模塊、借閱信息管理模塊、管理者管理信息模塊和查詢處理模塊。圖書館管理系統(tǒng)框圖如圖所示22創(chuàng)建數(shù)據(jù)庫列容允許Mullifidncharl-OU5-nchr10允許Mullifuidnchar10)團usirnchar10畫nB列名允許Nullf卜sidnchar(lO)Ssdatanchar(lO)圍snamenchar(lO)n列容允許MullIidTKhar(lO)Sn3、界面設計3.1登陸界面amespace圖書管理系統(tǒng)publicpartialclassFor

3、ml:FormpublicForml()InitializeComponent();publicstaticFormfm=null;privatestaticintErrorTimes=0;privatevoidbutton3_Click(objectsender,EventArgse)this.Close();privatevoidtextBox1_TextChanged(objectsender,EventArgse)privatevoidbutton1_Click(objectsender,EventArgse)if(textBox1.Text=""|textBox2

4、.Text="")MessageBox.Show("提示：請輸入用戶名和密碼！","警告")；SqlConnectionconn=newSqlConnection("Server二PC_201402131602;IntegratedSecurity二true;DataBase=|圖書管理系統(tǒng)");conn.Open();SqlCommandcmd=newSqlCommand("select*fromTable_1whereid='"+textBox1.Text.Trim()+"

5、'andus='"+textBox2.Text.Trim()+"'",conn);SqlDataReadersdr=cmd.ExecuteReader();sdr.Read();if(sdr.HasRows)MessageBox.Show("登錄成功!","提示")；Form2fm=newForm2();fm.Show();this.Hide();elseErrorTimes+;MessageBox.Show("用戶名或密碼不正確！您還有"+(3-ErrorTimes)+"

6、;次輸入密碼的機會，請重新輸入!如果超過3次，系統(tǒng)將自動關閉");if(ErrorTimes>=3)ErrorTimes=0;conn.Close();privatevoidForm1_Load(objectsender,EventArgse)privatevoidbutton4_Click(objectsender,EventArgse)if(textBox1.Text=""|textBox2.Text="")MessageBox.Show("提示：請輸入用戶名和密碼！","警告")；SqlCon

7、nectionconn=newSqlConnection("Server二PC_201402131602;IntegratedSecurity二true;DataBase=|圖書管理系統(tǒng)");conn.Open();SqlCommandcmd=newSqlCommand("select*fromTable_2whereuid='"+textBox1.Text.Trim()+"'andusr='"+textBox2.Text.Trim()+"'",conn);SqlDataReader

8、sdr=cmd.ExecuteReader();sdr.Read();if(sdr.HasRows)MessageBox.Show("登錄成功!","提示")；Form7fm=newForm7();fm.Show();this.Hide();elseErrorTimes+;MessageBox.Show("用戶名或密碼不正確！您還有"+(3-ErrorTimes)+次輸入密碼的機會，請重新輸入!如果超過3次，系統(tǒng)將自動關閉)；if(ErrorTimes>=3)ErrorTimes=0;conn.Close();privatevo

9、idbutton2_Click(objectsender,EventArgse)Form8fl二newForm8();fl.Show();privatevoidbutton5_Click(objectsender,EventArgse)this.Hide();Form10f2=newForm10();f2.Show();叫登？®面|=|回|圧|welcome3.2圖書管理系統(tǒng)界面namespace圖書管理系統(tǒng)publicpartialclassForm2:FormpublicForm2()InitializeComponent();privatevoidbutton5_Click(o

10、bjectsender,EventArgse)this.Close();privatevoidbutton3_Click(objectsender,EventArgse)Form3f2=newForm3();f2.Show();this.Close();MessageBox.Show("您已成功進入圖書信息！")；privatevoidbutton2_Click(objectsender,EventArgse)Form4f4=newForm4();f4.Show();this.Close();MessageBox.Show("您已成功進入還書系統(tǒng)！")；

11、privatevoidbutton1_Click(objectsender,EventArgse)Form5f5=newForm5();f5.Show();this.Close();MessageBox.Show("您已成功進入借書系統(tǒng)！")；3.3圖書信息namespace圖書管理系統(tǒng)publicpartialclassForm3:FormpublicForm3()InitializeComponent();privatevoidForm3_Load(objectsender,EventArgse)/TODO:這行代碼將數(shù)據(jù)加載到表“圖書管理系統(tǒng)DataSet.Table

12、_3”中。您可以根據(jù)需要移動或刪除它。this.table_3TableAdapter.Fill(this.圖書管理系統(tǒng)DataSet.Table_3);privatevoidtextBoxl_TextChanged(objectsender,EventArgse)privatevoidbuttonl_Click(objectsender,EventArgse)this.Close();3.4歸還圖書namespace圖書管理系統(tǒng)publicpartialclassForm4:FormpublicForm4()InitializeComponent();privatevoidbutton1_C

13、lick(objectsender,EventArgse)if(textBox1.Text="")MessageBox.Show(提示：請輸入所借書籍編號！","警告)；SqlConnectionconn=newSqlConnection("Server二PC_201402131602;IntegratedSecurity二true;DataBase=|圖書管理系統(tǒng)")；conn.Open();SqlCommandcmd=newSqlCommand("select*fromTable_4wheresid='"

14、;+textBox1.Text.Trim()+"'",conn);SqlDataReadersdr=cmd.ExecuteReader();sdr.Read();if(sdr.HasRows)MessageBox.Show("該書已還"，"提示")；elsesdr.Close();stringmyinsert="insertintoTable_4(sid)values('"+textBox1.Text+"')"SqlCommandmycom=newSqlCommand(m

15、yinsert,conn);mycom.ExecuteNonQuery();conn.Close();conn.Dispose();MessageBox.Show("您已還書成功！")；privatevoidForm4_Load（objectsender,EventArgse）/TODO:這行代碼將數(shù)據(jù)加載到表“圖書管理系統(tǒng)DataSet.Table_4”中。您可以根據(jù)需要移動或刪除它。this.table_4TableAdapter.Fill（this.圖書管理系統(tǒng)DataSet.Table_4）;/TODO:這行代碼將數(shù)據(jù)加載到表“圖書管理系統(tǒng)DataSet.Table

16、_3”中。您可以根據(jù)需要移動或刪除它。this.table_3TableAdapter.Fill（this.圖書管理系統(tǒng)DataSet.Table_3）;privatevoidbutton2_Click(objectsender,EventArgse)this.Close();Form2f2=newForm2();f2.Show();3.5已借圖書namespace圖書管理系統(tǒng)publicpartialclassForm5:FormpublicForm5()InitializeComponent();privatevoidbutton1_Click(objectsender,EventArgs

17、e)this.Close();Form2f2=newForm2();f2.Show();privatevoidForm5_Load(objectsender,EventArgse)/TODO:這行代碼將數(shù)據(jù)加載到表“圖書管理系統(tǒng)DataSet.Table_4”中。您可以根據(jù)需要移動或刪除它。this.table_4TableAdapter.Fill(this.圖書管理系統(tǒng)DataSet.Table_4);/TODO:這行代碼將數(shù)據(jù)加載到表“圖書管理系統(tǒng)DataSet.Table_3”中。您可以根據(jù)需要移動或刪除它。this.table_3TableAdapter.Fill(this.圖書管理系

18、統(tǒng)DataSet.Table_3);if(textBox1.Text="")MessageBox.Show(提示：請輸入所借書籍編號！","警告)；privatevoidbutton2_Click(objectsender,EventArgse)SqlConnectionconn=newSqlConnection("Server二PC_201402131602;IntegratedSecurity二true;DataBase=|圖書管理系統(tǒng)");conn.Open();SqlCommandcmd=newSqlCommand("

19、;select*fromTable_4wheresid='"+textBox1.Text.Trim()+"'",conn);SqlDataReadersdr=cmd.ExecuteReader();sdr.Read();if(sdr.HasRows)MessageBox.Show("該書已借"，”提示")；elsesdr.Close();stringmyinsert="insertintoTable_4(sid)values('"+textBox1.Text+"')&quo

20、t;SqlCommandmycom=newSqlCommand(myinsert，conn);mycom.ExecuteNonQuery();conn.Close();conn.Dispose();MessageBox.Show（您已借書成功！）;privatevoidtextBox2_TextChanged(objectsender，EventArgse)3.6用戶信息namespace圖書管理系統(tǒng)publicpartialclassForm6:FormpublicForm6()InitializeComponent();privatevoidForm6_Load(objectsender,

21、EventArgse)/TODO:這行代碼將數(shù)據(jù)加載到表“圖書管理系統(tǒng)DataSet.Table_1”中。您可以根據(jù)需要移動或刪除它。this.table_1TableAdapter.Fill(this.圖書管理系統(tǒng)DataSet.Table_1);this.Close();privatevoidbutton2_Click(objectsender,EventArgse)用戶信息1=1回3.7管理員主界面namespace圖書管理系統(tǒng)publicpartialclassForm7:FormpublicForm7()InitializeComponent();privatevoidbutton2

22、_Click(objectsender,EventArgse)Form6fl=newForm6();fl.Show();MessageBox.Show("您已成功進入用戶信息！")；Form3f2=newForm3();f2.Show();privatevoidbutton3_Click(objectsender,EventArgse)MessageBox.Show（"您已成功進入圖書信息！"）；privatevoidbuttonl_Click(objectsender,EventArgse)Form9f2=newForm9();f2.Show();Me

23、ssageBox.Show("您已成功進入添加圖書系統(tǒng)！")；privatevoidbutton4_Click(objectsender,EventArgse)this.Close();3.8注冊界面namespace圖書管理系統(tǒng)publicpartialclassForm8:FormpublicForm8()InitializeComponent();privatevoidbutton1_Click(objectsender,EventArgse)if(textBox1.Text=""|textBox2.Text="")Messag

24、eBox.Show("提示：請輸入用戶名和密碼！","警告")；SqlConnectionconn=newSqlConnection("Server二PC_201402131602;IntegratedSecurity二true;DataBase=|圖書管理系統(tǒng)");conn.Open();SqlCommandcmd=newSqlCommand("select*fromtable_1whereid='"+textBox1.Text.Trim()+"'andus='"+te

25、xtBox2.Text.Trim()+"'",conn);SqlDataReadersdr=cmd.ExecuteReader();sdr.Read();if(sdr.HasRows)MessageBox.Show("該用戶已注冊，請使用其他用戶名"，"提示")；elsesdr.Close();stringmyinsert="insertintotable_1(id,us)values('"+textBox1.Text+"','"+textBox2.Text+&q

26、uot;')"SqlCommandmycom=newSqlCommand(myinsert,conn);mycom.ExecuteNonQuery();conn.Close();conn.Dispose();MessageBox.Show("您已注冊成功！")；privatevoidbutton2_Click(objectsender,EventArgse)this.Close();privatevoidForm8_Load(objectsender,EventArgse)3.9添加圖書namespace圖書管理系統(tǒng)publicpartialclassFo

27、rm9:FormpublicForm9()InitializeComponent();privatevoidbutton2_Click(objectsender,EventArgse)privatevoidbutton1_Click(objectsender,EventArgse)SqlConnectionconn=newSqlConnection("server二PC_201402131602;database二圖書管理系統(tǒng)；integratedSecurity=true");stringsql="insertintoTable_3(sid,sdata,snam

28、e)values('"+textBox1.Text+"','"+textBox2.Text+"','"+textBox3.Text+"')"conn.Open();SqlCommandcomm=newSqlCommand(sql,conn);if(conn.State=ConnectionState.Closed)conn.Open();if(Convert.ToInt32(comm.ExecuteNonQuery()>0)label4.Text="成功！&qu

29、ot;MessageBox.Show("您已成功添加數(shù)據(jù)！")；elselabel4.Text="失??！"4、系統(tǒng)測試登陸借閱圖書歸還圖書圖書信息管理員登陸添加圖書用戶信息5、連接數(shù)據(jù)庫為數(shù)據(jù)庫BookManage和本系統(tǒng)之間建立一個數(shù)據(jù)連接。(1) 在服務器資源管理器中右擊“數(shù)據(jù)連接”節(jié)點(VS2008中操作)。在彈出的快捷菜單中執(zhí)行“添加連接”命令，打開DataLinkProperties對話框。切換到Provider選項卡，選中列表框中的MicrosoftOLEDBProviderforSQLServer項。單擊“下一步”切換到Connection

30、選項卡。(2) 在其中的第一個下拉列表框中選擇數(shù)據(jù)庫所在服務器名稱。輸入登錄服務器信息后選擇數(shù)據(jù)庫BookManage，然后單擊測試按鈕。如果測試成功，單擊“確定”按鈕。5.1連接數(shù)據(jù)庫(1) 定義數(shù)據(jù)庫連接字符串，代碼如下：PrivatestaticstringConnectString="DataSource=(local)sqlexpress;DataBase=BookManage.mdf"(2) 創(chuàng)建Connection對象，代碼如下：SqlConnectioncon=newSqlConnection(ConnectString);(3) 打開連接，代碼如下：con

31、.Open();(4) 關閉連接，代碼如下：con.Close();5.2操作數(shù)據(jù)庫中的數(shù)據(jù)usingSystem;usingSystem.Collections.Generic;usingSystem.Linq;usingSystem.Text;usingSystem.Data;usingSystem.Data.SqlClient;namespaceBookManageclassDataAccessprivatestaticstringConnectString="DataSource=SQLEXPRESS;AttachDbFilename=F:BookManagedataBook

32、Manage.mdf;IntegratedSecurity=False"/數(shù)據(jù)庫連接字符串/<summary>/根據(jù)表名獲取數(shù)據(jù)集的表/</summary>/<paramname="table"></param>/<returns></returns>publicstaticDataTableGetDataSetByTableName(stringtable)using(SqlConnectioncon=newSqlConnection(ConnectString)/創(chuàng)建數(shù)據(jù)庫連接對象stri

33、ngsql="select*from"+table+""/查詢sql語句trySqlDataAdapteradapter=newSqlDataAdapter(sql,con);/創(chuàng)建適配器對象DataSetds=newDataSet();/創(chuàng)建數(shù)據(jù)集對象adapter.Fill(ds,"table");/填充數(shù)據(jù)集returnds.TablesO;/返回數(shù)據(jù)表catch(SqlExceptionex)thrownewException(ex.Message);publicstaticDataSetGetDataSetBySql(stringsql)using(SqlConnectioncon=newSqlConnection(ConnectString)/創(chuàng)建數(shù)據(jù)庫連接對象SqlDataAdapteradapter=newSqlDataAdapter(sql,con);/創(chuàng)建適配器對象DataSetds=newDa