c# 编写 MYsql 增删改查

最新推荐文章于 2025-07-09 09:54:27 发布

成长的香蕉

最新推荐文章于 2025-07-09 09:54:27 发布

阅读量2k

点赞数 2

CC 4.0 BY-SA版权

文章标签： c# mysql

本文链接：https://blog.youkuaiyun.com/qq_41145567/article/details/82835394

本文演示了如何使用 C# 连接 MySQL 数据库，包括基本的查询、更新操作，以及参数化查询的实现方法。

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using MySql.Data.MySqlClient;
namespace mysql1
{
    class Program
    {
        static void Main(string[] args)
        {
            // 连接数据库
            string connectStr = "server = 127.0.0.1; port = 3306; user = root; password = root1;database = mysql; SslMode = none;";

            MySqlConnection conn = new MySqlConnection(connectStr);

            try
            {
                conn.Open();
                Console.WriteLine("已建立连接");
            }
            catch(MySqlException e)
            {
                Console.WriteLine(e.ToString());
            }
            //  查询数据库
            string sql = "select * from help_category ";

            MySqlCommand cmd = new MySqlCommand(sql, conn);
            MySqlDataReader reader = cmd.ExecuteReader();

            while(reader.Read())
            {
                Console.WriteLine(reader.GetInt32("help_category_id")+ "\t" + reader.GetString("name") + "\t"
                    + "\t" +   reader.GetInt32("parent_category_id"));//"userid"是数据库对应的列名，推荐这种方式
            }
       
            reader.Close();
            
            Console.WriteLine("\n");
            // 查询条件不固定

            string sql1 = "select * from help_category " +
                          "where help_category_id =@para";

            cmd.CommandText = sql1;
            cmd.Parameters.AddWithValue("para", 3); 
       
            MySqlDataReader reader1 = cmd.ExecuteReader();

            while (reader1.Read())
            {
                Console.WriteLine(reader1.GetInt32("help_category_id") + "\t" + reader1.GetString("name") + "\t"
                    + "\t" + reader1.GetInt32("parent_category_id"));//"userid"是数据库对应的列名，推荐这种方式
            }
            reader1.Close();

            //  增加记录

            //             string addStr = "insert into help_category(help_category_id, name, parent_category_id)" +
            //                 "values(43, 'zhange', 50)";
            // 
            //             cmd.CommandText = addStr;
            //             int result = cmd.ExecuteNonQuery();
            //             Console.WriteLine(result);

            // 删除记录
            //             string delete = "delete from help_category where help_category_id = 42";
            // 
            //             cmd.CommandText = delete;
            //             int result1 = cmd.ExecuteNonQuery();
            //             Console.WriteLine(result1);

        
            string update = "update help_category set name = 'wangyao' where help_category_id = 43";
            cmd.CommandText = update;
            int result2 = cmd.ExecuteNonQuery();
            Console.WriteLine(result2);
        }
    }
}