C#操作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)
{
//connectInfo 储存哪个数据库即Database;哪个ipDataSource;哪个端口号port;哪个数据库账号userid;指定数据库密码passward;
string connectInfo = "Database=mygame;Data Source=127.0.0.1;port=3306;userid=root;password=root";
//创建一个数据库链接
MySqlConnection connect = new MySqlConnection(connectInfo);
//打开数据库链接
connect.Open();
#region 查询
//创建数据库命令,有两个参数,第一个参数是数据库操作命令,第二个是数据库链接
//MySqlCommand cmd = new MySqlCommand("select * from usersinfo where id_usersinfo = 6", connect);
//使用读取命令
//MySqlDataReader reader = cmd.ExecuteReader();
//读取流即:reader.Read(),它返回一个bool值,如果存在,会返回一个true,不存在返回false
//while (reader.Read())
//{
//读取属性是username的字符串
// string username = reader.GetString("username");
//读取属性是password的字符串
//string password = reader.GetString("password");
//Console.WriteLine(username + ":" + password);
// }
#endregion
#region 写入
//用户自己定义用户名和密码
//string username = "张晓0坤"; string password = "123456789";
//这里的@符号后面跟参数,指的是未知的,使用cmdInsert.Parameters.AddWithValue()在下面赋值。
//MySqlCommand cmdInsert = new MySqlCommand("insert into usersinfo set username =@usern,password=@pwd", connect);
//cmdInsert.Parameters.AddWithValue("usern",username);
//cmdInsert.Parameters.AddWithValue("pwd",password);
//cmdInsert.ExecuteNonQuery();
#endregion
#region 删除
//MySqlCommand cmd = new MySqlCommand("delete from usersinfo where id_usersinfo = @id", connect);
//cmd.Parameters.AddWithValue("id", 3);
//cmd.ExecuteNonQuery();
#endregion
#region 更新
MySqlCommand cmd = new MySqlCommand("update usersinfo set password = @pwd where id_usersinfo = @id", connect);
cmd.Parameters.AddWithValue("id", 5);
cmd.Parameters.AddWithValue("pwd", "123456789kun");
cmd.ExecuteNonQuery();
#endregion
//关闭读取流
//reader.Close();
//关闭链接流
connect.Close();
Console.ReadKey();
}
}
}