Application: gvSIG desktop

package com.iver.cit.gvsig.jdbc_spatial;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

import java.util.Map;

import com.iver.cit.gvsig.fmap.drivers.DBLayerDefinition;

import com.iver.cit.gvsig.fmap.drivers.jdbc.postgis.PostGisDriver;

import com.iver.cit.gvsig.fmap.layers.LayerFactory;

import com.iver.utiles.extensionPoints.IExtensionBuilder;

/* gvSIG. Sistema de Informaci?n Geogr?fica de la Generalitat Valenciana

 *

 * Copyright (C) 2004 IVER T.I. and Generalitat Valenciana.

 *

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 2

 * of the License, or (at your option) any later version.

 *

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 *

 * You should have received a copy of the GNU General Public License

 * along with this program; if not, write to the Free Software

 * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307,USA.

 *

 * For more information, contact:

 *

 *  Generalitat Valenciana

 *   Conselleria d'Infraestructures i Transport

 *   Av. Blasco Ib??ez, 50

 *   46010 VALENCIA

 *   SPAIN

 *

 *      +34 963862235

 *   gvsig@gva.es

 *      www.gvsig.gva.es

 *

 *    or

 *

 *   IVER T.I. S.A

 *   Salamanca 50

 *   46005 Valencia

 *   Spain

 *

 *   +34 963163400

 *   dac@iver.es

 */

/* CVS MESSAGES:

 *

 * $Id: JDBCLayerBuilder.java 11150 2007-04-12 08:35:23Z  $

 * $Log$

 * Revision 1.2.4.3  2007-02-12 14:35:52  jmvivo

 * Quitado el soporte para Oracle spacial

 *

 * Revision 1.2  2006/04/18 06:19:06  jorpiell

 * Modificada la forma en la que se a?ade la clase que implementa la factor?a. Se tiene que pasar una instancia, y no una clase. Adem?s se la ha a?adido un constructor sin par?metros a la factoria.

 *

 * Revision 1.1  2006/04/11 11:54:38  jorpiell

 * Nueva clase que se usa para cargar una capa Postgis usando el mecanismo de extensibilidad

 *

 *

 */

/**

 * Creates a Postgis FLyrVect from a set of params

 * (URL, user name, password, ...). The catalog

 * extension uses this class to load a new layer

 * from a metadata.  

 * @author Jorge Piera Llodr? (piera_jor@gva.es)

 */

public class JDBCLayerBuilder implements IExtensionBuilder{

        public JDBCLayerBuilder(){

                super();

        }

        public Object create() {

                // TODO Auto-generated method stub

                return null;

        }

        public Object create(Object[] args) {

                // TODO Auto-generated method stub

                return null;

        }

        public Object create(Map args) {

                String dbURL = (String) args.get("DBURL");

                String user = (String) args.get((String) "USER");

                String pwd = (String) args.get((String) "PASSWORD");

                String layerName = (String) args.get((String) "NAME");

                String fidField = (String) args.get((String) "ID");

                String sFields = (String) args.get((String) "FIELDS");

                String[] fields = sFields.split(",");

                String geomField = (String) args.get((String) "GEOMFIELD");

                String tableName = (String) args.get((String) "TABLENAME");

                String whereClause = (String) args.get((String) "WHERECLAUSE");

                Connection conn;

                try {

                        conn = DriverManager.getConnection(dbURL, user, pwd);

                        conn.setAutoCommit(false);

                } catch (SQLException e) {

                        // TODO Auto-generated catch block

                        e.printStackTrace();

                        return null;

                }

                DBLayerDefinition lyrDef = new DBLayerDefinition();                

                lyrDef.setName(layerName);

                lyrDef.setTableName(tableName);

                lyrDef.setWhereClause(whereClause);

                lyrDef.setFieldNames(fields);

                lyrDef.setFieldGeometry(geomField);

                lyrDef.setFieldID(fidField);

                PostGisDriver pgd = new PostGisDriver();

                pgd.setData(conn, lyrDef);

                return LayerFactory.createDBLayer(pgd, layerName, null);

        }

}