Overview  Package   Class  Use  Tree  Deprecated  Index  Help 
 PREV CLASS   NEXT CLASS FRAMES    NO FRAMES    
SUMMARY: NESTED | FIELD | CONSTR | METHOD DETAIL: FIELD | CONSTR | METHOD

org.olat.core.commons.persistence
Interface DBQuery

All Known Implementing Classes:
DBQueryImpl
public interface DBQuery

A DBQuery is

Author:
Andreas

Method Summary
 int executeUpdate(org.hibernate.FlushMode nullOrFlushMode)
          Execute the update or delete statement.
 java.lang.String[] getNamedParameters()
           
 java.lang.String getQueryString()
           
 org.hibernate.type.Type[] getReturnTypes()
           
 java.util.List list()
           
 DBQuery setBigDecimal(int position, java.math.BigDecimal number)
           
 DBQuery setBigDecimal(java.lang.String name, java.math.BigDecimal number)
           
 DBQuery setBinary(int position, byte[] val)
           
 DBQuery setBinary(java.lang.String name, byte[] val)
           
 DBQuery setBoolean(int position, boolean val)
           
 DBQuery setBoolean(java.lang.String name, boolean val)
           
 DBQuery setByte(int position, byte val)
           
 DBQuery setByte(java.lang.String name, byte val)
           
 DBQuery setCacheable(boolean cacheable)
           
 DBQuery setCacheRegion(java.lang.String cacheRegion)
           
 DBQuery setCalendar(int position, java.util.Calendar calendar)
           
 DBQuery setCalendar(java.lang.String name, java.util.Calendar calendar)
           
 DBQuery setCalendarDate(int position, java.util.Calendar calendar)
           
 DBQuery setCalendarDate(java.lang.String name, java.util.Calendar calendar)
           
 DBQuery setCharacter(int position, char val)
           
 DBQuery setCharacter(java.lang.String name, char val)
           
 DBQuery setDate(int position, java.util.Date date)
           
 DBQuery setDate(java.lang.String name, java.util.Date date)
           
 DBQuery setDouble(int position, double val)
           
 DBQuery setDouble(java.lang.String name, double val)
           
 DBQuery setEntity(int position, java.lang.Object val)
           
 DBQuery setEntity(java.lang.String name, java.lang.Object val)
           
 DBQuery setFirstResult(int firstResult)
           
 DBQuery setFloat(int position, float val)
           
 DBQuery setFloat(java.lang.String name, float val)
           
 DBQuery setInteger(int position, int val)
           
 DBQuery setInteger(java.lang.String name, int val)
           
 DBQuery setLocale(int position, java.util.Locale locale)
           
 DBQuery setLocale(java.lang.String name, java.util.Locale locale)
           
 void setLockMode(java.lang.String alias, org.hibernate.LockMode lockMode)
           
 DBQuery setLong(int position, long val)
           
 DBQuery setLong(java.lang.String string, long value)
           
 DBQuery setMaxResults(int maxResults)
           
 DBQuery setParameter(int position, java.lang.Object val)
           
 DBQuery setParameter(int position, java.lang.Object val, org.hibernate.type.Type type)
           
 DBQuery setParameter(java.lang.String name, java.lang.Object val)
           
 DBQuery setParameter(java.lang.String name, java.lang.Object val, org.hibernate.type.Type type)
           
 DBQuery setParameterList(java.lang.String name, java.util.Collection vals)
           
 DBQuery setParameterList(java.lang.String name, java.util.Collection vals, org.hibernate.type.Type type)
           
 DBQuery setParameterList(java.lang.String name, java.lang.Object[] vals)
           
 DBQuery setParameterList(java.lang.String name, java.lang.Object[] vals, org.hibernate.type.Type type)
           
 DBQuery setProperties(java.lang.Object bean)
           
 DBQuery setSerializable(int position, java.io.Serializable val)
           
 DBQuery setSerializable(java.lang.String name, java.io.Serializable val)
           
 DBQuery setShort(int position, short val)
           
 DBQuery setShort(java.lang.String name, short val)
           
 DBQuery setString(int position, java.lang.String val)
           
 DBQuery setString(java.lang.String string, java.lang.String value)
           
 DBQuery setText(int position, java.lang.String val)
           
 DBQuery setText(java.lang.String name, java.lang.String val)
           
 DBQuery setTime(int position, java.util.Date date)
           
 DBQuery setTime(java.lang.String name, java.util.Date date)
           
 DBQuery setTimeout(int timeout)
           
 DBQuery setTimestamp(int position, java.util.Date date)
           
 DBQuery setTimestamp(java.lang.String name, java.util.Date date)
           
 java.lang.Object uniqueResult()
           
 

