Java OracleResultSet类代码示例

import oracle.jdbc.OracleResultSet; //导入依赖的package包/类
@Override
protected ResultSet wrapResultSet(JdbcEvent jdbcEvent,
		ResultSet executeQuery, String ref) {
	if (executeQuery instanceof OracleResultSet) {
		ResultSet wrapOracleResultSet = WrappedOracleStatement.wrapOracleResultSet(
				(OracleResultSet) executeQuery, ref, jdbcEvent, this);
		return wrapOracleResultSet;
	}

	return super.wrapResultSet(jdbcEvent, executeQuery, ref);
}
 

import oracle.jdbc.OracleResultSet; //导入依赖的package包/类
/**
 * 
 * wrapResultSet
 * 
 * @param resultSet the result set
 * @param currentRef the reference string
 * @param jdbcEvent the event
 * @param statement the statement
 * @return the wrapped result set
 */
public static ResultSet wrapOracleResultSet(OracleResultSet resultSet,
		String currentRef, JdbcEvent jdbcEvent, WrappedStatement statement) {
	ResultSet rslt;
	if (JdbcLogger.isResultSetSizeMeasured()) {
		rslt = new WrappedOracleCalculatedResultSet(resultSet, currentRef,
				jdbcEvent);
	} else {
		rslt = new WrappedOracleResultSet(resultSet, currentRef, jdbcEvent);
	}
	
	statement.addPendingResultSet(rslt);
	return rslt;
}
 

import oracle.jdbc.OracleResultSet; //导入依赖的package包/类
@Override
 protected ResultSet wrapResultSet(JdbcEvent jdbcEvent,
 		ResultSet executeQuery, String ref) {
     if (executeQuery instanceof OracleResultSet)
     {
return WrappedOracleStatement.wrapOracleResultSet(
		(OracleResultSet) executeQuery, ref, jdbcEvent, this);
     }

     return super.wrapResultSet(jdbcEvent, executeQuery, ref);
 }
 

import oracle.jdbc.OracleResultSet; //导入依赖的package包/类
/**
 * Retrieve LongObject from database.
 */
@Override
protected RDBLongObject IDtoLongObject ( int dbid, String table ) {
	RDBLongObject	res = null;
	try {
				String opName = "getLongObject";
				PreparedStatement ps = m_sql.getPreparedSQLStatement(opName, table); 
				ps.setInt(1,dbid);
				OracleResultSet rs = (OracleResultSet) ps.executeQuery();
				if (rs.next()) {
				   res = new RDBLongObject();
				   res.head = rs.getString(1);
				   BLOB blob = rs.getBLOB(2);
					
				   if (blob != null) {
					int len =  (int)blob.length();
					byte[] data = blob.getBytes(1,len);
					res.tail = new String(data, "UTF-8");
				   } else {
				   	res.tail = "";
				   }
				}
				rs.close();
				m_sql.returnPreparedSQLStatement(ps);
			
	} catch (SQLException e1) {
		// /* DEBUG */ System.out.println("Literal truncation (" + l.toString().length() + ") " + l.toString().substring(0, 150));
		throw new RDFRDBException("Failed to retrieve long object (SQL Exception): ", e1);
	} catch (UnsupportedEncodingException e2) {
		throw new RDFRDBException("Failed to retrieve long object (UnsupportedEncoding): ", e2);
	}
	return res;	
}
 

import oracle.jdbc.OracleResultSet; //导入依赖的package包/类
protected OracleResultSet getOracleResultSet(ResultSet resultSet) {

        if (resultSet instanceof OracleResultSet)
            return (OracleResultSet) resultSet;
        else
            try {
                return (OracleResultSet) ((WrappedResultSet) resultSet).getUnderlyingResultSet();
            } catch (SQLException e) {
                throw new OXFException(e);
            }
    }
 

import oracle.jdbc.OracleResultSet; //导入依赖的package包/类
protected OracleResultSet getOracleResultSet(ResultSet resultSet) {
    try {
        return resultSet instanceof OracleResultSet
            ? (OracleResultSet) resultSet
            : resultSet.unwrap(OracleResultSet.class);
    } catch (SQLException e) {
        throw new OXFException(e);
    }
}
 

import oracle.jdbc.OracleResultSet; //导入依赖的package包/类
protected OracleResultSet getOracleResultSet(ResultSet resultSet) {
    // Use classes from Tomcat DBCP to get the delegate
    if (resultSet instanceof OracleResultSet)
        return (OracleResultSet) resultSet;
    else
        return (OracleResultSet) ((DelegatingResultSet) resultSet).getDelegate();
}
 

