Package sk.iway.iwcm.doc

Class DataAccessHelper

java.lang.Object
sk.iway.iwcm.doc.DataAccessHelper
public class DataAccessHelper extends Object
Trieda po jej prepisani umoznuje nahravat dodatocne stlpce z databazy pre documents/groups tabulky Povodne som uvazoval spravit to cez eventy, ale kvoli performance som sa rozhodol takto (skaredo)

  • Constructor Summary

    Constructors
    Constructor
    Description
    DataAccessHelper()
     

  • Method Summary

    Modifier and Type
    Method
    Description
    static void
    docLoadData(ResultSet rs, DocDetails doc)
    Metoda je volana pri citani udajov z tabulky documents, umoznuje donacitat dalsie/specificke data Odporucame kvoli dalsiemu rozsirovaniu si spravit separe triedu a pri rozsireni tejto len volat metodu zo separe triedy, napr.
    static String[]
    getDocFields()
    Vrati zoznam DODATOCNYCH stlpcov pre SQL select/insert/update do documents tabulky, priklad: [show_in_navbar, show_in_sitemap, logged_show_in_navbar]
    static String[]
    getGroupFields()
    Vrati zoznam DODATOCNYCH stlpcov pre SQL insert/update do groups tabulky, priklad: [show_in_navbar, show_in_sitemap, logged_show_in_navbar]
    static void
    groupLoadData(ResultSet rs, GroupDetails group)
    Metoda je volana pri citani udajov z tabulky groups, umoznuje donacitat dalsie/specificke data
    static int
    setGroupPreparedStatement(PreparedStatement ps, GroupDetails group, int psCounter)
    Nastavi do SQL prepared statementu hodnoty z group objektu pre zapis do databazy

    Methods inherited from class java.lang.Object

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

  • Constructor Details

    • DataAccessHelper

      public DataAccessHelper()

  • Method Details

    • docLoadData

      public static void docLoadData(ResultSet rs, DocDetails doc)
      Metoda je volana pri citani udajov z tabulky documents, umoznuje donacitat dalsie/specificke data Odporucame kvoli dalsiemu rozsirovaniu si spravit separe triedu a pri rozsireni tejto len volat metodu zo separe triedy, napr. DataAccessHelperMyProjecy.docLoadData(doc, rs);
      Parameters:
      rs -
      doc -

    • getDocFields

      public static String[] getDocFields()
      Vrati zoznam DODATOCNYCH stlpcov pre SQL select/insert/update do documents tabulky, priklad: [show_in_navbar, show_in_sitemap, logged_show_in_navbar]
      Returns:

    • groupLoadData

      public static void groupLoadData(ResultSet rs, GroupDetails group)
      Metoda je volana pri citani udajov z tabulky groups, umoznuje donacitat dalsie/specificke data
      Parameters:
      rs -
      group -

    • getGroupFields

      public static String[] getGroupFields()
      Vrati zoznam DODATOCNYCH stlpcov pre SQL insert/update do groups tabulky, priklad: [show_in_navbar, show_in_sitemap, logged_show_in_navbar]
      Returns:

    • setGroupPreparedStatement

      public static int setGroupPreparedStatement(PreparedStatement ps, GroupDetails group, int psCounter) throws SQLException
      Nastavi do SQL prepared statementu hodnoty z group objektu pre zapis do databazy
      Parameters:
      ps -
      group -
      psCounter - - pocitadlo poradia parametrov
      Returns:
      Throws:
      SQLException