コード例 #1
0
  public Iterator<VehicleType> restore(VehicleType vehicleType) throws RARException {
    // String       selectClubSql = "select id, name, address, established, founderid from club";
    String selectVTSql =
        "select vt.vehicleTypeId, vt.typeName " + " from VehicleType vt where 1=1 ";
    Statement stmt = null;
    StringBuffer query = new StringBuffer(100);
    StringBuffer condition = new StringBuffer(100);

    condition.setLength(0);

    // form the query based on the given Club object instance
    query.append(selectVTSql);

    if (vehicleType != null) {
      if (vehicleType.getId() >= 0) // id is unique, so it is sufficient to get a VehicleType
      query.append(" and vehicleTypeId = " + vehicleType.getId());
      else if (vehicleType.getType()
          != null) // Type is unique, so it is sufficient to get a VehicleType
      query.append(" and typeName = '" + vehicleType.getType() + "'");
      else {
        /*
        if( club.getAddress() != null )
            condition.append( " and address = '" + club.getAddress() + "'" );

        if( club.getEstablishedOn() != null ) {
            if( condition.length() > 0 )
                condition.append( " and" );
            condition.append( " established = '" + club.getEstablishedOn() + "'" );
        }
        // This was already commented out
        //if( condition.length() > 0 ) {
        //    query.append(  " where " );
        //    query.append( condition );
        //}
        */
      }
    }

    try {

      stmt = conn.createStatement();

      // retrieve the persistent VehicleType object
      //
      if (stmt.execute(query.toString())) { // statement returned a result
        ResultSet r = stmt.getResultSet();
        return new VehicleTypeIterator(r, objectLayer);
      }
    } catch (Exception e) { // just in case...
      throw new RARException(
          "VehicleTypeManager.restore: Could not restore persistent VehicleType object; Root cause: "
              + e);
    }

    throw new RARException(
        "VehicleTypeManager.restore: Could not restore persistent VehicleType object");
  }
コード例 #2
0
  public Iterator<Vehicle> restoreVehicleVehicleType(VehicleType vehicleType) throws RARException {
    String selectPersonSql =
        "select v.registrationTag, v.lastService, v.make, v.mileage, v.model, v.rentalLocation, v.status, v.vehicleType, "
            + " v.vehicleYear, v.vehicleCondition, v.vehicleID"
            + "  vt.typeName, vt.vehicleTypeId from Vehicle v, VehicleType vt where v.vehicleID = vt.vehicleTypeId";

    Statement stmt = null;
    StringBuffer query = new StringBuffer(100);
    StringBuffer condition = new StringBuffer(100);

    condition.setLength(0);

    // form the query based on the given Person object instance
    query.append(selectPersonSql);

    if (vehicleType != null) {
      if (vehicleType.getId() >= 0) // id is unique, so it is sufficient to get a
      query.append(" and vt.vehicleTypeId = " + vehicleType.getId());
      // else if( vehicleType.getType() != null ) // userName is unique, so it is sufficient to get
      // a
      //    query.append( " and vt.vehicleType = '" + vehicleType.getType() + "'" );
      else {

        if (vehicleType.getType() != null)
          condition.append(" and vt.vehicleType = '" + vehicleType.getType() + "'");

        if (condition.length() > 0) {
          query.append(condition);
        }
      }
    }

    try {

      stmt = conn.createStatement();

      // retrieve the persistent Person object
      //
      if (stmt.execute(query.toString())) { // statement returned a result
        ResultSet r = stmt.getResultSet();
        return new VehicleIterator(r, objectLayer);
      }
    } catch (Exception e) { // just in case...
      throw new RARException(
          "VehicleManager.restoreReservationVehicleType: Could not restore persistent Vehicle object; Root cause: "
              + e);
    }

    // if we reach this point, it's an error
    throw new RARException(
        "VehicleManager.restoreReservationVehicleType: Could not restore persistent Vehicle object");
  }
コード例 #3
0
  public void save(VehicleType vehicleType) throws RARException {
    String insertVTSql = "insert into VehicleType ( typeName  ) values ( ? )";
    String updateVTSql = "update VehicleTye set typeName = ? where id = ?";
    PreparedStatement stmt = null;
    int inscnt;
    long VTId;

    /*
    if( club.getFounderId() == -1 )
        throw new ClubsException( "ClubManager.save: Attempting to save a Club without a founder" );
        */
    try {

      if (!vehicleType.isPersistent())
        stmt = (PreparedStatement) conn.prepareStatement(insertVTSql);
      else stmt = (PreparedStatement) conn.prepareStatement(updateVTSql);

      if (vehicleType.getType() != null) // type is unique and non null
        // This is me setting the value in col typeName in table VehicleType to the provided value
        stmt.setString(1, vehicleType.getType());
      else
        throw new RARException("VehicleTypeManager.save: can't save a VehicleType: name undefined");
      /*
       * This is an example for when there are more parameters to deal with
                  if( club.getAddress() != null )
                      stmt.setString( 2, club.getAddress() );
                  else
                      stmt.setNull( 2, java.sql.Types.VARCHAR );

                  if( club.getEstablishedOn() != null ) {
                      java.util.Date jDate = club.getEstablishedOn();
                      java.sql.Date sDate = new java.sql.Date( jDate.getTime() );
                      stmt.setDate( 3,  sDate );
                  }
                  else
                      stmt.setNull(3, java.sql.Types.DATE);

                  if( club.getFounder() != null && club.getFounder().isPersistent() )
                      stmt.setLong( 4, club.getFounder().getId() );
                  else
                      throw new ClubsException( "ClubManager.save: can't save a Club: founder is not set or not persistent" );
      */
      if (vehicleType.isPersistent()) stmt.setLong(2, vehicleType.getId());

      inscnt = stmt.executeUpdate();

      if (!vehicleType.isPersistent()) {
        if (inscnt >= 1) {
          String sql = "select last_insert_id()";
          if (stmt.execute(sql)) { // statement returned a result

            // retrieve the result
            ResultSet r = stmt.getResultSet();

            // we will use only the first row!
            //
            while (r.next()) {

              // retrieve the last insert auto_increment value
              VTId = r.getLong(1);
              if (VTId > 0) vehicleType.setId(VTId); // set this vehicleType's db id (proxy object)
            }
          }
        } else throw new RARException("VehicleTypeManager.save: failed to save a VehicleType");
      } else {
        if (inscnt < 1)
          throw new RARException("VehicleTypeManager.save: failed to save a VehicleType");
      }
    } catch (SQLException e) {
      e.printStackTrace();
      throw new RARException("VehicleTypeManager.save: failed to save a VehicleType: " + e);
    }
  }