Package sk.iway.iwcm.admin.xls

Class AbstractExcelImportService<T>

java.lang.Object
sk.iway.iwcm.admin.xls.AbstractExcelImportService<T>
Type Parameters:
T - Entita pre zapis do DB
All Implemented Interfaces:
ExcelImportServiceInterface
public abstract class AbstractExcelImportService<T> extends Object implements ExcelImportServiceInterface
Abstraktna trieda pre import xlsx a xls do DB pomocou Spring repository. Data sa precitaju z Excl suboru, mapuju sa property podla prveho riadku. Nacitane su do listu importedRows a nasledne zapisane do databazy volanim saveListToDB().

  • Constructor Summary

    Constructors
    Modifier
    Constructor
    Description
    protected
    AbstractExcelImportService(org.springframework.data.repository.CrudRepository<T,Long> repository, org.springframework.core.convert.ConversionService conversionService)
     

  • Method Summary

    Modifier and Type
    Method
    Description
    void
    afterRow(T bean)
    Metoda urcena na Override, volana po ziskanim kazdeho riadku excelu a konvertovanim na entitu
    void
    afterWorkbook(List<T> list)
    Metoda urcena na Override, volana po iteracii harkov
    void
    beforeRow(org.apache.poi.ss.usermodel.Row row)
    Metoda urcena na Override, volana pred ziskanim kazdeho riadku excelu
    void
    beforeWorkbook()
    Metoda urcena na Override, volana pred iteraciou harkov
    Optional<T>
    convertRowToBeanAndAddToList(org.apache.poi.ss.usermodel.Row row)
    Metoda pre konvertovanie riadku na entitu
    List<String>
    getFirstRowNames()
    Metoda pre navrat nazvov stlpcov
    void
    importFile(org.springframework.web.multipart.MultipartFile file)
    Metoda pre import zaznamov do DB
    void
    saveListToDB()
    Metoda pre ulozenie entit do DB

    Methods inherited from class java.lang.Object

    clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

  • Constructor Details

    • AbstractExcelImportService

      protected AbstractExcelImportService(org.springframework.data.repository.CrudRepository<T,Long> repository, org.springframework.core.convert.ConversionService conversionService)

  • Method Details

    • importFile

      public void importFile(org.springframework.web.multipart.MultipartFile file)
      Metoda pre import zaznamov do DB
      Specified by:
      importFile in interface ExcelImportServiceInterface
      Parameters:
      file - Subor so zaznamami

    • saveListToDB

      public void saveListToDB()
      Metoda pre ulozenie entit do DB

    • convertRowToBeanAndAddToList

      public Optional<T> convertRowToBeanAndAddToList(org.apache.poi.ss.usermodel.Row row)
      Metoda pre konvertovanie riadku na entitu
      Parameters:
      row - riadok excelu
      Returns:
      Optional entitu

    • beforeWorkbook

      public void beforeWorkbook()
      Metoda urcena na Override, volana pred iteraciou harkov

    • afterWorkbook

      public void afterWorkbook(List<T> list)
      Metoda urcena na Override, volana po iteracii harkov

    • beforeRow

      public void beforeRow(org.apache.poi.ss.usermodel.Row row)
      Metoda urcena na Override, volana pred ziskanim kazdeho riadku excelu

    • afterRow

      public void afterRow(T bean)
      Metoda urcena na Override, volana po ziskanim kazdeho riadku excelu a konvertovanim na entitu

    • getFirstRowNames

      public List<String> getFirstRowNames()
      Metoda pre navrat nazvov stlpcov