| java.lang.Object
 org.w3c.tools.jdbc.JdbcBeanSerializer
| Method Summary | |
| public void | clean()
| | protected String | computeSQLCount(boolean all, boolean distinct, String properties)
| | protected String | computeSQLDelete()
| | protected String | computeSQLInsert()
Compute the SQL request necessary to update the Database. | | protected String | computeSQLSelect(String orderby, boolean asc, boolean all, String select, String properties)
| | protected String | computeSQLUpdate(String primarykeys)
| | public int | count()
Count the number or row with columns matching the value of the
bean properties. | | public int | count(String properties)
Count the number or row with columns matching the value of the
given properties. | | public int | count(boolean all)
Count the number or row with columns matching the value of the
bean properties. | | public int | count(boolean all, boolean distinct)
| | public int | count(boolean all, boolean distinct, String properties)
Count the number or row with columns matching the value of the
given properties. | | public boolean | delete()
Delete the row relative to the current bean. | | public JdbcBeanSerializer | except(JdbcBeanInterface ebean)
USE THIS METHOD ONLY BEFORE SELECT QUERIES. | | protected void | finalize()
Called by the Garbage Collector. | | public boolean | first()
| | protected JdbcServer | getJdbcServer()
| | public void | initBean()
Restore default value except for JdbcBean properties. | | public boolean | insert()
Insert the current bean values in the associated table. | | public JdbcBeanSerializer | intersect(JdbcBeanInterface ibean)
USE THIS METHOD ONLY BEFORE SELECT QUERIES. | | public boolean | isLast()
| | protected boolean | isModified()
| | protected void | markModified(boolean modified)
| | public boolean | next()
| | public void | propertyChange(PropertyChangeEvent evt)
PropertyChangeListener implementation: This method gets called when
a bound property is changed. | | public void | removeExceptBean()
| | public void | removeIntersectBean()
| | public void | removeUnionBean()
| | public void | select()
Perform a sql select to update the beans properties. | | public void | select(boolean all)
Perform a sql select to update the beans properties. | | public void | select(String orderby)
Perform a sql select to update the beans properties. | | public void | select(String orderby, boolean asc, boolean all)
Perform a sql select to update the beans properties. | | public void | select(String orderby, boolean asc, boolean all, boolean distinct)
Perform a sql select to update the beans properties. | | public void | select(String orderby)
Perform a sql select to update the beans properties. | | public void | select(String orderby, boolean asc, boolean all, boolean distinct)
Perform a sql select to update the beans properties. | | public void | select(String orderby, boolean asc, boolean all, boolean distinct, String toselect)
Perform a sql select to update the beans properties. | | public void | selectDistinct(String column)
Perform a sql select to update only the given columns. | | public JdbcBeanSerializer | union(JdbcBeanInterface ubean)
USE THIS METHOD ONLY BEFORE QUERIES. | | public boolean | update(String primarykey)
Update the row relative to our bean. | | public boolean | update(String primarykeys)
Update the row relative to our bean. | | public void | updateProperties(JdbcBeanInterface ubean)
Update our bean property with the given bean property
(must be an instance of the same class). |
| EXCEPT | | final protected static int EXCEPT(Code) | | |
| INTERSECT | | final protected static int INTERSECT(Code) | | |
| NOTHING | | final protected static int NOTHING(Code) | | INTERSECT, UNION, EXCEPT.
|
| UNION | | final protected static int UNION(Code) | | |
| priority | | protected int priority(Code) | | |
| JdbcBeanSerializer | | public JdbcBeanSerializer(JdbcBeanInterface bean)(Code) | | Constructor
Parameters:
bean - the JdbcBean to serialize |
| clean | | public void clean()(Code) | | Clean cached properties (relative to our bean)
|
| computeSQLCount | | protected String computeSQLCount(boolean all, boolean distinct, String properties)(Code) | | |
| computeSQLInsert | | protected String computeSQLInsert()(Code) | | Compute the SQL request necessary to update the Database.
a String |
| count | | public int count()(Code) | | Count the number or row with columns matching the value of the
bean properties.
an int |
| count | | public int count(String properties)(Code) | | Count the number or row with columns matching the value of the
given properties.
Parameters:
properties - The property names an int |
| count | | public int count(boolean all)(Code) | | Count the number or row with columns matching the value of the
bean properties.
Parameters:
all - (join with associated beans?) an int |
| count | | public int count(boolean all, boolean distinct)(Code) | | Count the number or row with columns matching the value of the
bean properties
Parameters:
all - (join with associated beans?)
Parameters:
distinct - (SELECT DISTINCT?) an int |
| count | | public int count(boolean all, boolean distinct, String properties)(Code) | | Count the number or row with columns matching the value of the
given properties.
Parameters:
all - (join with associated beans?)
Parameters:
distinct - (SELECT DISTINCT?)
Parameters:
properties - The property names an int |
| delete | | public boolean delete()(Code) | | Delete the row relative to the current bean.
false if the DELETE request failed. |
| except | | public JdbcBeanSerializer except(JdbcBeanInterface ebean)(Code) | | USE THIS METHOD ONLY BEFORE SELECT QUERIES.
This will produce a select query with an EXCEPT statement in it
using the values of the given bean.
Parameters:
ibean - the intersect bean |
| finalize | | protected void finalize() throws Throwable(Code) | | Called by the Garbage Collector.
|
| first | | public boolean first()(Code) | | Go to the first row
false if there is no first row |
| initBean | | public void initBean()(Code) | | Restore default value except for JdbcBean properties.
|
| insert | | public boolean insert()(Code) | | Insert the current bean values in the associated table.
false if the INSERT request failed. |
| intersect | | public JdbcBeanSerializer intersect(JdbcBeanInterface ibean)(Code) | | USE THIS METHOD ONLY BEFORE SELECT QUERIES.
This will produce a select query with an INTERSECT statement in it
using the values of the given bean.
Parameters:
ibean - the intersect bean |
| isLast | | public boolean isLast()(Code) | | Did we reached the last row?
true if the last row is reached |
| isModified | | protected boolean isModified()(Code) | | |
| markModified | | protected void markModified(boolean modified)(Code) | | |
| next | | public boolean next()(Code) | | Update our bean with the value of the next row
false if there is no more row |
| propertyChange | | public void propertyChange(PropertyChangeEvent evt)(Code) | | PropertyChangeListener implementation: This method gets called when
a bound property is changed.
Parameters:
evt - A PropertyChangeEvent object describing the event source and the property that has changed. |
| removeExceptBean | | public void removeExceptBean()(Code) | | Remove the except bean
|
| removeIntersectBean | | public void removeIntersectBean()(Code) | | Remove the intersect bean
|
| removeUnionBean | | public void removeUnionBean()(Code) | | Remove the union bean
|
| select | | public void select()(Code) | | Perform a sql select to update the beans properties.
|
| select | | public void select(boolean all)(Code) | | Perform a sql select to update the beans properties.
Parameters:
all - join with attached beans? (default is true) |
| select | | public void select(String orderby)(Code) | | Perform a sql select to update the beans properties.
Parameters:
orderby - orderby rule |
| select | | public void select(String orderby, boolean asc, boolean all)(Code) | | Perform a sql select to update the beans properties.
Parameters:
orderby - orderby rule
Parameters:
asc - boolean if true orderby is ASC if false it itDESC (relative to the orderby[] parameter)
Parameters:
all - join with attached beans? (default is true) |
| select | | public void select(String orderby, boolean asc, boolean all, boolean distinct)(Code) | | Perform a sql select to update the beans properties.
Parameters:
orderby - orderby rule
Parameters:
asc - boolean if true orderby is ASC if false it itDESC (relative to the orderby[] parameter)
Parameters:
all - join with attached beans? (default is true)
Parameters:
distinct - if true, result won't have duplicate row (default is false) |
| select | | public void select(String orderby)(Code) | | Perform a sql select to update the beans properties.
Parameters:
orderby - array of orderby rules (ASC by default) |
| select | | public void select(String orderby, boolean asc, boolean all, boolean distinct)(Code) | | Perform a sql select to update the beans properties.
Parameters:
orderby - array of orderby rules
Parameters:
asc - array of boolean if true orderby is ASC if false it itDESC (relative to the orderby[] parameter)
Parameters:
all - join with attached beans? (default is true)
Parameters:
distinct - if true, result won't have duplicate row (default is false) |
| select | | public void select(String orderby, boolean asc, boolean all, boolean distinct, String toselect)(Code) | | Perform a sql select to update the beans properties.
Parameters:
orderby - array of orderby rules
Parameters:
asc - array of boolean if true orderby is ASC if false it itDESC (relative to the orderby[] parameter)
Parameters:
all - join with attached beans? (default is true)
Parameters:
distinct - if true, result won't have duplicate row (default is
Parameters:
toselect - array of columns name to selectfalse) |
| selectDistinct | | public void selectDistinct(String column)(Code) | | Perform a sql select to update only the given columns. (distinct flag is
set as true.
Parameters:
column - the bean property to update |
| union | | public JdbcBeanSerializer union(JdbcBeanInterface ubean)(Code) | | USE THIS METHOD ONLY BEFORE QUERIES.
This will produce a select query with an UNION statement in it
using the values of the given bean.
Parameters:
ibean - the intersect bean |
| update | | public boolean update(String primarykey)(Code) | | Update the row relative to our bean.
Parameters:
primarykey - The primary key of the SQL table false if the UPDATE request failed. |
| update | | public boolean update(String primarykeys)(Code) | | Update the row relative to our bean.
Parameters:
primarykey - The primary key of the SQL table false if the UPDATE request failed. |
| updateProperties | | public void updateProperties(JdbcBeanInterface ubean)(Code) | | Update our bean property with the given bean property
(must be an instance of the same class).
Parameters:
ubean - the bean to get new properties |
|
|