//import java.util.Vector;
import java.rmi.RemoteException;
-import java.sql.Date;
+import java.util.Date;
import java.util.HashSet;
import java.util.ListIterator;
import java.util.Vector;
private static DB4oManager theDB4oManager = null;
private static DB4oManagerAux theDB4oManagerAux;
-
+
static ConfigXML c;
private DB4oManager() throws Exception {
try {
Owner jon = new Owner("Jon");
Owner alfredo = new Owner("Alfredo");
- jon.addRuralHouse("Ezkioko", "Ezkioko etxea", "Ezkio", 3, 3, 3, 3, 3);
- jon.addRuralHouse("Eskiatze", "Eskiatzeko etxea", "Jaca", 4, 4, 4, 4, 4);
+ jon.addRuralHouse("Ezkioko", "Ezkioko etxea", "Beatriz", 3, 3, 3, 3,
+ 3);
+ jon.addRuralHouse("Eskiatze", "Eskiatzeko etxea", "Guazate", 4, 4, 4,
+ 4, 4);
jon.setBankAccount("1349 5677 21 2133567777");
- alfredo.addRuralHouse("Aitonako", "Casa del abuelo", "Pitillas", 5, 5, 5, 5,
- 5);
- alfredo.addRuralHouse("Murgoitz", "", "Murgia", 6, 6, 6, 6, 6);
+ alfredo.addRuralHouse("Aitonako", "Casa del abuelo", "Vegas", 5,
+ 5, 5, 5, 5);
+ alfredo.addRuralHouse("Murgoitz", "", "Cedro", 6, 6, 6, 6, 6);
alfredo.setBankAccount("4144 0087 23 9700002133");
Account jonAcc = new Account("userJon", "passJon", jon);
Account alfredoAcc = new Account("userAlfredo", "passAlfredo",
}
+
public Offer createOffer(RuralHouse ruralHouse, Date firstDay,
Date lastDay, float price) throws RemoteException, Exception {
Offer o = null;
try {
- RuralHouse proto = new RuralHouse(ruralHouse.getHouseName(),
- null, null, null, null);
+ RuralHouse proto = new RuralHouse(ruralHouse.getHouseName(), null,
+ null, null, null);
ObjectSet result = db.queryByExample(proto);
RuralHouse rh = (RuralHouse) result.next();
o = rh.createOffer(theDB4oManagerAux.offerNumber++, firstDay,
try {
-
db.store(offer);
db.commit();
}
return offer;
}
-
+
@SuppressWarnings("finally")
- public void deleteOffer(RuralHouse rh, Offer offer) throws RemoteException, Exception {
+ public void deleteOffer(RuralHouse rh, Offer offer) throws RemoteException,
+ Exception {
if (c.isDatabaseLocal() == false)
openSDB();
else
db.close();
}
}
-
/**
* This method creates a book with a corresponding parameters
if (c.isDatabaseLocal() == false)
openSDB();
- RuralHouse proto = new RuralHouse(ruralHouse.getHouseName(),
- null, ruralHouse.getDescription(), ruralHouse.getDistrict(),
- null);
+ RuralHouse proto = new RuralHouse(ruralHouse.getHouseName(), null,
+ ruralHouse.getDescription(), ruralHouse.getDistrict(), null);
ObjectSet result = db.queryByExample(proto);
RuralHouse rh = (RuralHouse) result.next();
try {
- RuralHouse rhn = (RuralHouse) db
- .queryByExample(
- new RuralHouse(rh.getHouseName(), null, null,
- null, null)).next();
+ RuralHouse rhn = (RuralHouse) db.queryByExample(
+ new RuralHouse(rh.getHouseName(), null, null, null, null))
+ .next();
if (rhn.overlapsWith(firstDay, lastDay) != null)
throw new OverlappingOfferExists();
else
openDB();
boolean stored = false;
- RuralHouse house = new RuralHouse(rh.getHouseName(), null, null,
- null, null);
+ RuralHouse house = new RuralHouse(rh.getHouseName(), null, null, null,
+ null);
try {
ObjectSet<Owner> result = db.queryByExample(house);
if (result.isEmpty()) {
return stored;
}
-
public void removeHouse(RuralHouse rh, Owner owner) {
if (c.isDatabaseLocal() == false)
openSDB();
else
- openDB();
+ openDB();
try {
ObjectSet<RuralHouse> result = db.queryByExample(rh);
if (!result.isEmpty()) {
RuralHouse found = (RuralHouse) result.get(0);
-// db.delete(found.getOwner());
+ // db.delete(found.getOwner());
db.store(owner);
db.delete(found);
db.commit();
}
}
-
- public Vector<RuralHouse> getRuralHousesByTown(String town){
- RuralHouse rh = new RuralHouse(null,null,null,town,null);
-
+
+ public Vector<RuralHouse> getRuralHousesByTown(String town) {
+ RuralHouse rh = new RuralHouse(null, null, null, town, null);
+
if (c.isDatabaseLocal() == false)
openSDB();
else
}
}
- public RuralHouse getRuralHouseByName(String name){
- RuralHouse rh = new RuralHouse(name,null,null,null,null);
-
+
+ public RuralHouse getRuralHouseByName(String name) {
+ RuralHouse rh = new RuralHouse(name, null, null, null, null);
+
if (c.isDatabaseLocal() == false)
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());
db.close();
- return ruralHouses.get(0);
- } catch (NullPointerException e){
+ if (!ruralHouses.isEmpty())
+ return ruralHouses.get(0);
+ else
+ return null;
+ } catch (NullPointerException e) {
return null;
}
-
-
-
+
}
-
- public Vector<RuralHouse> getRuralHouses(String town,int nBed , int nKit, int nBath, int nPark, int nLiv){
- HouseFeatures fea = new HouseFeatures(nBed,nKit,nBath,nLiv,nPark);
- RuralHouse rh = new RuralHouse(null,null,null,town,fea);
+
+ public Vector<RuralHouse> getRuralHouses(String town, int nBed, int nKit,
+ int nBath, int nPark, int nLiv) {
+ HouseFeatures fea = new HouseFeatures(nBed, nKit, nBath, nLiv, nPark);
+ RuralHouse rh = new RuralHouse(null, null, null, town, fea);
if (c.isDatabaseLocal() == false)
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());
db.close();
return ruralHouses;
- } catch (NullPointerException e){
+ } catch (NullPointerException e) {
return null;
}
-
-
-
+
}
}