文章目录
前言
图书馆管理系统主要功能有普通用户（学生）借书、管理员管理图书。
一、业务梳理与需求分析
1.功能描述
- 系统中的普通用户模块有以下功能： 图书查询：根据输入的搜索条件进行查询，可以查找多项，也可以查找所有图书。 图书借阅：提供图书借阅证号，可以进行图书借阅。
- 系统中的管理员用户模块有以下功能： 图书查询：查询图书信息。 图书借阅：提供图书借阅证号，可以进行图书借阅。 增加图书：增添新图书。 修改图书：对图书信息进行修改。 删除图书：删除过时的、不能借阅的图书。
2.实现步骤
- 一个完整系统的数据库设计。
- 图书馆管理系统的界面设计。
- 项目的通用类。
- 图书馆管理系统代码的实现和分析。
3.功能逻辑图
二、数据库设计
1.实体-关系（E-R图）概念模型设计
2.数据表设计
根据需求分析进行数据库设计，数据库名称为BookManage，根据E-R图，有学生表、图书信息表、管理员表、借阅表。学生和管理员合并为一张用户表，增加一个字段用户权限进行区分。
- 用户表结构
- 图书信息表结构
- 图书借阅信息表结构
三、WinForm界面交互设计
1、界面交互逻辑
2、项目树
3、主界面+登录界面
4、 图书查询界面
5、图书借阅界面
6、图书插入界面
7、图书更新/删除界面
四、通用类设计
1、与MySQL通讯模块（整个类模块中删除命名空间等，值保留这个类）
publicstaticclassDBModule{publicstatic string ServerIP ="**.**.**.**";publicstatic string ServerPort ="****";publicstatic string ServerUser ="****";publicstatic string ServerPassword ="****";publicstatic string ServerDBName ="bookmanage";}
2、数据库操作模块：
using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Threading.Tasks;using MySql.Data.MySqlClient;using System.Data;publicclassMySQLHelper{private MySqlConnection myConnection;private string mErrorString;//构造函数publicMySQLHelper(string strServerIP, string strServerPort, string strServerUser, string strPassword, string strDBName){
string strConnectionString = String.Format("server={0}; port={1}; user id={2}; password={3}; database={4}",
strServerIP, strServerPort, strServerUser, strPassword, strDBName);
myConnection =newMySqlConnection(strConnectionString);}//测试连接publicboolConnectionTest(){bool result =false;try{if(myConnection.State == System.Data.ConnectionState.Closed){
myConnection.Close();
result =true;}}catch(MySqlException ex){
mErrorString = ex.ToString();}return result;}/// <summary>/// 执行查询语句，用DataTable返回结果，调用前要传入DataTable的实例化对象作为参数/// </summary>/// <param name="strQuery">查询命令</param>/// <param name="dt">返回数据表</param>/// <returns></returns>publicboolExcuteQuerySql(string strQuery, ref DataTable dt){if(dt == null){
mErrorString ="传入的DataTable为null";returnfalse;}bool result =false;try{
MySqlCommand myCommand =newMySqlCommand(strQuery);
myCommand.Connection = myConnection;if(myConnection.State == ConnectionState.Closed){
myConnection.Open();}
dt.Load(myCommand.ExecuteReader());
result =true;}catch(MySqlException ex){
mErrorString = String.Format("ExcuteQuery {0} failed.", ex.ToString());returnfalse;}
finally
{
myConnection.Close();}return result;}/// <summary>/// 执行带参数的查询语句，使用前传入参数、DataTable实例化对象/// </summary>/// <param name="strQuery">查询语句</param>/// <param name="param"></param>/// <param name="dt"></param>/// <returns></returns>publicboolExcuteQuerySql(string strQuery, MySqlParameter[] param, ref DataTable dt){if(dt == null){
mErrorString ="传入的DataTable为null.";returnfalse;}bool result =false;try{
MySqlCommand myCommand =newMySqlCommand(strQuery);
myCommand.Connection = myConnection;if(myConnection.State == ConnectionState.Closed){
myConnection.Open();}for(int i =0; i < param.Length; i++){
myCommand.Parameters.Add(param[i]);}
dt.Load(myCommand.ExecuteReader());
result =true;}catch(MySqlException ex){
mErrorString = String.Format("ExcuteQuery {0} failed", strQuery)+ ex.Message;returnfalse;}
finally
{
myConnection.Close();}return result;}//执行非查询语句publicintExcuteSql(string SqlCmdText){int row =-1;try{
MySqlCommand myCommand =newMySqlCommand(SqlCmdText);
myCommand.CommandText = SqlCmdText;
myCommand.Connection = myConnection;if(myConnection.State == ConnectionState.Closed){
myConnection.Open();}
row = myCommand.ExecuteNonQuery();}catch(MySqlException ex){
mErrorString = String.Format("ExcuteNonQuery {0} failed", SqlCmdText);}return row;}//执行非查询语句publicintExcuteSql(string[] SqlCmdText){try{if(myConnection.State == ConnectionState.Closed){
myConnection.Open();}for(int i =0; i < SqlCmdText.Length; i++){
MySqlCommand myCommand =newMySqlCommand(SqlCmdText[i]);
myCommand.CommandText = SqlCmdText[i];
myCommand.Connection = myConnection;
myCommand.ExecuteNonQuery();}}catch(MySqlException ex){
mErrorString = String.Format("ExcuteNonQuery {0} failed", SqlCmdText)+ ex.Message;return-1;}return-1;}//执行带参数的非查询语句publicintExcuteSql(string SqlCmdText, MySqlParameter[] param){int row =-1;try{
MySqlCommand myCommand =newMySqlCommand(SqlCmdText);
myCommand.CommandText = SqlCmdText;
myCommand.Connection = myConnection;if(myConnection.State == ConnectionState.Closed){
myConnection.Open();}for(int i =0; i < param.Length; i++){
myCommand.Parameters.Add(param[i]);}
row = myCommand.ExecuteNonQuery();}catch(MySqlException ex){
mErrorString = String.Format("ExecuteNonQuery {0} failed", SqlCmdText)+ ex.Message;return row =-1;}return row;}public string GetErrInfo(){return mErrorString;}}
五、系统代码实现与分析
1、主界面代码：
using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Windows.Forms;namespace BookManage
{public partial classFrmMain:Form{publicstatic DialogResult result;//声明对话框返回对象publicFrmMain(){InitializeComponent();}/// <summary>/// 查询子窗体是否存在/// </summary>/// <param name="childfrmname"></param>/// <returns></returns>publicboolCheckChildFrm(string childfrmname){foreach(Form childFrm in this.MdiChildren)//遍历子窗体{if(childFrm.Name == childfrmname)//如果子窗体存在{if(childFrm.WindowState == FormWindowState.Minimized){
childFrm.WindowState = FormWindowState.Normal;}
childFrm.Activate();//激活该窗体returntrue;//存在返回true}}returnfalse;//不存在返回false}/// <summary>/// 用户登录菜单的事件处理/// </summary>/// <param name="sender"></param>/// <param name="e"></param>privatevoid 用户登录ToolStripMenuItem_Click(object sender, EventArgs e){//检测登录窗口是否打开if(this.CheckChildFrm("FrmLogin")==true){return;//窗口已经打开，返回}
FrmLogin user =newFrmLogin();//实例化登录窗体
user.ShowDialog();//登录窗体以模式对话框的方式打开//判断是否登录成功，登录成功则启用相应的菜单和按钮if(result == System.Windows.Forms.DialogResult.OK && FrmLogin.ustate ==0)//普通用户{
toolSBSearch.Enabled =true;
toolSBBookBorown.Enabled =true;}elseif(result == System.Windows.Forms.DialogResult.OK && FrmLogin.ustate ==1)//管理员{
toolSBSearch.Enabled =true;
toolSBBookBorown.Enabled =true;
toolMBookManage.Enabled =true;}}/// <summary>/// 用户登录按钮事件/// </summary>/// <param name="sender"></param>/// <param name="e"></param>privatevoidtoolSBLogin_Click(object sender, EventArgs e){//检测登录窗口是否打开if(this.CheckChildFrm("FrmLogin")==true){return;//窗口已经打开，返回}
FrmLogin user =newFrmLogin();//实例化登录窗体
user.ShowDialog();//登录窗体以模式对话框的方式打开//判断是否登录成功，登录成功则启用相应的菜单和按钮if(result == System.Windows.Forms.DialogResult.OK && FrmLogin.ustate ==0)//普通用户{//普通用户登录后使能按钮
toolSBSearch.Enabled =true;
toolSBBookBorown.Enabled =true;}elseif(result == System.Windows.Forms.DialogResult.OK && FrmLogin.ustate ==1)//管理员{//管理员登录后使能按钮
toolSBSearch.Enabled =true;
toolSBBookBorown.Enabled =true;
toolMBookManage.Enabled =true;}}/// <summary>/// 图书查询按钮，转到图书查询界面/// </summary>/// <param name="sender"></param>/// <param name="e"></param>privatevoidtoolSBSearch_Click(object sender, EventArgs e){if(this.CheckChildFrm("FrmBookSearch")==true){return;}
FrmBookSearch frmBookSearch =newFrmBookSearch();
frmBookSearch.MdiParent =this;//设置当前窗体的子窗体为frmBookSearch
frmBookSearch.Show();}/// <summary>/// 图书借阅按钮，转到图书借阅界面/// </summary>/// <param name="sender"></param>/// <param name="e"></param>privatevoidtoolSBBookBorown_Click(object sender, EventArgs e){if(this.CheckChildFrm("FrmBookBrown")==true){return;}
FrmBookBrown frmBookBrown =newFrmBookBrown();
frmBookBrown.MdiParent =this;//设置当前窗体的子窗体为frmBookBrown
frmBookBrown.Show();}/// <summary>/// 图书插入按钮，转到图书插入界面/// </summary>/// <param name="sender"></param>/// <param name="e"></param>privatevoidtoolMBookIn_Click(object sender, EventArgs e){if(this.CheckChildFrm("FrmBookIn")==true){return;}
FrmBookIn frmBookIn =newFrmBookIn();
frmBookIn.MdiParent =this;//设置当前窗体的子窗体为frmBookIn
frmBookIn.Show();}/// <summary>/// 图书更新/删除按钮，转到图书更新与删除界面/// </summary>/// <param name="sender"></param>/// <param name="e"></param>privatevoidtoolMBookUpdate_Click(object sender, EventArgs e){if(this.CheckChildFrm("FrmUpdateBook")==true){return;}
FrmUpdateBook frmUpdateBook =newFrmUpdateBook();
frmUpdateBook.MdiParent =this;//设置当前窗体的子窗体为frmUpdateBook
frmUpdateBook.Show();}privatevoidtoolSBExit_Click(object sender, EventArgs e){if(MessageBox.Show("确认退出程序？","确认信息", MessageBoxButtons.OKCancel)== System.Windows.Forms.DialogResult.OK){
System.Environment.Exit(0);}}}}
2、登录界面代码
using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Windows.Forms;namespace BookManage
{public partial classFrmLogin:Form{publicFrmLogin(){InitializeComponent();}publicstaticint ustate;//普通用户or管理员标志
FrmMain femmain =newFrmMain();privatevoidbtnLogin_Click(object sender, EventArgs e){//输入合法性判断if(Volidity())//合法性通过{
string state =this.cmbUserType.Text;int num;if(state.Equals("管理员"))//判断用户角色{
num =1;}else{
num =2;}//定义查询语句
string sql = String.Format("select * from user where uname='{0}' and upwd='{1}' and ustate='{2}'",this.txtUserName.Text.Trim(),this.txtPwd.Text.Trim(), num);
MySQLHelper sqlHelper =newMySQLHelper(DBModule.ServerIP, DBModule.ServerPort, DBModule.ServerUser, DBModule.ServerPassword, DBModule.ServerDBName);
DataTable dt =newDataTable();bool queryFlag = sqlHelper.ExcuteQuerySql(sql, ref dt);if(queryFlag ==false){
MessageBox.Show("登录失败，没有找到该用户");}if(dt.Rows.Count >0){
MessageBox.Show("登录成功！");
FrmMain.result = DialogResult.OK;//为变量result赋值
DBModule.UserName = txtUserName.Text;this.Close();}else{
MessageBox.Show("用户名或密码错误，请重新输入");}}}/// <summary>/// 验证合法性/// </summary>privateboolVolidity(){if(this.txtPwd.Text != string.Empty &&this.txtPwd.Text != string.Empty){returntrue;}else{
MessageBox.Show("用户名或密码不能为空");}returnfalse;}privatevoidbtnCancel_Click(object sender, EventArgs e){this.Close();}privatevoidcmbUserType_SelectedIndexChanged(object sender, EventArgs e){if(cmbUserType.SelectedIndex ==0){
cmbUserType.Text ="普通用户";
ustate =0;}else{
cmbUserType.Text ="管理员";
ustate =1;}}privatevoidFromLogin_Load(object sender, EventArgs e){this.cmbUserType.SelectedIndex =0;
ustate =0;}}}
3、图书查询模块代码
using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Windows.Forms;namespace BookManage
{public partial classFrmBookSearch:Form{publicFrmBookSearch(){InitializeComponent();}privatevoidbtnSearch_Click(object sender, EventArgs e){
string strBookType = cmbBokTyp.Text;
string strBookTypeOr = cmbBokTypOr.Text;
string strBookName = txtBokNm.Text;
string strBookNameOr = txtBokNmOr.Text;
string strBookConment = txtBokCotnt.Text;//定义sql语句
string sql ="SELECT * FROM book WHERE booktype='"+ strBookType +"'"+"or booktype='"+ strBookTypeOr +"'"+" and bookname='"+ strBookName +"';";
MySQLHelper sqlHelper =newMySQLHelper(DBModule.ServerIP, DBModule.ServerPort, DBModule.ServerUser, DBModule.ServerPassword, DBModule.ServerDBName);
DataTable dt =newDataTable();bool queryFlag = sqlHelper.ExcuteQuerySql(sql, ref dt);if(queryFlag ==false){
MessageBox.Show("查询失败，没有该图书信息");}if(dt.Rows.Count >0){
dgvBookSearch.DataSource = dt;}//设置列名标题
string[] strColumnName ={"图书ID","图书类别","书名","作者","价格","封面","内容简介","指定访问码"};for(int i =0; i < dgvBookSearch.Columns.Count; i++){
dgvBookSearch.Columns[i].HeaderText = strColumnName[i];}}privatevoidbtnClose_Click(object sender, EventArgs e){this.Close();}privatevoidFrmBookSearch_Load(object sender, EventArgs e){//图书类别的初始化
string sql ="SELECT DISTINCT booktype FROM book;";
MySQLHelper sqlHelper =newMySQLHelper(DBModule.ServerIP, DBModule.ServerPort, DBModule.ServerUser, DBModule.ServerPassword, DBModule.ServerDBName);
DataTable dtTtpe =newDataTable();try{bool queryFlag = sqlHelper.ExcuteQuerySql(sql, ref dtTtpe);if(queryFlag ==false){
MessageBox.Show("查询图书类型失败");}}catch(Exception ex){
MessageBox.Show("查询图书类型失败"+ ex.ToString());}if(dtTtpe.Rows.Count >0){for(int i =0; i < dtTtpe.Rows.Count; i++){this.cmbBokTyp.Items.Add(dtTtpe.Rows[i][0].ToString());this.cmbBokTypOr.Items.Add(dtTtpe.Rows[i][0].ToString());}}this.cmbBokTyp.SelectedIndex =0;this.cmbBokTypOr.SelectedIndex =0;}}}
4、图书借阅代码
using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Windows.Forms;namespace BookManage
{public partial classFrmBookBrown:Form{publicFrmBookBrown(){InitializeComponent();}
DataTable dt =newDataTable();
MySQLHelper sqlHelper =newMySQLHelper(DBModule.ServerIP, DBModule.ServerPort, DBModule.ServerUser, DBModule.ServerPassword, DBModule.ServerDBName);/// <summary>/// 图书借阅按钮/// </summary>/// <param name="sender"></param>/// <param name="e"></param>privatevoidbtnBrown_Click(object sender, EventArgs e){//获取下拉框中选中图书的IDint bookid = Convert.ToInt32(this.cmbBookName.SelectedIndex +1);//获取用户的借阅证int issid = Convert.ToInt32(this.txtIssueID.Text);//获取借阅时间
DateTime date = Convert.ToDateTime(this.IssDatetime.Text);//更新借阅信息
string sql ="insert into bookbrown (bookid, issbookid, issdatetime) values ('"+ bookid +"', '"+ issid +"', '"+ date +"');";//借阅信息中没有这本书才可借阅
DataTable dtC =newDataTable();
sqlHelper.ExcuteQuerySql("select bookid from bookbrown;", ref dtC);int flagTmp =0;for(int i =0; i < dtC.Rows.Count; i++){if(Convert.ToInt32(dtC.Rows[i][0].ToString())== bookid){
flagTmp =1;}}if(flagTmp ==1){
MessageBox.Show("这本书你已经借阅过，借阅不能超过1本","提示信息", MessageBoxButtons.OK);}else{if(sqlHelper.ExcuteSql(sql)==1){
MessageBox.Show("借阅成功");}else{
MessageBox.Show("借阅失败");}}//刷新借阅证中的图书信息
string sqlQ ="select bookinfo.bookid,bookname,issbookid,issdatetime from bookbrown,bookinfo where bookinfo.bookid=bookbrown.bookid;";bool queryFlagQ = sqlHelper.ExcuteQuerySql(sqlQ, ref dt);if(queryFlagQ ==true){this.dataGridView1.DataSource = dt;}}privatevoidbtnCancel_Click(object sender, EventArgs e){this.Close();}privatevoidFrmBookBrown_Load(object sender, EventArgs e){
string sql ="select * from bookinfo;";//联合图书信息表、借阅信息表查询
string sqlBro ="select bookinfo.bookid,bookname,issbookid,issdatetime from bookbrown,bookinfo where bookinfo.bookid=bookbrown.bookid;";//主键与外键的关联try{bool queryFlag = sqlHelper.ExcuteQuerySql(sql, ref dt);//查询图书信息if(queryFlag ==false){
MessageBox.Show("查询失败");}else{//自动加载图书名到下拉框for(int i =0; i < dt.Rows.Count; i++){this.cmbBookName.Items.Add(dt.Rows[i][1].ToString());}}//联合查询查询本人借阅信息
DataTable dtBro=newDataTable();bool queryFlagBro = sqlHelper.ExcuteQuerySql(sqlBro, ref dtBro);if(queryFlagBro ==true){this.dataGridView1.DataSource = dtBro;}else{
MessageBox.Show("查询借阅信息失败");}//查询用户信息
string sqlU ="select * from user where uname= '"+ DBModule.UserName +"';";
DataTable dtU =newDataTable();bool queryFlagU = sqlHelper.ExcuteQuerySql(sqlU, ref dtU);if(queryFlagU ==true){this.txtUserName.Text = dtU.Rows[0]["uname"].ToString();this.txtIssueID.Text = dtU.Rows[0]["upwd"].ToString();}//初始化列名
string[] strColumnName ={"图书编号","图书名称","指定访问码","借阅时间"};for(int i =0; i < dt.Columns.Count; i++){
dataGridView1.Columns[i].HeaderText=strColumnName[i];}}catch(Exception ex){
MessageBox.Show("");}}/// <summary>/// 图书名称选项变化的事件/// </summary>/// <param name="sender"></param>/// <param name="e"></param>privatevoidcmbBookName_SelectedIndexChanged(object sender, EventArgs e){//遍历图书信息表，查询和选中书名相同的信息，加载到界面foreach(DataRow row in dt.Rows){if(cmbBookName.Text == row["bookname"].ToString()){this.txtBookIssue.Text = row["bookissue"].ToString();this.txtBookAuthor.Text = row["bookauthor"].ToString();}}}}}
5、图书插入代码
using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Windows.Forms;namespace BookManage
{public partial classFrmBookIn:Form{publicFrmBookIn(){InitializeComponent();}/// <summary>/// 图书插入按钮/// </summary>/// <param name="sender"></param>/// <param name="e"></param>privatevoidbtnInsert_Click(object sender, EventArgs e){//定义变量接收控件的值
string strBookType = txtBookType.Text;
string strBookName = txtBookName.Text;
string strAuthor = txtAuthor.Text;
string strPrice = txtPrice.Text;
string strPic = txtPic.Text;
string strContent = txtContent.Text;
string strIssue = txtIssue.Text;if(Vaildate()){//sql语句
string sql ="insert into bookinfo (bookname, booktype, bookauthor, bookprice, bookpic, bookcontent, bookissue)"+" values ('"+ strBookName +"', '"+ strBookType +"', '"+ strAuthor +"', '"+ strPrice +"', '"+
strPic +"', '"+ strContent +"', '"+ strIssue +"');";
MySQLHelper sqlHelper =newMySQLHelper(DBModule.ServerIP, DBModule.ServerPort, DBModule.ServerUser, DBModule.ServerPassword, DBModule.ServerDBName);int result=sqlHelper.ExcuteSql(sql);if(result ==1){
MessageBox.Show("添加成功","提示", MessageBoxButtons.OK);}else{
MessageBox.Show("添加失败","提示", MessageBoxButtons.OK);}
DataTable dt =newDataTable();
sqlHelper.ExcuteQuerySql("select * from bookinfo;", ref dt);this.dataGridView1.DataSource = dt;//设置列名标题
string[] strColumnName ={"图书ID","图书类别","书名","作者","价格","封面","内容简介","指定访问码"};for(int i =0; i < dataGridView1.Columns.Count; i++){
dataGridView1.Columns[i].HeaderText = strColumnName[i];}}}/// <summary>/// 退出图书界面按钮/// </summary>/// <param name="sender"></param>/// <param name="e"></param>privatevoidbtnExit_Click(object sender, EventArgs e){this.Close();}/// <summary>/// 输入合法性验证/// </summary>/// <returns></returns>privateboolVaildate(){if(txtBookType.Text != string.Empty && txtBookName.Text != string.Empty && txtAuthor.Text != string.Empty
&& txtPrice.Text != string.Empty && txtPic.Text != string.Empty && txtContent.Text != string.Empty && txtIssue.Text != string.Empty){returntrue;}else{
MessageBox.Show("请出入完整信息");}returnfalse;}}}
6、图书更新/删除代码
using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Windows.Forms;namespace BookManage
{public partial classFrmUpdateBook:Form{publicFrmUpdateBook(){InitializeComponent();}
MySQLHelper sqlHelper =newMySQLHelper(DBModule.ServerIP, DBModule.ServerPort, DBModule.ServerUser, DBModule.ServerPassword, DBModule.ServerDBName);/// <summary>/// 保存信息/// </summary>/// <param name="sender"></param>/// <param name="e"></param>privatevoidbtnSave_Click(object sender, EventArgs e){
string sql ="select * from bookinfo;";
DataTable dt =newDataTable();if(MessageBox.Show("确实要将修改保存到数据库？","提示信息", MessageBoxButtons.OKCancel)== System.Windows.Forms.DialogResult.OK){bool queryFlag = sqlHelper.ExcuteQuerySql(sql, ref dt);if(queryFlag ==true){
MessageBox.Show("保存成功");}this.dataGridView1.DataSource = dt;}//设置列名标题
string[] strColumnName ={"图书ID","图书类别","书名","作者","价格","封面","内容简介","指定访问码"};for(int i =0; i < dataGridView1.Columns.Count; i++){
dataGridView1.Columns[i].HeaderText = strColumnName[i];}}/// <summary>/// 更新信息/// </summary>/// <param name="sender"></param>/// <param name="e"></param>privatevoidbtnUpdate_Click(object sender, EventArgs e){
string strBookType = txtBookType.Text;
string strBookName = txtBookName.Text;
string strBookAuthor = txtBookAuthor.Text;
string strBookPrice = txtBookPrice.Text;
string strBookPic = txtBookPic.Text;
string strBookContent = txtBookContent.Text;
string strBookIssue = txtBookIssue.Text;if(true){
string sql = string.Format("update bookinfo set booktype='{0}', bookname='{1}', bookauthor='{2}', bookprice='{3}', bookpic='{4}', bookcontent='{5}',bookissue='{6}' where bookid={7};",
strBookType, strBookName, strBookAuthor, strBookPrice, strBookPic, strBookContent, strBookIssue, Convert.ToInt32(txtBookID.Text));if(sqlHelper.ExcuteSql(sql)==1){
MessageBox.Show("更新成功","提示信息", MessageBoxButtons.OK);}else{
MessageBox.Show("更新失败","提示信息", MessageBoxButtons.OK);}}}/// <summary>/// 删除信息/// </summary>/// <param name="sender"></param>/// <param name="e"></param>privatevoidbtnDelete_Click(object sender, EventArgs e){if(this.txtBookID.Text != string.Empty){
string sql ="select * from bookbrown where bookid="+ Convert.ToInt32(txtBookID.Text)+"";
DataTable dt =newDataTable();bool queryFlag = sqlHelper.ExcuteQuerySql(sql, ref dt);if(queryFlag ==true&& dt.Rows.Count >0){
MessageBox.Show("此书有借阅，不能删除");}else{
string sqlDe ="delete from bookinfo where bookid="+this.txtBookID.Text +"";if(sqlHelper.ExcuteSql(sqlDe)==1){
MessageBox.Show("删除成功","提示信息", MessageBoxButtons.OK);}else{
MessageBox.Show("删除失败","提示信息", MessageBoxButtons.OK);}}}}/// <summary>/// 取消/// </summary>/// <param name="sender"></param>/// <param name="e"></param>privatevoidbtnCancel_Click(object sender, EventArgs e){}/// <summary>/// 验证输入合法性/// </summary>/// <returns></returns>privateboolVaildate(){if(txtBookType.Text != string.Empty && txtBookName.Text != string.Empty && txtBookAuthor.Text != string.Empty
&& txtBookPrice.Text != string.Empty && txtBookPic.Text != string.Empty
&& txtBookContent.Text != string.Empty && txtBookIssue.Text != string.Empty && txtBookID.Text != string.Empty){returntrue;}else{
MessageBox.Show("请出入完整信息");}returnfalse;}}}
总结
本项目实现一个简单的图书馆管理系统，是一个完整的图书馆管理系统的简化版。通过这个项目，了解整个桌面应用软件的规范化开发流程，业务梳理、需求分析、概要设计、详细设计、数据库设计、界面交互设计、详细代码设计等步骤。同时将代码开发规范融入其中，尽量使用较为规范的代码。加深了对WinForm界面控件的认识，对MySQL更加熟悉。数据库SQL语言操作还需要多联系，纸上得来终觉浅，觉知此事要躬行。SQL语句看似简单，实际操作起来是出问题最多的地方。
本文转载自: https://blog.csdn.net/qq_38628970/article/details/128912319
版权归原作者 JosieBook 所有， 如有侵权，请联系我们删除。
版权归原作者 JosieBook 所有， 如有侵权，请联系我们删除。