Innovative Software Solutions

package coding;

public abstract class Automobile {
	
	public void retailPrice(int price) {
		System.out.println("The retail price of this vehicle is " + price);
	}
	public abstract void wheelDrive();
	
	public abstract void passengerCapacity();
	
	public abstract void propulsionType();
	
	public abstract void efficiencyRate();

}

package coding;

public class Avalanche extends Automobile {

	@Override
	public void wheelDrive() {
		// TODO Auto-generated method stub
		System.out.println("Wheel Drive options: 2WH,Auto,4WH,4WL");
	}

	@Override
	public void passengerCapacity() {
		// TODO Auto-generated method stub
		System.out.println("Passenger capacity: 5 adults");
		
	}

	@Override
	public void propulsionType() {
		// TODO Auto-generated method stub
		System.out.println("Propulsion system:  5.3Litre V8");
	}

	@Override
	public void efficiencyRate() {
		// TODO Auto-generated method stub
		System.out.println("Efficiency rate:  15 MPG City/18 MPG Hwy");
		
	}

}

//===========================================================
// Prepare a SQL query to insert a row into the breed table.
//===========================================================
query = “INSERT INTO breed ”
+ “(thekey,”
+ “species_key,”
+ “breed_name,”
+ “breed_ext_id,”
+ “create_user,”
+ “create_stamp,”
+ “update_user,”
+ “update_stamp) ”
+ “VALUES(?,?,?,?,”
+ “?,CURRENT_TIMESTAMP,?,CURRENT_TIMESTAMP)”;
ps = conn.prepareStatement(query);
ps.setInt(1, brdKey);
ps.setInt(2, formDO.getSpeciesKey());
ps.setString(3, formDO.getBreedName());
ps.setString(4, formDO.getBreedExtId().toUpperCase());
ps.setString(5, request.getSession().getAttribute(“USERNAME”).toString());
ps.setString(6, request.getSession().getAttribute(“USERNAME”).toString());
ps.executeUpdate();