利用C#对数据库进行连接与增删改查

最新推荐文章于 2021-02-04 10:00:30 发布

D大调的叮当

最新推荐文章于 2021-02-04 10:00:30 发布

阅读量462

点赞数

文章标签： C# 数据库

本文链接：https://blog.csdn.net/weixin_45556869/article/details/102620976

版权

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

namespace MySQL_Operate
{
    class Program
    {
        static void Main(string[] args)
        {
            string connstr = "Database=mygamedb;Data Source=127.0.0.1;port=3306;User Id=root;Password=******;";
            MySqlConnection mysqlConnetion = new MySqlConnection(connstr);

            mysqlConnetion.Open();
            #region 查询
            //MySqlCommand cmd = new MySqlCommand("select * from users ", mysqlConnetion);
            //MySqlDataReader reader = cmd.ExecuteReader();
            //while (reader.Read())
            //{
            //    string id = reader.GetString("id");
            //    string username = reader.GetString("username");
            //    string password = reader.GetString("password");
            //    Console.WriteLine(id + ":" + username + ":" + password);
            //}
            //reader.Close();
            #endregion

            #region 增加
            //string name = "小兔山田心子"; string passsword = "1322";
            MySqlCommand cmd = new MySqlCommand("insert into users set username =" + name + ",password=" + passsword , mysqlConnetion);
            //MySqlCommand cmd = new MySqlCommand("insert into users set username = @un ,password = @psd", mysqlConnetion);
            //cmd.Parameters.AddWithValue("un", name);
            //cmd.Parameters.AddWithValue("psd", passsword);            
            //cmd.ExecuteNonQuery();
            #endregion

            #region 删除
            //MySqlCommand cmd = new MySqlCommand("delete from users where id=@id", mysqlConnetion);
            //cmd.Parameters.AddWithValue("id", 2);
            #endregion

            #region 更新
            //string newpsd = "231414";
            //MySqlCommand cmd = new MySqlCommand("update  users set password=@psd where id=@id", mysqlConnetion);
            //cmd.Parameters.AddWithValue("psd", newpsd);
            //cmd.Parameters.AddWithValue("id", 1);
            //cmd.ExecuteNonQuery();
            #endregion

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