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.sfm.jdbc.spring.JdbcTemplateCrud Maven / Gradle / Ivy
package org.sfm.jdbc.spring;
import org.sfm.jdbc.Crud;
import org.sfm.utils.RowHandler;
import org.springframework.dao.DataAccessException;
import org.springframework.jdbc.core.ConnectionCallback;
import org.springframework.jdbc.core.JdbcTemplate;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.Collection;
import java.util.List;
public class JdbcTemplateCrud {
private final JdbcTemplate jdbcTemplate;
private final Crud crud;
public JdbcTemplateCrud(JdbcTemplate jdbcTemplate, Crud crud) {
this.jdbcTemplate = jdbcTemplate;
this.crud = crud;
}
/**
* insert value into the db through the specified connection.
*
* @param value the value
* @throws SQLException if an error occurs
*/
public void create(final T value) throws SQLException {
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 SQLException if an error occurs
*/
public void create(final Collection values) throws SQLException {
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 SQLException
*/
public > RH create(final T value, final RH keyConsumer) throws SQLException {
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 SQLException
*/
public > RH create(final Collection values, final RH keyConsumer) throws SQLException {
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 SQLException if an error occurs
*/
public T read(final K key) throws SQLException {
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 rowHandler.
*
* @param keys the keys
* @param rowHandler the handler that is callback for each row
* @throws SQLException if an error occurs
*/
public > RH read(final Collection keys, final RH rowHandler) throws SQLException {
return
jdbcTemplate.execute(new ConnectionCallback() {
@Override
public RH doInConnection(Connection connection) throws SQLException, DataAccessException {
return crud.read(connection, keys, rowHandler);
}
});
}
/**
* update the object.
*
* @param value the object
* @throws SQLException if an error occurs
*/
public void update(final T value) throws SQLException {
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 SQLException if an error occurs
*/
public void update(final Collection values) throws SQLException {
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 SQLException if an error occurs
*/
public void delete(final K key) throws SQLException {
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 SQLException if an error occurs
*/
public void delete(final List keys) throws SQLException {
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 SQLException
* @throws UnsupportedOperationException
*/
public void createOrUpdate(final T value) throws SQLException {
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 SQLException
* @throws UnsupportedOperationException
*/
public void createOrUpdate(final Collection values) throws SQLException {
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 SQLException
*/
public > RH createOrUpdate(final T value, final RH keyConsumer) throws SQLException {
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 SQLException
*/
public > RH createOrUpdate(final Collection values, final RH keyConsumer) throws SQLException {
return jdbcTemplate.execute(new ConnectionCallback() {
@Override
public RH doInConnection(Connection connection) throws SQLException, DataAccessException {
return crud.createOrUpdate(connection, values, keyConsumer);
}
});
}
}
