edu.internet2.middleware.grouper.hibernate
Class BySqlStatic

java.lang.Object
  edu.internet2.middleware.grouper.hibernate.BySqlStatic

public class BySqlStatic
extends java.lang.Object

for simple HQL, use this instead of inverse of control. this will do proper error handling and descriptive exception handling. This will by default use the transaction modes GrouperTransactionType.READONLY_OR_USE_EXISTING, and GrouperTransactionType.READ_WRITE_OR_USE_EXISTING depending on if a transaction is needed.

Author:

mchyzer

Method Summary

static void	attachParams(java.sql.PreparedStatement statement, java.lang.Object params) Attach params for a prepared statement.
static void	attachParams(java.sql.PreparedStatement statement, java.lang.Object params, java.lang.Object types) Attach params for a prepared statement.
int	executeSql(java.lang.String sql) execute some sql
int	executeSql(java.lang.String sql, java.util.List<java.lang.Object> params) execute some sql
<T> java.util.List<T>	listSelect(java.lang.Class<T> returnClassType, java.lang.String sql, java.util.List<java.lang.Object> params) select one object from sql (one row, one col
<T> java.util.List<T>	listSelectHiberateMapped(java.lang.Class<T> returnClassType, java.lang.String query, java.util.List<java.lang.Object> params) select one object from sql (one row, one col
<T> T	select(java.lang.Class<T> returnClassType, java.lang.String sql) select one object from sql (one row, one col
<T> T	select(java.lang.Class<T> returnClassType, java.lang.String sql, java.util.List<java.lang.Object> params) select one object from sql (one row, one col

Methods inherited from class java.lang.Object

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

Method Detail

executeSql

public int executeSql(java.lang.String sql)

execute some sql

Parameters:

sql - can be insert, update, delete, or ddl

Returns:

the number of rows affected or 0 for ddl

executeSql

public int executeSql(java.lang.String sql,
                      java.util.List<java.lang.Object> params)

execute some sql

Parameters:

sql - can be insert, update, delete, or ddl

params - prepared statement params

Returns:

the number of rows affected or 0 for ddl

select

public <T> T select(java.lang.Class<T> returnClassType,
                    java.lang.String sql)

select one object from sql (one row, one col

Type Parameters:

T - the type

Parameters:

returnClassType - type to be returned (currnetly supports string and int

sql - can be insert, update, delete, or ddl

Returns:

the number of rows affected or 0 for ddl

select

public <T> T select(java.lang.Class<T> returnClassType,
                    java.lang.String sql,
                    java.util.List<java.lang.Object> params)

select one object from sql (one row, one col

Type Parameters:

T - the type

Parameters:

returnClassType - type to be returned (currnetly supports string and int

sql - can be insert, update, delete, or ddl

params - prepared statement params

Returns:

the number of rows affected or 0 for ddl

listSelectHiberateMapped

public <T> java.util.List<T> listSelectHiberateMapped(java.lang.Class<T> returnClassType,
                                                      java.lang.String query,
                                                      java.util.List<java.lang.Object> params)

select one object from sql (one row, one col

Type Parameters:

T - the type

Parameters:

returnClassType - type to be returned (currnetly supports string and int

sql - can be insert, update, delete, or ddl

params - prepared statement params

Returns:

the number of rows affected or 0 for ddl

listSelect

public <T> java.util.List<T> listSelect(java.lang.Class<T> returnClassType,
                                        java.lang.String sql,
                                        java.util.List<java.lang.Object> params)

select one object from sql (one row, one col

Type Parameters:

T - the type

Parameters:

returnClassType - type to be returned (currnetly supports string and int

sql - can be insert, update, delete, or ddl

params - prepared statement params

Returns:

the number of rows affected or 0 for ddl

attachParams

public static void attachParams(java.sql.PreparedStatement statement,
                                java.lang.Object params)
                         throws org.hibernate.HibernateException,
                                java.sql.SQLException

Attach params for a prepared statement. The type of the params and types must be the same (e.g. either both array or list, but not one is Array, and the other list

Parameters:

statement -

params - either null, Object, Object[], or List of Objects

Throws:

org.hibernate.HibernateException

java.sql.SQLException

attachParams

public static void attachParams(java.sql.PreparedStatement statement,
                                java.lang.Object params,
                                java.lang.Object types)
                         throws org.hibernate.HibernateException,
                                java.sql.SQLException

Attach params for a prepared statement. The type of the params and types must be the same (e.g. either both array or list, but not one is Array, and the other list

Parameters:

statement -

params - either null, Object, Object[], or List of Objects

types - either null, Type, Type[], or List of Objects

Throws:

org.hibernate.HibernateException

java.sql.SQLException