示例#1
0
  public Location getLocation(Store store, City city) {
    Location toReturn = null;
    connect();
    try {
      // Create a stmt object
      stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);

      // Query the database, storing the result
      // in an object of type ResultSet
      rs =
          stmt.executeQuery(
              "SELECT LocationId from Location, Store, City WHERE "
                  + "Store.StoreId='"
                  + store.getStoreId()
                  + "' AND City.CityId='"
                  + city.getCityId()
                  + "'");

      // Check if User is already in the database
      while (rs.next()) {
        String locationId = rs.getString("LocationId");
        toReturn = new Location(locationId, store.getStoreId(), city.getCityId());
      } // end while loop
    } catch (Exception e) {
      e.printStackTrace();
    } // end catch
    finally {
      disconnect();
    }
    return toReturn;
  }
示例#2
0
  public void addStore(Store toAdd) {
    connect();
    try {
      // Create a stmt object
      stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);

      // Query the database, storing the result
      // in an object of type ResultSet
      rs =
          stmt.executeQuery(
              "SELECT * from Store WHERE "
                  + "Name='"
                  + toAdd.getName()
                  + "' AND "
                  + "Address='"
                  + toAdd.getAddress()
                  + "'");

      // Check if User is already in the database
      while (rs.next()) {
        System.out.println("Store already exists in DB.");
        disconnect();
        return;
      } // end while loop

      stmt.executeUpdate(
          "INSERT INTO Store(Name, Address) VALUES ('"
              + toAdd.getName()
              + "', '"
              + toAdd.getAddress()
              + "')");
    } catch (Exception e) {
      e.printStackTrace();
    } // end catch
    finally {
      disconnect();
    }
  }