@Override
public GearBoxOil mapRow(ResultSet rs, int rowNum) throws SQLException {
GearBoxOil oil = new GearBoxOil();
oil.setId(rs.getInt("id"));
oil.setName(rs.getString("name"));
oil.setDescription(rs.getString("description"));
oil.setSpecification(rs.getString("Specification"));
oil.setJudgement(rs.getDouble("judgement"));
Manufacturer manufacturer = new Manufacturer();
manufacturer.setId(rs.getInt("manufacturer"));
manufacturer.setName(rs.getString("man_name"));
oil.setManufacturer(manufacturer);
OilStuff oilStuff = new OilStuff();
oilStuff.setId(rs.getInt("oilStuff"));
oilStuff.setName(rs.getString("os_name"));
oil.setOilStuff(oilStuff);
GearBoxType gearBoxType = new GearBoxType();
gearBoxType.setId(rs.getInt("gearBoxType"));
gearBoxType.setName(rs.getString("gbt_name"));
oil.setGearBoxType(gearBoxType);
oil.setPhoto(rs.getString("photo"));
oil.setPrice(rs.getDouble("price"));
oil.setValue(rs.getDouble("value"));
oil.setViscosity(rs.getString("viscosity"));
oil.setDiscount(rs.getDouble("discount"));
oil.setInStock(rs.getInt("instock"));
return oil;
}
