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

View differences:

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

  		




  46
  46
  
    
import java.awt.geom.Rectangle2D;


  		




  
  47
  
    
import java.nio.Buffer;


  		




  47
  48
  
    
import java.nio.ByteBuffer;


  		




  
  49
  
    
import java.nio.ByteOrder;


  		




  48
  50
  
    
import java.sql.Connection;


  		




  49
  51
  
    
import java.sql.Date;


  		




  50
  52
  
    
import java.sql.DriverManager;


  		




  ......




  218
  220
  
    
                // IGeometry gp = parser.parse(arrayByte);


  		




  219
  221
  
    
                // IGeometry gp2 = parser2.parse(arrayByte);


  		




  220
  222
  
    
            	


  		




  221
  
  
    
                String strAux = r.getString(2);


  		




  
  223
  
    
                String strAux = r.getString(5);


  		




  
  224
  
    
                System.out.println("Straux = " + strAux);


  		




  222
  225
  
    
//                long asLong = r.getLong(2);


  		




  223
  226
  
    
//                double asDouble = r.getDouble(2);


  		




  224
  227
  
    
//                Date asDate = r.getDate(2);


  		




  ......




  236
  239
  
    
                Date realDate1 = new Date(real_msecs_date1);


  		




  237
  240
  
    
                System.err.println("Date1 = " + realDate1 + " diff = " + (real_msecs_date1 - num_msSecs2000));


  		




  238
  241
  
    
                


  		




  
  242
  
    
                Calendar cal = new GregorianCalendar();


  		




  
  243
  
    
                cal.setTimeInMillis(0);


  		




  
  244
  
    
                // bufTime1.order(ByteOrder.LITTLE_ENDIAN);


  		




  239
  245
  
    
                long microsecs = bufTime1.getLong();


  		




  240
  
  
    
                long real_msecs = (long) (microsecs-num_msSecs2000);


  		




  
  246
  
    
                long real_msecs = microsecs - 3600000; // le quitamos una hora.


  		




  
  247
  
    
                cal.setTimeInMillis(real_msecs);


  		




  
  248
  
    
                long milis = cal.getTimeInMillis();


  		




  241
  249
  
    
                Time mytime1 = new Time(real_msecs);


  		




  242
  
  
    
                System.err.println("TIME1 = " + mytime1);


  		




  
  250
  
    
                Date mytime1asdate = new Date(real_msecs);


  		




  
  251
  
    
                System.err.println("microsecs = " + microsecs + " TIME1 = " + mytime1);


  		




  
  252
  
    
                System.err.println("microsecs = " + (long)num_msSecs2000 + " TIME1ASDATE = " + mytime1asdate);


  		




  243
  253
  
    

  		




  244
  254
  
    
				


  		




  245
  255
  
    
				double n1 = buf.getDouble(0); // num segs after 2000


  		












Also available in:  Unified diff