图书管理系统源码(C#版).pdf

《图书管理系统源码(C#版).pdf》由会员分享，可在线阅读，更多相关《图书管理系统源码(C#版).pdf（33页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、登录界面：using System；using System。Collections。Generic;using System。ComponentModel;using System。Data；using System.Drawing;using System。Text；using System。Windows.Forms；using System。Data.SqlClient；namespace bookpublic partial class login：Formpublic string password;/用来存储密码public login()InitializeComponent(

2、)；private void button2_Click（object sender,EventArgs e）Application。Exit()；private bool yanzhengshuru（）password=textBox3.Text;if(Typename。Text。Trim()=）MessageBox。Show(请选择登录类型”，”登录提示”,MessageBoxButtons。OK，MessageBoxIcon。Information）；Typename.Focus()；return false；else if（loginid。Text。Trim(）=”）MessageBo

3、x.Show（”请输入用户名”,登录提示”，MessageBoxButtons。OK,MessageBoxIcon.Information）;loginid。Focus（）;return false；else if（password=”）MessageBox.Show(请输入密码,登录提示,MessageBoxButtons。OK，MessageBoxIcon。Information）；textBox3.Focus();return false；elsereturn true；private void button1_Click(object sender,EventArgs e)userhe

4、lper.adminid=loginid。Text;/用户账号 password=textBox3.Text；/用户密码if(yanzhengshuru（）)if（Typename。Text.Trim(）=管理员”)string sql=string。Format(Select count(*)from admin where adminId=0 andadminpass=1,loginid.Text,password);trySqlCommand command=new SqlCommand（sql,Dbhelper。connection)；Dbhelper.connection.Open(

5、)；int count=（int)command.ExecuteScalar(）;if（count 1)MessageBox.Show（用户或密码不存在!)；/result=false;else admin admin=new admin(）；admin。Show(）;catch(Exception ex)MessageBox.Show(”操作数据库出错!)；Console。WriteLine(ex。Message）;finally Dbhelper.connection。Close（）;if(Typename.Text.Trim（）=”借阅者”）userhelper。readerid=Con

6、vert.ToString(loginid.Text);string sql=string。Format（Select count(）from reader where readerId=0 andreaderpass=1，userhelper.readerid，textBox3.Text);try/创建 Command 对象SqlCommand command=new SqlCommand（sql,Dbhelper.connection)；/打开数据库连接Dbhelper。connection.Open（);/验证是否为合法用户int count=(int)command。ExecuteSc

7、alar（)；if（count 1)MessageBox。Show(用户或密码不存在！）；/result=false；else reader reader=new reader（);reader。Show（）;catch(Exception ex）MessageBox。Show（”操作数据库出错!”）；Console。WriteLine（ex。Message）；/result=false;finally/关闭数据库连接Dbhelper.connection。Close（);private void login_Load(object sender，EventArgs e）读者界面;using

8、System；using System.Collections.Generic；using System。ComponentModel；using System。Data；using System。Drawing;using System.Text;using System.Windows。Forms;using System.Data.Sql；using System。Data.SqlClient;namespace bookpublic partial class reader：Formpublic reader(）InitializeComponent（)；private void bu

9、tton3_Click(object sender，EventArgs e）string id=Convert。ToString（textBox1。Text)；if(id！=userhelper。readerid）MessageBox。Show（”输入账号与登陆账号不相同，请重新输入，提示，MessageBoxButtons。OK,MessageBoxIcon.Warning）；textBox1。Text=”；textBox1.Focus（)；elsetrystring sql=string.Format（update reader set islost=0where readerid=1，是

10、，id）;Dbhelper.connection。Open（);SqlCommand command=new SqlCommand(sql,Dbhelper.connection）;int result=command。ExecuteNonQuery();if（result 1）MessageBox。Show（修改失败）;else MessageBox。Show（”挂失成功);catch MessageBox.Show(error”)；finally Dbhelper。connection。Close()；private void toolStripButton3_Click(object s

11、ender，EventArgs e）groupBox1.Visible=false;groupBox2.Visible=true;private void toolStripButton4_Click（object sender，EventArgs e）groupBox1。Visible=true；groupBox2。Visible=false;private void button5_Click(object sender,EventArgs e)textBox2。Text=”;textBox4。Text=;textBox5。Text=;private void Form1_Load（obj

12、ect sender,EventArgs e）toolStrip1.Text=string.Format（”学生:0”，userhelper.readerid）；private void button4_Click（object sender，EventArgs e）string id=Convert.ToString(textBox2。Text);if(id！=userhelper。readerid)MessageBox.Show（”输入账号与登陆账号不相同，请重新输入”，”提示,MessageBoxButtons.OK，MessageBoxIcon.Warning)；textBox1。Te

13、xt=”；textBox1。Focus(）;else if（textBox4。Text!=textBox5.Text)MessageBox。Show（两次密码输入不同）;else try string sql=string.Format（”update reader set readerpass=0 wherereaderid=1,textBox4。Text,id)；Dbhelper.connection。Open（）；SqlCommand command=new SqlCommand(sql，Dbhelper.connection);int result=command.ExecuteNon

14、Query（）;if（result 1)MessageBox.Show（修改失败);else MessageBox。Show（修改成功）;catch MessageBox。Show(error”）;finallyDbhelper.connection。Close()；private void toolStripButton6_Click（object sender,EventArgs e）addreader addreader=new addreader();addreader=new addreader();private void toolStripButton1_Click(object

15、 sender,EventArgs e)readsearchbook searchbook=new readsearchbook（）;searchbook。Show()；private void toolStripButton2_Click(object sender，EventArgs e)borrow a=new borrow（）；a.Show();private void toolStripButton5_Click（object sender,EventArgs e）readerseacherinfo a=new readerseacherinfo()；a.Show（）；private

16、 void 图书查询ToolStripMenuItem1_Click(object sender，EventArgs e）readsearchbook a=new readsearchbook();a.Show()；this。Close(）；private void 结束查询ToolStripMenuItem_Click（object sender，EventArgs e)borrow a=new borrow（)；a.Show（）；this。Close（);private void 修改密码ToolStripMenuItem_Click（object sender，EventArgs e)g

