Revision 5007 trunk/extensions/extJDBC/src/com/iver/cit/gvsig/fmap/drivers/jdbc/postgis/testPostGis.java

View differences:

testPostGis.java
43 43 
 */
44 44 
package com.iver.cit.gvsig.fmap.drivers.jdbc.postgis;
45 45 

  		




  46
  
  
    
import java.awt.Shape;


  		




  47
  
  
    
import java.io.InputStream;


  		




  48
  
  
    
import java.sql.Blob;


  		




  49
  46
  
    
import java.sql.Connection;


  		




  50
  47
  
    
import java.sql.DriverManager;


  		




  51
  48
  
    
import java.sql.PreparedStatement;


  		




  ......




  54
  51
  
    
import java.sql.Statement;


  		




  55
  52
  
    
import java.util.Enumeration;


  		




  56
  53
  
    

  		




  57
  
  
    
import org.postgresql.core.Field;


  		




  58
  54
  
    
import org.postgresql.fastpath.Fastpath;


  		




  59
  
  
    
import org.postgresql.fastpath.FastpathArg;


  		




  60
  
  
    
import org.postgresql.largeobject.LargeObjectManager;


  		




  61
  
  
    
import org.postgresql.util.PGobject;


  		




  62
  55
  
    

  		




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


  		




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


  		




  
  58
  
    
import com.iver.cit.gvsig.fmap.drivers.jdbc.WKBParser2;


  		




  65
  59
  
    

  		




  66
  60
  
    

  		




  67
  61
  
    
/**


  		




  ......




  106
  100
  
    
              


  		




  107
  101
  
    
              


  		




  108
  102
  
    
              t1 = System.currentTimeMillis();


  		




  109
  
  
    
              test2(conn, dburl, dbuser, dbpass, dbtable);


  		




  
  103
  
    
              // test2(conn, dburl, dbuser, dbpass, dbtable);


  		




  110
  104
  
    
              t2 = System.currentTimeMillis();


  		




  111
  105
  
    
    


  		




  112
  106
  
    
              System.out.println("Tiempo de consulta2:" + (t2 - t1) + " milisegundos");


  		




  ......




  168
  162
  
    
            // ResultSet r = ps.executeQuery();


  		




  169
  163
  
    
                        


  		




  170
  164
  
    
              // ResultSet r = s.executeQuery(strSQL);


  		




  
  165
  
    
            WKBParser2 parser2 = new WKBParser2();


  		




  171
  166
  
    
            WKBParser parser = new WKBParser();


  		




  172
  167
  
    
            long id=0;


  		




  173
  168
  
    
            /* for (int i=1; i< 100; i++)


  		




  ......




  190
  185
  
    
              */ 


  		




  191
  186
  
    
                // Object obj = r.getObject(2);


  		




  192
  187
  
    
                byte[] arrayByte = r.getBytes(1);


  		




  193
  
  
    
                IGeometry gp = parser.parse(arrayByte);


  		




  
  188
  
    
                


  		




  
  189
  
    
                // IGeometry gp = parser.parse(arrayByte);


  		




  
  190
  
    
                IGeometry gp2 = parser2.parse(arrayByte);


  		




  
  191
  
    
            	


  		




  194
  192
  
    
                // String strAux = r.getString(2);


  		




  195
  193
  
    
                // int id = r.getInt(2);


  		




  196
  194
  
    
                // System.out.println("Fila " + id + ":" + obj.toString());


  		












Also available in:  Unified diff