C#中的MySQL

using MySql.Data.MySqlClient;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;


namespace CSharpCallMySql
{
    class Program
    {
        static void Main(string[] args)
        {
            //Read();
            //Insert();
            //Update();
            //Delete();
            //ExcuteScala();
            Console.Write(VerifyUser("xiongpeng1", "xiongpeng"));
            Console.ReadKey();
        }

        public static void Insert()
        {
            string connCmd = "server=127.0.0.1;port=3306;database=mygamedb;user=root;password=root;";
            MySqlConnection conn = new MySqlConnection(connCmd);
            try
            {
                conn.Open();
                Console.WriteLine("连接成功");
                string cmdSql = "insert into users(userid, passwd) values('kangkang1', 'kangkang1');";
                Console.WriteLine(cmdSql);
                MySqlCommand cmd = new MySqlCommand(cmdSql, conn);
                int effectLines = cmd.ExecuteNonQuery();
            }
            catch (Exception e)
            {
                Console.Write(e);
            }
            finally
            {
                conn.Close();
            }
            Console.ReadKey();
        }

        public static void Read()
        {
            string str = "server=127.0.0.1;port=3306;database=mygamedb;user=root;password=root;";
            MySqlConnection con = new MySqlConnection(str);
            try
            {
                con.Open();
                Console.WriteLine("数据库连接成功！");
                string sql = "select * from users";
                MySqlCommand cmd = new MySqlCommand(sql, con);
                //cmd.ExecuteReader();
                //cmd.ExecuteScalar();
                //cmd.ExecuteNonQuery();
                MySqlDataReader reader = cmd.ExecuteReader();
                while (reader.Read())
                {
                    //Console.WriteLine(reader[0].ToString() + reader[1].ToString() + reader[2].ToString());
                    //Console.WriteLine(reader.GetInt32(0) + " " + reader.GetString(1) + " " + reader.GetString(2));
                    Console.WriteLine(reader.GetInt32("id") + " " + reader.GetString("userid") + " " + reader.GetString("passwd"));
                }
            }
            catch (Exception e)
            {
                Console.Write(e);
            }
            finally
            {
                con.Close();
            }
            Console.ReadKey();
        }

        public static void Update()
        {
            string connCmd = "server=127.0.0.1;port=3306;database=mygamedb;user=root;password=root;";
            MySqlConnection conn = new MySqlConnection(connCmd);
            try
            {
                conn.Open();
                Console.WriteLine("连接成功");
                string cmdSql = "update users set userid = 'sunwukong', passwd = '123swk' where id = 1;";
                Console.WriteLine(cmdSql);
                MySqlCommand cmd = new MySqlCommand(cmdSql, conn);
                int effectLines = cmd.ExecuteNonQuery();
            }
            catch (Exception e)
            {
                Console.Write(e);
            }
            finally
            {
                conn.Close();
            }
            Console.ReadKey();
        }

        public static void Delete()
        {
            string connCmd = "server=127.0.0.1;port=3306;database=mygamedb;user=root;password=root;";
            MySqlConnection conn = new MySqlConnection(connCmd);
            try
            {
                conn.Open();
                Console.WriteLine("连接成功");
                string cmdSql = "delete from users where id = 5";
                Console.WriteLine(cmdSql);
                MySqlCommand cmd = new MySqlCommand(cmdSql, conn);
                int effectLines = cmd.ExecuteNonQuery();
            }
            catch (Exception e)
            {
                Console.Write(e);
            }
            finally
            {
                conn.Close();
            }
            Console.ReadKey();
        }

        public static void ExcuteScala()
        {
            string str = "server=127.0.0.1;port=3306;database=mygamedb;user=root;password=root;";
            MySqlConnection con = new MySqlConnection(str);
            try
            {
                con.Open();
                Console.WriteLine("数据库连接成功！");
                string sql = "select count(*) from users";
                MySqlCommand cmd = new MySqlCommand(sql, con);
                object o = cmd.ExecuteScalar();
                Console.WriteLine(Convert.ToInt32(o));
                Console.ReadKey();
                
            }
            catch (Exception e)
            {
                Console.Write(e);
            }
            finally
            {
                con.Close();
            }
            Console.ReadKey();
        }

        public static bool VerifyUser(string username, string password)
        {
            string str = "server=127.0.0.1;port=3306;database=mygamedb;user=root;password=root;";
            MySqlConnection con = new MySqlConnection(str);
            try
            {
                con.Open();
                Console.WriteLine("数据库连接成功！");
                string sql = "select * from users where userid = @para1 and passwd = @para2";//此处标记，下面通过cmd对应修改
                MySqlCommand cmd = new MySqlCommand(sql, con);
                cmd.Parameters.Add("para1", username);
                cmd.Parameters.Add("para2", password);

                MySqlDataReader reader = cmd.ExecuteReader();
                if(reader.Read())
                {
                    return true;
                }
            }
            catch (Exception e)
            {
                Console.Write(e);
            }
            finally
            {
                con.Close();
            }
            Console.ReadKey();
            return false;
        }
    }
}