MySQL学习003：利用ExecuteScalar查询

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;
        }