All Downloads are FREE. Search and download functionalities are using the official Maven repository.
Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $
You can buy this project and download/modify it how often you want.
org.simpleflatmapper.jdbc.spring.JdbcTemplateCrud Maven / Gradle / Ivy
package org.simpleflatmapper.jdbc.spring;
import org.simpleflatmapper.jdbc.*;
import org.simpleflatmapper.util.CheckedConsumer;
import org.springframework.dao.DataAccessException;
import org.springframework.jdbc.core.ConnectionCallback;
import org.springframework.jdbc.core.JdbcOperations;
import java.lang.reflect.Type;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.Collection;
import java.util.List;
public class JdbcTemplateCrud {
private final JdbcOperations jdbcTemplate;
private final Crud crud;
public JdbcTemplateCrud(JdbcOperations jdbcOperations, Crud crud) {
this.jdbcTemplate = jdbcOperations;
this.crud = crud;
}
/**
* insert value into the db through the specified connection.
*
* @param value the value
* @throws DataAccessException if an error occurs
*/
public void create(final T value) throws DataAccessException {
jdbcTemplate.execute(new ConnectionCallback() {
@Override
public Object doInConnection(Connection connection) throws SQLException, DataAccessException {
crud.create(connection, value);
return null;
}
});
}
/**
* insert values into the db through the specified connection.
*
* @param values the values
* @throws DataAccessException if an error occurs
*/
public void create(final Collection values) throws DataAccessException {
jdbcTemplate.execute(new ConnectionCallback() {
@Override
public Object doInConnection(Connection connection) throws SQLException, DataAccessException {
crud.create(connection, values);
return null;
}
});
}
/**
* insert value into the db through the specified connection.
* Callback keyConsumer with the generated key if one was.
*
* @param value the value
* @param keyConsumer the key consumer
* @param the type of keyConsumer
* @return the keyConsumer
* @throws DataAccessException
*/
public > RH create(final T value, final RH keyConsumer) throws DataAccessException {
return
jdbcTemplate.execute(new ConnectionCallback() {
@Override
public RH doInConnection(Connection connection) throws SQLException, DataAccessException {
return crud.create(connection, value, keyConsumer);
}
});
}
/**
* insert values into the db through the specified connection.
* Callback keyConsumer for the generated keys.
*
* @param values the values
* @param keyConsumer the key consumer
* @param the type of keyConsumer
* @return the keyConsumer
* @throws DataAccessException
*/
public > RH create(final Collection values, final RH keyConsumer) throws DataAccessException {
return
jdbcTemplate.execute(new ConnectionCallback() {
@Override
public RH doInConnection(Connection connection) throws SQLException, DataAccessException {
return crud.create(connection, values, keyConsumer);
}
});
}
/**
* retrieve the object with the specified key.
*
* @param key the key
* @return the object or null if not found
* @throws DataAccessException if an error occurs
*/
public T read(final K key) throws DataAccessException {
return
jdbcTemplate.execute(new ConnectionCallback() {
@Override
public T doInConnection(Connection connection) throws SQLException, DataAccessException {
return crud.read(connection, key);
}
});
}
/**
* retrieve the objects with the specified keys and pass them to the consumer.
*
* @param keys the keys
* @param consumer the handler that is callback for each row
* @throws DataAccessException if an error occurs
*/
public > RH read(final Collection keys, final RH consumer) throws DataAccessException {
return
jdbcTemplate.execute(new ConnectionCallback() {
@Override
public RH doInConnection(Connection connection) throws SQLException, DataAccessException {
return crud.read(connection, keys, consumer);
}
});
}
/**
* update the object.
*
* @param value the object
* @throws DataAccessException if an error occurs
*/
public void update(final T value) throws DataAccessException {
jdbcTemplate.execute(new ConnectionCallback() {
@Override
public Object doInConnection(Connection connection) throws SQLException, DataAccessException {
crud.update(connection, value);
return null;
}
});
}
/**
* update the objects.
*
* @param values the objects
* @throws DataAccessException if an error occurs
*/
public void update(final Collection values) throws DataAccessException {
jdbcTemplate.execute(new ConnectionCallback() {
@Override
public Object doInConnection(Connection connection) throws SQLException, DataAccessException {
crud.update(connection, values);
return null;
}
});
}
/**
* delete the object with the specified key.
*
* @param key the key
* @throws DataAccessException if an error occurs
*/
public void delete(final K key) throws DataAccessException {
jdbcTemplate.execute(new ConnectionCallback() {
@Override
public Object doInConnection(Connection connection) throws SQLException, DataAccessException {
crud.delete(connection, key);
return null;
}
});
}
/**
* delete the objects with the specified keys.
*
* @param keys the keys
* @throws DataAccessException if an error occurs
*/
public void delete(final List keys) throws DataAccessException {
jdbcTemplate.execute(new ConnectionCallback() {
@Override
public Object doInConnection(Connection connection) throws SQLException, DataAccessException {
crud.delete(connection, keys);
return null;
}
});
}
/**
* UPSERT only supported on Mysql
* @param value the value
* @throws DataAccessException
* @throws UnsupportedOperationException
*/
public void createOrUpdate(final T value) throws DataAccessException {
jdbcTemplate.execute(new ConnectionCallback() {
@Override
public Object doInConnection(Connection connection) throws SQLException, DataAccessException {
crud.createOrUpdate(connection, value);
return null;
}
});
}
/**
* UPSERT only supported on Mysql
* @param values the values to upsert
* @throws DataAccessException
* @throws UnsupportedOperationException
*/
public void createOrUpdate(final Collection values) throws DataAccessException {
jdbcTemplate.execute(new ConnectionCallback() {
@Override
public Object doInConnection(Connection connection) throws SQLException, DataAccessException {
crud.createOrUpdate(connection, values);
return null;
}
});
}
/**
* UPSERT only supported on Mysql.
* Used the callback with caution has Mysql will return an incremented id event for when no insert actually occurred.
* @param value the value to upsert
* @param keyConsumer generated key consumer
* @param the keyConsumer type
* @return the keyConsumer
* @throws DataAccessException
*/
public > RH createOrUpdate(final T value, final RH keyConsumer) throws DataAccessException {
return jdbcTemplate.execute(new ConnectionCallback() {
@Override
public RH doInConnection(Connection connection) throws SQLException, DataAccessException {
return crud.createOrUpdate(connection, value, keyConsumer);
}
});
}
/**
* UPSERT only supported on Mysql.
* Used the callback with caution has Mysql will return an incremented id event for when no insert actually occurred.
* @param values the values to insert
* @param keyConsumer generated key consumer
* @param the keyConsumer type
* @return the keyConsumer
* @throws DataAccessException
*/
public > RH createOrUpdate(final Collection values, final RH keyConsumer) throws DataAccessException {
return jdbcTemplate.execute(new ConnectionCallback() {
@Override
public RH doInConnection(Connection connection) throws SQLException, DataAccessException {
return crud.createOrUpdate(connection, values, keyConsumer);
}
});
}
public ConnectedSelectQuery where(String whereClause, Type paramClass) {
SelectQuery selectQuery = crud.where(whereClause, paramClass);
return new ConnectedSelectQuery(selectQuery,
new JdbcTemplateTransactionTemplate(jdbcTemplate));
}
private static class JdbcTemplateTransactionTemplate implements TransactionTemplate {
private final JdbcOperations jdbcOperations;
private JdbcTemplateTransactionTemplate(JdbcOperations jdbcOperations) {
this.jdbcOperations = jdbcOperations;
}
@Override
public R doInTransaction(final SQLFunction sqlFunction) throws DataAccessException {
return jdbcOperations.execute(new ConnectionCallback() {
@Override
public R doInConnection(Connection con) throws SQLException, DataAccessException {
return sqlFunction.apply(con);
}
});
}
}
}
