Application: gvSIG desktop

/* 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.hardcode.gdbms.driver.oracle;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.ResultSetMetaData;

import java.sql.SQLException;

import java.sql.Statement;

public class OracleTest {

        public static void main(String[] args)

        {

                try {

                        Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();

                } catch (InstantiationException e) {

                        // TODO Auto-generated catch block

                        e.printStackTrace();

                } catch (IllegalAccessException e) {

                        // TODO Auto-generated catch block

                        e.printStackTrace();

                } catch (ClassNotFoundException e) {

                        // TODO Auto-generated catch block

                        e.printStackTrace();

                }

                 String connString="jdbc:oracle:thin:@FPL:1521:SGF";

        try {

                        Connection conn = DriverManager.getConnection(connString, "SCOTT", "TIGER");

                        String sql = "SELECT * FROM DEPT";

                        ResultSet rs = conn.createStatement().executeQuery(sql);

                        ResultSetMetaData metaData = rs.getMetaData();

                        String fields = "";

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

                        {

                                if (i==0)

                                        fields =metaData.getColumnName(i+1);

                                else

                                        fields =fields + ", " + metaData.getColumnName(i+1);

                        }

                        rs.close();

                        String sqlAux = sql.replaceFirst(" [*] ", " " + fields + " ");

                        System.out.println(sqlAux);

                Statement st = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,

                        ResultSet.CONCUR_UPDATABLE);

                        rs = st.executeQuery(sqlAux);

                if (rs.getConcurrency() != ResultSet.CONCUR_UPDATABLE)

                {

                        System.err.println("Error: No se puede editar la tabla " + fields);

                }

                } catch (SQLException e) {

                        // TODO Auto-generated catch block

                        e.printStackTrace();

                }

        }

}