@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;
    }