Java JDBCDataStore类代码示例

import org.geotools.jdbc.JDBCDataStore; //导入依赖的package包/类
/**
     * Calculates the UrbanGrid area/perimeters for each Administrative area inside a separate thread.
     * 
     * @param year Input ShapeFile year
     * @param imperviousnessReference Input ShapeFile layer
     * @param rois List of all the input Geometries
     * @param numThreads Number of threads to lauch
     * @param area Boolean indicating if area must be calculated. (Otherwise perimeter is calculated)
     * @return
     * @throws MalformedURLException
     * @throws IOException
     * @throws InterruptedException
     */
    private List<ListContainer> calculateGeometries(String year, FeatureTypeInfo imperviousnessReference, List<Geometry> rois,
            int numThreads, boolean area) throws MalformedURLException, IOException,
            InterruptedException {
        // Initialization of the CountDown latch for handling multiple threads together
        latch = new CountDownLatch(numThreads);
        // Datastore creation
        final JDBCDataStore ds = (JDBCDataStore) imperviousnessReference.getStore().getDataStore(null);
        // ThreadPoolExecutor object used for launching multiple threads simultaneously
        ThreadPoolExecutor executor = new ThreadPoolExecutor(numThreads, numThreads, 60,
                TimeUnit.SECONDS, new ArrayBlockingQueue<Runnable>(1000000));
        // Final list containing the result calculated by each thread
        List<ListContainer> allLists = new ArrayList<ListContainer>(numThreads);
        // Cycle on the input geometries
        for (Geometry geo : rois) {
            // Creation of a new ListContainer object
            ListContainer container = new ListContainer();
            allLists.add(container);
            // Creation of a new Runnable for the UrbanGrids computation
            MyRunnable run = new MyRunnable(year, geo, imperviousnessReference, ds, container, area);
            executor.execute(run);
        }
        // Waiting until all the threads have finished
        latch.await();
        // Executor closure
        executor.shutdown();

        executor.awaitTermination(30, TimeUnit.SECONDS);

        // Datastore disposal
//        ds.dispose();

        return allLists;
    }
 

import org.geotools.jdbc.JDBCDataStore; //导入依赖的package包/类
/**
 * Default constructor
 * 
 * @param au
 * @param geoCodingReference
 * @param populationReference
 * @throws IOException
 */
public SoilSealingAdministrativeUnit(String au, FeatureTypeInfo geoCodingReference,
        FeatureTypeInfo populationReference) throws IOException {
    if (!au.contains("_")) {
        throw new IOException("Invalid Administrative Unit name");
    }
    this.geoCodingReference = geoCodingReference;
    this.populationReference = populationReference;
    this.name = au.split("_")[0];
    this.parent = au.split("_")[1];

    FeatureReader<SimpleFeatureType, SimpleFeature> ftReader = null;
    Transaction transaction = new DefaultTransaction();
    try {
        final JDBCDataStore ds = (JDBCDataStore) geoCodingReference.getStore().getDataStore(null);
        Filter nameFilter = ff.equals(ff.property("name"), ff.literal(this.name));
        Filter parentFilter = ff.equals(ff.property("parent"), ff.literal(this.parent));
        Filter queryFilter = ff.and(Arrays.asList(nameFilter, parentFilter));
        Query query = new Query(geoCodingReference.getFeatureType().getName().getLocalPart(), queryFilter);
        
        ftReader = ds.getFeatureReader(query, transaction);

        while (ftReader.hasNext()) {
            Feature feature = ftReader.next();
            this.type = AuType.getType((Integer) feature.getProperty("type").getValue());
            this.the_geom = (Geometry) feature.getDefaultGeometryProperty().getValue();
            break;
        }
    } finally {
        if (ftReader != null) {
            ftReader.close();
        }

        transaction.commit();
        transaction.close();
    }

    if (this.type == null || this.the_geom == null) {
        throw new IOException("Invalid Administrative Unit name: no record found!");
    }

    switch (this.type) {
    case MUNICIPALITY:
        loadPopulationStatistics(this);
        break;
    case DISTRICT:
    case REGION:
        loadSubs(this);
        break;
    default:
        break;
    }
}
 

import org.geotools.jdbc.JDBCDataStore; //导入依赖的package包/类
/**
 * 
 * @param soilSealingAdministrativeUnit
 * @throws IOException
 */
private void loadPopulationStatistics(SoilSealingAdministrativeUnit soilSealingAdministrativeUnit) throws IOException {
    FeatureReader<SimpleFeatureType, SimpleFeature> ftReader = null;
    Transaction transaction = new DefaultTransaction();
    try {
        final JDBCDataStore ds = (JDBCDataStore) populationReference.getStore().getDataStore(null);
        Filter auNameFilter = ff.equals(ff.property("au_name"), ff.literal(this.name));
        Filter queryFilter = ff.and(Arrays.asList(auNameFilter));
        Query query = new Query(populationReference.getFeatureType().getName().getLocalPart(), queryFilter);

        ftReader = ds.getFeatureReader(query, transaction);
        
        while (ftReader.hasNext()) {
            Feature feature = ftReader.next();
            Collection<Property> properties = feature.getProperties();
            for (Property prop : properties) {
                if (prop.getName().getLocalPart().startsWith("a_")) {
                    Object yearPopulationValue = prop.getValue();
                    if (yearPopulationValue != null) {
                        population.put(prop.getName().getLocalPart().split("a_")[1], ((BigDecimal) yearPopulationValue).intValue());
                    }
                }
            }
        }
    } finally {
        if (ftReader != null) {
            ftReader.close();
        }

        transaction.commit();
        transaction.close();
    }
}
 

import org.geotools.jdbc.JDBCDataStore; //导入依赖的package包/类
@Override
protected JDBCDataStore createDataStoreInternal(JDBCDataStore dataStore, Map params)
        throws IOException {
		// disable fetch size
		// not fully supported by MonetDB 	
		dataStore.setFetchSize(0);
	
        return dataStore;
    }
 

import org.geotools.jdbc.JDBCDataStore; //导入依赖的package包/类
public MonetDBDialect(JDBCDataStore dataStore) {
    super(dataStore);
}
 

import org.geotools.jdbc.JDBCDataStore; //导入依赖的package包/类
protected SQLDialect createSQLDialect(JDBCDataStore dataStore) {
	 return new MonetDBDialect(dataStore);
}
 

import org.geotools.jdbc.JDBCDataStore; //导入依赖的package包/类
public void testCreateDataStore() throws Exception {
    JDBCDataStore ds = factory.createDataStore( params );
    assertNotNull( ds );
    assertTrue(ds.getDataSource() instanceof ManageableDataSource);
    ds.dispose();
}