class Program
    {
        static void Main(string[] args)
        {

            string mySqlStr = "Database=vr4;server=localhost;User Id=root;PassWord=;";//数据库格式，注意空格

            MySqlConnection mySqlCon = new MySqlConnection(mySqlStr);

            mySqlCon.Open();//打开数据库

            string ChaxunStr = "select * from student ";//当前你要操作的数据库的命令
            MySqlCommand mySqlcom = new MySqlCommand(ChaxunStr, mySqlCon);
            GetReadMySql(mySqlcom); //查询



            string ChaxunStr = "insert into student values(11,'3w',26,'n');";
            MySqlCommand mySqlcom = new MySqlCommand(ChaxunStr, mySqlCon);
            InsertMySql(mySqlcom);//插入（增）


            string ChaxunStr = "delete from student  where sid=11;";
            MySqlCommand mySqlcom = new MySqlCommand(ChaxunStr, mySqlCon);
            DelMySql(mySqlcom);//删除


            string ChaxunStr = "  update student set sage=88 where sid=1;";
            MySqlCommand mySqlcom = new MySqlCommand(ChaxunStr, mySqlCon);
            UpDateMySql(mySqlcom);//修改


            GetReadMySqlId(5);




            Console.ReadKey();
        }

        //查询的方法（查）
        static private void GetReadMySql(MySqlCommand mySqlcom)
        {
            MySqlDataReader reader = mySqlcom.ExecuteReader();//键值对
            try
            {
                while (reader.Read())
                {
                    if (reader.HasRows)//查找
                    {
                        Console.WriteLine("ID=" + reader.GetInt32(0) + "姓名:" + reader.GetString(1) + "年龄：" + reader.GetInt32(2) + "性别：" + reader.GetString(3));
                    }
                }

            }
            catch (Exception e)
            {

                Console.WriteLine("查询失败！" + e);
            }
            finally
            {
                reader.Close();
            }
        //    ctrl +e  +d  对齐
        //}




        //插入数据的方法（插入 增）
        static private void InsertMySql(MySqlCommand mySqlcom)
        {
            try
            {
                mySqlcom.ExecuteNonQuery();//执行mysql语句
               
            }
            catch (Exception e)
            {

                Console.WriteLine("插入异常"+e);
            }       
        }


        //删除数据的方法（删）
        static private void DelMySql(MySqlCommand mySqlcom)
        {          
           try
            {

                mySqlcom.ExecuteNonQuery();//执行mysql语句 注意传入放入参数语法
            }
            catch (Exception e)
            {

                Console.WriteLine("删除失败！" + e);
            }
            
        }

        
        //修改的方法
        static private void UpDateMySql(MySqlCommand mySqlcom)
        {
            try
            {

                mySqlcom.ExecuteNonQuery();//执行mysql语句 注意传入放入参数语法
            }
            catch (Exception e)
            {

                Console.WriteLine("更新失败！" + e);
            }

        }


        static private void GetReadMySqlId(int id)
        {
            string mySqlStr = "Database=vr4;server=localhost;User Id=root;PassWord=;";//数据库格式，注意空格

            MySqlConnection mySqlCon = new MySqlConnection(mySqlStr);
            string ChaxunStr = "select * from student where sid=" + id;//当前你要操作的数据库的命令
            MySqlCommand mySqlcom = new MySqlCommand(ChaxunStr, mySqlCon);
          
            MySqlDataReader reader ;//= mySqlcom.ExecuteReader();//键值对
            try
            {
                reader = mySqlcom.ExecuteReader();
                while (reader.Read())
                {
                    if (reader.GetInt32(0) == id)//查找
                    {
                        Console.WriteLine("ID=" + reader.GetInt32(0) + "姓名:" + reader.GetString(1) + "年龄：" + reader.GetInt32(2) + "性别：" + reader.GetString(3));
                    }
                }

            }
            catch (Exception e)
            {

                Console.WriteLine("查询失败！" + e);
            }
            finally
            {
                reader.Close();
            }        
        }
    }