C# 窗体程序，简单的读写mysql数据库

新建工程，添加MySql.Data引用。

添加database.cs文件

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

using MySql.Data.MySqlClient;
using System.Collections;

namespace mysql.database
{
    class database
    {
        MySqlConnection mysql;

        public void InitDatabase()
        {
            String mysqlStr = "Database=grb;Data Source=localhost;User Id=root;Password=123456;pooling=false;CharSet=utf8;port=3306";
            mysql = new MySqlConnection(mysqlStr);
        }

        /// <summary>
        /// 建立执行命令语句对象
        /// </summary>
        /// <param name="sql"></param>
        /// <param name="mysql"></param>
        /// <returns></returns>
        private static MySqlCommand getSqlCommand(String sql, MySqlConnection mysql)
        {
            MySqlCommand mySqlCommand = new MySqlCommand(sql, mysql);
            return mySqlCommand;
        }

        /// <summary>
        /// 遍历指定数据库表
        /// </summary>
        /// <param name="name"></param>
        /// <returns></returns>
        public List<List<string>> ReadTable(string name)
        {
            List<List<string>> datas = new List<List<string>>();
            String sql = "select * from " + name;
            Console.WriteLine("sql:" + sql);
            MySqlCommand mySqlCommand = getSqlCommand(sql, mysql);
            mysql.Open();

            MySqlDataReader reader = mySqlCommand.ExecuteReader();
            try
            {
                while (reader.Read())
                {
                    if (reader.HasRows) // 判断是否包含数据
                    {
                        List<string> data = new List<string>();
                        for (int i = 0; i < reader.FieldCount; i++) {
                            data.Add(reader.GetString(i));
                        }
                        datas.Add(data);
                    }
                }
            }
            catch (Exception) {
                Console.WriteLine("查询失败了！");
            }
            finally {
                reader.Close();
            }
            mysql.Close();
            return datas;
        }

        /// <summary>
        /// 写入数据
        /// </summary>
        /// <param name="name"></param>
        /// <param name="data"></param>
        /// <returns></returns>
        public bool WriteData(string name, string data)
        {
            bool ret = true;
            String sql = "insert into " + name + " values (" + data + ")";
            Console.WriteLine("sql:" + sql);
            mysql.Open();
            MySqlCommand mySqlCommand = getSqlCommand(sql, mysql);
            try {
                mySqlCommand.ExecuteNonQuery();
            }
            catch (Exception ex) {
                String message = ex.Message;
                Console.WriteLine("插入数据失败了！" + message);
                ret = false;
            }
            mysql.Close();
            return ret;
        }

        /// <summary>
        /// 删除数据
        /// </summary>
        /// <param name="name"></param>
        /// <returns></returns>
        public bool DelData(string name)
       {
            bool ret = true;
            String sql = "truncate table " + name;
            Console.WriteLine("sql:" + sql);
            MySqlCommand mySqlCommand = getSqlCommand(sql, mysql);
            mysql.Open();
            try {
                mySqlCommand.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                String message = ex.Message;
                Console.WriteLine("删除数据失败了！" + message);
                ret = false;
            }
            mysql.Close();
            return ret;
        }
        
        /// <summary>
        /// 获取表行数
        /// </summary>
        /// <param name="name"></param>
        /// <returns></returns>
        public int tables_num(string name)
        {
            int ret = 0;
            String sql = "select count(*) as value from " + name;
            Console.WriteLine("sql:" + sql);
            MySqlCommand mySqlCommand = getSqlCommand(sql, mysql);
            mysql.Open();
            MySqlDataReader reader = mySqlCommand.ExecuteReader();
            try
            {
                while (reader.Read()) {
                    if (reader.HasRows){
                        ret = reader.GetInt32(0);
                    }
                }
            }
            catch (Exception)
            {
                Console.WriteLine("查询失败了！");
            }
            finally
            {
                reader.Close();
            }
            mysql.Close();
            return ret;
        }
    }
}

操作结果如下：

工程源码下载地址：

https://download.csdn.net/download/gs1069405343/11833143