e4s.db.systabledef
Class T_E4S_QUERY_Obj

java.lang.Object
  e4s.util.E4Object
      e4s.db.systabledef.T_E4S_QUERY_Obj

public class T_E4S_QUERY_Obj
extends E4Object

Data access object for T_E4S_QUERY created: 20060328 142853 modified: 20071109 130448 Predefines a SQL statement that can be used as dynamic user query/report.

See Also:

T_E4S_QUERY_Sel, T_E4S_QUERY_Mod

Field Summary

protected java.lang.String	m_CLIENTS Current Value - will be initialized after reading but can be changed using set_CLIENTS(String).
protected java.util.Date	m_DATMOD Current Value - will be initialized after reading but can be changed using set_DATMOD(Date).
protected java.util.Date	m_DATNEW Current Value - will be initialized after reading but can be changed using set_DATNEW(Date).
protected long	m_ID Current Value - will be initialized after reading but can be changed using #set_ID(long).
protected long	m_init_ID Initial Value - will be initialized only and is used on executeDelete() or executeUpdate().
protected java.lang.String	m_REM Current Value - will be initialized after reading but can be changed using set_REM(String).
protected java.lang.String	m_SQL_QUERY Current Value - will be initialized after reading but can be changed using set_SQL_QUERY(String).
protected java.lang.String	m_TITLE Current Value - will be initialized after reading but can be changed using set_TITLE(String).

Fields inherited from class e4s.util.E4Object

CRLF, E4S_CORE_SYSTEM_LANGUAGE, NBSP, NULLSTR, URL_ENCODING_CHARSET

Constructor Summary

T_E4S_QUERY_Obj()

Method Summary

static java.lang.String	_getSVNVersionString() Return the version info patched by CVS.
void	executeDelete() Delete this record, based on a query of first unique index
void	executeDelete(E4DBConnection_Intf con) Delete this record, based on a query of first unique index
long	executeInsert()
long	executeInsert(E4DBConnection_Intf con)
void	executeUpdate() Update this record, based on a query of first unique index columns.
void	executeUpdate(E4DBConnection_Intf con) Update this record, based on a query of first unique index
java.lang.String	get_CLIENTS()
java.util.Calendar	get_DATMOD_C()
java.util.Date	get_DATMOD()
java.util.Calendar	get_DATNEW_C()
java.util.Date	get_DATNEW()
long	get_ID()
java.lang.String	get_REM()
java.lang.String	get_SQL_QUERY()
java.lang.String	get_TITLE()
E4DBTableName	getTableName()
void	set_CLIENTS(java.lang.String val)
void	set_DATMOD()
void	set_DATMOD(java.util.Calendar val)
void	set_DATMOD(java.util.Date val)
void	set_DATMOD(E4Date val)
void	set_DATNEW()
void	set_DATNEW(java.util.Calendar val)
void	set_DATNEW(java.util.Date val)
void	set_DATNEW(E4Date val)
void	set_init_ID(long val)
void	set_REM(java.lang.String val)
void	set_SQL_QUERY(java.lang.String val)
void	set_TITLE(java.lang.String val)
E4DBColumnInfo[]	unequalsColumns(T_E4S_QUERY_Obj obj2)

Methods inherited from class e4s.util.E4Object

Calendar, CName, CName, E4LabelApp, E4LabelApp, E4LabelApp, E4LabelApp, E4LabelApp, E4LabelApp, E4LabelNone, E4LabelNone, E4LabelNone, E4LabelNone, E4LabelSys, E4LabelSys, e4sCopyright, e4sVersion, encode, encode, encode, encodeHtml, encodeHtml, encodeHtml, encodeURL, encodeURL, encodeURL, finalize, getLINE, getTRACE, getTRACE, getTRACE, getTRACE, getTRACE, getTRACE, getTraceMemory, HtmlEncode, HtmlEncode, HtmlEncode, isdecimal, isdigit, isnotok, isnotok, isnumeric, isok, isok, isok, isok, lastCallingFunction, lastCallingFunction, lastCallingFunction, lastCallingFunction, lastCallingStack, mkdirs, null2nbsp, null2nbsp, null2nbsp, ok, ok, ok, ok, outPrintln, setLogFile4Trace, setTraceMemory, STACKTRACE, toDebug, toDouble, toFloat, toFloat, toString, TRACE_CALLS, TRACE, TRACE, TRACE, TRACE, TRACE, TRACE, TRACE, TRACE, TRACE, TRACE, TRACE, TRACE, wait

