@Test
 public void testGetResidential() throws SQLException {
   rp = new ResidentialProperty();
   rp.setPropertyId(100);
   ResultSet rs = rp.getResidential();
   assertNotNull(rs);
   if (rs.next()) {
     assertEquals(15, rs.getLong("specificationid"));
   }
 }
 @Test
 public void testUpdateProperty() {
   rp = new ResidentialProperty();
   rp.setArea(10);
   rp.setPropertyId(131);
   rp.setCurrentState(false);
   rp.setImage("PMS");
   rp.setStatus("Full");
   rp.setType("Residential");
   rp.setPrice(400000);
   assertTrue(rp.updateProperty());
 }