网络游戏_数据库更新
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();
}
}
}