resultsetdb.java

一个用java写的地震分析软件(无源码)-used to write a seismic analysis software (without source)

	return value;
    }

/** Returns a new DataObject whose value is set to that found in the ResultSet for the specified column index.
* If ResultSet object for specified column index is null, returns NullValueDb.NULL_xxx for the contained value type.
* and sets the state flags isNull() == true and isUpdate() == true.
* @see org.trinet.jdbc.NullValueDb
* @see org.trinet.jdbc.datatypes.DataObject
* @see org.trinet.jdbc.datatypes.DataBoolean
*/
    public DataBoolean getDataBoolean(int colNumber) throws SQLException {
        DataBoolean value = new DataBoolean(rs.getBoolean(colNumber));
	if (rs.wasNull()) {
	    value.setValue(false);
	    value.setNull(true);
	}
	value.setUpdate(false);
	return value;
    }

/** Returns a new DataObject whose value is set to that found in the ResultSet for the specified column name.
* If ResultSet object for specified column name is null, returns NullValueDb.NULL_xxx for the contained value type.
* and sets the state flags isNull() == true and isUpdate() == true.
* @see org.trinet.jdbc.NullValueDb
* @see org.trinet.jdbc.datatypes.DataObject
* @see org.trinet.jdbc.datatypes.DataDate
*/
    public DataDate getDataDate(String colName) throws SQLException {
        DataDate value = new DataDate(rs.getDate(colName));
	if (rs.wasNull()) {
	    value.setValue(NullValueDb.NULL_DATE);
	    value.setNull(true);
	}
	value.setUpdate(false);
	return value;
    }

/** Returns a new DataObject whose value is set to that found in the ResultSet for the specified column index.
* If ResultSet object for specified column index is null, returns NullValueDb.NULL_xxx for the contained value type.
* and sets the state flags isNull() == true and isUpdate() == true.
* @see org.trinet.jdbc.NullValueDb
* @see org.trinet.jdbc.datatypes.DataObject
* @see org.trinet.jdbc.datatypes.DataDate
*/
    public DataDate getDataDate(int colNumber) throws SQLException {
        DataDate value = new DataDate(rs.getDate(colNumber));
	if (rs.wasNull()) {
	    value.setValue(NullValueDb.NULL_DATE);
	    value.setNull(true);
	}
	value.setUpdate(false);
	return value;
    }

/** Returns a new DataObject whose value is set to that found in the ResultSet for the specified column name.
* If ResultSet object for specified column name is null, returns NullValueDb.NULL_xxx for the contained value type.
* and sets the state flags isNull() == true and isUpdate() == true.
* @see org.trinet.jdbc.NullValueDb
* @see org.trinet.jdbc.datatypes.DataObject
* @see org.trinet.jdbc.datatypes.DataTimestamp
*/
    public DataTimestamp getDataTimestamp(String colName) throws SQLException {
        DataTimestamp value = new DataTimestamp(rs.getTimestamp(colName));
	if (rs.wasNull()) {
	    value.setValue(NullValueDb.NULL_TIMESTAMP);
	    value.setNull(true);
	}
	value.setUpdate(false);
	return value;
    }

/** Returns a new DataObject whose value is set to that found in the ResultSet for the specified column index.
* If ResultSet object for specified column index is null, returns NullValueDb.NULL_xxx for the contained value type.
* and sets the state flags isNull() == true and isUpdate() == true.
* @see org.trinet.jdbc.NullValueDb
* @see org.trinet.jdbc.datatypes.DataObject
* @see org.trinet.jdbc.datatypes.DataTimestamp
*/
    public DataTimestamp getDataTimestamp(int colNumber) throws SQLException {
        DataTimestamp value = new DataTimestamp(rs.getTimestamp(colNumber));
	if (rs.wasNull()) {
	    value.setValue(NullValueDb.NULL_TIMESTAMP);
	    value.setNull(true);
	}
	value.setUpdate(false);
	return value;
    }

/** Returns a new DataObject whose value is set to that found in the ResultSet for the specified column name.
* If ResultSet object for specified column name is null, returns NullValueDb.NULL_xxx for the contained value type.
* and sets the state flags isNull() == true and isUpdate() == true.
* @see org.trinet.jdbc.NullValueDb
* @see org.trinet.jdbc.datatypes.DataObject
* @see org.trinet.jdbc.datatypes.DataString
*/
    public DataString getDataString(String colName) throws SQLException {
        DataString value = new DataString(rs.getString(colName));
	if (rs.wasNull()) {
	    value.setValue(NullValueDb.NULL_STRING);
	    value.setNull(true);
	}
	value.setUpdate(false);
	return value;
    }

