Biofilms play important roles in nutrients and energy cycling in aquatic ecosystems. We hypothesized that as eutrophication could change phytoplankton community and decrease phytoplankton diversity, ambient inorganic nitrogen level will affect the microbial community and diversity of biofilms and the roles of biofilms in nutrient cycling. Biofilms were cultured using a flow incubator either with replete inorganic nitrogen (N-rep) or without exogenous inorganic nitrogen supply (N-def). The results showed that the biomass and nitrogen and phosphorous accumulation of biofilms were limited by N deficiency; however, as expected, the N-def biofilms had significantly higher microbial diversity than that of N-rep biofilms. The microbial community of biofilms shifted in composition and abundance in response to ambient inorganic nitrogen level. For example, as compared between the N-def and the N-rep biofilms, the former consisted of more diazotrophs, while the latter consisted of more denitrifying bacteria. As a result of the shift of the functional microbial community, the N concentration of N-rep medium kept decreasing, while that of N-def medium showed an increasing trend in the late stage. This indicates that biofilms can serve as the source or the sink of nitrogen in aquatic ecosystems, and it depends on the inorganic nitrogen availability.