com.ds.fw.database
Class FwDBObject

java.lang.Object
  |
  +--com.ds.fw.types.FwSimpleObject
        |
        +--com.ds.fw.database.FwDBObject

All Implemented Interfaces:

java.lang.Cloneable, FwCopyableIF, FwDisplayableIF, FwSimpleObjectIF, java.io.Serializable

public class FwDBObject

extends FwSimpleObject

See Also:

Serialized Form

Field Summary

static java.lang.String	DATE_FORMAT
com.ds.fw.types.FwHashVector	hObjectData Contains the table data
int	idField The field id
static java.lang.String	TIME_FORMAT

Constructor Summary

FwDBObject()
The constructor

Method Summary

void	clear() Clear the FwHashVector hDBData
int	delete() Deletes rows from the table by given field id .
int	deleteByID(long gID) Deletes rows from the table by given field id .
static java.lang.String	encodeSQL(java.lang.String s)
void	finalize()
java.lang.String	formatDate(java.util.Date d)
java.lang.String	formatDateTime(java.util.Date da)
com.ds.fw.database.FwDBObject[]	get(com.ds.fw.beans.FwBaseBean aBean)
com.ds.fw.database.FwDBObject	get(long gID) Fills the data table hObjectData with data.
com.ds.fw.database.FwDBObject	get(java.lang.Object gID)
com.ds.fw.database.FwDBObject[]	get(java.lang.String whereC)
com.ds.fw.database.FwDBObject[]	get(java.lang.String whereC, java.lang.String orderC, java.lang.String groupC)
com.ds.fw.database.FwDBObject[]	get(java.lang.String whereC, java.lang.String orderC, java.lang.String groupC, java.lang.String selectC)
com.ds.fw.beans.FwBaseBean	get1(java.lang.String whereC, java.lang.String orderC, java.lang.String groupC)
com.ds.fw.beans.FwBaseBean	get1(java.lang.String whereC, java.lang.String orderC, java.lang.String groupC, java.lang.String selectC)
com.ds.fw.dbcon.FwDBConnManager	getConnection()
java.lang.String	getDataBase()
java.util.Date	getDataFrom(java.lang.Object o)
void	getDataFromBean(com.ds.fw.beans.FwBaseBean aBean, int row)
java.lang.Object	getDefautId() Gets the default id
java.lang.Object	getF(java.lang.String key)
com.ds.fw.database.FwDBField	getField(com.ds.fw.database.FwDBFieldInfo fi) Gets a field by its name
com.ds.fw.database.FwDBField	getField(int i) Gets a field by its number
com.ds.fw.database.FwDBField	getField(java.lang.String key) Gets a field by its name
com.ds.fw.database.FwDBField	getIDField() Gets the default field
int	getNBFields() Gets the number of the fields
com.ds.fw.types.FwHashVector	getObjectData() Return the table data
java.util.Vector	getTables()
java.lang.String	getTField(java.lang.String fname)
java.lang.String	getTField(java.lang.String pfield, java.lang.String table) Gets the field name with the table pseudonim for the SQL query.
long	insert()
long	insert(boolean fixID) Inserts a row .
void	setCloneObjectData(com.ds.fw.types.FwHashVector h) Sets the table data
void	setConnection(com.ds.fw.dbcon.FwDBConnManager c)
void	setDataBase(java.lang.String n)
void	setDateFormat()
void	setDateFormat(com.ds.fw.dbcon.FwDBConnManager conn)
void	setF(java.lang.String key, java.lang.Object o)
void	setField(com.ds.fw.database.FwDBField data) Sets a field
void	setField(com.ds.fw.database.FwDBFieldInfo info, java.lang.Object o) Sets a field
void	setField(java.lang.String fieldName, com.ds.fw.database.FwDBBaseTable table, java.lang.Object o)
void	setField(java.lang.String key, com.ds.fw.database.FwDBField data) Sets a field
void	setField(java.lang.String fieldKeyName, java.lang.String fieldName, com.ds.fw.database.FwDBBaseTable table, java.lang.Object o)
void	setField(java.lang.String fieldName, java.lang.String descr, int type, com.ds.fw.database.FwDBBaseTable table, java.lang.Object o, java.lang.Object o1)
void	setField(java.lang.String fieldKeyName, java.lang.String fieldName, java.lang.String descr, int type, com.ds.fw.database.FwDBBaseTable table, java.lang.Object o, java.lang.Object o1)
void	setFromDBObject(com.ds.fw.database.FwDBObject o)
void	setMetaData() Empty method .
void	setObjectData(com.ds.fw.types.FwHashVector h) Sets the table data
java.lang.String	toDate(java.util.Date d)
java.lang.String	toDateTime(java.util.Date d)
int	update()
void	updateDataGet() Empty method .
void	updateDataSet() Empty method .
int	updateID(java.lang.Object oID) Update a row .

