The invention discloses a bacteriostasis, sterilization and air purification type aqueous coating for glass doors. The coating is prepared by using the following raw materials, by weight, 30-34 parts of aqueous hydroxy acrylic resin, 7-9 parts of an aqueous film forming assistant, 13-15 parts of an organosilicon polyester resin emulsion, 12-14 parts of aqueous polyurethane resin, 0.6-1.2 parts of methyltrimethoxysilane, 0.7-1.3 parts of tributyl citrate, 1-2 parts of selenious nitrate, 0.2-0.3 parts of rare earth chloride, 0.3-0.5 parts of rosin-polythylene oxide ester, 2-3 parts of dipropylene glycol monomethyl ether, 1-2 parts of polytetrafluoroethylene, 2-3 parts of m-phenylenediamine, 1-2 parts of a pigment, 1-3 parts of N-methyldiethanolamine, 1-2 parts of activated clay, 1-3 parts of alpha-cyanoacrylate, 2-4 parts of chitosan fiber, 0.3-0.4 parts of propoxylated lanolin alcohol, 1-2 parts of sodium citrate and 13-16 parts of deionized water. The aqueous coating for glass has the advantages of excellent performances, substantial sterilization and mildew prevention effects, air purification, environmental protection, and suitableness for popularization.