圖書管理系統(tǒng)源碼(C版)

1、.登錄界面：usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespacebookpublicpartialclasslogin:Formpublicstringpassword;/用來儲存密碼publiclogin()InitializeComponent();privatevoidb

2、utton2_Click(objectsender,EventArgse)Application.Exit();privateboolyanzhengshuru()password=textBox3.Text;if(Typename.Text.Trim()=)MessageBox.Show(請選擇登錄種類,登錄提示,MessageBoxButtons.OK,MessageBoxIcon.Information);Typename.Focus();returnfalse;elseif(loginid.Text.Trim()=)MessageBox.Show(請輸入用戶名,登錄提示,Message

3、BoxButtons.OK,MessageBoxIcon.Information);loginid.Focus();returnfalse;elseif(password=)MessageBox.Show(請輸入密碼,登錄提示,MessageBoxButtons.OK,MessageBoxIcon.Information);textBox3.Focus();word專業(yè)資料.returnfalse;elsereturntrue;privatevoidbutton1_Click(objectsender,EventArgse)userhelper.adminid=loginid.Text;/用戶

4、賬號password=textBox3.Text;/用戶密碼if(yanzhengshuru()if(Typename.Text.Trim()=管理員)stringsql=string.Format(Selectcount(*)fromadminwhereadminId=0andadminpass=1,loginid.Text,password);trySqlCommandcommand=newSqlCommand(sql,Dbhelper.connection);Dbhelper.connection.Open();intcount=(int)command.ExecuteScalar();

5、if(count1)MessageBox.Show(用戶或密碼不存在！);/result=false;elseadminadmin=newadmin();admin.Show();catch(Exceptionex)MessageBox.Show(操作數(shù)據(jù)庫犯錯！);Console.WriteLine(ex.Message);finallyDbhelper.connection.Close();word專業(yè)資料.if(Typename.Text.Trim()=借閱者)userhelper.readerid=Convert.ToString(loginid.Text);stringsql=str

6、ing.Format(Selectcount(*)fromreaderwherereaderId=0andreaderpass=1,userhelper.readerid,textBox3.Text);try/創(chuàng)立Command對象SqlCommandcommand=newSqlCommand(sql,Dbhelper.connection);翻開數(shù)據(jù)庫連結(jié)Dbhelper.connection.Open();考證能否為合法用戶intcount=(int)command.ExecuteScalar();if(count1)MessageBox.Show(用戶或密碼不存在！);/result=f

7、alse;elsereaderreader=newreader();reader.Show();catch(Exceptionex)MessageBox.Show(操作數(shù)據(jù)庫犯錯！);Console.WriteLine(ex.Message);/result=false;finally封閉數(shù)據(jù)庫連結(jié)Dbhelper.connection.Close();privatevoidlogin_Load(objectsender,EventArgse)讀者界面;word專業(yè)資料.usingSystem;usingSystem.Collections.Generic;usingSystem.Compon

8、entModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.Sql;usingSystem.Data.SqlClient;namespacebookpublicpartialclassreader:Formpublicreader()InitializeComponent();privatevoidbutton3_Click(objectsender,EventArgse)stringid=Convert.ToString(textBox1.T

9、ext);if(id!=userhelper.readerid)MessageBox.Show(輸入賬號與登岸賬號不同樣，請從頭輸入,提示,MessageBoxButtons.OK,MessageBoxIcon.Warning);textBox1.Text=;textBox1.Focus();elsetrystringsql=string.Format(updatereadersetislost=0wherereaderid=1,是,id);Dbhelper.connection.Open();SqlCommandcommand=newSqlCommand(sql,Dbhelper.conne

10、ction);intresult=command.ExecuteNonQuery();if(result1)MessageBox.Show(改正失敗);elseMessageBox.Show(掛失成功);catchword專業(yè)資料.MessageBox.Show(error);finallyDbhelper.connection.Close();privatevoidtoolStripButton3_Click(objectsender,EventArgse)groupBox1.Visible=false;groupBox2.Visible=true;privatevoidtoolStripB

11、utton4_Click(objectsender,EventArgse)groupBox1.Visible=true;groupBox2.Visible=false;privatevoidbutton5_Click(objectsender,EventArgse)textBox2.Text=;textBox4.Text=;textBox5.Text=;privatevoidForm1_Load(objectsender,EventArgse)toolStrip1.Text=string.Format(學(xué)生：0,userhelper.readerid);privatevoidbutton4_C

12、lick(objectsender,EventArgse)stringid=Convert.ToString(textBox2.Text);if(id!=userhelper.readerid)MessageBox.Show(輸入賬號與登岸賬號不同樣，請從頭輸入,提示,MessageBoxButtons.OK,MessageBoxIcon.Warning);textBox1.Text=;textBox1.Focus();elseif(textBox4.Text!=textBox5.Text)MessageBox.Show(兩次密碼輸入不一樣);elsetryword專業(yè)資料.stringsql

13、=string.Format(updatereadersetreaderpass=0wherereaderid=1,textBox4.Text,id);Dbhelper.connection.Open();SqlCommandcommand=newSqlCommand(sql,Dbhelper.connection);intresult=command.ExecuteNonQuery();if(result1)MessageBox.Show(改正失敗);elseMessageBox.Show(改正成功);catchMessageBox.Show(error);finallyDbhelper.c

14、onnection.Close();privatevoidtoolStripButton6_Click(objectsender,EventArgse)addreaderaddreader=newaddreader();addreader=newaddreader();privatevoidtoolStripButton1_Click(objectsender,EventArgse)readsearchbooksearchbook=newreadsearchbook();searchbook.Show();privatevoidtoolStripButton2_Click(objectsend

15、er,EventArgse)borrowa=newborrow();a.Show();privatevoidtoolStripButton5_Click(objectsender,EventArgse)readerseacherinfoa=newreaderseacherinfo();a.Show();privatevoid圖書查問ToolStripMenuItem1_Click(objectsender,EventArgse)readsearchbooka=newreadsearchbook();a.Show();word專業(yè)資料.this.Close();privatevoid結(jié)束查問To

16、olStripMenuItem_Click(objectsender,EventArgse)borrowa=newborrow();a.Show();this.Close();privatevoid改正密碼ToolStripMenuItem_Click(objectsender,EventArgse)groupBox1.Visible=false;groupBox2.Visible=true;privatevoid掛失ToolStripMenuItem_Click(objectsender,EventArgse)groupBox1.Visible=true;groupBox2.Visible=

17、false;privatevoid退出ToolStripMenuItem_Click(objectsender,EventArgse)this.Close();privatevoidbutton2_Click(objectsender,EventArgse)Application.Exit();管理員界面;usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.F

18、orms;namespacebookpublicpartialclassadmin:Formpublicadmin()InitializeComponent();word專業(yè)資料.privatevoid退出ToolStripMenuItem_Click(objectsender,EventArgse)this.Close();privatevoidadmin_Load(objectsender,EventArgse)toolStrip1.Text=string.Format(管理員：登錄,userhelper.adminid);privatevoidtoolStripButton4_Click

19、(objectsender,EventArgse)/錄入學(xué)生信息addreaderaddreader=newaddreader();addreader.Show();this.Close();privatevoid借書信息ToolStripMenuItem_Click(objectsender,EventArgse)adminborrowa=newadminborrow();a.Show();privatevoid還書信息ToolStripMenuItem_Click(objectsender,EventArgse)adminborrowa=newadminborrow();a.Show();

20、privatevoid增添圖書ToolStripMenuItem_Click(objectsender,EventArgse)addbooka=newaddbook();a.Show();privatevoid刪除圖書ToolStripMenuItem_Click(objectsender,EventArgse)adminearchbooka=newadminearchbook();a.Show();privatevoid查問圖書ToolStripMenuItem_Click(objectsender,EventArgse)adminearchbooka=newadminearchbook()

21、;a.Show();privatevoid查問第一版社信息ToolStripMenuItem_Click(objectsender,EventArgse)publishera=newpublisher();a.Show();this.Close();word專業(yè)資料.privatevoid改正第一版社信息ToolStripMenuItem_Click(objectsender,EventArgse)publishera=newpublisher();a.Show();this.Close();privatevoid查問學(xué)生借閱信息ToolStripMenuItem_Click(objectse

22、nder,EventArgse)adminborrowa=newadminborrow();a.Show();privatevoidtoolStripButton6_Click_1(objectsender,EventArgse)/借書信息booksborrowa=newbooksborrow();a.Show();privatevoid增添ToolStripMenuItem_Click(objectsender,EventArgse)readerinfoa=newreaderinfo();a.Show();privatevoid刪除ToolStripMenuItem_Click(object

23、sender,EventArgse)deletereadera=newdeletereader();a.Show();增添圖書信息界面：usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespacebookpublicpartialclassaddbook:Formpublicaddbo

24、ok()InitializeComponent();word專業(yè)資料.privatevoidaddbook_Load(objectsender,EventArgse)trystringsql1=selectbooktypenamefrombooktype;SqlCommandcommand=newSqlCommand(sql1,Dbhelper.connection);Dbhelper.connection.Open();SqlDataReaderdatareader=command.ExecuteReader();stringtypename=;while(datareader.Read()

25、typename=(string)datareader0;comboBox2.Items.Add(typename);datareader.Close();stringsql2=selectpublishernamefrompublisher;SqlCommandcommand1=newSqlCommand(sql2,Dbhelper.connection);/Dbhelper.connection.Open();SqlDataReaderdatareader1=command1.ExecuteReader();stringpublishername=;while(datareader1.Re

26、ad()publishername=(string)datareader10;/MessageBox.Show(publishername);comboBox1.Items.Add(publishername);datareader1.Close();catchMessageBox.Show(error);finallyDbhelper.connection.Close();privatevoidbutton2_Click(objectsender,EventArgse)textBox1.Text=null;textBox2.Text=null;textBox4.Text=null;word專

27、業(yè)資料.comboBox2.Text=null;comboBox1.Text=null;privatestringtypdid(stringa)stringid=;stringsqltypeid=string.Format(selectbooktypeidfrombooktypewherebooktypename=0,a);trySqlCommandcommand=newSqlCommand(sqltypeid,Dbhelper.connection);Dbhelper.connection.Open();id=Convert.ToString(command.ExecuteScalar();

28、catchMessageBox.Show(error);finallyDbhelper.connection.Close();returnid;privatestringpublisheid(stringa)stringid=;stringsqlpublisheid=string.Format(selectpublisheridfrompublisherwherepublishername=0,a);trySqlCommandcommand=newSqlCommand(sqlpublisheid,Dbhelper.connection);Dbhelper.connection.Open();i

29、d=Convert.ToString(command.ExecuteScalar();catchMessageBox.Show(error);finallyDbhelper.connection.Close();returnid;word專業(yè)資料.privatevoidbutton1_Click(objectsender,EventArgse)stringname=textBox1.Text;stringwritter=textBox2.Text;stringpublisher=comboBox1.Text;stringtype=comboBox2.Text;stringprice=textB

30、ox4.Text;/stringid=textBox5.Text;stringtypeid=typdid(type);stringpublisherid=publisheid(publisher);stringbianhao=textBox3.Text;tryif(bianhao!=&name!=&writter!=&publisher!=&type!=&price!=)Dbhelper.connection.Open();stringsql=string.Format(insertintobook(BOOKID,bookname,bookwritter,publisherid,booktyp

31、eid,bookprice)values(0,1,2,3,4,5),bianhao,name,writter,publisherid,typeid,price);SqlCommandcommmand=newSqlCommand(sql,Dbhelper.connection);intab=commmand.ExecuteNonQuery();if(ab!=0)MessageBox.Show(保留成功,保留);elseMessageBox.Show(增添失敗);return;elseif(name=|writter=|publisher=|type=|price=)MessageBox.Show

32、(請輸入所有信息,錯誤,MessageBoxButtons.OK,MessageBoxIcon.Error);catch/(exceptionex)MessageBox.Show(操作數(shù)據(jù)庫犯錯,提示,MessageBoxButtons.OK,MessageBoxIcon.Information);word專業(yè)資料.finallyDbhelper.connection.Close();privatevoidbutton3_Click(objectsender,EventArgse)this.Close();增添讀者信息界面：usingSystem;usingSystem.Collections

33、.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespacebookpublicpartialclassaddreader:Formpublicaddreader()InitializeComponent();/退出窗口privatevoidbutton3_Click(objectsender,EventArgse)/Application.Exit()

34、;this.Close();/消除所有容privatevoidbutton1_Click(objectsender,EventArgse)textBox1.Text=null;textBox2.Text=null;textBox4.Text=null;textBox3.Text=null;textBox5.Text=null;comboBox1.Text=null;comboBox2.Text=null;word專業(yè)資料.privatevoidbutton2_Click(objectsender,EventArgse)/連結(jié)數(shù)據(jù)庫/定義變量stringname=textBox1.Text;st

35、ringage=textBox2.Text;stringsex=comboBox1.Text;stringstudentId=textBox3.Text;stringdept=textBox4.Text;stringzhuanye=textBox5.Text;stringmaxnumber=comboBox2.Text;stringpass=textBox6.Text;tryif(name!=&age!=&sex!=&studentId!=&dept!=&zhuanye!=&maxnumber!=&pass!=)Dbhelper.connection.Open();stringsql=stri

36、ng.Format(insertintoreader(readerid,readerpass,readername,readersex,readerage,readerdept,readerzhuanye,maxnumber)values(0,1,2,3,4,5,6,7),studentId,pass,name,sex,age,dept,zhuanye,maxnumber);SqlCommandcommmand=newSqlCommand(sql,Dbhelper.connection);intab=commmand.ExecuteNonQuery();if(ab!=0)MessageBox.

37、Show(保留成功,保留);elseMessageBox.Show(增添失敗);return;elseif(name=|age=|sex=|studentId=|dept=|zhuanye=|maxnumber=)MessageBox.Show(請輸入所有學(xué)生信息,錯誤,MessageBoxButtons.OK,MessageBoxIcon.Error);catch/(exceptionex)MessageBox.Show(操作數(shù)據(jù)庫犯錯,提示,MessageBoxButtons.OK,MessageBoxIcon.Information);/Console.WriteLine(ex);wor

38、d專業(yè)資料.finallyDbhelper.connection.Close();privatevoidbutton4_Click(objectsender,EventArgse)readerinfoa=newreaderinfo();a.Show();查問圖書界面：usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Dat

39、a.SqlClient;namespacebookpublicpartialclassadminborrow:FormprivateDataSetdataset=newDataSet();privateSqlDataAdapterdataadapter;publicadminborrow()InitializeComponent();privatevoidbutton2_Click(objectsender,EventArgse)if(comboBox1.Text=個人)trystringid=textBox1.Text;stringsql=string.Format(selectreader

40、id,bookid,borrowtime,returntime,outtimefromborrowwherereaderid=0,id);dataadapter=newSqlDataAdapter(sql,Dbhelper.connection);dataadapter.Fill(dataset,borrow);dataGridView1.DataSource=dataset.Tablesborrow;catchMessageBox.Show(error);word專業(yè)資料.finallyDbhelper.connection.Close();elsetrystringid=textBox1.

41、Text;stringsql=string.Format(selectreaderid,bookid,borrowtime,returntime,outtimefromborrow);dataadapter=newSqlDataAdapter(sql,Dbhelper.connection);dataadapter.Fill(dataset,borrow);dataGridView1.DataSource=dataset.Tablesborrow;catchMessageBox.Show(error);finallyDbhelper.connection.Close();privatevoid

42、button1_Click(objectsender,EventArgse)groupBox1.Visible=true;privatevoidbutton3_Click(objectsender,EventArgse)dataset.Tablesborrow.Clear();privatevoidbutton4_Click(objectsender,EventArgse)stringrid=textBox2.Text;stringbid=textBox3.Text;tryif(rid!=&bid!=)Dbhelper.connection.Open();word專業(yè)資料.stringsql=

43、string.Format(updateborrowsetreturntime=getdate(),outtime=已還wherereaderid=0andbookid=1andouttime=否,rid,bid);SqlCommandcommmand=newSqlCommand(sql,Dbhelper.connection);intab=commmand.ExecuteNonQuery();stringsql1=string.Format(updatebooksetifborrow=否wherebookid=0,bid);SqlCommandco=newSqlCommand(sql1,Db

44、helper.connection);intc=co.ExecuteNonQuery();if(ab!=0&c!=0)MessageBox.Show(還書成功,保留);elseMessageBox.Show(還書失敗);return;elseif(rid=|bid=)MessageBox.Show(請輸入所有信息,錯誤,MessageBoxButtons.OK,MessageBoxIcon.Error);catch/(exceptionex)MessageBox.Show(操作數(shù)據(jù)庫犯錯,提示,MessageBoxButtons.OK,MessageBoxIcon.Information);/

45、Console.WriteLine(ex);finallyDbhelper.connection.Close();usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespacebookword專業(yè)資料.publicpartialclassadminearchbook:Formprivat

46、eDataSetdataset=newDataSet();privateSqlDataAdapterdataadapter;publicadminearchbook()InitializeComponent();privatevoidbutton1_Click(objectsender,EventArgse)trystringsql;if(comboBox1.Text=書名)sql=string.Format(selectbookid,bookname,bookwritter,booktype.booktypename,bookprice,booktype.flow,publisher.pub

47、lishername,ifborrowfrombook,booktype,publisherwherebook.booktypeid=booktype.booktypeidandbook.publisherid=publisher.publisheridandbookname=0,textBox1.Text);elseif(comboBox1.Text=作者)sql=string.Format(selectbookid,bookname,bookwritter,booktype.booktypename,bookprice,booktype.flow,publisher.publisherna

48、me,ifborrowfrombook,booktype,publisherwherebook.booktypeid=booktype.booktypeidandbook.publisherid=publisher.publisheridandbookwritterlike%0%,textBox1.Text);elseif(comboBox1.Text=第一版社)sql=string.Format(selectbookid,bookname,bookwritter,booktype.booktypename,bookprice,booktype.flow,publisher.publisher

49、name,ifborrowfrombook,booktype,publisherwherebook.booktypeid=booktype.booktypeidandbook.publisherid=publisher.publisheridandbookTypeNamelike%0%,textBox1.Text);elseif(comboBox1.Text=類型)sql=string.Format(selectbookid,bookname,bookwritter,booktype.booktypename,bookprice,booktype.flow,publisher.publword

50、專業(yè)資料.ishername,ifborrowfrombook,booktype,publisherwherebook.booktypeid=booktype.booktypeidandbook.publisherid=publisher.publisheridandpublisherNamelike%0%,textBox1.Text);elsesql=selectbookid,bookname,bookwritter,booktype.booktypename,bookprice,booktype.flow,publisher.publishername,ifborrowfrombook,b

51、ooktype,publisherwherebook.booktypeid=booktype.booktypeidandbook.publisherid=publisher.publisherid;dataadapter=newSqlDataAdapter(sql,Dbhelper.connection);dataadapter.Fill(dataset,book);dataGridView1.DataSource=dataset.Tablesbook;catchMessageBox.Show(error);finallyDbhelper.connection.Close();privatev

52、oidcomboBox1_SelectedIndexChanged(objectsender,EventArgse)if(comboBox1.Text=書名)label2.Visible=true;label3.Visible=false;label4.Visible=false;label5.Visible=false;elseif(comboBox1.Text=作者)label2.Visible=false;label3.Visible=true;label4.Visible=false;label5.Visible=false;elseif(comboBox1.Text=第一版社)lab

53、el2.Visible=false;word專業(yè)資料.label3.Visible=false;label4.Visible=true;label5.Visible=false;elseif(comboBox1.Text=類型)label2.Visible=false;label3.Visible=false;label4.Visible=false;label5.Visible=true;elselabel2.Visible=false;label3.Visible=false;label4.Visible=false;label5.Visible=false;privatevoidbutt

54、on2_Click(objectsender,EventArgse)dataset.Tablesbook.Clear();/dataadapter.Fill(dataset,book);privatevoidbutton3_Click_1(objectsender,EventArgse)if(textBox2.Text!=)tryDbhelper.connection.Open();stringsql1=string.Format(deletefromborrowwherebookid=0,textBox2.Text);SqlCommandcon=newSqlCommand(sql1,Dbhe

55、lper.connection);intc=con.ExecuteNonQuery();stringsql=string.Format(deletefrombookwherebookid=0,textBox2.Text);SqlCommandcommmand=newSqlCommand(sql,Dbhelper.connection);intab=commmand.ExecuteNonQuery();if(c!=0&ab!=0)MessageBox.Show(刪除成功,保留);elseMessageBox.Show(刪除失敗);word專業(yè)資料.return;catch(Exceptionex

56、)MessageBox.Show(ex.ToString();finallyDbhelper.connection.Close();elseMessageBox.Show(請輸入圖書編號！);借書界面：usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespacebookpublicpa

57、rtialclassbooksborrow:Formpublicbooksborrow()InitializeComponent();privatevoidbutton1_Click(objectsender,EventArgse)stringrid=textBox1.Text;stringbid=textBox2.Text;tryif(rid!=&bid!=)Dbhelper.connection.Open();stringsql=string.Format(insertintoborrow(readerid,bookid)values(0,1),rid,bid);SqlCommandcom

58、mmand=newSqlCommand(sql,Dbhelper.connection);word專業(yè)資料.intab=commmand.ExecuteNonQuery();stringsql1=string.Format(updatebooksetifborrow=是wherebookid=0,bid);SqlCommandco=newSqlCommand(sql1,Dbhelper.connection);intc=co.ExecuteNonQuery();if(ab!=0&c!=0)MessageBox.Show(借閱成功,保留);elseMessageBox.Show(增添失敗);re

59、turn;elseif(rid=|bid=)MessageBox.Show(請輸入所有信息,錯誤,MessageBoxButtons.OK,MessageBoxIcon.Error);catch/(exceptionex)MessageBox.Show(操作數(shù)據(jù)庫犯錯,提示,MessageBoxButtons.OK,MessageBoxIcon.Information);/Console.WriteLine(ex);finallyDbhelper.connection.Close();privatevoidbutton2_Click(objectsender,EventArgse)this.C

60、lose();usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;word專業(yè)資料.usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespacebookpublicpartialclassborrow:FormprivateDataSetdataset=newDataSet();privateSqlDataAdapterdataadap