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.
package acolyte.jdbc;
import java.util.Locale;
import java.util.List;
import java.math.BigDecimal;
import java.sql.SQLException;
import java.sql.Types;
import org.apache.commons.lang3.builder.HashCodeBuilder;
import org.apache.commons.lang3.builder.EqualsBuilder;
import static acolyte.jdbc.Defaults.*;
/**
* Acolyte parameter meta-data.
*
* @author Cedric Chantepie
*/
public final class ParameterMetaData implements java.sql.ParameterMetaData {
// --- Properties ---
/**
* Definitions
*/
public final List parameters;
// --- Constructors ---
/**
* Constructor.
*
* @param parameters the definitions for the parameters
*/
public ParameterMetaData(final List parameters) {
if (parameters == null) {
throw new IllegalArgumentException("Missing definition");
} // end of if
this.parameters = parameters;
} // end of
// ---
/**
* {@inheritDoc}
*/
public int getParameterCount() throws SQLException {
return this.parameters.size();
} // end of getParameterCount
/**
* {@inheritDoc}
*/
public int isNullable(final int param) throws SQLException {
try {
return this.parameters.get(param-1).nullable;
} catch (NullPointerException e) {
throw new SQLException("Parameter is not set: " + param);
} catch (IndexOutOfBoundsException out) {
throw new SQLException("Parameter out of bounds: " + param);
} // end of catch
} // end of isNullable
/**
* {@inheritDoc}
*/
public boolean isSigned(final int param) throws SQLException {
try {
return this.parameters.get(param-1).signed;
} catch (NullPointerException e) {
throw new SQLException("Parameter is not set: " + param);
} catch (IndexOutOfBoundsException out) {
throw new SQLException("Parameter out of bounds: " + param);
} // end of catch
} // end of isSigned
/**
* {@inheritDoc}
*/
public int getPrecision(final int param) throws SQLException {
try {
return this.parameters.get(param-1).precision;
} catch (NullPointerException e) {
throw new SQLException("Parameter is not set: " + param);
} catch (IndexOutOfBoundsException out) {
throw new SQLException("Parameter out of bounds: " + param);
} // end of catch
} // end of getPrecision
/**
* {@inheritDoc}
*/
public int getScale(final int param) throws SQLException {
try {
return this.parameters.get(param-1).scale;
} catch (NullPointerException e) {
throw new SQLException("Parameter is not set: " + param);
} catch (IndexOutOfBoundsException out) {
throw new SQLException("Parameter out of bounds: " + param);
} // end of catch
} // end of getScale
/**
* {@inheritDoc}
*/
public int getParameterType(final int param) throws SQLException {
try {
return this.parameters.get(param-1).sqlType;
} catch (NullPointerException e) {
throw new SQLException("Parameter is not set: " + param);
} catch (IndexOutOfBoundsException out) {
throw new SQLException("Parameter out of bounds: " + param);
} // end of catch
} // end of getParameterType
/**
* {@inheritDoc}
*/
public String getParameterTypeName(final int param) throws SQLException {
try {
return this.parameters.get(param-1).sqlTypeName;
} catch (NullPointerException e) {
throw new SQLException("Parameter is not set: " + param);
} catch (IndexOutOfBoundsException out) {
throw new SQLException("Parameter out of bounds: " + param);
} // end of catch
} // end of getParameterTypeName
/**
* {@inheritDoc}
*/
public String getParameterClassName(final int param) throws SQLException {
try {
return this.parameters.get(param-1).className;
} catch (NullPointerException e) {
throw new SQLException("Parameter is not set: " + param);
} catch (IndexOutOfBoundsException out) {
throw new SQLException("Parameter out of bounds: " + param);
} // end of catch
} // end of getParameterClassName
/**
* {@inheritDoc}
*/
public int getParameterMode(final int param) throws SQLException {
try {
return this.parameters.get(param-1).mode;
} catch (NullPointerException e) {
throw new SQLException("Parameter is not set: " + param);
} catch (IndexOutOfBoundsException out) {
throw new SQLException("Parameter out of bounds: " + param);
} // end of catch
} // end of getParameterMode
/**
* {@inheritDoc}
*/
public boolean isWrapperFor(final Class iface) throws SQLException {
return iface.isAssignableFrom(this.getClass());
} // end of isWrapperFor
/**
* {@inheritDoc}
*/
public T unwrap(final Class iface) throws SQLException {
if (!isWrapperFor(iface)) {
throw new SQLException();
} // end of if
@SuppressWarnings("unchecked")
final T proxy = (T) this;
return proxy;
} // end of unwrap
// --- Factory methods ---
/**
* Default parameter.
* @param sqlType the SQL type for the parameter definition
* @return the default definition for a parameter of specified SQL type
*/
public static ParameterDef Default(final int sqlType) {
return new ParameterDef(jdbcTypeMappings.get(sqlType),
parameterModeIn,
sqlType,
jdbcTypeNames.get(sqlType),
jdbcTypePrecisions.get(sqlType),
jdbcTypeScales.get(sqlType),
parameterNullableUnknown,
jdbcTypeSigns.get(sqlType));
} // end of Default
/**
* Decimal parameter.
*
* @param sqlType the SQL type for the parameter definition
* @param scale the scale of the numeric parameter
* @return the parameter definition for a number with specified scale
*/
public static ParameterDef Scaled(final int sqlType, final int scale) {
return new ParameterDef(jdbcTypeMappings.get(sqlType),
parameterModeIn,
sqlType,
jdbcTypeNames.get(sqlType),
jdbcTypePrecisions.get(sqlType),
scale,
parameterNullableUnknown,
jdbcTypeSigns.get(sqlType));
} // end of Decimal
/**
* Null constructor.
*
* @param sqlType the SQL type for the parameter definition
* @return the parameter definition for a null parameter of specified type
*/
public static ParameterDef Null(final int sqlType) {
return Default(sqlType);
} // end of Null
/**
* Binary (bytes) definition
*/
public static final ParameterDef Binary = Default(Types.BINARY);
/**
* Blob definition
*/
public static final ParameterDef Blob = Default(Types.BLOB);
/**
* Boolean definition
*/
public static final ParameterDef Bool = Default(Types.BOOLEAN);
/**
* Byte definition
*/
public static final ParameterDef Byte = Default(Types.TINYINT);
/**
* Short definition
*/
public static final ParameterDef Short = Default(Types.SMALLINT);
/**
* Integer definition
*/
public static final ParameterDef Int = Default(Types.INTEGER);
/**
* Long definition
*/
public static final ParameterDef Long = Default(Types.BIGINT);
/**
* Float constructor.
*
* @param f the float value for the parameter
* @return Parameter definition for given float value
*/
public static ParameterDef Float(final float f) {
final BigDecimal bd = new BigDecimal(Float.toString(f));
return Scaled(Types.FLOAT, bd.scale());
} // end of Float
/**
* Float constructor (as REAL).
*
* @param f the float value for the parameter
* @return Parameter definition for given float value
*/
public static ParameterDef Real(final float f) {
final BigDecimal bd = new BigDecimal(Float.toString(f));
return Scaled(Types.REAL, bd.scale());
} // end of Real
/**
* Double constructor.
*
* @param d the double precision value for the parameter
* @return Parameter definition for given double precision value
*/
public static ParameterDef Double(final double d) {
final BigDecimal bd = new BigDecimal(String.format(Locale.US, "%f", d)).
stripTrailingZeros();
return Scaled(Types.DOUBLE, bd.scale());
} // end of Double
/**
* Numeric with default scale.
*/
public static final ParameterDef Numeric = Default(Types.NUMERIC);
/**
* BigDecimal constructor.
*
* @param bd the big decimal for the parameter
* @return Parameter definition for given big decimal
*/
public static ParameterDef Numeric(final BigDecimal bd) {
return Scaled(Types.NUMERIC, bd.scale());
} // end of Numeric
/**
* Decimal with default scale.
*/
public static final ParameterDef Decimal = Default(Types.DECIMAL);
/**
* BigDecimal constructor (as DECIMAL).
*
* @param bd the big decimal for the parameter
* @return Parameter definition for given big decimal
*/
public static ParameterDef Decimal(final BigDecimal bd) {
return Scaled(Types.DECIMAL, bd.scale());
} // end of Decimal
/**
* Array definition
*/
public static final ParameterDef Array = Default(Types.ARRAY);
/**
* String definition
*/
public static final ParameterDef Str = Default(Types.VARCHAR);
/**
* Date definition
*/
public static final ParameterDef Date = Default(Types.DATE);
/**
* Time definition
*/
public static final ParameterDef Time = Default(Types.TIME);
/**
* Timestamp definition
*/
public static final ParameterDef Timestamp = Default(Types.TIMESTAMP);
// --- Inner classes ---
/**
* Single parameter definition.
*/
public static final class ParameterDef {
public final String className;
public final int mode;
public final int sqlType;
public final String sqlTypeName;
public final int precision;
public final int scale;
public final int nullable;
public final boolean signed;
// --- Constructors ---
/**
* Bulk constructor
*
* @param className the name of the parameter class
* @param mode the parameter mode
* @param sqlType the SQL type of the parameter
* @param sqlTypeName the name of the SQL type
* @param precision the numeric precision (for number parameter)
* @param scale the numeric scale (for number parameter)
* @param nullable true if the parameter is nullable, or false
* @param signed true if the parameter is a signed number, or false
*/
public ParameterDef(final String className,
final int mode,
final int sqlType,
final String sqlTypeName,
final int precision,
final int scale,
final int nullable,
final boolean signed) {
if (className == null) {
throw new IllegalArgumentException("Missing class name");
} // end of if
if (sqlTypeName == null) {
throw new IllegalArgumentException("Missing SQL type name");
} // end of if
// ---
this.className = className;
this.mode = mode;
this.sqlType = sqlType;
this.sqlTypeName = sqlTypeName;
this.precision = precision;
this.scale = scale;
this.nullable = nullable;
this.signed = signed;
} // end of
// ---
/**
* {@inheritDoc}
*/
public String toString() {
return String.format("ParameterDef(class = %s, mode = %s, sqlType = %s(%d), precision = %d, scale = %d, nullable = %s, signed = %s)", this.className, this.mode, this.sqlTypeName, this.sqlType, this.precision, this.scale, this.nullable, this.signed);
} // end of toString
/**
* {@inheritDoc}
*/
public boolean equals(Object o) {
if (o == null || !(o instanceof ParameterDef)) {
return false;
} // end of if
final ParameterDef other = (ParameterDef) o;
return new EqualsBuilder().
append(this.className, other.className).
append(this.mode, other.mode).
append(this.sqlType, other.sqlType).
append(this.sqlTypeName, other.sqlTypeName).
append(this.precision, other.precision).
append(this.scale, other.scale).
append(this.nullable, other.nullable).
append(this.signed, other.signed).
isEquals();
} // end of equals
/**
* {@inheritDoc}
*/
public int hashCode() {
return new HashCodeBuilder(11, 1).
append(this.className).
append(this.mode).
append(this.sqlType).
append(this.sqlTypeName).
append(this.precision).
append(this.scale).
append(this.nullable).
append(this.signed).
toHashCode();
} // end of hashCode
} // end of class Parameter
} // end of class ParameterMetaData