Methods inherited from class com.ds.fw.types.FwSimpleObject

getClassName, getClone, getCopy, getCopy, getDeepCopy, getDisplayString, getDisplayStringFor, postCopy, printStackTrace, toString, toStringValue

Methods inherited from class java.lang.Object

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

Field Detail

hObjectData

public com.ds.fw.types.FwHashVector hObjectData

Contains the table data

idField

public int idField

The field id

DATE_FORMAT

public static java.lang.String DATE_FORMAT

TIME_FORMAT

public static java.lang.String TIME_FORMAT

Constructor Detail

FwDBObject

public FwDBObject()

The constructor

Method Detail

setFromDBObject

public void setFromDBObject(com.ds.fw.database.FwDBObject o)

getField

public com.ds.fw.database.FwDBField getField(java.lang.String key)

Gets a field by its name

Parameters:

key - - the field name

Returns:

FwDBField object containing the requested field, null if the key is not mapped to any value in the data table.

getField

public com.ds.fw.database.FwDBField getField(com.ds.fw.database.FwDBFieldInfo fi)

Gets a field by its name

Parameters:

fi - - the FwDBFieldInfo

Returns:

FwDBField object containing the requested field, null if the key is not mapped to any value in the data table.

getField

public com.ds.fw.database.FwDBField getField(int i)

Gets a field by its number

Parameters:

i - index of element to return.

Returns:

the field (as FwDBField object) at the specified position in the data table.

setField

public void setField(java.lang.String key,
                     com.ds.fw.database.FwDBField data)

Sets a field

Parameters:

key - - the key for this field

data - - the field data

setField

public void setField(com.ds.fw.database.FwDBField data)

Sets a field

Parameters:

data - - the field data

setField

public void setField(com.ds.fw.database.FwDBFieldInfo info,
                     java.lang.Object o)

Sets a field

setField

public void setField(java.lang.String fieldKeyName,
                     java.lang.String fieldName,
                     java.lang.String descr,
                     int type,
                     com.ds.fw.database.FwDBBaseTable table,
                     java.lang.Object o,
                     java.lang.Object o1)

setField

public void setField(java.lang.String fieldName,
                     java.lang.String descr,
                     int type,
                     com.ds.fw.database.FwDBBaseTable table,
                     java.lang.Object o,
                     java.lang.Object o1)

setField

public void setField(java.lang.String fieldName,
                     com.ds.fw.database.FwDBBaseTable table,
                     java.lang.Object o)

setField

public void setField(java.lang.String fieldKeyName,
                     java.lang.String fieldName,
                     com.ds.fw.database.FwDBBaseTable table,
                     java.lang.Object o)

getObjectData

public com.ds.fw.types.FwHashVector getObjectData()

Return the table data

Returns:

the table data

setObjectData

public void setObjectData(com.ds.fw.types.FwHashVector h)

Sets the table data

Parameters:

h - - the new data

setCloneObjectData

public void setCloneObjectData(com.ds.fw.types.FwHashVector h)

Sets the table data

Parameters:

h - - the new data

getNBFields

public int getNBFields()

Gets the number of the fields

Returns:

the number of the fields

clear

public void clear()

Clear the FwHashVector hDBData

getF

public java.lang.Object getF(java.lang.String key)

setF

public void setF(java.lang.String key,
                 java.lang.Object o)

setMetaData

public void setMetaData()

Empty method . Class must be extended and this method must be override before use.

updateDataGet

public void updateDataGet()

Empty method . Class must be extended and this method must be override before use.

updateDataSet

public void updateDataSet()

Empty method . Class must be extended and this method must be override before use.

getIDField

public com.ds.fw.database.FwDBField getIDField()

Gets the default field

Returns:

the default field

getDefautId

public java.lang.Object getDefautId()
                             throws java.sql.SQLException

Gets the default id

Returns:

the id for the default field (as BigDecimal), null if there was some exception , during the execution of the sql request

java.sql.SQLException

getTables

public java.util.Vector getTables()

insert

public long insert(boolean fixID)
            throws java.sql.SQLException

Inserts a row . Calls method updateDataGet.

Parameters:

fixID - - if true insert a row with a given id , if false - with default id

