svn-gvsig-desktop / trunk / org.gvsig.desktop / org.gvsig.desktop.library / org.gvsig.expressionevaluator / org.gvsig.expressionevaluator.swing / org.gvsig.expressionevaluator.swing.impl / src / main / java / org / gvsig / expressionevaluator / swing / impl / Utils.java @ 44630
History | View | Annotate | Download (4.81 KB)
1 | 43983 | jjdelcerro | package org.gvsig.expressionevaluator.swing.impl; |
---|---|---|---|
2 | |||
3 | import java.util.Comparator; |
||
4 | 44098 | jjdelcerro | import java.util.Date; |
5 | 43983 | jjdelcerro | import java.util.Objects; |
6 | 44098 | jjdelcerro | import org.apache.commons.lang.StringEscapeUtils; |
7 | import org.gvsig.expressionevaluator.ExpressionBuilder; |
||
8 | import org.gvsig.expressionevaluator.ExpressionEvaluatorLocator; |
||
9 | import org.gvsig.fmap.geom.Geometry; |
||
10 | import org.gvsig.fmap.geom.primitive.Envelope; |
||
11 | import org.gvsig.timesupport.Time; |
||
12 | 43983 | jjdelcerro | |
13 | /*
|
||
14 | * To change this license header, choose License Headers in Project Properties.
|
||
15 | * To change this template file, choose Tools | Templates
|
||
16 | * and open the template in the editor.
|
||
17 | */
|
||
18 | /**
|
||
19 | *
|
||
20 | * @author jjdelcerro
|
||
21 | */
|
||
22 | 44098 | jjdelcerro | public class Utils { |
23 | 43983 | jjdelcerro | |
24 | public static Comparator naturalComparator() { |
||
25 | return new Comparator() { |
||
26 | @Override
|
||
27 | public int compare(Object o1, Object o2) { |
||
28 | 44259 | jjdelcerro | if (o1 instanceof Integer && o2 instanceof Number ) { |
29 | return Long.compare((Integer) o1, ((Number)o2).intValue()); |
||
30 | |||
31 | } else if (o1 instanceof Long && o2 instanceof Number ) { |
||
32 | return Long.compare((Long) o1, ((Number)o2).longValue()); |
||
33 | |||
34 | } else if (o1 instanceof Double && o2 instanceof Number ) { |
||
35 | return Double.compare((Double) o1, ((Number)o2).doubleValue()); |
||
36 | |||
37 | } else if (o1 instanceof Float && o2 instanceof Number) { |
||
38 | return Double.compare((Float) o1, ((Number)o2).floatValue()); |
||
39 | |||
40 | } else if (o1 instanceof Number && o2 instanceof Number) { |
||
41 | return Double.compare( getDouble((Number) o1), getDouble((Number) o2)); |
||
42 | |||
43 | } else if (o1 instanceof String && o2 instanceof String) { |
||
44 | return ((String) o1).compareToIgnoreCase((String)o2); |
||
45 | |||
46 | 43983 | jjdelcerro | } else {
|
47 | 44259 | jjdelcerro | try {
|
48 | return ((Comparable) o1).compareTo((Comparable)o2); |
||
49 | } catch(Exception ex) { |
||
50 | return Objects.toString(o1, "").compareTo(Objects.toString(o2, "")); |
||
51 | } |
||
52 | 43983 | jjdelcerro | } |
53 | } |
||
54 | }; |
||
55 | } |
||
56 | 44006 | jjdelcerro | |
57 | 44259 | jjdelcerro | private static double getDouble(Number n) { |
58 | 44006 | jjdelcerro | if( n==null ) { |
59 | return 0; |
||
60 | } |
||
61 | 44259 | jjdelcerro | return n.doubleValue();
|
62 | 44006 | jjdelcerro | } |
63 | 44098 | jjdelcerro | |
64 | public static String repr(Object value) { |
||
65 | if (value == null) { |
||
66 | return "NULL"; |
||
67 | } else if (value instanceof Date) { |
||
68 | return "'" + StringEscapeUtils.escapeSql(((Date) value).toString()) + "'"; |
||
69 | // return "DATE('" + value + "')";
|
||
70 | } else if (value instanceof Boolean) { |
||
71 | return value.toString();
|
||
72 | } else if (value instanceof String) { |
||
73 | return "'" + StringEscapeUtils.escapeSql((String) value) + "'"; |
||
74 | } else if (value instanceof Geometry) { |
||
75 | ExpressionBuilder builder = ExpressionEvaluatorLocator.getManager().createExpressionBuilder(); |
||
76 | return builder.geometry((Geometry)value).toString();
|
||
77 | } else if (value instanceof Envelope) { |
||
78 | ExpressionBuilder builder = ExpressionEvaluatorLocator.getManager().createExpressionBuilder(); |
||
79 | return builder.envelope((Envelope)value).toString();
|
||
80 | } else if (value instanceof Time) { |
||
81 | return "'" + StringEscapeUtils.escapeSql(((Date) value).toString()) + "'"; |
||
82 | } else if (value instanceof Number) { |
||
83 | return ((Number)value).toString(); |
||
84 | } else {
|
||
85 | return StringEscapeUtils.escapeSql(value.toString());
|
||
86 | } |
||
87 | |||
88 | } |
||
89 | |||
90 | public static String toString(Object value) { |
||
91 | if (value == null) { |
||
92 | return "NULL"; |
||
93 | } else if (value instanceof Date) { |
||
94 | return "'" + StringEscapeUtils.escapeSql(((Date) value).toString()) + "'"; |
||
95 | // return "DATE('" + value + "')";
|
||
96 | } else if (value instanceof Boolean) { |
||
97 | return value.toString();
|
||
98 | } else if (value instanceof String) { |
||
99 | return "'" + StringEscapeUtils.escapeSql((String) value) + "'"; |
||
100 | } else if (value instanceof Geometry) { |
||
101 | try {
|
||
102 | return ((Geometry)value).convertToWKT();
|
||
103 | } catch (Exception ex) { |
||
104 | return "[ERROR] "+ex.getMessage(); |
||
105 | } |
||
106 | } else if (value instanceof Envelope) { |
||
107 | try {
|
||
108 | return ((Envelope)value).getGeometry().convertToWKT();
|
||
109 | } catch (Exception ex) { |
||
110 | return "[ERROR] "+ex.getMessage(); |
||
111 | } |
||
112 | } else if (value instanceof Time) { |
||
113 | return "'" + StringEscapeUtils.escapeSql(((Date) value).toString()) + "'"; |
||
114 | } else if (value instanceof Number) { |
||
115 | return ((Number)value).toString(); |
||
116 | } else {
|
||
117 | return StringEscapeUtils.escapeSql(value.toString());
|
||
118 | } |
||
119 | |||
120 | } |
||
121 | |||
122 | 43983 | jjdelcerro | } |