svn-gvsig-desktop / tags / v1_1_Build_1013 / libraries / libFMap / src / com / iver / cit / gvsig / fmap / drivers / XTypes.java @ 13521
History | View | Annotate | Download (6.8 KB)
| 1 | 5634 | fjp | /*
|
|---|---|---|---|
| 2 | * Created on 26-oct-2005
|
||
| 3 | *
|
||
| 4 | * gvSIG. Sistema de Informaci?n Geogr?fica de la Generalitat Valenciana
|
||
| 5 | 12472 | jmvivo | *
|
| 6 | 5634 | fjp | * Copyright (C) 2004 IVER T.I. and Generalitat Valenciana.
|
| 7 | 12472 | jmvivo | *
|
| 8 | 5634 | fjp | * This program is free software; you can redistribute it and/or
|
| 9 | * modify it under the terms of the GNU General Public License
|
||
| 10 | * as published by the Free Software Foundation; either version 2
|
||
| 11 | * of the License, or (at your option) any later version.
|
||
| 12 | 12472 | jmvivo | *
|
| 13 | 5634 | fjp | * This program is distributed in the hope that it will be useful,
|
| 14 | * but WITHOUT ANY WARRANTY; without even the implied warranty of
|
||
| 15 | * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
|
||
| 16 | * GNU General Public License for more details.
|
||
| 17 | 12472 | jmvivo | *
|
| 18 | 5634 | fjp | * You should have received a copy of the GNU General Public License
|
| 19 | * along with this program; if not, write to the Free Software
|
||
| 20 | * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
|
||
| 21 | 12472 | jmvivo | *
|
| 22 | 5634 | fjp | * For more information, contact:
|
| 23 | *
|
||
| 24 | * Generalitat Valenciana
|
||
| 25 | * Conselleria d'Infraestructures i Transport
|
||
| 26 | * Av. Blasco Ib??ez, 50
|
||
| 27 | * 46010 VALENCIA
|
||
| 28 | * SPAIN
|
||
| 29 | *
|
||
| 30 | * +34 963862235
|
||
| 31 | * gvsig@gva.es
|
||
| 32 | * www.gvsig.gva.es
|
||
| 33 | 12472 | jmvivo | *
|
| 34 | 5634 | fjp | * or
|
| 35 | 12472 | jmvivo | *
|
| 36 | 5634 | fjp | * IVER T.I. S.A
|
| 37 | * Salamanca 50
|
||
| 38 | * 46005 Valencia
|
||
| 39 | * Spain
|
||
| 40 | 12472 | jmvivo | *
|
| 41 | 5634 | fjp | * +34 963163400
|
| 42 | * dac@iver.es
|
||
| 43 | */
|
||
| 44 | package com.iver.cit.gvsig.fmap.drivers; |
||
| 45 | |||
| 46 | 7095 | fjp | import java.math.BigDecimal; |
| 47 | 5634 | fjp | import java.nio.ByteBuffer; |
| 48 | import java.sql.ResultSet; |
||
| 49 | import java.sql.ResultSetMetaData; |
||
| 50 | import java.sql.SQLException; |
||
| 51 | 7095 | fjp | import java.sql.Timestamp; |
| 52 | 5634 | fjp | import java.sql.Types; |
| 53 | |||
| 54 | import com.hardcode.gdbms.engine.values.BooleanValue; |
||
| 55 | import com.hardcode.gdbms.engine.values.DateValue; |
||
| 56 | import com.hardcode.gdbms.engine.values.DoubleValue; |
||
| 57 | import com.hardcode.gdbms.engine.values.FloatValue; |
||
| 58 | import com.hardcode.gdbms.engine.values.IntValue; |
||
| 59 | import com.hardcode.gdbms.engine.values.LongValue; |
||
| 60 | import com.hardcode.gdbms.engine.values.NullValue; |
||
| 61 | 6990 | fjp | import com.hardcode.gdbms.engine.values.ShortValue; |
| 62 | 5634 | fjp | import com.hardcode.gdbms.engine.values.StringValue; |
| 63 | 6990 | fjp | import com.hardcode.gdbms.engine.values.TimeValue; |
| 64 | import com.hardcode.gdbms.engine.values.TimestampValue; |
||
| 65 | 5634 | fjp | import com.hardcode.gdbms.engine.values.Value; |
| 66 | import com.hardcode.gdbms.engine.values.ValueFactory; |
||
| 67 | |||
| 68 | 7095 | fjp | public class XTypes { |
| 69 | 12472 | jmvivo | public final static double NUM_msSecs2000 = 9.466776E11; |
| 70 | 7095 | fjp | public final static int POINT2D = 100; |
| 71 | |||
| 72 | public final static int LINE2D = 101; |
||
| 73 | |||
| 74 | public final static int POLYGON2D = 102; |
||
| 75 | |||
| 76 | public final static int MULTI2D = 103; |
||
| 77 | |||
| 78 | public static String fieldTypeToString(int fieldType) { |
||
| 79 | String aux = "text"; // Por defecto. |
||
| 80 | switch (fieldType) {
|
||
| 81 | case Types.SMALLINT: |
||
| 82 | aux = "integer";
|
||
| 83 | break;
|
||
| 84 | case Types.INTEGER: |
||
| 85 | aux = "integer";
|
||
| 86 | break;
|
||
| 87 | case Types.BIGINT: |
||
| 88 | aux = "integer";
|
||
| 89 | break;
|
||
| 90 | case Types.BOOLEAN: |
||
| 91 | aux = "boolean";
|
||
| 92 | break;
|
||
| 93 | case Types.DECIMAL: |
||
| 94 | aux = "numeric";
|
||
| 95 | break;
|
||
| 96 | case Types.DOUBLE: |
||
| 97 | aux = "float8";
|
||
| 98 | break;
|
||
| 99 | case Types.FLOAT: |
||
| 100 | aux = "float";
|
||
| 101 | break;
|
||
| 102 | case Types.CHAR: |
||
| 103 | aux = "char";
|
||
| 104 | break;
|
||
| 105 | case Types.VARCHAR: |
||
| 106 | aux = "text";
|
||
| 107 | break;
|
||
| 108 | case Types.LONGVARCHAR: |
||
| 109 | aux = "text";
|
||
| 110 | break;
|
||
| 111 | |||
| 112 | case POINT2D:
|
||
| 113 | aux = "POINT";
|
||
| 114 | break;
|
||
| 115 | case LINE2D:
|
||
| 116 | aux = "MULTILINESTRING";
|
||
| 117 | break;
|
||
| 118 | case POLYGON2D:
|
||
| 119 | aux = "MULTIPOLYGON";
|
||
| 120 | break;
|
||
| 121 | case MULTI2D:
|
||
| 122 | aux = "GEOMETRY";
|
||
| 123 | break;
|
||
| 124 | |||
| 125 | } |
||
| 126 | |||
| 127 | return aux;
|
||
| 128 | } |
||
| 129 | |||
| 130 | 5634 | fjp | /**
|
| 131 | * @param fieldId
|
||
| 132 | * @throws SQLException
|
||
| 133 | */
|
||
| 134 | public static Value getValue(ResultSet rs, int fieldId) throws SQLException { |
||
| 135 | byte[] data; |
||
| 136 | data = rs.getBytes(fieldId); |
||
| 137 | Value val = null;
|
||
| 138 | ResultSetMetaData metaData = rs.getMetaData();
|
||
| 139 | if (data == null) |
||
| 140 | val = ValueFactory.createNullValue(); |
||
| 141 | else {
|
||
| 142 | ByteBuffer buf = ByteBuffer.wrap(data); |
||
| 143 | if (metaData.getColumnType(fieldId) == Types.VARCHAR) |
||
| 144 | val = ValueFactory.createValue(rs.getString(fieldId)); |
||
| 145 | if (metaData.getColumnType(fieldId) == Types.FLOAT) |
||
| 146 | val = ValueFactory.createValue(buf.getFloat()); |
||
| 147 | if (metaData.getColumnType(fieldId) == Types.DOUBLE) |
||
| 148 | val = ValueFactory.createValue(buf.getDouble()); |
||
| 149 | if (metaData.getColumnType(fieldId) == Types.INTEGER) |
||
| 150 | val = ValueFactory.createValue(buf.getInt()); |
||
| 151 | 6990 | fjp | if (metaData.getColumnType(fieldId) == Types.SMALLINT) |
| 152 | val = ValueFactory.createValue(buf.getShort()); |
||
| 153 | if (metaData.getColumnType(fieldId) == Types.TINYINT) |
||
| 154 | 7095 | fjp | val = ValueFactory.createValue(buf.getShort()); |
| 155 | 5634 | fjp | if (metaData.getColumnType(fieldId) == Types.BIGINT) |
| 156 | val = ValueFactory.createValue(buf.getLong()); |
||
| 157 | 12534 | jmvivo | if (metaData.getColumnType(fieldId) == Types.BIT || metaData.getColumnType(fieldId) == Types.BOOLEAN ) |
| 158 | 5634 | fjp | val = ValueFactory.createValue(rs.getBoolean(fieldId)); |
| 159 | if (metaData.getColumnType(fieldId) == Types.DATE) |
||
| 160 | val = ValueFactory.createValue(rs.getDate(fieldId)); |
||
| 161 | 6990 | fjp | if (metaData.getColumnType(fieldId) == Types.TIME) |
| 162 | val = ValueFactory.createValue(rs.getTime(fieldId)); |
||
| 163 | if (metaData.getColumnType(fieldId) == Types.TIMESTAMP) |
||
| 164 | val = ValueFactory.createValue(rs.getTimestamp(fieldId)); |
||
| 165 | 7095 | fjp | |
| 166 | 12534 | jmvivo | |
| 167 | |||
| 168 | 5634 | fjp | } |
| 169 | return val;
|
||
| 170 | } |
||
| 171 | |||
| 172 | 7095 | fjp | public static void updateValue(ResultSet rs, int fieldId_ceroBased, |
| 173 | Value val) throws SQLException { |
||
| 174 | 5634 | fjp | if (val instanceof NullValue) |
| 175 | return;
|
||
| 176 | 5700 | fjp | // byte[] data;
|
| 177 | 5634 | fjp | ResultSetMetaData metaData = rs.getMetaData();
|
| 178 | int fieldId = fieldId_ceroBased + 1; |
||
| 179 | 5700 | fjp | // System.out.println("EScritrua: " + metaData.isDefinitelyWritable(1));
|
| 180 | 7095 | fjp | switch (val.getSQLType()) {
|
| 181 | 5634 | fjp | case Types.VARCHAR: |
| 182 | case Types.LONGVARCHAR: |
||
| 183 | 5663 | fjp | // Para evitar escribir en el campo geometria:
|
| 184 | if (metaData.getColumnType(fieldId) == Types.OTHER) |
||
| 185 | return;
|
||
| 186 | 5634 | fjp | StringValue valStr = (StringValue) val; |
| 187 | rs.updateString(fieldId, valStr.getValue()); |
||
| 188 | 7095 | fjp | // System.out.println("Field " + fieldId + " :" +
|
| 189 | // metaData.getColumnTypeName(fieldId));
|
||
| 190 | 5634 | fjp | break;
|
| 191 | case Types.FLOAT: |
||
| 192 | FloatValue vFloat = (FloatValue) val; |
||
| 193 | rs.updateFloat(fieldId, vFloat.getValue()); |
||
| 194 | break;
|
||
| 195 | case Types.DOUBLE: |
||
| 196 | DoubleValue vDouble = (DoubleValue) val; |
||
| 197 | rs.updateDouble(fieldId, vDouble.getValue()); |
||
| 198 | break;
|
||
| 199 | case Types.INTEGER: |
||
| 200 | 6990 | fjp | IntValue vInt = (IntValue) val; |
| 201 | 7095 | fjp | rs.updateInt(fieldId, vInt.getValue()); |
| 202 | 12472 | jmvivo | break;
|
| 203 | 5663 | fjp | case Types.SMALLINT: |
| 204 | 6990 | fjp | ShortValue vShort = (ShortValue) val; |
| 205 | rs.updateShort(fieldId, vShort.shortValue()); |
||
| 206 | 5634 | fjp | break;
|
| 207 | case Types.BIGINT: |
||
| 208 | LongValue vLong = (LongValue) val; |
||
| 209 | rs.updateLong(fieldId, vLong.getValue()); |
||
| 210 | break;
|
||
| 211 | case Types.BIT: |
||
| 212 | case Types.BOOLEAN: |
||
| 213 | BooleanValue vBool = (BooleanValue) val; |
||
| 214 | rs.updateBoolean(fieldId, vBool.getValue()); |
||
| 215 | break;
|
||
| 216 | case Types.DATE: |
||
| 217 | 6990 | fjp | DateValue vDate = (DateValue) val; |
| 218 | 7095 | fjp | rs.updateDate(fieldId, vDate.getValue()); |
| 219 | 12472 | jmvivo | break;
|
| 220 | 5663 | fjp | case Types.TIME: |
| 221 | 6990 | fjp | TimeValue vTime = (TimeValue) val; |
| 222 | rs.updateTime(fieldId, vTime.getValue()); |
||
| 223 | 5634 | fjp | break;
|
| 224 | 6990 | fjp | case Types.TIMESTAMP: |
| 225 | TimestampValue vTimeStamp = (TimestampValue) val; |
||
| 226 | rs.updateTimestamp(fieldId, vTimeStamp.getValue()); |
||
| 227 | break;
|
||
| 228 | 7095 | fjp | |
| 229 | 5634 | fjp | default:
|
| 230 | 7095 | fjp | System.err.println("Tipo no soportado:" |
| 231 | + metaData.getColumnType(fieldId) + ". Field:" + fieldId
|
||
| 232 | + ": " + metaData.getColumnName(fieldId));
|
||
| 233 | // throw new UnsupportedOperationException();
|
||
| 234 | |||
| 235 | 5634 | fjp | } |
| 236 | } |
||
| 237 | |||
| 238 | } |