com.viaoa.ds.jdbc.delegate

Class SelectDelegate

java.lang.Object

com.viaoa.ds.jdbc.delegate.SelectDelegate

public class SelectDelegate
extends Object

Manages Selects/Queries for JDBC datasource.

Author:

vvia

Constructor Summary

Constructors

Constructor and Description
SelectDelegate()

Method Summary

Modifier and Type	Method and Description
static int	count(OADataSourceJDBC ds, Class selectClass, Object whereObject, String propertyFromWhereObject, int max)
static int	count(OADataSourceJDBC ds, Class selectClass, Object whereObject, String extraWhere, Object[] args, String propertyFromWhereObject, int max)
static int	count(OADataSourceJDBC ds, Class clazz, String queryWhere, int max)
static int	count(OADataSourceJDBC ds, Class clazz, String queryWhere, Object[] params, int max)
static int	count(OADataSourceJDBC ds, Class clazz, String queryWhere, Object param, int max)
static int	countPassthru(OADataSourceJDBC ds, String query, int max)
static Object	execute(OADataSourceJDBC ds, String command)
static ArrayList<ManyToMany>	getManyToMany(OADataSourceJDBC ds, OALinkInfo linkInfo) 20180602 select Link table.
static byte[]	getPropertyBlobValue(OADataSourceJDBC ds, OAObject whereObject, String property)
static String	getSelectSQL(OADataSourceJDBC ds, QueryConverter qc, Class clazz, OAObject whereObject, String extraWhere, Object[] args, String propertyFromWhereObject, String queryOrder, int max, boolean bDirty)
static OADataSourceIterator	select(OADataSourceJDBC ds, Class clazz, OAObject whereObject, String extraWhere, Object[] params, String propertyFromWhereObject, String queryOrder, int max, boolean bDirty)
static OADataSourceIterator	select(OADataSourceJDBC ds, Class clazz, String queryWhere, Object[] params, String queryOrder, int max, boolean bDirty)
static OADataSourceIterator	selectObject(OADataSourceJDBC ds, Class clazz, OAObjectKey key, boolean bDirty)
static Iterator	selectPassthru(OADataSourceJDBC ds, Class clazz, String query, int max, boolean bDirty)
static OADataSourceIterator	selectPassthru(OADataSourceJDBC ds, Class clazz, String queryWhere, String queryOrder, int max, boolean bDirty) Note: queryWhere needs to begin with "FROM TABLENAME WHERE ..." queryOrder will be prefixed with "ORDER BY "

Methods inherited from class java.lang.Object

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

Constructor Detail

SelectDelegate

public SelectDelegate()

Method Detail

select

public static OADataSourceIterator select(OADataSourceJDBC ds,
                                          Class clazz,
                                          String queryWhere,
                                          Object[] params,
                                          String queryOrder,
                                          int max,
                                          boolean bDirty)

select

public static OADataSourceIterator select(OADataSourceJDBC ds,
                                          Class clazz,
                                          OAObject whereObject,
                                          String extraWhere,
                                          Object[] params,
                                          String propertyFromWhereObject,
                                          String queryOrder,
                                          int max,
                                          boolean bDirty)

selectObject

public static OADataSourceIterator selectObject(OADataSourceJDBC ds,
                                                Class clazz,
                                                OAObjectKey key,
                                                boolean bDirty)
                                         throws Exception

Throws:

Exception

getSelectSQL

public static String getSelectSQL(OADataSourceJDBC ds,
                                  QueryConverter qc,
                                  Class clazz,
                                  OAObject whereObject,
                                  String extraWhere,
                                  Object[] args,
                                  String propertyFromWhereObject,
                                  String queryOrder,
                                  int max,
                                  boolean bDirty)

selectPassthru

public static Iterator selectPassthru(OADataSourceJDBC ds,
                                      Class clazz,
                                      String query,
                                      int max,
                                      boolean bDirty)

selectPassthru

public static OADataSourceIterator selectPassthru(OADataSourceJDBC ds,
                                                  Class clazz,
                                                  String queryWhere,
                                                  String queryOrder,
                                                  int max,
                                                  boolean bDirty)

Note: queryWhere needs to begin with "FROM TABLENAME WHERE ..." queryOrder will be prefixed with "ORDER BY "

execute

public static Object execute(OADataSourceJDBC ds,
                             String command)

countPassthru

public static int countPassthru(OADataSourceJDBC ds,
                                String query,
                                int max)

count

public static int count(OADataSourceJDBC ds,
                        Class selectClass,
                        Object whereObject,
                        String propertyFromWhereObject,
                        int max)

count

public static int count(OADataSourceJDBC ds,
                        Class selectClass,
                        Object whereObject,
                        String extraWhere,
                        Object[] args,
                        String propertyFromWhereObject,
                        int max)

count

public static int count(OADataSourceJDBC ds,
                        Class clazz,
                        String queryWhere,
                        int max)

count

public static int count(OADataSourceJDBC ds,
                        Class clazz,
                        String queryWhere,
                        Object param,
                        int max)

count

public static int count(OADataSourceJDBC ds,
                        Class clazz,
                        String queryWhere,
                        Object[] params,
                        int max)

getPropertyBlobValue

public static byte[] getPropertyBlobValue(OADataSourceJDBC ds,
                                          OAObject whereObject,
                                          String property)
                                   throws Exception

Throws:

Exception

getManyToMany

public static ArrayList<ManyToMany> getManyToMany(OADataSourceJDBC ds,
                                                  OALinkInfo linkInfo)

20180602 select Link table.