In this paper, SiO2 composite particles prepared by Stober method combining colloidal SiO2 particles and powder SiO2 particles are used to construct rough surface on glass substrate, acidic organosilicon oligomer prepared by prepolymerization of triethoxymethylsilane (MTES) and ethyl orthosilicate (TEOS) is used as bonding agent, modified by using coupling agent KH540 and fluorosilane PFDT, and SiO2 composite particles/acidic organosilicon oligomer composite superhydrophobic coating is prepared on glass substrate by spraying method. The SiO2 composite particle/acidic silicone oligomer composite superhydrophobic coating was prepared on glass substrate by spraying method, and then the effects of SiO2 composite particle, acidic silicone oligomer, coupling agent KH540 and fluorosilane PFDT on the composite coating were investigated. The study shows that when the SiO2 composite particles consist of two kinds of particles, namely, colloidal SiO2 particles with a particle size of 110 nm and powder SiO2 particles with a particle size of 50 nm, and the mass ratio of SiO2 composite particles solution to acidic silicone diluent is 4:1, and the mass ratio of coupling agent KH540 to fluorosilane PFDT is 1% of the mixture, the composite coating can achieve a light transmission rate of 88% in the visible light wavelength range. The composite coating can reach 88% light transmittance in the visible wavelength range, 155° static contact angle, and maintain superhydrophobicity after 60 cm abrasion on 800-grit sandpaper, with good self-cleaning property, providing a simple and low-cost solution for the preparation of transparent superhydrophobic coatings.