图书管理系统源码C#版

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()InitializeCompon

2、ent();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.

3、Trim() = )MessageBox.Show( 请输入用户名 , 登录提示 , MessageBoxButtons .OK, MessageBoxIcon.Information);loginid.Focus();return false ;else if (password = )MessageBox.Show( 请输入密码 , 登录提示 , MessageBoxButtons .OK, MessageBoxIcon.Information);textBox3.Focus();return falseelsereturn true ; private void button1_Clic

4、k( object sender, EventArgs e)userhelper .adminid= loginid.Text;/ 用户账号password = textBox3.Text; / 用户密码if (yanzhengshuru()if (Typename.Text.Trim() = 管理员 )string sql = string .Format( Select count(*) from admin where adminId=0 and adminpass=1 , loginid.Text, password);try SqlCommandcommand = new SqlCo

5、mmand(sql, Dbhelper .connection); Dbhelper .connection.Open();int count = ( int )command.ExecuteScalar();if (count 1)MessageBox.Show( 用户或密码不存在！ ); /result = false;elseadmin admin = new admin();admin.Show();catch ( Exception ex)MessageBox.Show( 操作数据库出错！ ); Console .WriteLine(ex.Message);finallyDbhelp

6、er .connection.Close();if (Typename.Text.Trim() = 借阅者 )userhelper .readerid = Convert .ToString (loginid.Text);string sql = string .Format( Select count(*) from reader where readerId=0 and readerpass=1 , userhelper .readerid,textBox3.Text);try/ 创建 Command 对象SqlCommandcommand = new SqlCommand(sql, Db

7、helper .connection);/ 打开数据库连接Dbhelper .connection.Open();/ 验证是否为合法用户int count = ( int )command.ExecuteScalar();if (count 1)MessageBox.Show( 用户或密码不存在！ );/result = false;elsereader reader = new reader ();reader.Show();catch ( Exception ex)MessageBox.Show( 操作数据库出错！ );Console .WriteLine(ex.Message);/res

8、ult = false;finally/ 关闭数据库连接Dbhelper .connection.Close();private void login_Load( object sender, EventArgs e) 读者界面 ;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.Sql;usin

9、g System.Data.SqlClient;namespace bookpublic partial class reader : Formpublic reader() InitializeComponent();private void button3_Click( object sender, EventArgs e)string id = Convert .ToString (textBox1.Text);if (id!= userhelper .readerid)MessageBox.Show( 输入账号与登陆账号不相同，请重新输入, 提示 , MessageBoxButtons

10、 .OK, MessageBoxIcon .Warning);textBox1.Text = ; textBox1.Focus();elsetrystring sql = string .Format( update reader set islost=0where readerid=1 , 是 ,id);Dbhelper .connection.Open();SqlCommandcommand = new SqlCommand(sql, Dbhelper .connection); int result = command.ExecuteNonQuery();if (result 1)Mes

11、sageBox.Show( 修改失败 );else MessageBox.Show( 挂失成功 );catchMessageBox.Show( error );finallyDbhelper .connection.Close();private void toolStripButton3_Click( object sender, EventArgs e) groupBox1.Visible =false ;groupBox2.Visible =true ;private void toolStripButton4_Click( object sender, EventArgs e) tru

12、e ; false ;object sender, EventArgs e)groupBox1.Visible = groupBox2.Visible =private void button5_Click(textBox2.Text = textBox4.Text =textBox5.Text = private void Form1_Load( object sender, EventArgs e) .readerid);, 提示toolStrip1.Text = string .Format( 学生： 0 , userhelper private void button4_Click(

13、object sender, EventArgs e) string id = Convert .ToString (textBox2.Text);if (id!= userhelper .readerid)MessageBox.Show( 输入账号与登陆账号不相同，请重新输入 , MessageBoxButtons .OK, MessageBoxIcon .Warning);textBox1.Text = ; textBox1.Focus();else if (textBox4.Text!=textBox5.Text)MessageBox.Show ( 两次密码输入不同 );else try

14、string sql = string .Format( update reader set readerpass=0 wherereaderid=1, textBox4.Text,id);Dbhelper .connection.Open();SqlCommandcommand = new SqlCommand(sql, Dbhelper .connection);int result = command.ExecuteNonQuery();if (result 1)MessageBox.Show( 修改失败 );else MessageBox.Show( 修改成功 );catchMessa

15、geBox.Show( error );finallyDbhelper .connection.Close();privatevoid toolStripButton6_Click(object sender, EventArgs e)addreader addreader = new addreader ();addreader =new addreader ();private void toolStripButton1_Click(object sender, EventArgs e)readsearchbook searchbook =new readsearchbook ();sea

16、rchbook.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 void 图书查询 ToolStripMenuItem1_Click(object sender, EventArgs e)

17、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) groupBox1.Visible =false ;groupBox2.Visible =tr