Returns:

1 if there is a row inserted in the database , 0 - if the row cannot be inserted (there was some error during the execution).

java.sql.SQLException

See Also:

updateDataGet()

insert

public long insert()
            throws java.sql.SQLException

java.sql.SQLException

updateID

public int updateID(java.lang.Object oID)
             throws java.sql.SQLException

Update a row . Calls method updateDataGet()

Returns:

0 if there was a problem during the execution of the query (or it was successful, but no rows were updated) and the number of the updated rows otherwise.

java.sql.SQLException

See Also:

updateDataGet()

update

public int update()
           throws java.sql.SQLException

java.sql.SQLException

get

public com.ds.fw.database.FwDBObject get(long gID)
                                  throws java.sql.SQLException

Fills the data table hObjectData with data. Calls methods updateDataGet() and updateDataSet().

Parameters:

gID -

Returns:

the number of the elements returned by the sql query .

java.sql.SQLException

See Also:

updateDataGet(), updateDataSet()

get

public com.ds.fw.database.FwDBObject get(java.lang.Object gID)
                                  throws java.sql.SQLException

java.sql.SQLException

get

public com.ds.fw.database.FwDBObject[] get(java.lang.String whereC)
                                    throws java.sql.SQLException

java.sql.SQLException

get

public com.ds.fw.database.FwDBObject[] get(java.lang.String whereC,
                                           java.lang.String orderC,
                                           java.lang.String groupC)
                                    throws java.sql.SQLException

java.sql.SQLException

get

public com.ds.fw.database.FwDBObject[] get(java.lang.String whereC,
                                           java.lang.String orderC,
                                           java.lang.String groupC,
                                           java.lang.String selectC)
                                    throws java.sql.SQLException

java.sql.SQLException

get

public com.ds.fw.database.FwDBObject[] get(com.ds.fw.beans.FwBaseBean aBean)
                                    throws java.sql.SQLException

java.sql.SQLException

getDataFromBean

public void getDataFromBean(com.ds.fw.beans.FwBaseBean aBean,
                            int row)

get1

public com.ds.fw.beans.FwBaseBean get1(java.lang.String whereC,
                                       java.lang.String orderC,
                                       java.lang.String groupC)
                                throws java.sql.SQLException

java.sql.SQLException

get1

public com.ds.fw.beans.FwBaseBean get1(java.lang.String whereC,
                                       java.lang.String orderC,
                                       java.lang.String groupC,
                                       java.lang.String selectC)
                                throws java.sql.SQLException

java.sql.SQLException

delete

public int delete()
           throws java.sql.SQLException

Deletes rows from the table by given field id .

Returns:

the number of the row deleted

java.sql.SQLException

deleteByID

public int deleteByID(long gID)
               throws java.sql.SQLException

Deletes rows from the table by given field id .

Parameters:

gID - - the field id for the where clause of the sql query

Returns:

the number of the row deleted

java.sql.SQLException

getTField

public java.lang.String getTField(java.lang.String fname)

getTField

public java.lang.String getTField(java.lang.String pfield,
                                  java.lang.String table)

Gets the field name with the table pseudonim for the SQL query. (i.e. 'a.field')

Parameters:

table - the table name

Returns:

the table pseudonim and the field name

setDateFormat

public void setDateFormat()
                   throws java.sql.SQLException

java.sql.SQLException

setDateFormat

public void setDateFormat(com.ds.fw.dbcon.FwDBConnManager conn)
                   throws java.sql.SQLException

java.sql.SQLException

formatDate

public java.lang.String formatDate(java.util.Date d)

getDataFrom

public java.util.Date getDataFrom(java.lang.Object o)

toDate

public java.lang.String toDate(java.util.Date d)
                        throws java.sql.SQLException

java.sql.SQLException

formatDateTime

public java.lang.String formatDateTime(java.util.Date da)

toDateTime

public java.lang.String toDateTime(java.util.Date d)
                            throws java.sql.SQLException

java.sql.SQLException

setConnection

public void setConnection(com.ds.fw.dbcon.FwDBConnManager c)
                   throws java.sql.SQLException

java.sql.SQLException

getConnection

public com.ds.fw.dbcon.FwDBConnManager getConnection()
                                              throws java.sql.SQLException

java.sql.SQLException

finalize

public void finalize()

Overrides:

finalize in class java.lang.Object

encodeSQL

public static java.lang.String encodeSQL(java.lang.String s)

getDataBase

public java.lang.String getDataBase()

setDataBase

public void setDataBase(java.lang.String n)