}
}
+ public void deleteDB() {
+
+ if (c.isDatabaseLocal() == false)
+ openSDB();
+ else
+ openDB();
+
+ try {
+ Owner proto = new Owner(null, null);
+ ObjectSet result = db.queryByExample(proto);
+ Vector<Owner> owners = new Vector<Owner>();
+ while (result.hasNext()) {
+ Owner o = (Owner) result.next();
+ System.out.println("Deleted owner: " + o.toString());
+ db.delete(o);
+ }
+ db.commit();
+ } finally {
+ db.close();
+ }
+ }
+
+
@SuppressWarnings("finally")
public Offer createOffer(RuralHouse ruralHouse, Date firstDay,
Date lastDay, float price) throws RemoteException, Exception {
Offer o = null;
-
+
if (c.isDatabaseLocal() == false)
openSDB();
else
openDB();
-
- try {
-
+ try {
RuralHouse proto = new RuralHouse(ruralHouse.getHouseName(),
null, null, null, null);
.println("Error: com.db4o.ext.ObjectNotStorableException in createOffer");
} finally {
db.close();
- return o;
}
+ return o;
}
- public void deleteDB() {
+ @SuppressWarnings("finally")
+ public Offer modifyOffer(Offer offer) throws RemoteException, Exception {
+ if (c.isDatabaseLocal() == false)
+ openSDB();
+ else
+ openDB();
+ try {
+
+
+ db.store(offer);
+ db.commit();
+
+ } catch (com.db4o.ext.ObjectNotStorableException e) {
+ System.out
+ .println("Error: com.db4o.ext.ObjectNotStorableException in createOffer");
+ } finally {
+ db.close();
+ }
+ return offer;
+ }
+
+ @SuppressWarnings("finally")
+ public void deleteOffer(RuralHouse rh, Offer offer) throws RemoteException, Exception {
if (c.isDatabaseLocal() == false)
openSDB();
else
openDB();
-
+
try {
- Owner proto = new Owner(null, null);
- ObjectSet result = db.queryByExample(proto);
- Vector<Owner> owners = new Vector<Owner>();
- while (result.hasNext()) {
- Owner o = (Owner) result.next();
- System.out.println("Deleted owner: " + o.toString());
- db.delete(o);
- }
+
+ db.store(rh);
+ db.delete(offer);
db.commit();
+
+ } catch (com.db4o.ext.ObjectNotStorableException e) {
+ System.out
+ .println("Error: com.db4o.ext.ObjectNotStorableException in createOffer");
} finally {
db.close();
}
}
+
/**
* This method creates a book with a corresponding parameters
public Booking createBooking(RuralHouse ruralHouse, Date firstDate,
Date lastDate, String bookTelephoneNumber)
throws OfferCanNotBeBooked {
-
+
if (c.isDatabaseLocal() == false)
openSDB();
else
openDB();
-
+
Booking bok = null;
-
+
try {
if (c.isDatabaseLocal() == false)
.println("Error: com.db4o.ext.ObjectNotStorableException in createBooking");
} catch (Exception exc) {
exc.printStackTrace();
+ } finally {
+ db.close();
}
- db.close();
return bok;
}
public Vector<RuralHouse> getAllRuralHouses() throws RemoteException,
Exception {
-
+
if (c.isDatabaseLocal() == false)
openSDB();
else
public boolean existsOverlappingOffer(RuralHouse rh, Date firstDay,
Date lastDay) throws RemoteException, OverlappingOfferExists {
-
+
if (c.isDatabaseLocal() == false)
openSDB();
else
openDB();
-
+
try {
-
RuralHouse rhn = (RuralHouse) db
.queryByExample(
*/
public Vector<Account> getAccount(String usr, String pwd)
throws RemoteException, Exception {
-
+
if (c.isDatabaseLocal() == false)
openSDB();
else
openDB();
-
+
try {
Account proto = new Account(usr, pwd, new Owner(null, null));
ObjectSet<Account> result = db.queryByExample(proto);
openSDB();
else
openDB();
-
+
boolean stored = false;
RuralHouse house = new RuralHouse(rh.getHouseName(), null, null,
null, null);
return stored;
}
- public void removeHouse(String houseName) {
+
+ public void removeHouse(RuralHouse rh, Owner owner) {
if (c.isDatabaseLocal() == false)
openSDB();
else
- openDB();
-
- RuralHouse house = new RuralHouse(houseName, null, null, null, null);
+ openDB();
try {
- ObjectSet<RuralHouse> result = db.queryByExample(house);
+ ObjectSet<RuralHouse> result = db.queryByExample(rh);
if (!result.isEmpty()) {
RuralHouse found = (RuralHouse) result.get(0);
+// db.delete(found.getOwner());
+ db.store(owner);
db.delete(found);
db.commit();
}
openSDB();
else
openDB();
-
- try{
+
+ try {
ObjectSet<RuralHouse> result = db.queryByExample(rh);
Vector<RuralHouse> ruralHouses = new Vector<RuralHouse>();
- while(result.hasNext())
+ while (result.hasNext())
ruralHouses.add(result.next());
return ruralHouses;
- }finally{
+ } finally {
db.close();
}
-
+
}
public RuralHouse getRuralHouseByName(String name){
RuralHouse rh = new RuralHouse(name,null,null,null,null);