dive4elements/gnv-client: geo-backend/src/main/java/de/intevation/gnv/geobackend/sde/datasources/Row.java annotate

annotate geo-backend/src/main/java/de/intevation/gnv/geobackend/sde/datasources/Row.java @ 268:71b2f263f036

Add WKT-Syntaxt to Shape ReturnValue geo-backend/trunk@218 c6561f87-3c4e-4783-a992-168aeb5c3f6f

author	Tim Englich <tim.englich@intevation.de>
date	Wed, 14 Oct 2009 10:01:45 +0000
parents	031ef9649cd1
children	69ddef25e822

rev	line source
129 110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	1 /**
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	2 * Title: Row, $Header: /share/gdi/SDI-Suite/Repository/projekte/BSH-GDI/genericViewer/src/main/java/de/conterra/bsh/gdi/gnviewer/datasources/Row.java,v 1.4 2008/01/30 12:38:34 blume Exp $
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	3 * Source: $Source: /share/gdi/SDI-Suite/Repository/projekte/BSH-GDI/genericViewer/src/main/java/de/conterra/bsh/gdi/gnviewer/datasources/Row.java,v $
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	4 * created by: Stefan Blume (blume)
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	5 * erstellt am: 21.11.2007
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	6 * Copyright: con terra GmbH, 2005
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	7 *
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	8 * modified by: $Author: blume $
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	9 * modified on: $Date: 2008/01/30 12:38:34 $
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	10 * Version: $Revision: 1.4 $
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	11 * TAG: $Name: $
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	12 * locked from: $Locker: $
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	13 * CVS State: $State: Exp $
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	14 * Project: $ProjectName$
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	15 */
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	16 package de.intevation.gnv.geobackend.sde.datasources;
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	17
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	18 import java.util.ArrayList;
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	19 import java.util.Calendar;
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	20 import java.util.Date;
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	21
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	22 import org.apache.log4j.Logger;
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	23
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	24 import com.esri.sde.sdk.client.SDEPoint;
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	25 import com.esri.sde.sdk.client.SeException;
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	26 import com.esri.sde.sdk.client.SeShape;
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	27
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	28 import de.intevation.gnv.geobackend.sde.datasources.exception.TechnicalException;
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	29 import de.intevation.gnv.geobackend.util.DateUtils;
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	30
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	31 /**
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	32 * A Row represents a set of values.
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	33 * In a technical manner (e.g. database manner) a row contains all attributes of a single "hit".
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	34 *
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	35 * @author blume
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	36 * @version 1.0
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	37 * @serial 1.0
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	38 * @see
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	39 * @since 21.11.2007 11:00:54
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	40 */
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	41 public class Row {
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	42
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	43 /**
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	44 * Default Logging instance
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	45 */
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	46 private static Logger sLogger = Logger.getLogger(Row.class);
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	47 private static boolean sDebug = sLogger.isDebugEnabled();
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	48
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	49 /**
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	50 * Data container.
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	51 */
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	52 private Object[] mObjects;
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	53
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	54 /**
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	55 * Constructor.
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	56 *
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	57 * @param pRowSize the number of attributes contained by this row.
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	58 */
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	59 public Row(int pRowSize) {
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	60 mObjects = new Object[pRowSize];
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	61 }
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	62
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	63 /**
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	64 * Constructor.
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	65 *
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	66 * @param ArrayStr a line from CSV-File.
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	67 */
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	68 public Row (String[] ArrayStr){
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	69 this (ArrayStr.length);
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	70 int nLength = ArrayStr.length;
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	71 for (int i=0; i < nLength; i++){
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	72 //if (sDebug)
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	73 // sLogger.debug(" ArrayStr["+i+" ]=" + ArrayStr[i]);
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	74 addObject(ArrayStr[i], i);
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	75
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	76 }
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	77
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	78 }
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	79
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	80
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	81 /**
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	82 * Adds an attribute value to a specific position of this row.
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	83 *
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	84 * @param pObject the object to be stored.
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	85 * @param pPos the postion the value to be saved
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	86 */
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	87 public void addObject(Object pObject, int pPos) {
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	88 mObjects[pPos] = pObject;
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	89 }
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	90
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	91 /**
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	92 * Returns a Value out of the Row.
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	93 *
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	94 * @param pPos the position of the value to be returned.
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	95 * @return an Object! (not strongly typed)
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	96 * @throws TechnicalException
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	97 */
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	98 public Object getValue(int pPos) throws TechnicalException {
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	99 if (pPos < mObjects.length) {
263 031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part Tim Englich <tim.englich@intevation.de> parents: 129 diff changeset	100
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part Tim Englich <tim.englich@intevation.de> parents: 129 diff changeset	101 Object o = mObjects[pPos];
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part Tim Englich <tim.englich@intevation.de> parents: 129 diff changeset	102 if (o instanceof SeShape){
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part Tim Englich <tim.englich@intevation.de> parents: 129 diff changeset	103 return this.getPosValue(pPos);
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part Tim Englich <tim.englich@intevation.de> parents: 129 diff changeset	104 }else{
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part Tim Englich <tim.englich@intevation.de> parents: 129 diff changeset	105 return o;
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part Tim Englich <tim.englich@intevation.de> parents: 129 diff changeset	106 }
129 110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	107 } else {
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	108 throw new TechnicalException("Cannot access this field position. Size is: " + mObjects.length);
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	109 }
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	110 }
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	111
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	112
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	113 /**
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	114 * This is a covenient method for getting strongly typed objects out of the row.
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	115 * It has to be ensured, that the type of the requested row position has been resolved out of the ColumnDefinition ({@link ResultSet#getColumnDefinitions()}).
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	116 * In fact, this method executes a simple cast to the desired type.
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	117 *
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	118 * @param pPos the position of the object to be resolved.
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	119 * @return a strongly typed Date
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	120 * @throws TechnicalException
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	121 * @see #getValue(int)
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	122 */
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	123 public Date getDateValue(int pPos) throws TechnicalException {
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	124 Date date = null;
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	125 try {
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	126 Calendar lCalendar = (Calendar) getValue(pPos);
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	127 date = lCalendar.getTime();
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	128 }
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	129 catch (ClassCastException e) {
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	130 try{
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	131 //SimpleDateFormat formatter = new SimpleDateFormat("dd-MMM-yyyy HH:mm:ss");
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	132 date = DateUtils.getDateFromString ((String)getValue(pPos)); //(Date)formatter.parse((String)getValue(pPos));
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	133
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	134
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	135 }
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	136 catch (Exception ex){
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	137 sLogger.error(getValue(pPos) + " " + ex.getMessage(), ex);
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	138 throw new TechnicalException("Could not cast this value to the Date Type. Object is of value type: " + getValue(pPos).getClass().getName());
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	139 }
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	140 }
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	141
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	142 return date;
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	143 }
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	144
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	145 /**
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	146 * This is a covenient method for getting strongly typed objects out of the row.
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	147 * It has to be ensured, that the type of the requested row position has been resolved out of the ColumnDefinition ({@link ResultSet#getColumnDefinitions()}).
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	148 * In fact, this method executes a simple cast to the desired type.
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	149 *
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	150 * @param pPos the position of the object to be resolved.
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	151 * @return a strongly typed String
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	152 * @throws TechnicalException
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	153 * @see #getValue(int)
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	154 */
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	155 public String getStringValue(int pPos) throws TechnicalException {
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	156 try {
263 031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part Tim Englich <tim.englich@intevation.de> parents: 129 diff changeset	157 Object o = this.getValue(pPos);
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part Tim Englich <tim.englich@intevation.de> parents: 129 diff changeset	158 String returnValue = null;
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part Tim Englich <tim.englich@intevation.de> parents: 129 diff changeset	159 if (o instanceof SeShape){
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part Tim Englich <tim.englich@intevation.de> parents: 129 diff changeset	160 returnValue = this.getPosValue(pPos);
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part Tim Englich <tim.englich@intevation.de> parents: 129 diff changeset	161 }else{
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part Tim Englich <tim.englich@intevation.de> parents: 129 diff changeset	162 returnValue = (String)o;
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part Tim Englich <tim.englich@intevation.de> parents: 129 diff changeset	163 }
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part Tim Englich <tim.englich@intevation.de> parents: 129 diff changeset	164 return returnValue;
129 110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	165 } catch (ClassCastException e) {
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	166 throw new TechnicalException("Could not cast this value to the String Type. Object is of value type: " + getValue(pPos).getClass().getName());
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	167 }
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	168 }
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	169
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	170 /**
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	171 * This is a covenient method for getting strongly typed objects out of the row.
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	172 * It has to be ensured, that the type of the requested row position has been resolved out of the ColumnDefinition ({@link ResultSet#getColumnDefinitions()}).
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	173 * In fact, this method executes a simple cast to the desired type.
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	174 *
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	175 * @param pPos the position of the object to be resolved.
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	176 * @throws TechnicalException
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	177 * @see #getValue(int)
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	178 * * @return a strongly typed int
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	179 */
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	180 public int getIntValue(int pPos) throws TechnicalException {
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	181 try {
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	182 return (Integer) getValue(pPos);
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	183 } catch (ClassCastException e) {
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	184 throw new TechnicalException("Could not cast this value to the Integer Type. Object is of value type: " + getValue(pPos).getClass().getName());
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	185 }
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	186 }
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	187
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	188 /**
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	189 * This is a covenient method for getting strongly typed objects out of the row.
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	190 * It has to be ensured, that the type of the requested row position has been resolved out of the ColumnDefinition ({@link ResultSet#getColumnDefinitions()}).
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	191 * In fact, this method executes a simple cast to the desired type.
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	192 *
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	193 * @param pPos the position of the object to be resolved.
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	194 * @throws TechnicalException
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	195 * @see #getValue(int)
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	196 * * @return a strongly typed Double
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	197 */
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	198 public Double getDoubleValue(int pPos) throws TechnicalException {
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	199 try {
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	200 return (Double) getValue(pPos);
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	201 } catch (ClassCastException e) {
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	202 try{
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	203 return new Double ((String)getValue(pPos));
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	204 }
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	205 catch(Exception ex){
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	206 sLogger.error(getValue(pPos) + " " + ex.getMessage(), ex);
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	207 throw new TechnicalException("Could not cast this value to the Double Type. Object is of value type: " + getValue(pPos).getClass().getName());
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	208 }
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	209 }
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	210 }
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	211
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	212 /**
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	213 * This is a covenient method for getting strongly typed objects out of the row.
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	214 * It has to be ensured, that the type of the requested row position has been resolved out of the ColumnDefinition ({@link ResultSet#getColumnDefinitions()}).
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	215 * In fact, this method executes a simple cast to the desired type.
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	216 *
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	217 * @param pPos the position of the object to be resolved.
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	218 * @return a strongly typed Float
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	219 * @throws TechnicalException
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	220 * @see #getValue(int)
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	221 */
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	222 public Float getFloatValue(int pPos) throws TechnicalException {
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	223 try {
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	224 return (Float) getValue(pPos);
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	225 } catch (ClassCastException e) {
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	226 throw new TechnicalException("Could not cast this value to the Float Type. Object is of value type: " + getValue(pPos).getClass().getName());
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	227 }
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	228 }
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	229 /**
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	230 * This is a covenient method for getting strongly typed objects out of the row.
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	231 * It has to be ensured, that the type of the requested row position has been resolved out of the ColumnDefinition ({@link ResultSet#getColumnDefinitions()}).
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	232 * In fact, this method executes a simple cast to the desired type.
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	233 *
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	234 * @param pPos the position of the object to be resolved.
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	235 * @return a strongly typed Float
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	236 * @throws TechnicalException
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	237 * @see #getValue(int)
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	238 */
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	239 public String getPosValue(int pPos)throws TechnicalException{
268 71b2f263f036 Add WKT-Syntaxt to Shape ReturnValue Tim Englich <tim.englich@intevation.de> parents: 263 diff changeset	240 SeShape val;
71b2f263f036 Add WKT-Syntaxt to Shape ReturnValue Tim Englich <tim.englich@intevation.de> parents: 263 diff changeset	241 ArrayList aList;
71b2f263f036 Add WKT-Syntaxt to Shape ReturnValue Tim Englich <tim.englich@intevation.de> parents: 263 diff changeset	242 SDEPoint mPoint[];
71b2f263f036 Add WKT-Syntaxt to Shape ReturnValue Tim Englich <tim.englich@intevation.de> parents: 263 diff changeset	243 StringBuffer returnValue = new StringBuffer();
71b2f263f036 Add WKT-Syntaxt to Shape ReturnValue Tim Englich <tim.englich@intevation.de> parents: 263 diff changeset	244 synchronized (returnValue) {
71b2f263f036 Add WKT-Syntaxt to Shape ReturnValue Tim Englich <tim.englich@intevation.de> parents: 263 diff changeset	245
71b2f263f036 Add WKT-Syntaxt to Shape ReturnValue Tim Englich <tim.englich@intevation.de> parents: 263 diff changeset	246 try {
71b2f263f036 Add WKT-Syntaxt to Shape ReturnValue Tim Englich <tim.englich@intevation.de> parents: 263 diff changeset	247 val = (SeShape) this.mObjects[pPos];
71b2f263f036 Add WKT-Syntaxt to Shape ReturnValue Tim Englich <tim.englich@intevation.de> parents: 263 diff changeset	248 aList = val.getAllPoints(0,false);
71b2f263f036 Add WKT-Syntaxt to Shape ReturnValue Tim Englich <tim.englich@intevation.de> parents: 263 diff changeset	249 mPoint = (SDEPoint[])aList.get(0);
71b2f263f036 Add WKT-Syntaxt to Shape ReturnValue Tim Englich <tim.englich@intevation.de> parents: 263 diff changeset	250
71b2f263f036 Add WKT-Syntaxt to Shape ReturnValue Tim Englich <tim.englich@intevation.de> parents: 263 diff changeset	251 if (mPoint.length == 1){ // PUNKT
71b2f263f036 Add WKT-Syntaxt to Shape ReturnValue Tim Englich <tim.englich@intevation.de> parents: 263 diff changeset	252 returnValue.append("POINT(").append(mPoint[0].getX()).append(" ").append(mPoint[0].getY()).append(")");
71b2f263f036 Add WKT-Syntaxt to Shape ReturnValue Tim Englich <tim.englich@intevation.de> parents: 263 diff changeset	253 }else{
71b2f263f036 Add WKT-Syntaxt to Shape ReturnValue Tim Englich <tim.englich@intevation.de> parents: 263 diff changeset	254 returnValue.append("LINESTRING(");
71b2f263f036 Add WKT-Syntaxt to Shape ReturnValue Tim Englich <tim.englich@intevation.de> parents: 263 diff changeset	255 for (int i = 0; i< mPoint.length;i++){
71b2f263f036 Add WKT-Syntaxt to Shape ReturnValue Tim Englich <tim.englich@intevation.de> parents: 263 diff changeset	256 returnValue.append(mPoint[0].getX()).append(" ").append(mPoint[0].getY());
71b2f263f036 Add WKT-Syntaxt to Shape ReturnValue Tim Englich <tim.englich@intevation.de> parents: 263 diff changeset	257 if (i < mPoint.length-1){
71b2f263f036 Add WKT-Syntaxt to Shape ReturnValue Tim Englich <tim.englich@intevation.de> parents: 263 diff changeset	258 returnValue.append(" , ");
71b2f263f036 Add WKT-Syntaxt to Shape ReturnValue Tim Englich <tim.englich@intevation.de> parents: 263 diff changeset	259 }
71b2f263f036 Add WKT-Syntaxt to Shape ReturnValue Tim Englich <tim.englich@intevation.de> parents: 263 diff changeset	260 }
71b2f263f036 Add WKT-Syntaxt to Shape ReturnValue Tim Englich <tim.englich@intevation.de> parents: 263 diff changeset	261 returnValue.append(")");
71b2f263f036 Add WKT-Syntaxt to Shape ReturnValue Tim Englich <tim.englich@intevation.de> parents: 263 diff changeset	262 }
71b2f263f036 Add WKT-Syntaxt to Shape ReturnValue Tim Englich <tim.englich@intevation.de> parents: 263 diff changeset	263 // String nord="N";
71b2f263f036 Add WKT-Syntaxt to Shape ReturnValue Tim Englich <tim.englich@intevation.de> parents: 263 diff changeset	264 // String ost="E";
71b2f263f036 Add WKT-Syntaxt to Shape ReturnValue Tim Englich <tim.englich@intevation.de> parents: 263 diff changeset	265 // if (lat <0 ){nord="S"; lat=-lat;}
71b2f263f036 Add WKT-Syntaxt to Shape ReturnValue Tim Englich <tim.englich@intevation.de> parents: 263 diff changeset	266 // if (lon <0 ){ost="W"; lon=-lon;}
71b2f263f036 Add WKT-Syntaxt to Shape ReturnValue Tim Englich <tim.englich@intevation.de> parents: 263 diff changeset	267 // return String.format("%1$02d�%2$1S %3$05.2f' %4$03d�%5$1S %6$05.2f'",
71b2f263f036 Add WKT-Syntaxt to Shape ReturnValue Tim Englich <tim.englich@intevation.de> parents: 263 diff changeset	268 // (int)lat, nord,60.(lat-((int)lat)),(int)lon,ost,60.(lon-((int)lon)));
71b2f263f036 Add WKT-Syntaxt to Shape ReturnValue Tim Englich <tim.englich@intevation.de> parents: 263 diff changeset	269 } catch (SeException e) {
71b2f263f036 Add WKT-Syntaxt to Shape ReturnValue Tim Englich <tim.englich@intevation.de> parents: 263 diff changeset	270 throw new TechnicalException("Could not cast this value to the Float Type. Object is of value type: " + getValue(pPos).getClass().getName());
71b2f263f036 Add WKT-Syntaxt to Shape ReturnValue Tim Englich <tim.englich@intevation.de> parents: 263 diff changeset	271 }
129 110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	272 }
268 71b2f263f036 Add WKT-Syntaxt to Shape ReturnValue Tim Englich <tim.englich@intevation.de> parents: 263 diff changeset	273 return returnValue.toString();
129 110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	274 }
110e3ac1b7d2 Library Dependencies Added to pom.xml-File Tim Englich <tim.englich@intevation.de> parents: diff changeset	275 }

Mercurial > dive4elements > gnv-client

annotate geo-backend/src/main/java/de/intevation/gnv/geobackend/sde/datasources/Row.java @ 268:71b2f263f036