C#面向对象简单图书管理系统MySql数据库

【实例简介】

C#图书管理系统，使用MySql数据库

附有MySql数据库文件

【实例截图】

【核心代码】

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;
using MySql.Data.MySqlClient;

namespace 图书管理系统
{
    public partial class mainCenter : Form
    {
        public mainCenter()
        {
            InitializeComponent();
            
            
            MySqlConnection conn=getConn();
            conn.Open();
            MySqlDataAdapter da=new MySqlDataAdapter();
            string selectCmd = "select bookName as '图书名',bookAuthor as '作者',bookPrice as '价格',bookPress as '出版社',bookType as '类型',(case isBorrowed when 0 then '未借阅' else '已借阅' end) as '借阅情况' from `C#librarycenter`.bookinfo";
            da.SelectCommand=new MySqlCommand(selectCmd,conn);

            DataTable dt=new DataTable();
            dt.Clear();
            da.Fill(dt);
            
            dataGridView1.DataSource = dt;
            dataGridView1.AllowUserToAddRows = false;

            login login=new login();
            label1.Text="欢迎用户" login.userName "使用图书管理系统";
        }

        private void toolStripContainer1_ContentPanel_Load(object sender, EventArgs e)
        {

        }

        private void textBox1_TextChanged(object sender, EventArgs e)
        {
            
        }

        private void mainCenter_Load(object sender, EventArgs e)
        {
            textBox1.Text = "请输入要查找的图书名";
        }

        private void button1_Click(object sender, EventArgs e)
        {
            string bookName = textBox1.Text;
            MySqlConnection conn = getConn();
            conn.Open();

            MySqlDataAdapter da=new MySqlDataAdapter();
            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 where bookName like '%" textBox1.Text "%'",conn);
            da.SelectCommand = cmd1;
            DataTable dt=new DataTable();
            dt.Clear();

            da.Fill(dt);
            dataGridView1.DataSource = dt;
            dataGridView1.AllowUserToAddRows = false;
        }

        private void textBox1_MouseClick(object sender, MouseEventArgs e)
        {
            textBox1.Text = "";
        }

        private void 图书借阅toolStripMenuItem1_Click(object sender, EventArgs e)
        {
            borrow br=new borrow();
            br.Show();
        }

        private void 图书归还toolStripMenuItem2_Click(object sender, EventArgs e)
        {
            MySqlConnection conn = getConn();
            conn.Open();
            string username = login.userName;
            string cmd = "select userName from `C#librarycenter`.borrowed where userName = '" username "' ";
            MySqlCommand cmd1=new MySqlCommand(cmd,conn);
            MySqlDataReader dr = cmd1.ExecuteReader();
            while (dr.Read())
            {
                returnBook returnbook=new returnBook();
                returnbook.Show();
                return;
            }

            if (dr.Read()==false)
            {
                MessageBox.Show("你没有借书记录");
            }
        }

       private void 个人信息toolStripMenuItem3_Click(object sender, EventArgs e)
       {
           editUser eu=new editUser();
           eu.Show();
       }

       private void 退出系统toolStripMenuItem6_Click(object sender, EventArgs e)
       {
           Environment.Exit(0);
       }

       private void 关于toolStripMenuItem7_Click(object sender, EventArgs e)
       {
           MessageBox.Show("作者：Johnny Lee\r\n完成时间:2018-4");
       }

       private void 借阅信息toolStripMenuItem4_Click(object sender, EventArgs e)
       {
           borrowInfo bi=new borrowInfo();
           bi.Show();
       }

       private void 刷新toolStripMenuItem5_Click(object sender, EventArgs e)
       {
           MySqlConnection conn = getConn();
           conn.Open();
           MySqlDataAdapter da = new MySqlDataAdapter();
           string selectCmd = "select bookName as '图书名',bookAuthor as '作者',bookPrice as '价格',bookPress as '出版社',bookType as '类型',(case isBorrowed when 0 then '未借阅' else '已借阅' end) as '借阅情况' from `C#librarycenter`.bookinfo";
           da.SelectCommand = new MySqlCommand(selectCmd, conn);

           DataTable dt = new DataTable();
           dt.Clear();
           da.Fill(dt);

           dataGridView1.DataSource = dt;
           dataGridView1.AllowUserToAddRows = false;
       }

        //获得数据库连接
        private MySqlConnection getConn()
        {
            string sql = "server=localhost;userId=root;password=123;port=3306;database=C#librarycenter;";
            MySqlConnection conn = new MySqlConnection(sql);

            return conn;
        }
    }
}