Fabrication of anti-wetting coatings with anti-biofouling and anti-biofilm properties has become a hot spot of attention in recent years. However, the anti-biofilm mechanism of anti-bacterial adhesion coatings with different wet resistance properties has not been explored in detail. In this work, SiOx micro-nano particles were prepared by the Stöber method and were in situ modified. The SiOx/waterborne polyurethane (WPU) coatings were prepared by the drop coating method, and the coatings with different hydrophobic and oleophobic properties were constructed by modifying the process conditions using SiOx micro-nano particles as the roughness construction factor. Taking the dominant spoilage bacteria of aquatic products, Shewanella putrefaciens as the object, the anti-bacterial adhesion properties and anti-biofilm mechanism of the SiOx/WPU coatings were investigated. The results show that, with the unmodified SiOx particles increasing from 1.2% (w/V) to 4.0% (w/V), the hydrophobicity and thermal stability of the SiOx/WPU coatings are significantly enhanced, but the oil repellency becomes worse due to the mesoporous structure. After SiOx micro-nano particles are modified with 1H,1H,2H,2H-perfluorooctyl trichlorosilane (PFOTS), the surface energy of the SiOx/WPU coatings is decreased, the liquid repellency is improved, and the surfaces are rough with the appearance of fluorocarbon compounds, but the thermal stabilities are slightly reduced. Among them, after the secondary modification of SiOx micro-nano particles, the SiOx/WPU coatings showed excellent oil repellency, lower surface energies and higher fluorocarbon content on the surface. Particularly, SiOx/WPU coatings exhibited super-amphiphobicity after adjusting the amount of concentrated ammonia added during the secondary modification process. Meanwhile, we found that for the hydrophobic SiOx/WPU coatings, the stronger the oleophobic property, the greater the anti-bacterial adhesion ability is, while the anti-bacterial adhesion ability of hydrophobic and selectively oleophobic or superhydrophobic and oleophobic SiOx/WPU coatings is poor than that of amphiphilic SiOx/WPU coatings. However, because the super-amphiphobic SiOx/WPU coatings can be in the Cassie state with the bacterial solution for a long time, it can "capture" enough air to inhibit the irreversible adhesion of the bacteria. More importantly, the coatings can also inhibit the metabolic activity, secretion of extracellular polysaccharides, and activities of ATPase and AKP of the adherent bacteria, so it has a better anti-biofilm property. The anti-biofilm coatings can be used as food packaging materials or coated on the inner surface of packaging boxes to prevent the microbial infection.