import oracle.jdbc.OracleResultSet; //导入依赖的package包/类
protected void fillX3dMaterialValues (X3DMaterial x3dMaterial, OracleResultSet rs) throws SQLException {

		double ambientIntensity = rs.getDouble("x3d_ambient_intensity");
		if (!rs.wasNull()) {
			x3dMaterial.setAmbientIntensity(ambientIntensity);
		}
		double shininess = rs.getDouble("x3d_shininess");
		if (!rs.wasNull()) {
			x3dMaterial.setShininess(shininess);
		}
		double transparency = rs.getDouble("x3d_transparency");
		if (!rs.wasNull()) {
			x3dMaterial.setTransparency(transparency);
		}
		Color color = getX3dColorFromString(rs.getString("x3d_diffuse_color"));
		if (color != null) {
			x3dMaterial.setDiffuseColor(color);
		}
		color = getX3dColorFromString(rs.getString("x3d_specular_color"));
		if (color != null) {
			x3dMaterial.setSpecularColor(color);
		}
		color = getX3dColorFromString(rs.getString("x3d_emissive_color"));
		if (color != null) {
			x3dMaterial.setEmissiveColor(color);
		}
		x3dMaterial.setIsSmooth(rs.getInt("x3d_is_smooth") == 1);
	}
 

import oracle.jdbc.OracleResultSet; //导入依赖的package包/类
public WrappedOracleResultSet(ResultSet resultSet, String reference,
		JdbcEvent event) {
	super(resultSet, reference, event);
	oracleRs = (OracleResultSet) resultSet;
}
 

import oracle.jdbc.OracleResultSet; //导入依赖的package包/类
public WrappedOracleCalculatedResultSet(ResultSet resultSet, String reference,
		JdbcEvent event) {
	super(resultSet, reference, event);
	oracleRs = (OracleResultSet) resultSet;
}
 

import oracle.jdbc.OracleResultSet; //导入依赖的package包/类
protected List<PlacemarkType> createPlacemarksForFootprint(OracleResultSet rs, KmlSplittingResult work) throws SQLException {

		List<PlacemarkType> placemarkList = new ArrayList<PlacemarkType>();
		PlacemarkType placemark = kmlFactory.createPlacemarkType();
		placemark.setName(work.getGmlId());
		placemark.setId(DisplayForm.FOOTPRINT_PLACEMARK_ID + placemark.getName());

		if (work.getDisplayForm().isHighlightingEnabled()) {
			placemark.setStyleUrl("#" + getStyleBasisName() + DisplayForm.FOOTPRINT_STR + "Style");
		}
		else {
			placemark.setStyleUrl("#" + getStyleBasisName() + DisplayForm.FOOTPRINT_STR + "Normal");
		}

		if (getBalloonSettings().isIncludeDescription()) {
			addBalloonContents(placemark, work.getId());
		}
		MultiGeometryType multiGeometry = kmlFactory.createMultiGeometryType();
		placemark.setAbstractGeometryGroup(kmlFactory.createMultiGeometry(multiGeometry));

		PolygonType polygon = null; 
		while (rs.next()) {
			STRUCT buildingGeometryObj = (STRUCT)rs.getObject(1); 

			if (!rs.wasNull() && buildingGeometryObj != null) {
				eventDispatcher.triggerEvent(new GeometryCounterEvent(null, this));

				polygon = kmlFactory.createPolygonType();
				polygon.setTessellate(true);
				polygon.setExtrude(false);
				polygon.setAltitudeModeGroup(kmlFactory.createAltitudeMode(AltitudeModeEnumType.CLAMP_TO_GROUND));

				JGeometry groundSurface = convertToWGS84(JGeometry.load(buildingGeometryObj));
				int dim = groundSurface.getDimensions();
				for (int i = 0; i < groundSurface.getElemInfo().length; i = i+3) {
					LinearRingType linearRing = kmlFactory.createLinearRingType();
					BoundaryType boundary = kmlFactory.createBoundaryType();
					boundary.setLinearRing(linearRing);
					switch (groundSurface.getElemInfo()[i+1]) {
					case EXTERIOR_POLYGON_RING:
						polygon.setOuterBoundaryIs(boundary);
						break;
					case INTERIOR_POLYGON_RING:
						polygon.getInnerBoundaryIs().add(boundary);
						break;
					case POINT:
					case LINE_STRING:
						continue;
					default:
						Logger.getInstance().warn("Unknown geometry for " + work.getGmlId());
						continue;
					}

					double[] ordinatesArray = groundSurface.getOrdinatesArray();
					int startNextGeometry = ((i+3) < groundSurface.getElemInfo().length) ? 
							groundSurface.getElemInfo()[i+3] - 1: // still more geometries
								ordinatesArray.length; // default
							// order points counter-clockwise
							for (int j = startNextGeometry - dim; j >= groundSurface.getElemInfo()[i] - 1; j = j-dim) {
								linearRing.getCoordinates().add(String.valueOf(ordinatesArray[j] + "," + ordinatesArray[j+1] + ",0"));
							}
				}
				multiGeometry.getAbstractGeometryGroup().add(kmlFactory.createPolygon(polygon));
			}
		}
		if (polygon != null) { // if there is at least some content
			placemarkList.add(placemark);
		}
		return placemarkList;
	}
 

import oracle.jdbc.OracleResultSet; //导入依赖的package包/类
protected List<PlacemarkType> createPlacemarksForGeometry(OracleResultSet rs,
		KmlSplittingResult work) throws SQLException{
	return createPlacemarksForGeometry(rs, work, false, false);
}