C#MySQL图书管理系统

院专年2014学生姓名 号 师 开发环境：Windows10-开发工具：VisualStudio013数据库工具管理员表图书信息表借阅信息表用户信息表adminInfo否管理员否否bookInfo否图书编号否否否否是是是借阅人的是0borrowed否借阅信息是操作人是是图书是0是是UserInfo否用户否否是csmainCenter.cs：stringsql="server=localhost;userid=root;password=123456;database=C#librarycenter";MySqlConnectionconnnewMySqlConnection(sql);MySqlDataAdapterdata1=MySqlCommandcmd1=newMySqlCommand("SELECTbookName'图书名',bookAuthoras'作者',bookPriceas'图书价格',bookPress'出版社',bookTypeas',(CASEisBorrowedWHEN0THENELSE'已借阅'END)as'借阅情况'FROM`c#librarycenter`.bookinfo",data1.SelectCommandcmd1;//设置为已实例化SqlDataAdapter的查询命令DataTabledt=newDataTable();data1.Fill(dt);//把数据填充到dataGridView1.DataSourcedt;//将数据集绑定datagridview,完成显示dataGridView1.AllowUserToAddRows=false;loginlogin=label1.Text="这里是SMART-LIBRARY！用户："+}privatevoidbutton1_Click(objectsender,EventArgse){Stringso=textBox1.Text;Stringsql="server=localhost;userid=root;password=123456;database=C#librarycenter";MySqlConnectionconnnewMySqlConnection(sql);MySqlDataAdapterdata1=MySqlCommandcmd1=newMySqlCommand("SELECTbookName'图书名',bookAuthoras'作者',bookPriceas'图书价格',bookPress'出版社',bookTypeas',(CASEisBorrowedWHEN0THENELSEEND)as'FROM`c#librarycenter`.bookinfowherebookNamelike'%"+so+"%'",conn);//sql语句data1.SelectCommand=cmd1;//设置为已实例化SqlDataAdapter//DataSetds1newDataSet();//实例化datasetDataTabledt=newDataTable();data1.Fill(dt);//把数据填充到dataGridView1.DataSourcedt;//将数据集绑定datagridview,完成显示dataGridView1.AllowUserToAddRows=false;}主要实现代码-privatevoiddataGridView1_CellContentClick(objectsender,DataGridViewCellEventArgse){intr=stringh=this.dataGridView1.Rows[r].Cells[1].Value.ToString();strings=loginlogin=newlogin();StringuserId="";DateTimedt=DateTime.Now;StringborrowedTime=dt.ToString("yyyy-MM-stringsql="server=localhost;userid=root;password=123456;database=C#librarycenter";MySqlConnectionconn=StringupdateBorrow1="selectuserIdfromuserInfowhere=MySqlCommandmysqlcommand=newMySqlCommand(updateBorrow1,conn);MySqlDataReadermdr=mysqlcommand.ExecuteReader();if(mdr.Read()){userId=}StringupdateBorrow2="updatebookInfosetisBorrowed='1',borrowId='"+userId+"',borrowedTime='"+borrowedTime+"'wherebookId='"+h+"'";MySqlCommandmysqlcommand2=newMySqlCommand(updateBorrow2,conn);inti=mysqlcommand2.ExecuteNonQuery();if(i!=-{MessageBox.Show(login.username+"\r\n恭喜你借"+"<<"+s>>\r\n}{MessageBox.Show("}StringupdateBorrow3="insertintoborrowed(userId,userName,bookId,editTime,bookName,edit)values('"+userIdlogin.usernamehborrowedTime"','"+s+"','借书')";MySqlCommandmysqlcommand3=newMySqlCommand(updateBorrow3,conn);}主要实现代码–privatevoiddataGridView1_CellContentClick(objectsender,DataGridViewCellEventArgse){intr=stringh=this.dataGridView1.Rows[r].Cells[1].Value.ToString();strings=this.dataGridView1.Rows[r].Cells[2].Value.ToString();DateTimedt=DateTime.Now;StringreturnedTime=dt.ToString("yyyy-MM-StringuserId=stringsql="server=localhost;userid=root;password=123456;database=C#librarycenter";MySqlConnectionconn=newMySqlConnection(sql);StringupdateBorrow1="updatebookInfosetisBorrowed='0',borrowId=null,borrowedTime=nullwherebookId='"+h+"'";MySqlCommandmysqlcommand2=newMySqlCommand(updateBorrow1,conn);inti=mysqlcommand2.ExecuteNonQuery();if(i!=-{MessageBox.Show(login.username+"\r\n<<"+s+"\r\n}{MessageBox.Show("}StringupdateBorrow="selectuserIdfromuserInfowhereuserName='"+login.username+"'";MySqlCommandmysqlcommand=newMySqlCommand(updateBorrow,conn);MySqlDataReadermdr=mysqlcommand.ExecuteReader();if{userId=}StringupdateBorrow2="insertintoborrowed(userId,userName,bookId,editTime,bookName,edit)values('"+userIdlogin.usernamehreturnedTime"','"+s+"','还书')";MySqlCommandmysqlcommand3=newMySqlCommand(updateBorrow2,conn);}主要实现代码–privatevoidbutton1_Click(objectsender,EventArgs{loginlogin=newlogin();Stringpw=textBox1.Text;Stringnpw=Stringun=login.username;StringuserPassword="";StringuserId="";if(male.Checked==true)ans="male";if(female.Checked==true)ans="female";Stringsql="server=localhost;userid=root;password=123456;database=C#librarycenter";MySqlConnectionconn=newMySqlConnection(sql);Stringyanzheng="SELECTuserPasswordFROMuserinfowhere=MySqlCommandyz=newMySqlCommand(yanzheng,conn);MySqlDataReadermdr2=yz.ExecuteReader();if{userPassword=}if(textBox2.Text.Trim()!={if(pw=={Stringeditsql1="selectuserIdfromuserInfowhereuserName=+login.username+"'MySqlCommandcmd1=newMySqlCommand(editsql1,conn);MySqlDataReadermdr=cmd1.ExecuteReader();if(mdr.Read()){userId=mdr.GetString(0);}else{}Stringeditsql2="updateuserInfosetuserPassword='"+npw+"',userSex='"+ans+"'whereuserId='"+userId+"'";MySqlCommandcmd2=newMySqlCommand(editsql2,conn);inti=cmd2.ExecuteNonQuery();if(i=={MessageBox.Show(login.username"\r\n您的信息修改成功！\r\n}{MessageBox.Show("修改失败，请联系管理员}}{MessageBox.Show("}}{MessageBox.Show("}}borrowedinfo.cs：label1.Text=login.usernameStringsql="server=localhost;userid=root;password=123456;database=C#librarycenter";MySqlConnectionconnnewMySqlConnection(sql);StringuserId=MySqlCommandcmd=newMySqlCommand("selectuserIdfromborrowedwhereuserName='"+login.username+"'",conn);MySqlDataReadermdr=cmd.ExecuteReader();if(mdr.Read()){userId=mdr.GetString(0);}MySqlDataAdapterdata1=MySqlCommandcmd1=newMySqlCommand("selectbookId'图书编号',bookNameas',editTimeas',editasfromborrowedwhereuserId='"+userId+"'",conn);//sql语句data1.SelectCommand=cmd1;//设置为已实例化SqlDataAdapter//DataSetds1newDataSet();//实例化datasetDataTabledt=newDataTable();data1.Fill(dt);//把数据填充到dataGridView1.DataSourcedt;//将数据集绑定datagridview,完成显示dataGridView1.AllowUserToAddRows=false;}主要实现代码–privatevoid关于ToolStripMenuItem_Click(objectsender,EventArgs{MessageBox.Show("制作者：MatthewHan\r\n完成时间：2017-6-}privatevoid退出系统ToolStripMenuItem_Click(objectsender,{}privatevoid图书管理ToolStripMenuItem_Click(objectsender,{editMaineditMain=neweditMain();editMain.FormBorderStyle=FormBorderStyle.None;editMain.Dock=DockStyle.Fill;editMain.TopLevel=false;}privatevoid添加图书ToolStripMenuItem_Click(objectsender,{edit2edit2=newedit2();}privatevoid用户管理ToolStripMenuItem_Click(objectsender,{edit3edit3=newedit3();edit3.FormBorderStyle=FormBorderStyle.None;edit3.Dock=DockStyle.Fill;edit3.TopLevel=false;}editMain.cs&edit1.cs：privatevoiddataGridView1_CellContentClick(objectsender,DataGridViewCellEventArgse){intr=stringbn=this.dataGridView1.Rows[r].Cells[1].Value.ToString();stringba=this.dataGridView1.Rows[r].Cells[2].Value.ToString();stringbp1=this.dataGridView1.Rows[r].Cells[3].Value.ToString();stringbp2=this.dataGridView1.Rows[r].Cells[4].Value.ToString();stringbt=this.dataGridView1.Rows[r].Cells[5].Value.ToString();editMaineditMain=neweditMain();editMain.bookname=editMain.bookauthor=ba.ToString();editMain.bookprice=bp1.ToString();editMain.bookpress=bp2.ToString();editMain.booktype=bt.ToString();edit1edit1=newedit1();}publicedit1(){editMaineditMain=neweditMain();label6.Text=editMain.bookname;textBox1.Text=editMain.bookauthor;textBox2.Text=editMain.bookprice;textBox3.Text=editMain.bookpress;textBox4.Text=editMain.booktype;}privatevoidbutton1_Click(objectsender,EventArgs{Stringbn=editMain.bookname;Stringba=textBox1.Text;Stringbp1=textBox2.Text;Stringbp2=textBox3.Text;Stringbt=textBox4.Text;Stringsql="server=localhost;userid=root;password=123456;database=C#librarycenter";MySqlConnectionconn=newMySqlConnection(sql);Stringsql2="updatebookInfosetbookAuthor='"+ba+"',bookPrice='"+bp1+"',bookPress='"+bp2+"',bookType='"+bt+"'wherebookName='"+bn+"'MySqlCommandcmd=newMySqlCommand(sql2,inti=cmd.ExecuteNonQuery();if(i==1)MessageBox.Show("}主要实现代码–privatevoidbutton1_Click(objectsender,EventArgse){Stringbn=textBox5.Text;Stringba=textBox1.Text;Stringbp1=textBox2.Text;Stringbp2=Stringbt=Stringsql="server=localhost;userid=root;