17、roupBox1。Visible=false;groupBox2.Visible=true;private void 挂失ToolStripMenuItem_Click（object sender,EventArgs e)groupBox1.Visible=true;groupBox2.Visible=false；private void 退出ToolStripMenuItem_Click（object sender,EventArgs e)this。Close(）；private void button2_Click(object sender,EventArgs e)Application

18、。Exit（);管理员界面;using System;using System.Collections。Generic；using System.ComponentModel；using System.Data;using System。Drawing；using System。Text;using System。Windows。Forms;namespace bookpublic partial class admin：Formpublic admin（）InitializeComponent（);private void 退出ToolStripMenuItem_Click(object s

19、ender,EventArgs e）this。Close（);private void admin_Load(object sender，EventArgs e）toolStrip1.Text=string。Format(管理员:登录”,userhelper.adminid）;private void toolStripButton4_Click(object sender，EventArgs e)/录入学生信息addreader addreader=new addreader();addreader。Show(）；this.Close(）;private void 借书信息ToolStrip

20、MenuItem_Click(object sender,EventArgs e)adminborrow a=new adminborrow();a。Show（）;private void 还书信息ToolStripMenuItem_Click(object sender，EventArgs e)adminborrow a=new adminborrow（);a。Show()；private void 添加图书ToolStripMenuItem_Click（object sender,EventArgs e)addbook a=new addbook（)；a。Show（);private vo