Method Detail

setLong

DBQuery setLong(java.lang.String string,
                long value)
Parameters:
string -
value -
Returns:
See Also:
Query

setString

DBQuery setString(java.lang.String string,
                  java.lang.String value)
Parameters:
string -
value -
Returns:
See Also:
Query

setTime

DBQuery setTime(java.lang.String name,
                java.util.Date date)
Parameters:
name -
date -
Returns:
See Also:
Query

executeUpdate

int executeUpdate(org.hibernate.FlushMode nullOrFlushMode)
Execute the update or delete statement. The semantics are compliant with the ejb3 Query.executeUpdate() method.

Parameters:
nullOrFlushMode - either pass null if you don't want to set the FlushMode - otherwise pass the FlushMode you want to set on the query for execution
Returns:
the number of entities updated or deleted

list

java.util.List list()
Returns:
See Also:
Query

getNamedParameters

java.lang.String[] getNamedParameters()
Returns:
See Also:
Query

getQueryString

java.lang.String getQueryString()
Returns:
See Also:
Query

getReturnTypes

org.hibernate.type.Type[] getReturnTypes()
Returns:
See Also:
Query

setBigDecimal

DBQuery setBigDecimal(int position,
                      java.math.BigDecimal number)
Parameters:
position -
number -
Returns:
See Also:
Query

setBigDecimal

DBQuery setBigDecimal(java.lang.String name,
                      java.math.BigDecimal number)
Parameters:
name -
number -
Returns:
See Also:
Query

setBinary

DBQuery setBinary(int position,
                  byte[] val)
Parameters:
position -
val -
Returns:
See Also:
Query

setBinary

DBQuery setBinary(java.lang.String name,
                  byte[] val)
Parameters:
name -
val -
Returns:
See Also:
Query

setBoolean

DBQuery setBoolean(int position,
                   boolean val)
Parameters:
position -
val -
Returns:
See Also:
Query

setBoolean

DBQuery setBoolean(java.lang.String name,
                   boolean val)
Parameters:
name -
val -
Returns:
See Also:
Query

setByte

DBQuery setByte(int position,
                byte val)
Parameters:
position -
val -
Returns:
See Also:
Query

setByte

DBQuery setByte(java.lang.String name,
                byte val)
Parameters:
name -
val -
Returns:
See Also:
Query

setCacheable

DBQuery setCacheable(boolean cacheable)
Parameters:
cacheable -
Returns:
See Also:
Query

setCacheRegion

DBQuery setCacheRegion(java.lang.String cacheRegion)
Parameters:
cacheRegion -
Returns:
See Also:
Query

setCalendar

DBQuery setCalendar(int position,
                    java.util.Calendar calendar)
Parameters:
position -
calendar -
Returns:
See Also:
Query

setCalendar

DBQuery setCalendar(java.lang.String name,
                    java.util.Calendar calendar)
Parameters:
name -
calendar -
Returns:
See Also:
Query

setCalendarDate

DBQuery setCalendarDate(int position,
                        java.util.Calendar calendar)
Parameters:
position -
calendar -
Returns:
See Also:
Query

setCalendarDate

DBQuery setCalendarDate(java.lang.String name,
                        java.util.Calendar calendar)
Parameters:
name -
calendar -
Returns:
See Also:
Query

setCharacter

DBQuery setCharacter(int position,
                     char val)
Parameters:
position -
val -
Returns:
See Also:
Query

setCharacter

DBQuery setCharacter(java.lang.String name,
                     char val)
Parameters:
name -
val -
Returns:
See Also:
Query

setDate

DBQuery setDate(int position,
                java.util.Date date)
Parameters:
position -
date -
Returns:
See Also:
Query

setDate

DBQuery setDate(java.lang.String name,
                java.util.Date date)
Parameters:
name -
date -
Returns:
See Also:
Query

setDouble

DBQuery setDouble(int position,
                  double val)
Parameters:
position -
val -
Returns:
See Also:
Query

setDouble

DBQuery setDouble(java.lang.String name,
                  double val)
Parameters:
name -
val -
Returns:
See Also:
Query

setEntity

DBQuery setEntity(int position,
                  java.lang.Object val)
Parameters:
position -
val -
Returns:
See Also:
Query

setEntity

DBQuery setEntity(java.lang.String name,
                  java.lang.Object val)
Parameters:
name -
val -
Returns:
See Also:
Query

setFirstResult

DBQuery setFirstResult(int firstResult)
Parameters:
firstResult -
Returns:
See Also:
Query

setFloat

DBQuery setFloat(int position,
                 float val)
