//引入头文件
using MySql.Data.MySqlClient;
//连接操作
string constr = “Database = test007;Data Source = 127.0.0.1;port = 3306;User Id =root;Password = root;”
MySqlConnection conn = new MySqlConnection(constr);
//打开数据库
conn.Open();
//创建一条mysql语句
MySqlCommand cmd = new MySqlCommand(“select * from user”, conn)
//创建mysql流
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read()) //reader.Read()每次读取一行,连续调用,一直下一行下一行
{
string username = reader.GetString(“username”);
string password = reader.GetString(“password”);
Console.WriteLine(username + “:” + password);
}
reader.Close(); //读取完后,必须关闭流
//写入一条mysql
cmd.ExecuteNonQuery();
conn.Close(); //操作完成后,需要关闭数据库
mySql注入问题
原因:字符串拼接的方式,如果值的内容包含了一条mysql语句,则会被执行到。
解决方式,采用赋值方式
string username = “haha”; string password = “haha;delete from user;”;
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();