C + MySQL 图书管理系统.pptxVIP

《C#面向对象程序设计》课程设计;1;系统流程图（不包含注册功能）;1;模块分析 cs 文件：; MySqlCommand cmd1 = new MySqlCommand(SELECT bookName as 图书名 ,bookAuthor as 作者,bookPrice as 图书价格,bookPress as 出版社,bookType as 图书 类型,(CASE isBorrowed WHEN 0 THEN 未借阅 ELSE 已借阅 END) as借阅情况 FROM `c#librarycenter`.bookinfo, conn);//sql语句 data1.SelectCommand = cmd1;//设置为已实例化SqlDataAdapter的查询命令 DataTable dt = new DataTable(); dt.Clear(); data1.Fill(dt);//把数据填充到datatable dataGridView1.DataSource = dt;//将数据集绑定datagridview,完成显示 dataGridView1.AllowUserToAddRows = false; // login login = new login(); label1.Text = 这里是SMART-LIBRARY！用户： + login.username; // } 查找功能：;类型,(CASE isBorrowed WHEN 0 THEN 未借阅 ELSE 已借阅 END) as借阅情况 FROM `c#librarycenter`.bookinfo where bookName like %+ so +% , conn);//sql语句 data1.SelectCommand = cmd1;//设置为已实例化SqlDataAdapter的查询命令 //DataSet ds1 = new DataSet();//实例化dataset DataTable dt = new DataTable(); dt.Clear(); data1.Fill(dt);//把数据填充到datatable dataGridView1.DataSource = dt;//将数据集绑定datagridview,完成显示 dataGridView1.AllowUserToAddRows = false; } 借阅功能：;6; mysqlcommand3.ExecuteNonQuery(); //刷新dataGridView1，重新绑定数据源 f5(); } 归还图书功能：;成功); } else { MessageBox.Show(系统出了点问题，请联系管理员！); } //更新借阅表 String updateBorrow = select userId from userInfo where userName = + login.username + ; MySqlCommand mysqlcommand = new MySqlCommand(updateBorrow, conn); MySqlDataReader mdr = mysqlcommand.ExecuteReader(); if (mdr.Read()) { userId = mdr.GetString(0).ToString(); } mdr.Close(); String updateBorrow2 = insert into borrowed(userId,userNam