We reinvestigate the hydration structure of water and the variation of related short range hydration force during the normal approach between two mica surfaces in water, by using a newly developed molecular ensemble that allows for water molecules being squeezed out under ambient conditions. The ensemble includes a hydrophilic mica pore and a hydrophobic smooth pore. At comparably larger distance (D>1.0 nm), the force between two mica surfaces in water is attractive due to the inability of potassium ions (K+) to build up osmotic repulsive pressures, consistent with theoretical predictions (Israelachvili, Intermolecular & Surface Forces, 1991). When the contact gap, D, begin to be slightly less that 1.0 nm, corresponding to three water layers, we observe a force transition to a repulsive region. Further increase in confinement leads to the transition of three-water-layer to the two-water-layer structure. This transition corresponds to a plateau of repulsive hydration force, as observed in the surface force apparatus (SFA) experiments (Israelachvili and Pashley, Nature 306, 249 (1983)). For the two-water-layer structure, very steep, repulsive hydration force is observed, and there is no sign to squeeze out the last two layers. Surprisingly, the structure factor of two-layer water is much lower than that of bilayer ice (Leng and Cummings, J. Chem. Phys., 124, 74711; 125, 104701 (2006)), indicating that water is more amorphous in this layered structure. The density of confined water is quite close to the bulk density, very different from what we found previously. The diffusion of water molecules confined between two hydrophilic mica surfaces is much slower that that in hydrophobic pore. This finding is valuable in understanding the dynamics of water molecules in many situations, for example, in protein folding in intracellular environment.