Java Code Examples for java.sql.CallableStatement#getByte()
The following examples show how to use
java.sql.CallableStatement#getByte() .
You can vote up the ones you like or vote down the ones you don't like,
and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.
Example 1
| Source File: SQLQuery.java From micro-integrator with Apache License 2.0 | 4 votes |
|
private ParamValue getOutparameterValue(CallableStatement cs, String type, int ordinal)
throws DataServiceFault {
try {
Object elementValue;
if (type.equals(DBConstants.DataTypes.STRING)) {
elementValue = cs.getString(ordinal);
return new ParamValue(elementValue == null ? null : elementValue.toString());
} else if (type.equals(DBConstants.DataTypes.DOUBLE)) {
elementValue = cs.getDouble(ordinal);
return new ParamValue(elementValue == null ? null
: ConverterUtil.convertToString((Double) elementValue));
} else if (type.equals(DBConstants.DataTypes.BIGINT)) {
elementValue = cs.getLong(ordinal);
return new ParamValue(elementValue == null ? null
: ConverterUtil.convertToString((Long) elementValue));
} else if (type.equals(DBConstants.DataTypes.INTEGER)) {
elementValue = cs.getInt(ordinal);
return new ParamValue(elementValue == null ? null
: ConverterUtil.convertToString((Integer) elementValue));
} else if (type.equals(DBConstants.DataTypes.TIME)) {
elementValue = cs.getTime(ordinal);
return new ParamValue(elementValue == null ? null
: this.convertToTimeString((Time) elementValue));
} else if (type.equals(DBConstants.DataTypes.DATE)) {
elementValue = cs.getDate(ordinal);
return new ParamValue(elementValue == null ? null
: ConverterUtil.convertToString((Date) elementValue));
} else if (type.equals(DBConstants.DataTypes.TIMESTAMP)) {
if (timeConvertEnabled) {
elementValue = cs.getTimestamp(ordinal, calendar);
} else {
elementValue = cs.getTimestamp(ordinal);
}
return new ParamValue(elementValue == null ? null
: this.convertToTimestampString((Timestamp) elementValue));
} else if (type.equals(DBConstants.DataTypes.BLOB)) {
elementValue = cs.getBlob(ordinal);
return new ParamValue(elementValue == null ? null
: this.getBase64StringFromInputStream(((Blob) elementValue)
.getBinaryStream()));
} else if (type.equals(DBConstants.DataTypes.CLOB)) {
elementValue = cs.getClob(ordinal);
return new ParamValue(elementValue == null ? null :
deriveValueFromClob((Clob) elementValue));
} else if (type.equals(DBConstants.DataTypes.STRUCT)) {
elementValue = cs.getObject(ordinal);
return new ParamValue(elementValue == null ? null : (Struct) elementValue);
} else if (type.equals(DBConstants.DataTypes.ARRAY)) {
Array dataArray = cs.getArray(ordinal);
ParamValue paramValue = new ParamValue(ParamValue.PARAM_VALUE_ARRAY);
if (dataArray != null) {
this.processSQLArray(dataArray, paramValue);
}
return paramValue;
} else if (type.equals(DBConstants.DataTypes.NUMERIC)) {
elementValue = cs.getBigDecimal(ordinal);
return new ParamValue(elementValue == null ? null
: ConverterUtil.convertToString((BigDecimal) elementValue));
} else if (type.equals(DBConstants.DataTypes.BIT)) {
elementValue = cs.getBoolean(ordinal);
return new ParamValue(elementValue == null ? null
: ConverterUtil.convertToString((Boolean) elementValue));
} else if (type.equals(DBConstants.DataTypes.TINYINT)) {
elementValue = cs.getByte(ordinal);
return new ParamValue(elementValue == null ? null
: ConverterUtil.convertToString((Byte) elementValue));
} else if (type.equals(DBConstants.DataTypes.SMALLINT)) {
elementValue = cs.getShort(ordinal);
return new ParamValue(elementValue == null ? null
: ConverterUtil.convertToString((Short) elementValue));
} else if (type.equals(DBConstants.DataTypes.REAL)) {
elementValue = cs.getFloat(ordinal);
return new ParamValue(elementValue == null ? null
: ConverterUtil.convertToString((Float) elementValue));
} else if (type.equals(DBConstants.DataTypes.BINARY)) {
elementValue = cs.getBlob(ordinal);
return new ParamValue(elementValue == null ? null
: this.getBase64StringFromInputStream(((Blob) elementValue)
.getBinaryStream()));
} else {
throw new DataServiceFault("Unsupported data type: " + type);
}
} catch (SQLException e) {
throw new DataServiceFault(e, "Error in getting sql output parameter values.");
}
}
Example 2
| Source File: ByteTypeHandler.java From tangyuan2 with GNU General Public License v3.0 | 4 votes |
|
@Override
public Byte getNullableResult(CallableStatement cs, int columnIndex) throws SQLException {
return cs.getByte(columnIndex);
}
Example 3
| Source File: ByteTypeHandler.java From mybaties with Apache License 2.0 | 4 votes |
|
@Override
public Byte getNullableResult(CallableStatement cs, int columnIndex)
throws SQLException {
return cs.getByte(columnIndex);
}
Example 4
| Source File: InnerCallableStatementGetter.java From hasor with Apache License 2.0 | 4 votes |
|
public static Object getValue(final CallableStatement cs, final int index, Class<?> requiredType) throws SQLException {
Object value = null;
boolean wasNullCheck = false;
if (requiredType == null) {
return cs.getObject(index);
}
requiredType = primitiveToWrapper(requiredType);
// Explicitly extract typed value, as far as possible.
if (String.class.equals(requiredType)) {
value = cs.getString(index);
} else if (Integer.class.equals(requiredType)) {
value = cs.getInt(index);
wasNullCheck = true;
} else if (Double.class.equals(requiredType)) {
value = cs.getDouble(index);
wasNullCheck = true;
} else if (Boolean.class.equals(requiredType)) {
value = cs.getBoolean(index) ? Boolean.TRUE : Boolean.FALSE;
wasNullCheck = true;
} else if (java.sql.Date.class.equals(requiredType)) {
value = cs.getDate(index);
} else if (java.sql.Time.class.equals(requiredType)) {
value = cs.getTime(index);
} else if (java.sql.Timestamp.class.equals(requiredType)) {
value = cs.getTimestamp(index);
} else if (java.util.Date.class.equals(requiredType)) {
value = new java.util.Date(cs.getTimestamp(index).getTime());
} else if (Byte.class.equals(requiredType)) {
value = cs.getByte(index);
wasNullCheck = true;
} else if (Short.class.equals(requiredType)) {
value = cs.getShort(index);
wasNullCheck = true;
} else if (Long.class.equals(requiredType)) {
value = cs.getLong(index);
wasNullCheck = true;
} else if (Float.class.equals(requiredType)) {
value = cs.getFloat(index);
wasNullCheck = true;
} else if (Number.class.equals(requiredType)) {
value = cs.getDouble(index);
wasNullCheck = true;
} else if (byte[].class.equals(requiredType)) {
value = cs.getBytes(index);
} else if (java.math.BigDecimal.class.equals(requiredType)) {
value = cs.getBigDecimal(index);
} else if (java.sql.Blob.class.equals(requiredType)) {
value = cs.getBlob(index);
} else if (java.sql.Clob.class.equals(requiredType)) {
value = cs.getClob(index);
} else if (java.net.URL.class.equals(requiredType)) {
value = cs.getURL(index);
} else {
// Some unknown type desired -> rely on getObject.
value = cs.getObject(index);
}
// Perform was-null check if demanded (for results that the JDBC driver returns as primitives).
if (wasNullCheck && value != null && cs.wasNull()) {
value = null;
}
return value;
}
Example 5
| Source File: ByteTypeHandler.java From mybatis with Apache License 2.0 | 4 votes |
|
@Override
public Byte getNullableResult(CallableStatement cs, int columnIndex)
throws SQLException {
return cs.getByte(columnIndex);
}
