C#调用MySql的API

           首先,输入读取需要读取的文本~ IP 端口 读取的表格 帐号 密码

            string connectStr = "server=127.0.0.1;port=3306;database=game_signball;user=root;password=1234;";
            conn = new MySqlConnection(connectStr);//连接的API

查

               conn.Open();//开始连接

                cmd = new MySqlCommand(sql, conn);//命令台

                MySqlDataReader read = cmd.ExecuteReader();//读取

                while (read.Read())//遍历每一行,以三列为标准
                {

                    //read.GetInt32("id"); 这样能获取列所有

                    Console.WriteLine(read[0].ToString() + "+" + read[1].ToString() + "+" + read[2].ToString());
                }

增

                string sql = "insert into sign(username,password) values('fuck','556677')";
                cmd = new MySqlCommand(sql, conn);

删

                string sql = "delete from sign where id = 4;";
                cmd = new MySqlCommand(sql, conn);

改

                string sql = "update sign set username='kkccjj',password='oneonetwotwo'where id = 2;";
                cmd = new MySqlCommand(sql, conn);

其他

                int read = cmd.ExecuteNonQuery(); //返回被影响是第几行

                conn.Close(); //关闭连接

验证帐号密码正确性的例子

            string sql = "select * from sign where username = '"+username+"'and password ='"+password+"'";
            MySqlCommand cmd = new MySqlCommand(sql, conn);
            MySqlDataReader read = cmd.ExecuteReader();           

            string sql = "select * from sign where username =@a and password =@b"; //替换法~和上面的2选1
            MySqlCommand cmd = new MySqlCommand(sql, conn);
            cmd.Parameters.AddWithValue("a", username);
            cmd.Parameters.AddWithValue("b",password);

            if (read.Read())
            {
                return true;
            }
            else
            {
                return false;
            }