21、id 删除图书ToolStripMenuItem_Click(object sender,EventArgs e）adminearchbook a=new adminearchbook（);a。Show(）;private void 查询图书ToolStripMenuItem_Click(object sender,EventArgs e）adminearchbook a=new adminearchbook（）；a。Show(）；private void 查询出版社信息ToolStripMenuItem_Click(object sender，EventArgs e）publisher a=

22、new publisher(）；a。Show(）；this.Close（);private void 修改出版社信息ToolStripMenuItem_Click（object sender，EventArgs e）publisher a=new publisher（)；a.Show（)；this.Close()；private void 查询学生借阅信息ToolStripMenuItem_Click（object sender，EventArgs e）adminborrow a=new adminborrow(）；a。Show（）;private void toolStripButton6_

23、Click_1(object sender，EventArgs e）/借书信息 booksborrow a=new booksborrow()；a.Show();private void 添加ToolStripMenuItem_Click(object sender，EventArgs e)readerinfo a=new readerinfo()；a.Show(）；private void 删除ToolStripMenuItem_Click（object sender，EventArgs e）deletereader a=new deletereader（）；a。Show(）；添加图书信息界

24、面：using System；using System。Collections。Generic；using System.ComponentModel；using System.Data；using System。Drawing；using System。Text；using System.Windows.Forms；using System.Data.SqlClient;namespace bookpublic partial class addbook:Form public addbook（)InitializeComponent（）；private void addbook_Load(

25、object sender，EventArgs e）try string sql1=select booktypename from booktype；SqlCommand command=new SqlCommand（sql1，Dbhelper。connection);Dbhelper。connection。Open(）；SqlDataReader datareader=command.ExecuteReader（）;string typename=”;while(datareader.Read（)typename=(string）datareader0；comboBox2。Items。Ad

26、d（typename）；datareader。Close();string sql2=select publishername from publisher;SqlCommand command1=new SqlCommand（sql2,Dbhelper。connection）;/Dbhelper.connection.Open（);SqlDataReader datareader1=command1.ExecuteReader()；string publishername=”；while(datareader1.Read（)publishername=(string）datareader10

27、；/MessageBox。Show（publishername）；comboBox1.Items。Add(publishername)；datareader1。Close();catch MessageBox.Show（error）;finally Dbhelper。connection.Close（）;private void button2_Click(object sender,EventArgs e）textBox1.Text=null;textBox2.Text=null；textBox4.Text=null；comboBox2.Text=null；comboBox1.Text=nu

28、ll;private string typdid(string a)string id=”;string sqltypeid=string.Format（select booktypeid from booktype wherebooktypename=0,a）;trySqlCommand command=new SqlCommand（sqltypeid,Dbhelper。connection);Dbhelper.connection。Open();id=Convert。ToString(command.ExecuteScalar(）；catchMessageBox.Show（”error)；

29、finally Dbhelper.connection.Close(）；return id；private string publisheid(string a）string id=”;string sqlpublisheid=string。Format（select publisherid from publisher wherepublishername=0,a);trySqlCommand command=new SqlCommand（sqlpublisheid，Dbhelper。connection）；Dbhelper。connection.Open()；id=Convert。ToSt

30、ring(command。ExecuteScalar(）;catch MessageBox.Show(”error);finally Dbhelper.connection。Close（）；return id;private void button1_Click(object sender，EventArgs e)string name=textBox1。Text;string writter=textBox2.Text；string publisher=comboBox1.Text;string type=comboBox2。Text;string price=textBox4.Text;/

31、string id=textBox5.Text;string typeid=typdid（type);string publisherid=publisheid（publisher）;string bianhao=textBox3.Text;try if(bianhao！=&name!=”&writter！=”&publisher！=”&type!=”&price!=”)Dbhelper。connection。Open（）；string sql=string.Format(insert into book（BOOKID，bookname，bookwritter,publisherid,book

32、typeid,bookprice）values（0,1,2,3,4，5)”，bianhao，name,writter,publisherid,typeid,price)；SqlCommand commmand=new SqlCommand（sql，Dbhelper。connection);int ab=commmand。ExecuteNonQuery(）；if（ab！=0)MessageBox.Show（”保存成功，保存”）;else MessageBox。Show（添加失败）;return;else if（name=”writter=”|publisher=|type=”|price=”)M

33、essageBox.Show(请输入所有信息，”错误”,MessageBoxButtons.OK，MessageBoxIcon。Error)；catch/(exception ex）MessageBox。Show(”操作数据库出错”，”提示”,MessageBoxButtons。OK，MessageBoxIcon.Information）；finallyDbhelper.connection。Close(）;private void button3_Click(object sender，EventArgs e)this.Close(）;添加读者信息界面：using System;using

34、System。Collections.Generic;using System。ComponentModel；using System。Data；using System.Drawing；using System。Text;using System。Windows.Forms；using System.Data.SqlClient；namespace bookpublic partial class addreader:Form public addreader（）InitializeComponent();/退出窗口private void button3_Click（object send

35、er，EventArgs e）/Application。Exit（）；this。Close(）；/清除所有内容private void button1_Click（object sender，EventArgs e)textBox1.Text=null；textBox2.Text=null;textBox4。Text=null；textBox3.Text=null；textBox5.Text=null;comboBox1.Text=null；comboBox2.Text=null;private void button2_Click(object sender,EventArgs e）/连接数

36、据库/定义变量string name=textBox1.Text;string age=textBox2。Text;string sex=comboBox1。Text；string studentId=textBox3。Text；string dept=textBox4。Text；string zhuanye=textBox5.Text；string maxnumber=comboBox2。Text;string pass=textBox6.Text；try if（name！=”age!=”&sex！=”&studentId！=”&dept!=”zhuanye！=”maxnumber!=pas

37、s!=”)Dbhelper。connection.Open();string sql=string.Format(insert into reader（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);SqlCommand commmand=new SqlCommand（sql,Dbhelper。connection)；in

38、t ab=commmand.ExecuteNonQuery（)；if(ab！=0)MessageBox.Show(”保存成功，保存”);else MessageBox.Show（”添加失败”）;return；else if(name=”|age=”sex=”|studentId=|dept=|zhuanye=”|maxnumber=”)MessageBox.Show(请输入所有学生信息,错误，MessageBoxButtons.OK,MessageBoxIcon.Error)；catch/(exception ex)MessageBox.Show(操作数据库出错，提示”，MessageBoxB

39、uttons。OK，MessageBoxIcon.Information）；/Console。WriteLine(ex);finally Dbhelper。connection。Close();private void button4_Click（object sender,EventArgs e）readerinfo a=new readerinfo（）;a.Show（）；查询图书界面:using System;using System.Collections.Generic;using System。ComponentModel;using System.Data；using System

40、。Drawing;using System。Text；using System。Windows。Forms；using System.Data.SqlClient;namespace bookpublic partial class adminborrow:Formprivate DataSet dataset=new DataSet（);private SqlDataAdapter dataadapter；public adminborrow（）InitializeComponent();private void button2_Click(object sender，EventArgs e

41、）if（comboBox1。Text=个人”)trystring id=textBox1。Text；string sql=string。Format(select readerid，bookid,borrowtime,returntime,outtime from borrow where readerid=0,id);dataadapter=new SqlDataAdapter（sql，Dbhelper。connection）；dataadapter。Fill（dataset,”borrow”）;dataGridView1。DataSource=dataset。Tables”borrow;c

42、atch MessageBox。Show（error）;finally Dbhelper.connection.Close();elsetry string id=textBox1。Text;string sql=string。Format（select readerid，bookid,borrowtime,returntime，outtime from borrow”）；dataadapter=new SqlDataAdapter(sql，Dbhelper.connection）；dataadapter。Fill(dataset，borrow”)；dataGridView1.DataSour

43、ce=dataset。Tablesborrow；catchMessageBox.Show(error”）;finallyDbhelper.connection。Close(）;private void button1_Click（object sender,EventArgs e）groupBox1.Visible=true；private void button3_Click(object sender，EventArgs e)dataset。Tables”borrow”.Clear（）;private void button4_Click（object sender,EventArgs e

44、）string rid=textBox2。Text;string bid=textBox3.Text；tryif（rid！=”bid！=”)Dbhelper.connection.Open();string sql=string.Format(update borrow set returntime=getdate（）,outtime=已还 where readerid=0and bookid=1 and outtime=否,rid,bid);SqlCommand commmand=new SqlCommand(sql,Dbhelper。connection)；int ab=commmand。

45、ExecuteNonQuery()；string sql1=string。Format(update book set ifborrow=否 where bookid=0,bid）；SqlCommand co=new SqlCommand(sql1，Dbhelper.connection）；int c=co.ExecuteNonQuery（)；if（ab!=0&c!=0)MessageBox.Show（还书成功，保存）；elseMessageBox.Show(”还书失败”);return；else if（rid=”|bid=”)MessageBox.Show（请输入所有信息”，错误,Messa

46、geBoxButtons。OK，MessageBoxIcon.Error)；catch/(exception ex)MessageBox。Show（操作数据库出错,”提示”，MessageBoxIcon.Information）;/Console.WriteLine（ex）;finallyDbhelper。connection.Close（);using System；using System。Collections。Generic;using System。ComponentModel；using System.Data；using System。Drawing；using System。T

47、ext；using System。Windows.Forms;using System.Data。SqlClient；namespace bookpublic partial class adminearchbook：Formprivate DataSet dataset=new DataSet();private SqlDataAdapter dataadapter；public adminearchbook()InitializeComponent();private void button1_Click（object sender，EventArgs e）try string sql;M

48、essageBoxButtons。OK，if(comboBox1.Text=”书名)sql=string。Format（”selectbookid,bookname,bookwritter,booktype.booktypename,bookprice,booktype。flow,publisher。publishername，ifborrow from book,booktype,publisher where book.booktypeid=booktype.booktypeidand book.publisherid=publisher。publisherid and bookname=

49、0”，textBox1。Text）;else if(comboBox1。Text=”作者)sql=string.Format(”select bookid，bookname,bookwritter，booktype。booktypename，bookprice,booktype.flow，publisher.publishername,ifborrow from book，booktype,publisher where book。booktypeid=booktype。booktypeid and book。publisherid=publisher.publisherid and book

50、writter like 0，textBox1.Text)；else if（comboBox1。Text=出版社）sql=string。Format(”select bookid，bookname，bookwritter，booktype。booktypename,bookprice,booktype。flow,publisher.publishername,ifborrow from book，booktype,publisher where book。booktypeid=booktype.booktypeid and book。publisherid=publisher.publishe