@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"));
}