The present disclosure provides an edge and bottom water invasion simulation apparatus and method, a storage medium, and a product. A controller controls an inert gas to be injected into a first intermediate container, and stops the injection. The controller controls formation water to be injected into the first intermediate container, and stops the injection. The controller controls the first intermediate container to be communicated with a core holder, and adjusts a pressure of a back pressure valve, so that the formation water enters a core to simulate edge and bottom water invasion. In the present disclosure, by adding the inert gas and the formation water to the intermediate container, an infinite edge and bottom water with sufficient energy at an early stage of a water invasion and a limited edge and bottom water with lower energy at a later stage of the water invasion can be effectively simulated.