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

最新推荐文章于 2025-03-22 15:37:33 发布

激萌の小宅

最新推荐文章于 2025-03-22 15:37:33 发布

阅读量2k

点赞数 1

分类专栏：各种算法文章标签： C# mysql 窗体数据库

本文链接：https://blog.youkuaiyun.com/gs1069405343/article/details/102158295

版权

各种算法专栏收录该内容

7 篇文章

订阅专栏

本文详细介绍了一种使用C#语言进行MySQL数据库操作的方法，包括连接数据库、读取数据、写入数据、删除数据和获取表行数等功能的实现过程。通过具体的代码示例，读者可以快速掌握如何在C#应用程序中高效地进行数据库操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

新建工程，添加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;
        }
    }
}

操作结果如下：