org.simpleflatmapper.jdbc.spring

Class JdbcTemplateCrud<T,K>

java.lang.Object

org.simpleflatmapper.jdbc.spring.JdbcTemplateCrud<T,K>

public class JdbcTemplateCrud<T,K>
extends Object

Constructor Summary

Constructors

Constructor and Description
JdbcTemplateCrud(org.springframework.jdbc.core.JdbcOperations jdbcOperations, org.simpleflatmapper.jdbc.Crud<T,K> crud)

Method Summary

Modifier and Type	Method and Description
void	create(Collection<T> values) insert values into the db through the specified connection.
<RH extends org.simpleflatmapper.util.CheckedConsumer<? super K>> RH	create(Collection<T> values, RH keyConsumer) insert values into the db through the specified connection.
void	create(T value) insert value into the db through the specified connection.
<RH extends org.simpleflatmapper.util.CheckedConsumer<? super K>> RH	create(T value, RH keyConsumer) insert value into the db through the specified connection.
void	createOrUpdate(Collection<T> values) UPSERT only supported on Mysql
<RH extends org.simpleflatmapper.util.CheckedConsumer<? super K>> RH	createOrUpdate(Collection<T> values, RH keyConsumer) UPSERT only supported on Mysql.
void	createOrUpdate(T value) UPSERT only supported on Mysql
<RH extends org.simpleflatmapper.util.CheckedConsumer<? super K>> RH	createOrUpdate(T value, RH keyConsumer) UPSERT only supported on Mysql.
void	delete(K key) delete the object with the specified key.
void	delete(List<K> keys) delete the objects with the specified keys.
<RH extends org.simpleflatmapper.util.CheckedConsumer<? super T>> RH	read(Collection<K> keys, RH consumer) retrieve the objects with the specified keys and pass them to the consumer.
T	read(K key) retrieve the object with the specified key.
void	update(Collection<T> values) update the objects.
void	update(T value) update the object.
<P> org.simpleflatmapper.jdbc.ConnectedSelectQuery<T,P>	where(String whereClause, Type paramClass)

Methods inherited from class java.lang.Object

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

Constructor Detail

JdbcTemplateCrud

public JdbcTemplateCrud(org.springframework.jdbc.core.JdbcOperations jdbcOperations,
                        org.simpleflatmapper.jdbc.Crud<T,K> crud)

Method Detail

create

public void create(T value)
            throws org.springframework.dao.DataAccessException

insert value into the db through the specified connection.

Parameters:

value - the value

Throws:

org.springframework.dao.DataAccessException - if an error occurs

create

public void create(Collection<T> values)
            throws org.springframework.dao.DataAccessException

insert values into the db through the specified connection.

Parameters:

values - the values

Throws:

org.springframework.dao.DataAccessException - if an error occurs

create

public <RH extends org.simpleflatmapper.util.CheckedConsumer<? super K>> RH create(T value,
                                                                                   RH keyConsumer)
                                                                            throws org.springframework.dao.DataAccessException

insert value into the db through the specified connection. Callback keyConsumer with the generated key if one was.

Type Parameters:

RH - the type of keyConsumer

Parameters:

value - the value

keyConsumer - the key consumer

Returns:

the keyConsumer

Throws:

org.springframework.dao.DataAccessException

create

public <RH extends org.simpleflatmapper.util.CheckedConsumer<? super K>> RH create(Collection<T> values,
                                                                                   RH keyConsumer)
                                                                            throws org.springframework.dao.DataAccessException

insert values into the db through the specified connection. Callback keyConsumer for the generated keys.

Type Parameters:

RH - the type of keyConsumer

Parameters:

values - the values

keyConsumer - the key consumer

Returns:

the keyConsumer

Throws:

org.springframework.dao.DataAccessException

read

public T read(K key)
       throws org.springframework.dao.DataAccessException

retrieve the object with the specified key.

Parameters:

key - the key

Returns:

the object or null if not found

Throws:

org.springframework.dao.DataAccessException - if an error occurs

read

public <RH extends org.simpleflatmapper.util.CheckedConsumer<? super T>> RH read(Collection<K> keys,
                                                                                 RH consumer)
                                                                          throws org.springframework.dao.DataAccessException

retrieve the objects with the specified keys and pass them to the consumer.

Parameters:

keys - the keys

consumer - the handler that is callback for each row

Throws:

org.springframework.dao.DataAccessException - if an error occurs

update

public void update(T value)
            throws org.springframework.dao.DataAccessException

update the object.

Parameters:

value - the object

Throws:

org.springframework.dao.DataAccessException - if an error occurs

update

public void update(Collection<T> values)
            throws org.springframework.dao.DataAccessException

update the objects.

Parameters:

values - the objects

Throws:

org.springframework.dao.DataAccessException - if an error occurs

delete

public void delete(K key)
            throws org.springframework.dao.DataAccessException

delete the object with the specified key.

Parameters:

key - the key

Throws:

org.springframework.dao.DataAccessException - if an error occurs

delete

public void delete(List<K> keys)
            throws org.springframework.dao.DataAccessException

delete the objects with the specified keys.

Parameters:

keys - the keys

Throws:

org.springframework.dao.DataAccessException - if an error occurs

createOrUpdate

public void createOrUpdate(T value)
                    throws org.springframework.dao.DataAccessException

UPSERT only supported on Mysql

Parameters:

value - the value

Throws:

org.springframework.dao.DataAccessException

UnsupportedOperationException

createOrUpdate

public void createOrUpdate(Collection<T> values)
                    throws org.springframework.dao.DataAccessException

UPSERT only supported on Mysql

Parameters:

values - the values to upsert

Throws:

org.springframework.dao.DataAccessException

UnsupportedOperationException

createOrUpdate

public <RH extends org.simpleflatmapper.util.CheckedConsumer<? super K>> RH createOrUpdate(T value,
                                                                                           RH keyConsumer)
                                                                                    throws org.springframework.dao.DataAccessException

UPSERT only supported on Mysql. Used the callback with caution has Mysql will return an incremented id event for when no insert actually occurred.

Type Parameters:

RH - the keyConsumer type

Parameters:

value - the value to upsert

keyConsumer - generated key consumer

Returns:

the keyConsumer

Throws:

org.springframework.dao.DataAccessException

createOrUpdate

public <RH extends org.simpleflatmapper.util.CheckedConsumer<? super K>> RH createOrUpdate(Collection<T> values,
                                                                                           RH keyConsumer)
                                                                                    throws org.springframework.dao.DataAccessException

UPSERT only supported on Mysql. Used the callback with caution has Mysql will return an incremented id event for when no insert actually occurred.

Type Parameters:

RH - the keyConsumer type

Parameters:

values - the values to insert

keyConsumer - generated key consumer

Returns:

the keyConsumer

Throws:

org.springframework.dao.DataAccessException

where

public <P> org.simpleflatmapper.jdbc.ConnectedSelectQuery<T,P> where(String whereClause,
                                                                     Type paramClass)