@Before
 public void setUp() throws SQLException {
   ds = prepareDataSource();
   DBUtils.executeSqlScript(ds, HotelManager.class.getResource("createTables.sql"));
   manager = new RoomManagerImpl();
   manager.setDataSource(ds);
 }
 @After
 public void tearDown() throws SQLException {
   DBUtils.executeSqlScript(ds, HotelManager.class.getResource("dropTables.sql"));
 }