src.com.ibm.as400.access.JDSimpleRow Maven / Gradle / Ivy
Show all versions of jt400 Show documentation
///////////////////////////////////////////////////////////////////////////////
//
// JTOpen (IBM Toolbox for Java - OSS version)
//
// Filename: JDSimpleRow.java
//
// The source code contained herein is licensed under the IBM Public License
// Version 1.0, which has been approved by the Open Source Initiative.
// Copyright (C) 1997-2001 International Business Machines Corporation and
// others. All rights reserved.
//
///////////////////////////////////////////////////////////////////////////////
package com.ibm.as400.access;
import java.sql.SQLException;
import java.util.Calendar;
/**
The JDSimpleRow class implements a row of data generated
on the client.
**/
class JDSimpleRow
implements JDRow
{
static final String copyright = "Copyright (C) 1997-2001 International Business Machines Corporation and others.";
// Private data.
private String[] fieldNames_;
private int[] fieldNullables_;
private SQLData[] sqlData_;
private boolean[] sqlNulls_;
private boolean[] sqlDataMappingErrors_;
/**
Constructs a JDSimpleRow object.
@param fieldNames Field names.
@param sqlData Initial contents of SQL data. This is
needed immediately just to describe the
format.
@param fieldNullables Field nullables (either DatabaseMetaData.
columnNoNulls, columnNullable or
columnNullableUnknown).
**/
JDSimpleRow (String[] fieldNames,
SQLData[] sqlData,
int[] fieldNullables)
{
fieldNames_ = fieldNames;
fieldNullables_ = fieldNullables;
sqlData_ = sqlData;
sqlNulls_ = new boolean[sqlData_.length];
sqlDataMappingErrors_ = new boolean[sqlData_.length];
}
/**
Constructs a JDSimpleRow object. The format is determined
based on another JDRow object.
@param other The other row.
@param clone true if a full clone should be made, or
false if just references.
**/
JDSimpleRow (JDRow otherRow, boolean clone)
throws SQLException
{
int fieldCount = otherRow.getFieldCount ();
fieldNames_ = new String[fieldCount];
fieldNullables_ = new int[fieldCount];
sqlData_ = new SQLData[fieldCount];
sqlNulls_ = new boolean[fieldCount];
sqlDataMappingErrors_ = new boolean[fieldCount];
for(int i = 0; i < fieldCount; ++i)
{
fieldNames_[i] = otherRow.getFieldName (i+1);
fieldNullables_[i] = otherRow.isNullable (i+1);
if(clone)
{ // @E1C
sqlData_[i] = (SQLData) otherRow.getSQLData (i+1).clone ();
sqlNulls_[i] = false; // @E1A
sqlDataMappingErrors_[i] = false;
} // @E1A
else
{ // @E1C
sqlData_[i] = otherRow.getSQLData (i+1);
sqlNulls_[i] = otherRow.isNull (i+1); // @E1C
sqlDataMappingErrors_[i] = otherRow.isDataMappingError(i+1);
} // @E1A
}
}
/**
Sets the data.
@param data The data.
**/
void setData (Object[] data)
throws SQLException
{
Calendar calendar = AS400Calendar.getGregorianInstance ();
for(int i = 0; i < sqlData_.length; ++i)
sqlData_[i].set (data[i], calendar, -1);
}
/**
Sets the SQL data mapping errors.
@param dataMappingErrors The data mapping errors.
**/
void setDataMappingErrors(boolean[] dataMappingErrors)
{
sqlDataMappingErrors_ = dataMappingErrors;
}
/**
Sets the nulls.
@param nulls The nulls.
**/
void setNulls (boolean[] nulls)
{
sqlNulls_ = nulls;
}
//-------------------------------------------------------------//
// //
// INTERFACE IMPLEMENTATIONS //
// //
//-------------------------------------------------------------//
public int findField(String name) throws SQLException {
if (name.startsWith("\"") && name.endsWith("\""))
{
name = JDUtilities.stripOuterDoubleQuotes(name);
for (int i = 1; i <= sqlData_.length; ++i)
if (name.equals(getFieldName(i)))
return i;
} else
{
name = name.toUpperCase(); //@PDA
//X.equalsIgnoreCase(Y) converts both X and Y to uppercase.
//column names that are non-delim are returned uppercase,
//so just one call to name.UpperCase() is sufficient for
// comparisons.
for (int i = 0; i < fieldNames_.length; ++i)
if (name.equals(fieldNames_[i])) //@PDC
return i + 1;
}
JDError.throwSQLException(JDError.EXC_COLUMN_NOT_FOUND);
return -1;
}
public int getFieldCount ()
{
return fieldNames_.length;
}
public String getFieldName (int index)
throws SQLException
{
try
{
return fieldNames_[index-1];
}
catch(ArrayIndexOutOfBoundsException e)
{
JDError.throwSQLException (JDError.EXC_DESCRIPTOR_INDEX_INVALID, e);
return null;
}
}
/* @C1D
public int getFieldPrecision (int index)
throws SQLException
{
try {
return sqlData_[index-1].getPrecision ();
}
catch (ArrayIndexOutOfBoundsException e) {
JDError.throwSQLException (JDError.EXC_DESCRIPTOR_INDEX_INVALID, e);
return -1;
}
}
public int getFieldScale (int index)
throws SQLException
{
try {
return sqlData_[index-1].getMaximumScale ();
}
catch (ArrayIndexOutOfBoundsException e) {
JDError.throwSQLException (JDError.EXC_DESCRIPTOR_INDEX_INVALID, e);
return -1;
}
}
*/
public SQLData getSQLData (int index)
throws SQLException
{
try
{
return sqlData_[index-1];
}
catch(ArrayIndexOutOfBoundsException e)
{
JDError.throwSQLException (JDError.EXC_DESCRIPTOR_INDEX_INVALID, e);
return null;
}
}
public SQLData getSQLType (int index)
throws SQLException
{
try
{
return sqlData_[index-1];
}
catch(ArrayIndexOutOfBoundsException e)
{
JDError.throwSQLException (JDError.EXC_DESCRIPTOR_INDEX_INVALID, e);
return null;
}
}
/**
Is there a data mapping error for the field?
@param index The field index (1-based).
@return true or false
@exception SQLException If an error occurs.
**/
public boolean isDataMappingError(int index)
throws SQLException
{
try
{
return sqlDataMappingErrors_[index-1];
}
catch(ArrayIndexOutOfBoundsException e)
{
JDError.throwSQLException(JDError.EXC_DESCRIPTOR_INDEX_INVALID, e);
return false;
}
}
public boolean isNull (int index)
throws SQLException
{
try
{
return sqlNulls_[index-1];
}
catch(ArrayIndexOutOfBoundsException e)
{
JDError.throwSQLException (JDError.EXC_DESCRIPTOR_INDEX_INVALID, e);
return false;
}
}
public int isNullable (int index)
throws SQLException
{
try
{
return fieldNullables_[index-1];
}
catch(ArrayIndexOutOfBoundsException e)
{
JDError.throwSQLException (JDError.EXC_DESCRIPTOR_INDEX_INVALID, e);
return -1;
}
}
/*@L1A*/
public String getSQLTypeName(int index) throws SQLException {
return getSQLData (index).getTypeName();
}
/* get the CCSID of the column @V8A*/
public int getCCSID(int index) throws SQLException {
SQLData sqlData = getSQLType(index);
if (SQLDataBase.isCharacterType(sqlData.getSQLType())) {
return -1;
} else {
return 0;
}
}
}