2"&dk/thoerup/traininfoservice/StationDAOjava/lang/ObjectLOCATION_LIMITI ConstantValueloggerLjava/util/logging/Logger;()VCode java/lang/Class getName()Ljava/lang/String; java/util/logging/Logger  getLogger.(Ljava/lang/String;)Ljava/util/logging/Logger;  LineNumberTableLocalVariableTable   this(Ldk/thoerup/traininfoservice/StationDAO;convertSingleRowT(Ljava/sql/ResultSet;)Ldk/thoerup/android/traininfo/common/StationBean$StationEntry; Exceptions'java/sql/SQLException) ?@ getDouble(I)D (B CD setLatitude(D)V (F GD setLongitude (I J< setRegional (L M< setStrain (O P<setMetro (R S< setAddress (U V4 setCalcdist (X Y getRegional ([ \] setIsRegional(Z)V (_ ` getStrain (b c] setIsStrain (e fgetMetro (h i] setIsMetroresLjava/sql/ResultSet;station>Ldk/thoerup/android/traininfo/common/StationBean$StationEntry; StackMapTableconvertResultsetG(Ljava/sql/ResultSet;)Ldk/thoerup/android/traininfo/common/StationBean;r/dk/thoerup/android/traininfo/common/StationBean q qu vwentriesLjava/util/List; y #$ {}|java/util/List ~add(Ljava/lang/Object;)Z , next()Zstations1Ldk/thoerup/android/traininfo/common/StationBean;getByIdA(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= < append(I)Ljava/lang/StringBuilder; AND enabled=true -(Ljava/lang/String;)Ljava/lang/StringBuilder; toString (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 idSQLLjava/lang/String;connLjava/sql/Connection;stmtLjava/sql/Statement;resultjava/lang/Stringjava/lang/Throwable getByNameE(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 prepareStatement0(Ljava/lang/String;)Ljava/sql/PreparedStatement; valueOf&(Ljava/lang/Object;)Ljava/lang/String;% java/sql/PreparedStatement  setString(ILjava/lang/String;)V ()Ljava/sql/ResultSet;  op nameLjava/sql/PreparedStatement;getByLocationWorker6(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)VlatitudeD longitudegeolimitZlimitExpression getByLocation5(DD)Ldk/thoerup/android/traininfo/common/StationBean;  { size()IgetByLocation failover: (D)Ljava/lang/StringBuilder;,  <info getByListSELECT id,name,latitude,longitude,stationcode_fjrn,stationcode_stog,stationcode_metro, address,0.0 FROM trainstations WHERE id IN  AND enabled = true ORDER BY name listgetStationName (SELECT name FROM trainstations WHERE id=  isClosedjava/lang/Exception stationIDrs getIdByName(Ljava/lang/String;)ISELECT 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; ( getId SourceFileStationDAO.java InnerClasses StationEntry!   0     /*  !"#$%& s(Y*M,++1,+59,+=A,+=E,+5H,+5K,+5N,+5Q,+ =T,,WZ,,^a,,dg,:)4?KWcp !# !"jklmnY|,((,((N(,((N(,((op%& %qYsM,t*+xzW+,'( )(#+ %!"%jkn  q%& YMN::N-:,:W*x:*:  - -  - -GGj1 21456:"<*=4><?G@IANBUCZDaEeFkGnAsBzCDEFIR!"}{xujkDmn%mnVG, , ,( %& M::::,:Y+ŷɶY+ŷɶ:*N,:      - ddfSZ[ \ ^_a6bQdZedgfhkirjwk~lmnhijklmoR!"a&  jknFd,  q, %& D ۧ:Y߷:: : : :  :  ' ) ' ) : * :,:              9!|~!+~0369>IR[`ir{p !"0'3 6 9jk nR Ae ,S   q, %& C*'):t+Y')*'): 7@*C!"CC :n@q%& Y+MN::N-:,:*:*:  - -  - -&GGj  #&*2<GINUZaeknszR!"u s#p&mjkDn%n\G, , ,q  8 LMM,N-Y :H5L