Parameters:
position -
val -
Returns:
See Also:
Query

setFloat

DBQuery setFloat(java.lang.String name,
                 float val)
Parameters:
name -
val -
Returns:
See Also:
Query

setInteger

DBQuery setInteger(int position,
                   int val)
Parameters:
position -
val -
Returns:
See Also:
Query

setInteger

DBQuery setInteger(java.lang.String name,
                   int val)
Parameters:
name -
val -
Returns:
See Also:
Query

setLocale

DBQuery setLocale(int position,
                  java.util.Locale locale)
Parameters:
position -
locale -
Returns:
See Also:
Query

setLocale

DBQuery setLocale(java.lang.String name,
                  java.util.Locale locale)
Parameters:
name -
locale -
Returns:
See Also:
Query

setLockMode

void setLockMode(java.lang.String alias,
                 org.hibernate.LockMode lockMode)
Parameters:
alias -
lockMode -
See Also:
Query

setLong

DBQuery setLong(int position,
                long val)
Parameters:
position -
val -
Returns:
See Also:
Query

setMaxResults

DBQuery setMaxResults(int maxResults)
Parameters:
maxResults -
Returns:
See Also:
Query

setParameter

DBQuery setParameter(int position,
                     java.lang.Object val,
                     org.hibernate.type.Type type)
Parameters:
position -
val -
type -
Returns:
See Also:
Query

setParameter

DBQuery setParameter(int position,
                     java.lang.Object val)
Parameters:
position -
val -
Returns:
See Also:
Query

setParameter

DBQuery setParameter(java.lang.String name,
                     java.lang.Object val,
                     org.hibernate.type.Type type)
Parameters:
name -
val -
type -
Returns:
See Also:
Query

setParameter

DBQuery setParameter(java.lang.String name,
                     java.lang.Object val)
Parameters:
name -
val -
Returns:
See Also:
Query

setParameterList

DBQuery setParameterList(java.lang.String name,
                         java.util.Collection vals,
                         org.hibernate.type.Type type)
Parameters:
name -
vals -
type -
Returns:
See Also:
Query

setParameterList

DBQuery setParameterList(java.lang.String name,
                         java.util.Collection vals)
Parameters:
name -
vals -
Returns:
See Also:
Query

setParameterList

DBQuery setParameterList(java.lang.String name,
                         java.lang.Object[] vals,
                         org.hibernate.type.Type type)
Parameters:
name -
vals -
type -
Returns:
See Also:
Query

setParameterList

DBQuery setParameterList(java.lang.String name,
                         java.lang.Object[] vals)
Parameters:
name -
vals -
Returns:
See Also:
Query

setProperties

DBQuery setProperties(java.lang.Object bean)
Parameters:
bean -
Returns:
See Also:
Query

setSerializable

DBQuery setSerializable(int position,
                        java.io.Serializable val)
Parameters:
position -
val -
Returns:
See Also:
Query

setSerializable

DBQuery setSerializable(java.lang.String name,
                        java.io.Serializable val)
Parameters:
name -
val -
Returns:
See Also:
Query

setShort

DBQuery setShort(int position,
                 short val)
Parameters:
position -
val -
Returns:
See Also:
Query

setShort

DBQuery setShort(java.lang.String name,
                 short val)
Parameters:
name -
val -
Returns:
See Also:
Query

setString

DBQuery setString(int position,
                  java.lang.String val)
Parameters:
position -
val -
Returns:
See Also:
Query

setText

DBQuery setText(int position,
                java.lang.String val)
Parameters:
position -
val -
Returns:
See Also:
Query

setText

DBQuery setText(java.lang.String name,
                java.lang.String val)
Parameters:
name -
val -
Returns:
See Also:
Query

setTime

DBQuery setTime(int position,
                java.util.Date date)
Parameters:
position -
date -
Returns:
See Also:
Query

setTimeout

DBQuery setTimeout(int timeout)
Parameters:
timeout -
Returns:
See Also:
Query

setTimestamp

DBQuery setTimestamp(int position,
                     java.util.Date date)
Parameters:
position -
date -
Returns:
See Also:
Query

setTimestamp

DBQuery setTimestamp(java.lang.String name,
                     java.util.Date date)
Parameters:
name -
date -
Returns:
See Also:
Query

uniqueResult

java.lang.Object uniqueResult()
Returns:
See Also:
Query
Overview  Package   Class  Use  Tree  Deprecated  Index  Help 
 PREV CLASS   NEXT CLASS FRAMES    NO FRAMES    
SUMMARY: NESTED | FIELD | CONSTR | METHOD DETAIL: FIELD | CONSTR | METHOD