@Test
 public void testOneResidential() throws SQLException {
   rp = new ResidentialProperty();
   rp.setStatus("ForRent");
   ResultSet rs = rp.oneResidential(100);
   assertNotNull(rs);
   if (rs.next()) {
     assertEquals(100, rs.getLong("rrpropertyid"));
   }
 }
 @Test
 public void testInsertResidential() {
   rp = new ResidentialProperty();
   rp.setArea(10);
   rp.setCurrentState(false);
   rp.setImage("PMS");
   rp.setStatus("Full");
   rp.setType("Residential");
   rp.setPrice(400000);
   assertTrue(rp.insertResidential());
 }