/** Deletes a single row in the producto table. */
public void delete(ProductoPk pk) throws ProductoDaoException {
long t1 = System.currentTimeMillis();
// declare variables
final boolean isConnSupplied = (userConn != null);
Connection conn = null;
PreparedStatement stmt = null;
try {
// get the user-specified connection or get a connection from the ResourceManager
conn = isConnSupplied ? userConn : ResourceManager.getConnection();
if (logger.isDebugEnabled()) {
logger.debug("Executing " + SQL_DELETE + " with PK: " + pk);
}
stmt = conn.prepareStatement(SQL_DELETE);
stmt.setString(1, pk.getIdProducto());
int rows = stmt.executeUpdate();
long t2 = System.currentTimeMillis();
if (logger.isDebugEnabled()) {
logger.debug(rows + " rows affected (" + (t2 - t1) + " ms)");
}
} catch (Exception _e) {
logger.error("Exception: " + _e.getMessage(), _e);
throw new ProductoDaoException("Exception: " + _e.getMessage(), _e);
} finally {
ResourceManager.close(stmt);
if (!isConnSupplied) {
ResourceManager.close(conn);
}
}
}
/** Returns all rows from the producto table that match the specified arbitrary SQL statement */
public Producto[] findByDynamicSelect(String sql, Object[] sqlParams)
throws ProductoDaoException {
// declare variables
final boolean isConnSupplied = (userConn != null);
Connection conn = null;
PreparedStatement stmt = null;
ResultSet rs = null;
try {
// get the user-specified connection or get a connection from the ResourceManager
conn = isConnSupplied ? userConn : ResourceManager.getConnection();
// construct the SQL statement
final String SQL = sql;
if (logger.isDebugEnabled()) {
logger.debug("Executing " + SQL);
}
// prepare statement
stmt = conn.prepareStatement(SQL);
stmt.setMaxRows(maxRows);
// bind parameters
for (int i = 0; sqlParams != null && i < sqlParams.length; i++) {
stmt.setObject(i + 1, sqlParams[i]);
}
rs = stmt.executeQuery();
// fetch the results
return fetchMultiResults(rs);
} catch (Exception _e) {
logger.error("Exception: " + _e.getMessage(), _e);
throw new ProductoDaoException("Exception: " + _e.getMessage(), _e);
} finally {
ResourceManager.close(rs);
ResourceManager.close(stmt);
if (!isConnSupplied) {
ResourceManager.close(conn);
}
}
}
/** Updates a single row in the producto table. */
public void update(ProductoPk pk, Producto dto) throws ProductoDaoException {
long t1 = System.currentTimeMillis();
// declare variables
final boolean isConnSupplied = (userConn != null);
Connection conn = null;
PreparedStatement stmt = null;
try {
// get the user-specified connection or get a connection from the ResourceManager
conn = isConnSupplied ? userConn : ResourceManager.getConnection();
StringBuffer sql = new StringBuffer();
sql.append("UPDATE " + getTableName() + " SET ");
boolean modified = false;
if (dto.isIdProductoModified()) {
if (modified) {
sql.append(", ");
}
sql.append("ID_PRODUCTO=?");
modified = true;
}
if (dto.isNombreProductoModified()) {
if (modified) {
sql.append(", ");
}
sql.append("NOMBRE_PRODUCTO=?");
modified = true;
}
if (dto.isPrecioModified()) {
if (modified) {
sql.append(", ");
}
sql.append("PRECIO=?");
modified = true;
}
if (dto.isImagenModified()) {
if (modified) {
sql.append(", ");
}
sql.append("IMAGEN=?");
modified = true;
}
if (dto.isCantidadModified()) {
if (modified) {
sql.append(", ");
}
sql.append("CANTIDAD=?");
modified = true;
}
if (dto.isActivoModified()) {
if (modified) {
sql.append(", ");
}
sql.append("ACTIVO=?");
modified = true;
}
if (dto.isFechaCreacionModified()) {
if (modified) {
sql.append(", ");
}
sql.append("FECHA_CREACION=?");
modified = true;
}
if (dto.isUsuarioCreacionModified()) {
if (modified) {
sql.append(", ");
}
sql.append("USUARIO_CREACION=?");
modified = true;
}
if (dto.isFechaUltimaModificacionModified()) {
if (modified) {
sql.append(", ");
}
sql.append("FECHA_ULTIMA_MODIFICACION=?");
modified = true;
}
if (dto.isUsuarioUltimaModificacionModified()) {
if (modified) {
sql.append(", ");
}
sql.append("USUARIO_ULTIMA_MODIFICACION=?");
modified = true;
}
if (dto.isCategoriaIdCategoriaModified()) {
if (modified) {
sql.append(", ");
}
sql.append("CATEGORIA_ID_CATEGORIA=?");
modified = true;
}
if (dto.isCatalogoIdCatalogoModified()) {
if (modified) {
sql.append(", ");
}
sql.append("CATALOGO_ID_CATALOGO=?");
modified = true;
}
if (!modified) {
// nothing to update
return;
}
sql.append(" WHERE ID_PRODUCTO=?");
if (logger.isDebugEnabled()) {
logger.debug("Executing " + sql.toString() + " with values: " + dto);
}
stmt = conn.prepareStatement(sql.toString());
int index = 1;
if (dto.isIdProductoModified()) {
stmt.setString(index++, dto.getIdProducto());
}
if (dto.isNombreProductoModified()) {
stmt.setString(index++, dto.getNombreProducto());
}
if (dto.isPrecioModified()) {
stmt.setDouble(index++, dto.getPrecio());
}
if (dto.isImagenModified()) {
super.setBlobColumn(stmt, index++, dto.getImagen());
}
if (dto.isCantidadModified()) {
if (dto.isCantidadNull()) {
stmt.setNull(index++, java.sql.Types.FLOAT);
} else {
stmt.setFloat(index++, dto.getCantidad());
}
}
if (dto.isActivoModified()) {
stmt.setShort(index++, dto.getActivo());
}
if (dto.isFechaCreacionModified()) {
stmt.setTimestamp(
index++,
dto.getFechaCreacion() == null
? null
: new java.sql.Timestamp(dto.getFechaCreacion().getTime()));
}
if (dto.isUsuarioCreacionModified()) {
stmt.setString(index++, dto.getUsuarioCreacion());
}
if (dto.isFechaUltimaModificacionModified()) {
stmt.setTimestamp(
index++,
dto.getFechaUltimaModificacion() == null
? null
: new java.sql.Timestamp(dto.getFechaUltimaModificacion().getTime()));
}
if (dto.isUsuarioUltimaModificacionModified()) {
stmt.setString(index++, dto.getUsuarioUltimaModificacion());
}
if (dto.isCategoriaIdCategoriaModified()) {
stmt.setInt(index++, dto.getCategoriaIdCategoria());
}
if (dto.isCatalogoIdCatalogoModified()) {
stmt.setInt(index++, dto.getCatalogoIdCatalogo());
}
stmt.setString(index++, pk.getIdProducto());
int rows = stmt.executeUpdate();
reset(dto);
long t2 = System.currentTimeMillis();
if (logger.isDebugEnabled()) {
logger.debug(rows + " rows affected (" + (t2 - t1) + " ms)");
}
} catch (Exception _e) {
logger.error("Exception: " + _e.getMessage(), _e);
throw new ProductoDaoException("Exception: " + _e.getMessage(), _e);
} finally {
ResourceManager.close(stmt);
if (!isConnSupplied) {
ResourceManager.close(conn);
}
}
}