de.hattrickorganizer.database
Class MatchesKurzInfoTable

java.lang.Object
  extended by de.hattrickorganizer.database.MatchesKurzInfoTable

public final class MatchesKurzInfoTable
extends java.lang.Object


Field Summary
protected  JDBCAdapter adapter
          Database connection
protected  de.hattrickorganizer.database.ColumnDescriptor[] columns
          describes a tableColumn (name, datatype, nullable ..)
static java.lang.String TABLENAME
          tablename
 
Constructor Summary
protected MatchesKurzInfoTable(JDBCAdapter adapter)
           
 
Method Summary
 void createTable()
           
protected  int delete(java.lang.String[] whereColumns, java.lang.String[] whereValues)
           
protected  void dropTable()
          Drop the current table
protected  de.hattrickorganizer.database.ColumnDescriptor[] getColumns()
           
protected  java.lang.String[] getCreateIndizeStatements()
           
 MatchKurzInfo[] getMatchesKurzInfo(int teamId)
          holt die MAtches zu einem Team aus der DB
 MatchKurzInfo[] getMatchesKurzInfo(int teamId, int matchtyp, boolean asc)
          Wichtig: Wenn die Teamid = -1 ist muss der Matchtyp ALLE_SPIELE sein!
protected  java.sql.ResultSet getSelectByHrfID(int hrfID)
          TODO Missing Method Documentation
protected  java.lang.String getTableName()
           
protected  java.lang.String getTableType()
           
protected  void initColumns()
           
 boolean isMatchVorhanden(int matchid)
          Ist das Match schon in der Datenbank vorhanden?
protected  void setColumns(de.hattrickorganizer.database.ColumnDescriptor[] columns)
           
 void storeMatchKurzInfos(MatchKurzInfo[] matches)
          speichert die Matches
protected  void truncateTable()
          Truncate the current table (i.e.
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

TABLENAME

public static final java.lang.String TABLENAME
tablename

See Also:
Constant Field Values

columns

protected de.hattrickorganizer.database.ColumnDescriptor[] columns
describes a tableColumn (name, datatype, nullable ..)


adapter

protected JDBCAdapter adapter
Database connection

Constructor Detail

MatchesKurzInfoTable

protected MatchesKurzInfoTable(JDBCAdapter adapter)
Method Detail

initColumns

protected void initColumns()

getCreateIndizeStatements

protected java.lang.String[] getCreateIndizeStatements()

getMatchesKurzInfo

public MatchKurzInfo[] getMatchesKurzInfo(int teamId,
                                          int matchtyp,
                                          boolean asc)
Wichtig: Wenn die Teamid = -1 ist muss der Matchtyp ALLE_SPIELE sein!

Parameters:
teamId - Die Teamid oder -1 für alle
matchtyp - Welche Matches? Konstanten im SpielePanel!
asc - TODO Missing Constructuor Parameter Documentation
Returns:
TODO Missing Return Method Documentation

isMatchVorhanden

public boolean isMatchVorhanden(int matchid)
Ist das Match schon in der Datenbank vorhanden?

Parameters:
matchid - TODO Missing Constructuor Parameter Documentation
Returns:
TODO Missing Return Method Documentation

getMatchesKurzInfo

public MatchKurzInfo[] getMatchesKurzInfo(int teamId)
holt die MAtches zu einem Team aus der DB

Parameters:
teamId - Die Teamid oder -1 für alle
Returns:
TODO Missing Return Method Documentation

storeMatchKurzInfos

public void storeMatchKurzInfos(MatchKurzInfo[] matches)
speichert die Matches

Parameters:
matches - TODO Missing Constructuor Parameter Documentation

getTableType

protected java.lang.String getTableType()

getTableName

protected java.lang.String getTableName()

setColumns

protected void setColumns(de.hattrickorganizer.database.ColumnDescriptor[] columns)

getColumns

protected de.hattrickorganizer.database.ColumnDescriptor[] getColumns()

delete

protected int delete(java.lang.String[] whereColumns,
                     java.lang.String[] whereValues)

createTable

public void createTable()

getSelectByHrfID

protected java.sql.ResultSet getSelectByHrfID(int hrfID)
TODO Missing Method Documentation

Parameters:
tableName - TODO Missing Method Parameter Documentation
hrfID - TODO Missing Method Parameter Documentation
Returns:
TODO Missing Return Method Documentation

dropTable

protected void dropTable()
Drop the current table


truncateTable

protected void truncateTable()
Truncate the current table (i.e. remove all rows)