Application: gvSIG desktop

/*

 * Created on 11-mar-2005

 *

 * 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

 */

package com.iver.cit.gvsig.fmap.drivers.jdbc.mysql;

import java.sql.ResultSet;

import java.sql.ResultSetMetaData;

import java.sql.SQLException;

import java.sql.Types;

import com.hardcode.gdbms.engine.values.Value;

import com.hardcode.gdbms.engine.values.ValueFactory;

import com.iver.cit.gvsig.fmap.core.DefaultFeature;

import com.iver.cit.gvsig.fmap.core.IFeature;

import com.iver.cit.gvsig.fmap.core.IGeometry;

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

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

import com.iver.cit.gvsig.fmap.drivers.jdbc.WKBParser;

/**

 * @author FJP

 *

 * TODO To change the template for this generated type comment go to

 * Window - Preferences - Java - Code Generation - Code and Comments

 */

public class MySqlFeatureIterator implements IFeatureIterator {

    private WKBParser parser = new WKBParser();

    ResultSet rs;

    String strAux;

    IGeometry geom;

    int numColumns;

    int idFieldID = -1;

    int[] relIds;

    private DBLayerDefinition lyrDef;

    private ResultSetMetaData metaData = null;

    Value[] regAtt;

    /**

     * @throws SQLException

     * 

     */

    public MySqlFeatureIterator(ResultSet rs) {

        // Debe ser forward only

        this.rs = rs;

        try {

            numColumns = rs.getMetaData().getColumnCount();

            regAtt = new Value[numColumns-1];

            metaData = rs.getMetaData();

        } catch (SQLException e) {

            // TODO Auto-generated catch block

            e.printStackTrace();

        }

    }

    /* (non-Javadoc)

     * @see com.iver.cit.gvsig.fmap.drivers.jdbc.GeometryIterator#hasNext()

     */

    public boolean hasNext() throws SQLException {

        if (rs.next())

            return true;

        else

        {

            closeIterator();

            return false;

        }

    }

    /* (non-Javadoc)

     * @see com.iver.cit.gvsig.fmap.drivers.jdbc.GeometryIterator#next()

     */

    public IFeature next() throws SQLException {

        byte[] data = rs.getBytes(1);                

        geom = parser.parse(data);

        for (int fieldId=2; fieldId <= numColumns; fieldId++ )

        {

            Value val = null;

            if (metaData.getColumnType(fieldId) == Types.VARCHAR)

            {

                String strAux = rs.getString(fieldId);

                if (strAux == null) strAux = "";

                val =  ValueFactory.createValue(strAux);

            }

            if (metaData.getColumnType(fieldId) == Types.FLOAT)

                val = ValueFactory.createValue(rs.getFloat(fieldId));

            if (metaData.getColumnType(fieldId) == Types.DOUBLE)

                val = ValueFactory.createValue(rs.getDouble(fieldId));

            if (metaData.getColumnType(fieldId) == Types.INTEGER)

                val = ValueFactory.createValue(rs.getInt(fieldId));

            if (metaData.getColumnType(fieldId) == Types.BIGINT)

                val = ValueFactory.createValue(rs.getLong(fieldId));

            if (metaData.getColumnType(fieldId) == Types.BIT)

                val = ValueFactory.createValue(rs.getBoolean(fieldId));

            if (metaData.getColumnType(fieldId) == Types.DATE)

                val = ValueFactory.createValue(rs.getDate(fieldId));

            regAtt[relIds[fieldId-2]] = val;

        }

        // TODO: Aqu? habr?a que usar una Factor?a.

        IFeature feat = null;

        if (idFieldID != -1)

        {

            String theID = regAtt[lyrDef.getIdFieldID()].toString();

            feat = new DefaultFeature(geom, regAtt, theID);

        }

        else

            feat = new DefaultFeature(geom, regAtt);

        return feat;

    }

    /* (non-Javadoc)

     * @see com.iver.cit.gvsig.fmap.drivers.IFeatureIterator#closeIterator()

     */

    public void closeIterator() throws SQLException {

        rs.close();

    }

    public void setLyrDef(DBLayerDefinition lyrDef)

    {

        this.lyrDef  =lyrDef;

        // Aunque no nos hayan pedido todos los campos, devolveremos

        // tantos atributos como la capa tiene. Eso s?, puestos a null

        regAtt = new Value[lyrDef.getFieldNames().length];

        relIds = new int[numColumns-1];

        try {

            for (int i=2; i<= metaData.getColumnCount(); i++)

            {

                int idRel = lyrDef.getFieldIdByName(metaData.getColumnName(i));

                relIds[i-2] = idRel;

                if (lyrDef.getFieldID().equals(metaData.getColumnName(i)))

                {

                    idFieldID = i;

                    break;

                }

            }

        } catch (SQLException e) {

            // Si no est?, no pasa nada

        }

    }

}