The dynamic heterogeneity of water drive sandstone reservoir in high water cut stage is strong, which leads to the differential enrichment and distribution of remaining oil. The adjustment of injection-production relationship can effectively guide the work of stabilizing oil and controlling water. Based on the principle of inter-well connectivity, this paper comprehensively considers the geological characteristics and development dynamics, and constructs the multi-layer reservoir joint well network inter-well connectivity model. By integrating the automatic history matching and the real-time injection-production optimization algorithms, the accurate inversion of connectivity parameters and real-time optimization prediction of production dynamics are realized. Field applications in the block X demonstrated that this method resulted in an annual increase in oil production of 16,000 cubic meters and a reduction in water cut by 0.87%, showing significant enhancement in oil recovery and water control. This method can be applied to guide the adjustment of the planar injection-production structure in similar reservoirs.