C#—连接MYSQL数据库进行增删改查

打开VS，添加引用，添加MYsql.data.dll，引入命名空间using MySql.data.MySqlClient;

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using MySql.Data.MySqlClient;

namespace MYSQL数据库连接操作
{
    class Program
    {
        static void Main(string[] args)
        {
            //填入你自己的账号密码
            string connStr = "Database=test;Data Source=127.0.0.1;port=3306;User ID=root;Password=root;";
            MySqlConnection connect = new MySqlConnection(connStr);
            connect.Open(); //打开连接

            #region 查询
            //string cmdStr ="select * from user";
            //MySqlCommand cmd = new MySqlCommand(cmdStr, connect);
            //MySqlDataReader reader =  cmd.ExecuteReader();//读取数据
            //while (reader.Read())  //读取到一行记录时返回true
            //{
            //    string username = reader.GetString("username");
            //    string password = reader.GetString("password");
            //    Console.WriteLine(username + " " + password);
            //}
            //reader.Close();
            #endregion

            #region 插入
            //string username = "jss";
            //string password = "9450";
            //MySqlCommand cmd = new MySqlCommand("insert into user set username= @usn,password=@pwd",connect);
            //cmd.Parameters.AddWithValue("usn", username);// 添加了每个参数集合必须具有关联的名称
            //cmd.Parameters.AddWithValue("pwd", password);
            //cmd.ExecuteNonQuery();
            #endregion

            #region      删除
            //MySqlCommand cmd = new MySqlCommand("delete from user where id = @id",connect);
            //cmd.Parameters.AddWithValue("id",1);
            //cmd.ExecuteNonQuery();
            #endregion

            #region      修改/更新
            //MySqlCommand cmd = new MySqlCommand("update user set password=@psw where id = @id", connect);
            //cmd.Parameters.AddWithValue("psw", 66666);
            //cmd.Parameters.AddWithValue("id", 2);
            //cmd.ExecuteNonQuery();
            #endregion

            connect.Close();
            Console.ReadKey();
        }
    }
}