201711122248->mysql库依据条件选择数据

目的:选出符合条件的数据

详细代码：

            string sqlconst = "server=localhost;user=root;database=mytestsql;port=3306;password=root;";
            MySqlConnection connect = new MySqlConnection(sqlconst);
            connect.Open();
            Console.WriteLine("成功链接mysql...");

            MySqlCommand command = new MySqlCommand("select * from testuserid", connect);
            MySqlDataReader reader = command.ExecuteReader();
            try
            {
                while (reader.Read())
                {
                    if (reader.HasRows)
                    {
                        Console.WriteLine("testuserid=" + reader.GetInt32(0) + "/testint=" + reader.GetInt32(1));
                    }
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine("查询失败...");
            }
            finally
            {
                reader.Close();
            }