/** * Move the physical binary data to this SQL parameter row. * @param statement The SQL prepare statement. * @param iType the type of SQL statement. * @param iParamColumn The column in the prepared statement to set the data. * @exception SQLException From SQL calls. */ public void getSQLFromField(PreparedStatement statement, int iType, int iParamColumn) throws SQLException { if (this.isNull()) { if ((this.isNullable()) && (iType != DBConstants.SQL_SELECT_TYPE)) statement.setNull(iParamColumn, Types.INTEGER); else statement.setInt(iParamColumn, NAN); } else statement.setShort(iParamColumn, (short)this.getValue()); } /**
/** * Move the physical binary data to this SQL parameter row. * @param statement The SQL prepare statement. * @param iType the type of SQL statement. * @param iParamColumn The column in the prepared statement to set the data. * @exception SQLException From SQL calls. */ public void getSQLFromField(PreparedStatement statement, int iType, int iParamColumn) throws SQLException { if (this.isNull()) { if ((this.isNullable()) && (iType != DBConstants.SQL_SELECT_TYPE)) statement.setNull(iParamColumn, Types.INTEGER); else statement.setInt(iParamColumn, NAN); } else statement.setShort(iParamColumn, (short)this.getValue()); } /**
/** * Move the physical binary data to this SQL parameter row. * @param statement The SQL prepare statement. * @param iType the type of SQL statement. * @param iParamColumn The column in the prepared statement to set the data. * @exception SQLException From SQL calls. */ public void getSQLFromField(PreparedStatement statement, int iType, int iParamColumn) throws SQLException { if (this.isNull()) { if ((this.isNullable()) && (iType != DBConstants.SQL_SELECT_TYPE)) statement.setNull(iParamColumn, Types.INTEGER); else statement.setInt(iParamColumn, NAN); } else statement.setShort(iParamColumn, (short)this.getValue()); } /**
/** * Move the physical binary data to this SQL parameter row. * @param resultset The resultset to get the SQL data from. * @param iColumn the column in the resultset that has my data. * @exception SQLException From SQL calls. */ public void moveSQLToField(ResultSet resultset, int iColumn) throws SQLException { short sResult = resultset.getShort(iColumn); if (resultset.wasNull()) this.setString(Constants.BLANK, false, DBConstants.READ_MOVE); // Null value else { if ((!this.isNullable()) && (sResult == NAN)) this.setString(Constants.BLANK, false, DBConstants.READ_MOVE); // Null value else this.setValue(sResult, false, DBConstants.READ_MOVE); } } /**
/** * Move the physical binary data to this SQL parameter row. * @param resultset The resultset to get the SQL data from. * @param iColumn the column in the resultset that has my data. * @exception SQLException From SQL calls. */ public void moveSQLToField(ResultSet resultset, int iColumn) throws SQLException { short sResult = resultset.getShort(iColumn); if (resultset.wasNull()) this.setString(Constants.BLANK, false, DBConstants.READ_MOVE); // Null value else { if ((!this.isNullable()) && (sResult == NAN)) this.setString(Constants.BLANK, false, DBConstants.READ_MOVE); // Null value else this.setValue(sResult, false, DBConstants.READ_MOVE); } } /**
/** * Move the physical binary data to this SQL parameter row. * @param resultset The resultset to get the SQL data from. * @param iColumn the column in the resultset that has my data. * @exception SQLException From SQL calls. */ public void moveSQLToField(ResultSet resultset, int iColumn) throws SQLException { short sResult = resultset.getShort(iColumn); if (resultset.wasNull()) this.setString(Constants.BLANK, false, DBConstants.READ_MOVE); // Null value else { if ((!this.isNullable()) && (sResult == NAN)) this.setString(Constants.BLANK, false, DBConstants.READ_MOVE); // Null value else this.setValue(sResult, false, DBConstants.READ_MOVE); } } /**