The invention discloses a method for preparing an abrasion-resistant super-hydrophobic ceramic coating through a thermal spraying technology and a product. The method includes the following steps that (1) a substrate is subjected to surface roughening treatment; (2) a micro-patterned ceramic coating is prepared on the surface of the substrate through a plasma spraying technology; and (3) a low surface energy substance layer is sprayed to the obtained ceramic coating through a liquid material flame spraying technology, and the super-hydrophobic abrasion-resistant coating can be obtained. The material obtained through the preparing method has both the advantages of abrasion resistance and super-hydrophobic property, the tribological property of the super-hydrophobic coating is greatly improved, the static contact angle of the obtained coating can reach 150-180 degrees, and the rolling angle of the coating is smaller than 5 degrees. The method can prepare the abrasion-resistant super-hydrophobic coating on the basis of the surfaces of different substrates and is wide in the application range.