Methods inherited from class java.lang.Object

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

Field Detail

m_CLIENTS

protected java.lang.String m_CLIENTS

Current Value - will be initialized after reading but can be changed using set_CLIENTS(String). List of clients (empty means all)

m_DATMOD

protected java.util.Date m_DATMOD

Current Value - will be initialized after reading but can be changed using set_DATMOD(Date). Date modified

m_DATNEW

protected java.util.Date m_DATNEW

Current Value - will be initialized after reading but can be changed using set_DATNEW(Date). Date created

m_ID

protected long m_ID

Current Value - will be initialized after reading but can be changed using #set_ID(long). ID

m_init_ID

protected long m_init_ID

Initial Value - will be initialized only and is used on executeDelete() or executeUpdate(). ID

m_REM

protected java.lang.String m_REM

Current Value - will be initialized after reading but can be changed using set_REM(String). Remark

m_SQL_QUERY

protected java.lang.String m_SQL_QUERY

Current Value - will be initialized after reading but can be changed using set_SQL_QUERY(String). SQL Query statement

m_TITLE

protected java.lang.String m_TITLE

Current Value - will be initialized after reading but can be changed using set_TITLE(String). Title

Constructor Detail

T_E4S_QUERY_Obj

public T_E4S_QUERY_Obj()

Method Detail

executeInsert

public long executeInsert()
                   throws E4DBException

Throws:

E4DBException

executeInsert

public long executeInsert(E4DBConnection_Intf con)
                   throws E4DBException

Throws:

E4DBException

getTableName

public E4DBTableName getTableName()

set_CLIENTS

public void set_CLIENTS(java.lang.String val)

get_CLIENTS

public java.lang.String get_CLIENTS()

set_DATMOD

public void set_DATMOD(java.util.Date val)

set_DATMOD

public void set_DATMOD(java.util.Calendar val)

set_DATMOD

public void set_DATMOD(E4Date val)

set_DATMOD

public void set_DATMOD()

get_DATMOD

public java.util.Date get_DATMOD()

get_DATMOD_C

public java.util.Calendar get_DATMOD_C()

set_DATNEW

public void set_DATNEW(java.util.Date val)

set_DATNEW

public void set_DATNEW(java.util.Calendar val)

set_DATNEW

public void set_DATNEW(E4Date val)

set_DATNEW

public void set_DATNEW()

get_DATNEW

public java.util.Date get_DATNEW()

get_DATNEW_C

public java.util.Calendar get_DATNEW_C()

set_init_ID

public void set_init_ID(long val)

get_ID

public long get_ID()

set_REM

public void set_REM(java.lang.String val)

get_REM

public java.lang.String get_REM()

set_SQL_QUERY

public void set_SQL_QUERY(java.lang.String val)

get_SQL_QUERY

public java.lang.String get_SQL_QUERY()

set_TITLE

public void set_TITLE(java.lang.String val)

get_TITLE

public java.lang.String get_TITLE()

unequalsColumns

public E4DBColumnInfo[] unequalsColumns(T_E4S_QUERY_Obj obj2)

executeDelete

public void executeDelete()
                   throws E4DBException

Delete this record, based on a query of first unique index

Throws:

E4DBException

executeDelete

public void executeDelete(E4DBConnection_Intf con)
                   throws E4DBException

Delete this record, based on a query of first unique index

Throws:

E4DBException

executeUpdate

public void executeUpdate()
                   throws E4DBException

Update this record, based on a query of first unique index columns.

Throws:

E4DBException

executeUpdate

public void executeUpdate(E4DBConnection_Intf con)
                   throws E4DBException

Update this record, based on a query of first unique index

Throws:

E4DBException

_getSVNVersionString

public static java.lang.String _getSVNVersionString()

Return the version info patched by CVS.