mysql修改游戏数据库_网络游戏_数据库更新

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=game;Data Source=127.0.0.1;port=3306;User Id=root;Password=shirln123My;";

MySqlConnection conn = new MySqlConnection(connStr);

conn.Open();

#region 查询

// MySqlCommand cmd = new MySqlCommand("select * from user where id=1", conn);

// MySqlDataReader reader = cmd.ExecuteReader();

//while(reader.Read())

// {

//     string username = reader.GetString("username");

//     string password = reader.GetString("password");

//     Console.WriteLine(username+";"+password);

// }

// reader.Close();

#endregion

#region 插入

//string username = "cwer";

//string password = "qwedv';delete  from user;";

MySqlCommand cmd = new MySqlCommand("insert into user set username='" + username + "'" + ",password='" + password + "'", conn);

cmd.ExecuteNonQuery();

//MySqlCommand cmd = new MySqlCommand("insert into user set username=@un,password=@pwd", conn);

//cmd.Parameters.AddWithValue("un", username);

//cmd.Parameters.AddWithValue("pwd", password);

//cmd.ExecuteNonQuery();

#endregion

#region 删除

//MySqlCommand cmd = new MySqlCommand("delete from user where id=@id", conn);

//cmd.Parameters.AddWithValue("id", 10);

//cmd.ExecuteNonQuery();

#endregion

#region 更新

MySqlCommand cmd = new MySqlCommand("update user set username=@un where id=11", conn);

cmd.Parameters.AddWithValue("un", "shirln");

cmd.ExecuteNonQuery();

#endregion

conn.Close();

Console.ReadKey();

}

}

}