18、ue ;private void 挂失 ToolStripMenuItem_Click( object sender, EventArgs e)groupBox1.Visible =groupBox2.Visible =true ; false ;private void 退出 ToolStripMenuItem_Click( object sender, EventArgs e)this .Close();private void button2_Click( object sender, EventArgs e) Application .Exit(); 管理员界面 ;using Syst

19、em;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 sender, EventArgs e)t

20、his .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 借书信息 ToolSt

21、ripMenuItem_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(

22、);a.Show();private void 删除图书 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(

23、object sender, EventArgs e) publisher a = 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 =

24、 new adminborrow ();a.Show();private void toolStripButton6_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( o

25、bject sender, EventArgs e)deletereader a = new deletereader ();a.Show(); 添加图书信息界面： 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 cl

26、ass addbook : Formpublic addbook()InitializeComponent();private void addbook_Load( object sender, EventArgs e) trystring sql1 = select booktypename from booktype;SqlCommandcommand = new SqlCommand(sql1, Dbhelper .connection);Dbhelper .connection.Open();SqlDataReader datareader = command.ExecuteReade

27、r();string typename = ;while (datareader.Read()typename = (string )datareader0;comboBox2.Items.Add(typename);datareader.Close();string sql2 = select publishername from publisher;SqlCommandcommand1 = new SqlCommand(sql2, Dbhelper .connection); /Dbhelper.connection.Open();SqlDataReader datareader1 = c

28、ommand1.ExecuteReader();string publishername = ;while (datareader1.Read()publishername = (string )datareader10;/MessageBox.Show(publishername); comboBox1.Items.Add(publishername);datareader1.Close();catchMessageBox.Show( error );finallyDbhelper .connection.Close();private void button2_Click( object

29、sender, EventArgs e)textBox1.Text =nulltextBox2.Text =nulltextBox4.Text =nullcomboBox2.Text =nullcomboBox1.Text =nullprivate string typdid( string a)string id = ;string sqltypeid = string .Format( select booktypeid from booktype where booktypename=0 , a);try SqlCommandcommand=new SqlCommand(sqltypei

30、d, Dbhelper .connection); Dbhelper .connection.Open();id = Convert .ToString(command.ExecuteScalar();catchMessageBox.Show( error );finallyDbhelper .connection.Close();return id;private string publisheid( string a)string id = ;string sqlpublisheid = string .Format( select publisherid from publisher w

31、here publishername=0, a);try SqlCommandcommand = new SqlCommand(sqlpublisheid, Dbhelper .connection); Dbhelper .connection.Open();id = Convert .ToString(command.ExecuteScalar();catchMessageBox.Show( error );finallyDbhelper .connection.Close(); return id;private void button1_Click( object sender, Eve

32、ntArgs e)string name =textBox1 .Text ;string writter=textBox2 .Text ;string publisher = comboBox1.Text;string type=comboBox2.Text;string price = textBox4.Text;/string id = textBox5.Text;string typeid = typdid(type);string publisherid = publisheid(publisher);string bianhao = textBox3.Text;try!=if (bi

33、anhao!= &name!= &writter != & publisher!= &type != &price )Dbhelper .connection.Open();string sql = string .Format( insert into book (BOOKID,bookname,bookwritter,publisherid,booktypeid,bookprice) values (0,1,2,3,4,5) ,bianhao, name,writter ,publisherid,typeid,price);SqlCommandcommmand = new SqlComma

34、nd(sql, Dbhelper .connection );int ab =commmand.ExecuteNonQuery();if (ab != 0)MessageBox.Show( 保存成功 , 保存);elseMessageBox.Show( 添加失败 );return ; else if (name = | writter = | publisher = | type= | price= MessageBox.Show( 请输入所有信息 , 错误 , MessageBoxButtons .OK , MessageBoxIcon .Error );catch /(exception

35、ex)MessageBox.Show( 操作数据库出错 , 提示, MessageBoxButtons .OK, MessageBoxIcon.Information);finallyDbhelper .connection.Close();private void button3_Click( object sender, EventArgs e) this .Close(); 添加读者信息界面： using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using

36、System.Drawing;using System.Text;using System.Windows.Forms;using System.Data.SqlClient; namespace bookpublic partial class addreader : Formpublic addreader()InitializeComponent(); / 退出窗口private void button3_Click( object sender,/Application.Exit();this .Close(); / 清除所有内容private void button1_Click(

37、object sender,EventArgs e)EventArgs e)textBox1.Text =nulltextBox2.Text =nulltextBox4.Text =nulltextBox3.Text =nulltextBox5.Text =nullcomboBox1.Text =nullcomboBox2.Text =null private void button2_Click( object sender, / 连接数据库 / 定义变量EventArgs e)string name =textBox1 .Text ; string age=textBox2 .Text ;

38、string sex = 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();string

39、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);SqlCommandcommmand = new SqlCommand(sql, Dbhelper .connection );int ab = commmand.Exec

40、uteNonQuery();if (ab != 0)MessageBox.Show( 保存成功 , 保存);elseMessageBox.Show( 添加失败 );return ; else if (name = | age = | sex = | studentId = | dept= | zhuanye = | maxnumber = )MessageBox.Show( 请输入所有学生信息 ,错误 , MessageBoxButtons .OK , MessageBoxIcon .Error );catch /(exception ex)MessageBox.Show( 操作数据库出错 ,

41、 提示, MessageBoxButtons .OK, MessageBoxIcon.Information);/ Console.WriteLine (ex);Dbhelper .connection.Close(); finallyprivate void button4_Click( object sender, EventArgs e)readerinfo a = new readerinfo ();a.Show(); 查询图书界面： using System; using System.Collections.Generic; using System.ComponentModel;

42、 using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; namespace book public partial class adminborrow : Formprivate DataSet dataset = new DataSet ();private SqlDataAdapter dataadapter;public adminborrow()InitializeComponent();private vo

43、id button2_Click( object sender, EventArgs e)if (comboBox1.Text = 个人)try string id = textBox1.Text;, id);string sql = string .Format( select readerid,bookid,borrowtime,returntime,outtime from borrow where readerid=0dataadapter = new SqlDataAdapter (sql, Dbhelper .connection); dataadapter.Fill(datase

44、t, borrow );dataGridView1.DataSource = dataset.Tables borrow ;catchMessageBox.Show( error );Dbhelper .connection.Close();finallyelsetrydataadapter =new SqlDataAdapter (sql,Dbhelper .connection);dataadapter.Fill(dataset,borrow );dataGridView1.DataSource = dataset.Tablesborrow ;catchMessageBox.Show( e

45、rror );finallyDbhelper .connection.Close();privatevoidbutton1_Click( object sender,EventArgs e)groupBox1.Visible =true ;private void button3_Click( object sender,EventArgs e)dataset.Tablesborrow .Clear();privatevoid button4_Click( object sender,EventArgs e)string id = textBox1.Text;string sql = stri

46、ng .Format( select);readerid,bookid,borrowtime,returntime,outtime from borrowstring rid = textBox2.Text;string bid = textBox3.Text;tryif (rid != & bid != )Dbhelper .connection.Open();string sql = string .Format( update borrow setreturntime=getdate(),outtime=已还 where readerid= 0and bookid=1 and outti

47、me =否 rid, bid);SqlCommandcommmand = new SqlCommand(sql, Dbhelper .connection); int ab = commmand.ExecuteNonQuery();,bid);string sql1 = string .Format( update book set ifborrow=否 where bookid=0SqlCommandco = new SqlCommand(sql1, Dbhelper .connection );int c = co.ExecuteNonQuery();if (ab != 0&c!=0)Me

48、ssageBox.Show( 还书成功 , 保存 );elseMessageBox.Show( 还书失败 );return ;else if (rid = | bid = )MessageBox.Show( 请输入所有信息 , 错误 , MessageBoxButtons .OK, MessageBoxIcon.Error);catch /(exception ex)MessageBox.Show( 操作数据库出错 , 提示, MessageBoxButtons .OK, MessageBoxIcon.Information);/ Console.WriteLine (ex);finallyD

49、bhelper .connection.Close();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 adminearchbook : Form private DataSet dataset = new

50、 DataSet ();private SqlDataAdapter dataadapter;public adminearchbook()InitializeComponent();private void button1_Click( object sender, EventArgs e)trystring sql;if (comboBox1.Text = 书名 )sql =string .Format( select bookid,bookname,bookwritter,booktype.booktypename,bookprice,booktype.flow,publisher.pu

51、blishe rname,ifborrow from book,booktype,publisher where book.booktypeid=booktype.booktypeid and book.publisherid=publisher.publisherid and bookname = 0, textBox1.Text);else if (comboBox1.Text = 作者 )sql =string .Format( select bookid,bookname,bookwritter,booktype.booktypename,bookprice,booktype.flow

52、,publisher.publishe rname,ifborrow from book,booktype,publisher where book.booktypeid=booktype.booktypeid and book.publisherid=publisher.publisherid and bookwritter like %0%, textBox1.Text);else if (comboBox1.Text = 出版社 )sql =string .Format( select bookid,bookname,bookwritter,booktype.booktypename,bookprice,booktype.flow,publisher.publishe rname,ifborrow fr