SQL语法:https://www.w3school.com.cn/sql/sql_intro.asp
一、利用ExecuteScalar查询得到一个值的结果
static void ExcuteScalar()
{
//跟MySQL建立连接
string connectStr = "server=127.0.0.1;port=3306;database=mygamedb;user=root;password=root;";
MySqlConnection conn = new MySqlConnection(connectStr);
try
{
conn.Open();
string sql = "select count(*) from users";
MySqlCommand cmd = new MySqlCommand(sql, conn);//创建命令
object o = cmd.ExecuteScalar();
int count = Convert.ToInt32(o.ToString());
Console.WriteLine(count);
Console.WriteLine("C#和MySQL已经建立连接");
}
catch (Exception e)
{
Console.WriteLine(e.ToString());
}
finally
{
conn.Close();
}
}
二、查询添加参数,用于验证用户名和密码
static bool VerifyUser(string username,string password)
{
//跟MySQL建立连接
string connectStr = "server=127.0.0.1;port=3306;database=mygamedb;user=root;password=root;";
MySqlConnection conn = new MySqlConnection(connectStr);
try
{
conn.Open();
//string sql = "select * from users where username='" + username + "'and password='" + password + "'";//我们自己按照查询条件去组拼sql
string sql = "select * from users where username=@username and password=@password";//第二种查询方式
MySqlCommand cmd = new MySqlCommand(sql, conn);//创建命令
cmd.Parameters.AddWithValue("username", username);//第二种查询方式
cmd.Parameters.AddWithValue("password", password);//第二种查询方式
MySqlDataReader reader = cmd.ExecuteReader();
if(reader.Read())
{
return true;
}
}
catch (Exception e)
{
Console.WriteLine(e.ToString());
}
finally
{
conn.Close();
}
return false;
}