| 1 |
2" &dk/thoerup/traininfoservice/StationDAO java/lang/Object LOCATION_LIMIT I
ConstantValue logger Ljava/util/logging/Logger; <clinit> ()V Code |
| 2 |
java/lang/Class getName ()Ljava/lang/String; |
| 3 |
java/util/logging/Logger getLogger .(Ljava/lang/String;)Ljava/util/logging/Logger; |
| 4 |
LineNumberTable LocalVariableTable <init> |
| 5 |
this (Ldk/thoerup/traininfoservice/StationDAO; convertSingleRow T(Ljava/sql/ResultSet;)Ldk/thoerup/android/traininfo/common/StationBean$StationEntry; |
| 6 |
Exceptions ' java/sql/SQLException ) <dk/thoerup/android/traininfo/common/StationBean$StationEntry |
| 7 |
( , . - java/sql/ResultSet / 0 getInt (I)I |
| 8 |
( 2 3 4 setId (I)V , 6 7 8 getString (I)Ljava/lang/String; |
| 9 |
( : ; < setName (Ljava/lang/String;)V , > ? @ getDouble (I)D |
| 10 |
( B C D setLatitude (D)V |
| 11 |
( F G D setLongitude |
| 12 |
( I J < setRegional |
| 13 |
( L M < setStrain |
| 14 |
( O P < setMetro |
| 15 |
( R S < |
| 16 |
setAddress |
| 17 |
( U V 4 setCalcdist |
| 18 |
( X Y getRegional |
| 19 |
( [ \ ]
setIsRegional (Z)V |
| 20 |
( _ ` getStrain |
| 21 |
( b c ] setIsStrain |
| 22 |
( e f getMetro |
| 23 |
( h i ] |
| 24 |
setIsMetro res Ljava/sql/ResultSet; station >Ldk/thoerup/android/traininfo/common/StationBean$StationEntry;
StackMapTable convertResultset G(Ljava/sql/ResultSet;)Ldk/thoerup/android/traininfo/common/StationBean; r /dk/thoerup/android/traininfo/common/StationBean |
| 25 |
q q u v w entries Ljava/util/List; |
| 26 |
y # $ { } | java/util/List ~ add (Ljava/lang/Object;)Z , next ()Z stations 1Ldk/thoerup/android/traininfo/common/StationBean; getById A(I)Ldk/thoerup/android/traininfo/common/StationBean$StationEntry; java/lang/StringBuilder ~SELECT id,name,latitude,longitude,stationcode_fjrn,stationcode_stog,stationcode_metro,address,0.0 FROM trainstations WHERE id= |
| 27 |
< |
| 28 |
append (I)Ljava/lang/StringBuilder; AND enabled=true |
| 29 |
-(Ljava/lang/String;)Ljava/lang/StringBuilder; |
| 30 |
toString |
| 31 |
(dk/thoerup/traininfoservice/DBConnection
getConnection ()Ljava/sql/Connection; java/sql/Connection createStatement ()Ljava/sql/Statement; java/sql/Statement executeQuery ((Ljava/lang/String;)Ljava/sql/ResultSet; , close id SQL Ljava/lang/String; conn Ljava/sql/Connection; stmt Ljava/sql/Statement; result java/lang/String java/lang/Throwable getByName E(Ljava/lang/String;)Ldk/thoerup/android/traininfo/common/StationBean; SELECT id,name,latitude,longitude,stationcode_fjrn,stationcode_stog, stationcode_metro, address, 0.0 FROM trainstations WHERE (name ILIKE ? OR ? ~~~ ANY(aliases)) AND enabled = true ORDER BY name prepareStatement 0(Ljava/lang/String;)Ljava/sql/PreparedStatement; |
| 32 |
valueOf &(Ljava/lang/Object;)Ljava/lang/String; % java/sql/PreparedStatement setString (ILjava/lang/String;)V ()Ljava/sql/ResultSet; |
| 33 |
o p name Ljava/sql/PreparedStatement; getByLocationWorker 6(DDZ)Ldk/thoerup/android/traininfo/common/StationBean; 2AND abs(latitude-?)<0.4 AND abs(longitude-?)<0.75 SELECT id,name,latitude,longitude,stationcode_fjrn,stationcode_stog, stationcode_metro, address, earth_distance( earth_coord, ll_to_earth(?,?))::int AS calcdist FROM trainstations WHERE enabled = true ORDER BY calcdist ASC LIMIT setDouble (ID)V latitude D longitude geolimit Z limitExpression
getByLocation 5(DD)Ldk/thoerup/android/traininfo/common/StationBean; |
| 34 |
{ size ()I getByLocation failover: |
| 35 |
(D)Ljava/lang/StringBuilder; , |
| 36 |
< info getByList SELECT id,name,latitude,longitude,stationcode_fjrn,stationcode_stog,stationcode_metro, address,0.0 FROM trainstations WHERE id IN AND enabled = true ORDER BY name list getStationName (SELECT name FROM trainstations WHERE id=
isClosed java/lang/Exception stationID rs getIdByName (Ljava/lang/String;)I SELECT id,name,latitude,longitude,stationcode_fjrn,stationcode_stog, stationcode_metro, address, 0.0 FROM trainstations WHERE name = ? AND enabled = true LIMIT 1 { get (I)Ljava/lang/Object; |
| 37 |
( getId |
| 38 |
SourceFile StationDAO.java InnerClasses StationEntry ! |
| 39 |
0 |
| 40 |
/ *
! " # $ % &
s (Y *M,+ + 1,+ 5 9,+ = A,+ = E,+ 5 H,+ 5 K,+ 5 N,+ 5 Q,+ = T,, W Z,, ^ a,, d g, : ) 4 ? K W c p ! # ! " j k l m n Y | , ( ( , ( (N ( , ( (N ( , ( ( o p % &
% qY sM , t*+ x z W+ , ' ( ) ( # + % ! " % j k n q % &
Y MN:: N- :, : W* x: *: |
| 41 |
|
| 42 |
- - |
| 43 |
|
| 44 |
- - G G j 1 2 1 4 5 6 : " < * = 4 > < ? G @ I A N B U C Z D a E e F k G n A s B z C D E F I R ! " } { x u j k D m n % m n V G ,
, , ( % &
M::: :, : Y+ ŷ ɶ Y+ ŷ ɶ :* N ,: |
| 45 |
|
| 46 |
|
| 47 |
|
| 48 |
|
| 49 |
|
| 50 |
- d d f S Z [ \ ^ _ a 6 b Q d Z e d g f h k i r j w k ~ l m n h i j k l m o R ! " a & j k n F d ,
q , % &
D
ۧ : Y߷ :: : |
| 51 |
: : : |
| 52 |
|
| 53 |
' |
| 54 |
) |
| 55 |
' |
| 56 |
) |
| 57 |
: * : ,: |
| 58 |
|
| 59 |
|
| 60 |
|
| 61 |
|
| 62 |
|
| 63 |
|
| 64 |
|
| 65 |
|
| 66 |
|
| 67 |
9 ! | ~ ! + ~ 0 3 6 9 > I R [ ` i r { p ! " 0 ' 3 6 |
| 68 |
9 j k n R |
| 69 |
A e |
| 70 |
, S
|
| 71 |
q , % &
C*') : t + Y ' ) *') : 7 @ * C ! " C C : n @ q % &
Y + MN:: N- :, :* : *: |
| 72 |
|
| 73 |
- - |
| 74 |
|
| 75 |
- - & G G j |
| 76 |
# & * 2 < G I N U Z a e k n s z R ! " u s # p & m j k D n % n \ G ,
, , q 8
LM M, N- Y |
| 77 |
: H 5 L <N, O, F, =: 8:, , , :, , , :+ < ? @ S V @ [ ] p s x R ) 3 ? @ M V [ ] j s u x 4 l / ) k n ]
< , BB B B % &
M::: :, :+ :* N ,: |
| 78 |
|
| 79 |
|
| 80 |
|
| 81 |
|
| 82 |
|
| 83 |
- t - t (
8 8 j |
| 84 |
% . 8 : ? F K R W ^ a f m r y ~ R ! " 5 a D |
| 85 |
j k n G 8 ,
q , |
| 86 |
( q! |
Parent Directory
| 
Revision Log