The effect of ZnO nanoparticles (ZnO NPs), with different concentrations in simulated water, on the activity of sulfate-reducing bacteria (SRB) and their adhesion behaviour on stainless-steel surfaces, with and without visible light treatment, were investigated. The results showed that the concentration of ZnO NPs and light treatment greatly influenced the antibacterial performance of the NPs. In the water solution without light treatment, the low concentration (no more than 1 mg/L) of ZnO NPs in the aqueous solution promoted the growth of SRB, and the amount of biofilm attached to the stainless-steel surface increased. As the concentration increased, ZnO NPs exhibited antibacterial effects. In water under visible light irradiation, ZnO NPs showed antibacterial performance at all the concentrations studied (0.5~50 mg/L), and the antibacterial efficiency increased with the increase in the concentration of NPs. The determination results of the reactive oxygen species showed that light treatment can stimulate ZnO NPs in water to generate ·OH and O2·−, which exhibited good antibacterial properties. The adhesion amount of SRB on the stainless-steel surface was inversely proportional to the antibacterial efficiency of ZnO NPs.