Application: gvSIG desktop

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import com.hardcode.gdbms.driver.postgresql.PostgreSQLDriver;

import com.iver.cit.gvsig.fmap.edition.writers.JdbcWriter;

		// Para postgres:

		// primero creamos 2 tablas y luego usamos JdbcWriter para a?adir los campos

		// y rellenar las tablas

		/* JdbcWriter pgEdgeWriter = new JdbcWriter();

		pgEdgeWriter.setCreateTable(true);

		pgEdgeWriter.setWriteAll(true);

		JdbcWriter pgNodeWriter = new JdbcWriter();

		pgNodeWriter.setCreateTable(true);

		pgNodeWriter.setWriteAll(true);

		PostgreSQLDriver pgDriver = new PostgreSQLDriver();

		Connection conn = pgDriver.getConnection("localhost", 5432, "latin1", "postgres", "aquilina");

		Statement stCreate = conn.createStatement();

		try {

			stCreate.execute("DROP TABLE nodes;");

		} catch (SQLException e1) {

			// Si no existe la tabla, no hay que borrarla.

		}

		try {

			stCreate.execute("DROP TABLE edges;");

		} catch (SQLException e1) {

			// Si no existe la tabla, no hay que borrarla.

		}

		stCreate.execute("CREATE TABLE nodes (id int4, x float8, y float8);");

		stCreate.execute("CREATE TABLE edges ();");

		conn.commit();

		conn.setAutoCommit(false);

		Statement st = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,

				ResultSet.CONCUR_UPDATABLE);

		ResultSet res = st.executeQuery("SELECT nodes.oid, nodes.* FROM nodes;");

		if (res.getConcurrency() != ResultSet.CONCUR_UPDATABLE) {

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

			return;

		}

		// res.moveToInsertRow();

		ResultSet resEdges = st.executeQuery("SELECT edges.oid, edges.* FROM edges;");

		pgEdgeWriter.initialize(conn, res);

		pgNodeWriter.initialize(conn, resEdges);

		netBuilder.setEdgeWriter(pgEdgeWriter);

		netBuilder.setNodeWriter(pgNodeWriter); */