| gvSIG desktop 1

package org.gvsig.remoteservices.conf.mapserver.test;

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

 * tat 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

*/

import java.io.File;

import java.io.IOException;

import java.sql.Date;

import java.sql.Types;

import java.util.Calendar;

import com.hardcode.gdbms.engine.data.DataSourceFactory;

import com.hardcode.gdbms.engine.data.driver.DriverException;

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

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

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

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

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

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

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

import com.iver.cit.gvsig.fmap.drivers.dbf.DBFDriver;

import com.iver.cit.gvsig.fmap.edition.DefaultRowEdited;

import com.iver.cit.gvsig.fmap.edition.EditionException;

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

/**

* @author fjp

*

* Abrimos un dbf y le a?adimos un campo. Lo rellenamos con la fecha actual con formato cadena.

*

*/

public class AddFieldToDBF  {

        public String dbfFile ="c:/0libro.dbf";

        public String fieldName = "date";

        public static void main(String[] args) {

                AddFieldToDBF prueba = new AddFieldToDBF();

                String []fechas = {"2000-12-01", "2000-11-17"};

                prueba.add("prb.dbf", "date", fechas);

        }

        public void add(String dbfFile, String fieldName, String[] values) {

       DBFDriver driver = new DBFDriver();

       File myFile = new File(dbfFile);

       try {

               System.out.println("Adding time to "+dbfFile);

               // Abrimos el fichero

                        driver.open(myFile);

                        // Comprobamos que tenemos acceso de escritura.

                        if (driver.canSaveEdits())

                        {

                                // Creamos el nuevo campo

                                FieldDescription dateField = new FieldDescription();

                                dateField.setFieldName(fieldName);

                                dateField.setFieldType(Types.VARCHAR);

                                dateField.setFieldLength(20);

                                // Creamos un array con el nuevo campo

                                ITableDefinition tableDef = driver.getTableDefinition();

                                FieldDescription[] oldFields = tableDef.getFieldsDesc();

                                int numOldFields = oldFields.length;

                                FieldDescription[] newFields = new FieldDescription[numOldFields + 1];

                                System.arraycopy(oldFields, 0, newFields, 0, numOldFields);

                                newFields[numOldFields] = dateField;

                                tableDef.setFieldsDesc(newFields);

                                driver.initialize(tableDef);

                                driver.preProcess();

                                Value[] att = new Value[newFields.length];

                                Calendar today = Calendar.getInstance();

                                for (int i=0; i < driver.getRowCount(); i++)

                                {

                                        for (int j=0; j < numOldFields; j++)

                                        {

                                                att[j] = driver.getFieldValue(i, j);

                                        }

                                        att[numOldFields] = ValueFactory.createValue(values[i]);

                                        DefaultRow row = new DefaultRow(att);

                                        DefaultRowEdited edRow = new DefaultRowEdited(row,

                                                        DefaultRowEdited.STATUS_MODIFIED, i);

                                        driver.process(edRow);

                                }

                                driver.postProcess();

                                System.out.println("Fichero modificado");

                        }

                        else

                        {

                                System.err.println("El fichero no tiene permiso de edici?n");

                        }

                        driver.close();

                } catch (IOException e) {

                        // TODO Auto-generated catch block

                        e.printStackTrace();

                } catch (EditionException e) {

                        // TODO Auto-generated catch block

                        e.printStackTrace();

                } catch (DriverException e) {

                        // TODO Auto-generated catch block

                        e.printStackTrace();

                }

        }

}