/** Returns a new DataObject whose value is set to that found in the ResultSet for the specified column index.
* If ResultSet object for specified column index is null, returns NullValueDb.NULL_xxx for the contained value type.
* and sets the state flags isNull() == true and isUpdate() == true.
* @see org.trinet.jdbc.NullValueDb
* @see org.trinet.jdbc.datatypes.DataObject
* @see org.trinet.jdbc.datatypes.DataString
*/
    public DataString getDataString(int colNumber) throws SQLException {
        DataString value = new DataString(rs.getString(colNumber));
	if (rs.wasNull()) {
	    value.setValue(NullValueDb.NULL_STRING);
	    value.setNull(true);
	}
	value.setUpdate(false);
	return value;
    }

/** Returns an object extending the DataObject.class whose class type is defined by the input Class argument,
* which must be a class extending the base DataObject class. The value of the returned DataObject is set to value
* as returned by the getDataXXX(int index)  methods in this class.
* If ResultSet object for specified column index is null, returns NullValueDb.NULL_xxx for the contained value type.
* and sets the state flags isNull() == true and isUpdate() == true.
* Checks input index against index of named column in ResultSet object.
* Returns null if the input Class is not one of the recognized extensions of DataObject.
* Throws NoSuchFieldException if specified column name is not found in ResultSet object.
* Throws IndexOutOfBoundsException if specified index exceeds column count in ResultSet object.
* @see org.trinet.jdbc.NullValueDb
* @see org.trinet.jdbc.datatypes.DataObject
* @see org.trinet.jdbc.datatypes.DataString
* @see org.trinet.jdbc.datatypes.DataLong
* @see org.trinet.jdbc.datatypes.DataDouble
* @see org.trinet.jdbc.datatypes.DataInteger
* @see org.trinet.jdbc.datatypes.DataFloat
* @see org.trinet.jdbc.datatypes.DataDate
* @see org.trinet.jdbc.datatypes.DataTimestamp
* @see org.trinet.jdbc.datatypes.DataBoolean
*/
//    public DataObject getDataObject (int index, String fieldName, Class fieldClass, DataTableRow row) throws NoSuchFieldException,
//    public DataObject getDataObject (int index, String fieldName, Class fieldClass) throws NoSuchFieldException,
    public DataObject getDataObject (int index, Class fieldClass) throws NoSuchFieldException,
		IndexOutOfBoundsException, SQLException {
//	int colIndex = this.findColumn(fieldName);
	int colIndex = index;
	if (colIndex < 0) throw new NoSuchFieldException("ResultSetDb getDataObject name table field not found. ");
	ResultSetMetaData rsmd = rs.getMetaData();
	if (index > rsmd.getColumnCount()) 
	    throw new IndexOutOfBoundsException("ResultSetDb getDataObject requested columnIndex offset not found in ResultSet");
//	try {
	    if (fieldClass.getName().endsWith("DataString")) {
		return getDataString(colIndex);
	    }
	    else if (fieldClass.getName().endsWith("DataDouble")) {
		return getDataDouble(colIndex);
	    }
	    else if (fieldClass.getName().endsWith("DataInteger")) {
		return getDataInteger(colIndex);
	    }
	    else if (fieldClass.getName().endsWith("DataDate")) {
		return getDataDate(colIndex);
	    }
	    else if (fieldClass.getName().endsWith("DataFloat")) {
		return getDataFloat(colIndex);
	    }
	    else if (fieldClass.getName().endsWith("DataLong")) {
		return getDataLong(colIndex);
	    }
	    else if (fieldClass.getName().endsWith("DataTimestamp")) {
		return getDataTimestamp(colIndex);
	    }
	    else if (fieldClass.getName().endsWith("DataBoolean")) {
		return getDataBoolean(colIndex);
	    }

/*	}
	catch (SQLException ex) {
	    System.out.println("ResultSetDb getDataObject field class: " + fieldClass.getName());
	    SQLExceptionHandler.prtSQLException(ex);
	}
*/
	return null;
    }

/** Returns the ResultSet column number corresponding the input column name string.
* Returns -1, if no such column or an SQLException occurs.
*/ 
    public int findColumn(String name) {
	int retVal = -1;
	try {
	    retVal =  rs.findColumn(name); 
	}
	catch (SQLException ex) {
	    System.out.println("ResultSetDb findColumn(name) table column not found?: " + name);
	    SQLExceptionHandler.prtSQLException(ex);
	}
	return retVal;
    }
}