A long-acting super-hydrophobic coating resistant to water pressure impact and preparation method thereof. The long-acting super-hydrophobic coating includes a conductive substrate and the following raw materials in parts by weight: 1 part to 10 parts of titanium source or zinc source, 40 parts to 100 parts of deionized water, 20 parts to 50 parts of hydrochloric acid or 20 parts to 40 parts of sodium hydroxide, 1 part to 10 parts of electrolyte, 1 part to 10 parts of low surface energy modifier, 10 parts to 20 parts of high molecular polymer, 1 part to 5 parts of carbon nanotube and 70 parts to 100 parts of organic solvent. The long-acting super-hydrophobic coating has an organic-inorganic nano-interpenetrating network structure, which improves the stability of the multi-stage nano-micro structure, so that the super-hydrophobic coating surface has a good high-pressure water impact resistance and high-pressure static water resistance.