mysql与vs的增删改查

using System;
using MySql.Data.MySqlClient;

class Program
{
    static void Main()
    {
        string connectionString = "Server=localhost;Database=testdb;Uid=root;Pwd=password;";
        MySqlConnection connection = new MySqlConnection(connectionString);

        try
        {
            connection.Open();

            // 增
            string insertQuery = "INSERT INTO users (name, email) VALUES ('John Doe', 'john@example.com')";
            MySqlCommand insertCommand = new MySqlCommand(insertQuery, connection);
            insertCommand.ExecuteNonQuery();

            // 查
            string selectQuery = "SELECT * FROM users";
            MySqlCommand selectCommand = new MySqlCommand(selectQuery, connection);
            MySqlDataReader reader = selectCommand.ExecuteReader();
            while (reader.Read())
            {
                Console.WriteLine($"ID: {reader.GetInt32(0)}, Name: {reader.GetString(1)}, Email: {reader.GetString(2)}");
            }

            // 改
            string updateQuery = "UPDATE users SET email = 'john.doe@example.com' WHERE id = 1";
            MySqlCommand updateCommand = new MySqlCommand(updateQuery, connection);
            updateCommand.ExecuteNonQuery();

            // 删
            string deleteQuery = "DELETE FROM users WHERE id = 1";
            MySqlCommand deleteCommand = new MySqlCommand(deleteQuery, connection);
            deleteCommand.ExecuteNonQuery();
        }
        catch (Exception ex)
        {
            Console.WriteLine(ex.Message);
        }
        finally
        {
            connection.Close();
        }
    }
}