引用MySql的DLL,可以直接百度获取。
增删改查
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 conStr = "Database=test007;Data Source=127.0.0.1;port=3306;User Id=root;Password=1234;";//进行连接前的配置
MySqlConnection connection = new MySqlConnection(conStr);//连接数据库
connection.Op en();//打开连接
#region 查询
//MySqlCommand command = new MySqlCommand("select * from user", connection);//选择读取那个列
//MySqlDataReader reader = command.ExecuteReader();//读取数据
//while (reader.Read())//判断是否读取到了
//{
// string usename = reader.GetString("usename");//读取 列下数据
// string password = reader.GetString("password");
// Console.WriteLine(usename + "." + password);
//}
//reader.Close();//关闭数据读取
#endregion
#region 插入
//string usename = "cwer"; string password = "lcker';delete from user;";
MySqlCommand cmd = new MySqlCommand("insert into user set usename='" + usename + "'" + ",password='" + password + "'", connection);//添加数据usename即cwer插入到usename列下注此处的名字必须和数据库中列的表头相同不然报错。容易被串改,误用
//MySqlCommand cmd = new MySqlCommand("insert into user set usename=@un,password=@pwd", connection);//此步骤和下面两个可以有效防止恶意删改
//cmd.Parameters.AddWithValue("un", usename);
//cmd.Parameters.AddWithValue("pwd", password);
//cmd.ExecuteNonQuery();//插入
#endregion
#region 删除
//MySqlCommand cmd = new MySqlCommand("delete from user where id=@id", connection);
//cmd.Parameters.AddWithValue("id", 19);
//cmd.ExecuteNonQuery();
#endregion
#region 更新
//MySqlCommand cmd = new MySqlCommand("update user set password =@psw where id=18", connection);
//cmd.Parameters.AddWithValue("psw", "siki.com1");
//cmd.ExecuteNonQuery();//执行
// //connection.Close();//关闭连接
#endregion
Console.ReadKey();
}
}
}
string usename = "cwer"; string password = "lcker';delete from user;";
MySqlCommand cmd = new MySqlCommand("insert into user set usename=@un,password=@pwd", connection);//此步骤和下面两个可以有效防止恶意删改
cmd.Parameters.AddWithValue("un", usename);
cmd.Parameters.AddWithValue("pwd", password);