| gvSIG desktop 1

/* gvSIG. Geographic Information System of the Valencian Government

*

* Copyright (C) 2007-2008 Infrastructures and Transports Department

* of the Valencian Government (CIT)

*

* 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., 51 Franklin Street, Fifth Floor, Boston,

* MA  02110-1301, USA.

*

*/

/*

* AUTHORS (In addition to CIT):

* 2008 Geographic Information research group: http://www.geoinfo.uji.es

* Departamento de Lenguajes y Sistemas Inform?ticos (LSI)

* Universitat Jaume I

* {{Task}}

*/

package org.gvsig.metadata.extended.persistence;

import org.gvsig.metadata.extended.ExtendedMetadata;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

public class H2Persistence implements MDPersistence{

        Connection conn = null;

        public H2Persistence() {

                        try {

                                Class.forName("org.h2.Driver");

                                conn = DriverManager.getConnection("jdbc:h2:~/extMetadata", "gvsig", "metadata");

                        } catch (ClassNotFoundException e) {

                                // TODO Auto-generated catch block

                                e.printStackTrace();

                        } catch (SQLException e) {

                                // TODO Auto-generated catch block

                                e.printStackTrace();

                        }

        }

        public boolean recoverMD(ExtendedMetadata md) {

                return false;

        }

        public boolean queryMD(String s) {

                String sql = "SELECT * FROM TEST";

                PreparedStatement prep;

                try {

                        prep = conn.prepareStatement(sql);

                        ResultSet rs = prep.executeQuery();

                        while (rs.next()) {

                                String id = rs.getString(1);

                                String name = rs.getString(2);

                                System.out.println("ID: " + id);

                                System.out.println("NAME: " + name);

                        }

                } catch (SQLException e) {

                        // TODO Auto-generated catch block

                        e.printStackTrace();

                }

                return false;

        }

        public boolean storeMD(ExtendedMetadata md) {

                return false;

        }

        public void createDB() {

        }

}