thoerup/traininfoservice/DumpResultSet.class

ت‏؛¾2ّ)dk/thoerup/traininfoservice/DumpResultSetjavax/servlet/http/HttpServletserialVersionUIDJ
ConstantValue<init>()VCode

LineNumberTableLocalVariableTablethis+Ldk/thoerup/traininfoservice/DumpResultSet;
dumpResultset&(Ljava/lang/String;)Ljava/lang/String;
Exceptionsjavax/servlet/ServletExceptionjava/lang/StringBuilder

(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;.0/java/sql/ResultSet12getMetaData()Ljava/sql/ResultSetMetaData;465java/sql/ResultSetMetaData78getColumnCount()I:<h2>
<=>append-(Ljava/lang/String;)Ljava/lang/StringBuilder;@</h2>B<table border=1><tr>D<th>4FGH
getColumnName(I)Ljava/lang/String;J</th>L</tr>

N<tr>.PQH  getStringS
U<br>
WYXjava/lang/StringZ[replaceD(Ljava/lang/CharSequence;Ljava/lang/CharSequence;)Ljava/lang/String;]<td>_</td>a</tr>
.cdenext()Zg</table>i
Rowcount: 
k=l(I)Ljava/lang/StringBuilder;n<br>
pGenerated: rjava/util/Date
q
u=v-(Ljava/lang/Object;)Ljava/lang/StringBuilder;
x
y(Ljava/lang/Throwable;)V.{|eisClosed.~close({(~"{"~
…†‡toString()Ljava/lang/String;‰java/lang/ExceptionsqlLjava/lang/String;sbLjava/lang/StringBuilder;connLjava/sql/Connection;stmtLjava/sql/Statement;rsLjava/sql/ResultSet;countImetaLjava/sql/ResultSetMetaData;columnsivalueeLjava/lang/Exception;
StackMapTableںjava/lang/Throwable
dumpUpdate(¢£¤execute(Ljava/lang/String;)Z(¦§8getUpdateCount©Affected rows: querydoGetR(Ljavax/servlet/http/HttpServletRequest;Ljavax/servlet/http/HttpServletResponse;)V®java/io/IOException°dump²´³%javax/servlet/http/HttpServletRequestµgetParameter·all
W¹؛»equals(Ljava/lang/Object;)Z½'SELECT * FROM trainstations ORDER BY id
؟ءcoordsأSSELECT * FROM trainstations WHERE latitude IS NULL OR longitude IS NULL ORDER BY idإ     duplicateاISELECT name,count(*) FROM trainstations GROUP BY name HAVING count(*) > 1ةallfullثپselect *, '<a href="http://maps.google.dk/?q=' ||latitude || ',' || longitude || '">Maps</a>' AS maps, '<a href="http://www.bane.dk/visStation.asp?ArtikelID=4275&W=FJRN&S=' || stationcode_fjrn  || '">Bane.dk Fjern</a>' as banedk1, '<a href="http://www.bane.dk/visStation.asp?ArtikelID=4275&W=S2&S=' || stationcode_stog  || '">Bane.dk stog</a>' as banedk2 FROM trainstations ORDER BY idحdisabledد=SELECT * FROM trainstations WHERE enabled = false ORDER BY idر      noaddressسBSELECT * FROM trainstations WHERE address IS NULL or address = '' صaliases×5SELECT * FROM trainstations WHERE aliases IS NOT nullظupdatecoordsغFUPDATE trainstations SET earth_coord = ll_to_earth(latitude,longitude)
ف كء<a href=DumpResultSet?dump=all>All</a><br><a href=DumpResultSet?dump=allfull>All with links</a><br><a href=DumpResultSet?dump=coords>Missing coords</a><br><a href=DumpResultSet?dump=duplicate>Duplicate stations</a><br><a href=DumpResultSet?dump=disabled>Disabled stations</a><br><a href=DumpResultSet?dump=noaddress>No address</a><br><a href=DumpResultSet?dump=aliases>Has aliases</a><br><a href=DumpResultSet?dump=updatecoords>update coords</a><br>ل   text/htmlمهن&javax/servlet/http/HttpServletResponseوçsetContentType(Ljava/lang/String;)Vمéêë    getWriter()Ljava/io/PrintWriter;
يïîjava/io/PrintWriterًçprintlnreq'Ljavax/servlet/http/HttpServletRequest;resp(Ljavax/servlet/http/HttpServletResponse;res
SourceFileDumpResultSet.java!
3*·
±
(
¾»Y·MN::6¸N-¹!:+¹':¹-:¹36,9¶;+¶;?¶;W,A¶;W6        §,C¶;    ¹E¶;I¶;W„       ¤ےل,K¶;W§P„,M¶;W6     §2  ¹O:

ئ
RT¶V:
,\¶;
¶;^¶;W„            ¤ےح,`¶;W¹bڑے¬,f¶;W,h¶;¶jm¶;W,o¶;»qY·s¶tm¶;W§b:»Y·w؟:ئ¹zڑ¹}§:ئ¹€ڑ¹پ§:-ئ-¹‚ڑ-¹ƒ§:؟ئ¹zڑ¹}§:ئ¹€ڑ¹پ§:-ئ-¹‚ڑ-¹ƒ§:,¶„°  ˆ03ˆ5KNˆPcfˆkپ„ˆ†œںˆ،´·ˆض5

!#$&)'2(;*K+R,X-p,z/پ0„2‡4ژ5”6ں7¤8¯:ہ5ت<ر0غ>â?َ@ABCF)G3H5JDKNLPO]PfQhRkFzG„H†J•KںL،O®P·Q¹S„
¾¾ٹ‹¶Œچ
´ژڈ
±گ‘®’“ù”•2ع–—;رک•U%™•       ‘9™•       ں!ڑ‹

›œ‌²ےX
W"(.4ْüüWْْ
ے:W"(.ˆK‍ےW"(.‍BˆBˆBˆےW"(.BˆBˆBˆ ,ئ»Y·MN:¸N-¹!:+¹،W¹¥6,9¶;+¶;?¶;W,¨¶;¶jW§G:»Y·w؟:ئ¹€ڑ¹پ§:-ئ-¹‚ڑ-¹ƒ§:؟ئ¹€ڑ¹پ§:-ئ-¹‚ڑ-¹ƒ§:,¶„°
GJˆ
VVXnqˆs†‰ˆژ¤§ˆ©¼؟ˆjWY
Z
\]^"_+a;bJcLdVeXgghqisl€m‰n‹oژg‌h§i©l¶m؟nءqHئئھ‹¾Œچ
¼ژڈ
¹گ‘+”•L
›œ‌fےJW"(ˆK‍ےW"(‍BˆBˆےW"(BˆBˆ«¬‘ت+¯¹±N:-ئ -¶¶¸™*¼¶¾:§Œ-ہ¶¸™*آ¶¾:§x-ؤ¶¸™*ئ¶¾:§d-ب¶¸™*ت¶¾:§P-ج¶¸™*خ¶¾:§<-ذ¶¸™*ز¶¾:§(-ش¶¸™*ض¶¾:§-ط¶¸™*ع¶ـ:اق:,à¹â,¹è¶ى±bx z|}~$-€8پA‚LƒU„`‰iٹt‹}Œˆچ‘ژœڈ¥گ“²”¶‍¾ںة 4تتٌٍتَô       ء°‹¾ُ‹‌       ‎$WWِ÷
1	ت‏؛¾2ّ)dk/thoerup/traininfoservice/DumpResultSetjavax/servlet/http/HttpServletserialVersionUIDJ ConstantValue<init>()VCode
2
3	LineNumberTableLocalVariableTablethis+Ldk/thoerup/traininfoservice/DumpResultSet; dumpResultset&(Ljava/lang/String;)Ljava/lang/String;
4	Exceptionsjavax/servlet/ServletExceptionjava/lang/StringBuilder
5
6	(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;.0/java/sql/ResultSet12getMetaData()Ljava/sql/ResultSetMetaData;465java/sql/ResultSetMetaData78getColumnCount()I:<h2>
7	<=>append-(Ljava/lang/String;)Ljava/lang/StringBuilder;@</h2>B<table border=1><tr>D<th>4FGH getColumnName(I)Ljava/lang/String;J</th>L</tr>
8
9	N<tr>.PQH getStringS
10	U<br>
11	WYXjava/lang/StringZ[replaceD(Ljava/lang/CharSequence;Ljava/lang/CharSequence;)Ljava/lang/String;]<td>_</td>a</tr>
12	.cdenext()Zg</table>i
13	Rowcount:
14	k=l(I)Ljava/lang/StringBuilder;n<br>
15	pGenerated: rjava/util/Date
16	q
17	u=v-(Ljava/lang/Object;)Ljava/lang/StringBuilder;
18	x
19	y(Ljava/lang/Throwable;)V.{\|eisClosed.~close({(~"{"~
20	…†‡toString()Ljava/lang/String;‰java/lang/ExceptionsqlLjava/lang/String;sbLjava/lang/StringBuilder;connLjava/sql/Connection;stmtLjava/sql/Statement;rsLjava/sql/ResultSet;countImetaLjava/sql/ResultSetMetaData;columnsivalueeLjava/lang/Exception; StackMapTableںjava/lang/Throwable
21	dumpUpdate(¢£¤execute(Ljava/lang/String;)Z(¦§8getUpdateCount©Affected rows: querydoGetR(Ljavax/servlet/http/HttpServletRequest;Ljavax/servlet/http/HttpServletResponse;)V®java/io/IOException°dump²´³%javax/servlet/http/HttpServletRequestµgetParameter·all
22	W¹؛»equals(Ljava/lang/Object;)Z½'SELECT * FROM trainstations ORDER BY id
23	؟ءcoordsأSSELECT * FROM trainstations WHERE latitude IS NULL OR longitude IS NULL ORDER BY idإ duplicateاISELECT name,count() FROM trainstations GROUP BY name HAVING count() > 1ةallfullثپselect , '<a href="http://maps.google.dk/?q=' \|\|latitude \|\| ',' \|\| longitude \|\| '">Maps</a>' AS maps, '<a href="http://www.bane.dk/visStation.asp?ArtikelID=4275&W=FJRN&S=' \|\| stationcode_fjrn \|\| '">Bane.dk Fjern</a>' as banedk1, '<a href="http://www.bane.dk/visStation.asp?ArtikelID=4275&W=S2&S=' \|\| stationcode_stog \|\| '">Bane.dk stog</a>' as banedk2 FROM trainstations ORDER BY idحdisabledد=SELECT FROM trainstations WHERE enabled = false ORDER BY idر noaddressسBSELECT * FROM trainstations WHERE address IS NULL or address = '' صaliases×5SELECT * FROM trainstations WHERE aliases IS NOT nullظupdatecoordsغFUPDATE trainstations SET earth_coord = ll_to_earth(latitude,longitude)
24	ف كء<a href=DumpResultSet?dump=all>All</a><br><a href=DumpResultSet?dump=allfull>All with links</a><br><a href=DumpResultSet?dump=coords>Missing coords</a><br><a href=DumpResultSet?dump=duplicate>Duplicate stations</a><br><a href=DumpResultSet?dump=disabled>Disabled stations</a><br><a href=DumpResultSet?dump=noaddress>No address</a><br><a href=DumpResultSet?dump=aliases>Has aliases</a><br><a href=DumpResultSet?dump=updatecoords>update coords</a><br>ل text/htmlمهن&javax/servlet/http/HttpServletResponseوçsetContentType(Ljava/lang/String;)Vمéêë getWriter()Ljava/io/PrintWriter;
25	يïîjava/io/PrintWriterًçprintlnreq'Ljavax/servlet/http/HttpServletRequest;resp(Ljavax/servlet/http/HttpServletResponse;res
26	SourceFileDumpResultSet.java!
27	3*· ±
28	( ¾»Y·MN::6¸N-¹!:+¹':¹-:¹36,9¶;+¶;?¶;W,A¶;W6 §,C¶; ¹E¶;I¶;W„ ¤ےل,K¶;W§P„,M¶;W6 §2 ¹O:
29
30	ئ
31	RT¶V:
32	,\¶;
33	¶;^¶;W„ ¤ےح,`¶;W¹bڑے¬,f¶;W,h¶;¶jm¶;W,o¶;»qY·s¶tm¶;W§b:»Y·w؟:ئ¹zڑ¹}§:ئ¹€ڑ¹پ§:-ئ-¹‚ڑ-¹ƒ§:؟ئ¹zڑ¹}§:ئ¹€ڑ¹پ§:-ئ-¹‚ڑ-¹ƒ§:,¶„° ˆ03ˆ5KNˆPcfˆkپ„ˆ†œںˆ،´·ˆض5
34	!#$&)'2(;*K+R,X-p,z/پ0„2‡4ژ5”6ں7¤8¯:ہ5ت<ر0غ>â?َ@ABCF)G3H5JDKNLPO]PfQhRkFzG„H†J•KںL،O®P·Q¹S„ ¾¾ٹ‹¶Œچ
35	´ژڈ ±گ‘®’“ù”•2ع–—;رک•U%™• ‘9™• ں!ڑ‹
36
37	›œ‌²ےX
38	W"(.4ْüüWْْ ے:W"(.ˆK‍ےW"(.‍BˆBˆBˆےW"(.BˆBˆBˆ ,ئ»Y·MN:¸N-¹!:+¹،W¹¥6,9¶;+¶;?¶;W,¨¶;¶jW§G:»Y·w؟:ئ¹€ڑ¹پ§:-ئ-¹‚ڑ-¹ƒ§:؟ئ¹€ڑ¹پ§:-ئ-¹‚ڑ-¹ƒ§:,¶„° GJˆ VVXnqˆs†‰ˆژ¤§ˆ©¼؟ˆjWY
39	Z \]^"_+a;bJcLdVeXgghqisl€m‰n‹oژg‌h§i©l¶m؟nءqHئئھ‹¾Œچ
40	¼ژڈ ¹گ‘+”•L
41	›œ‌fےJW"(ˆK‍ےW"(‍BˆBˆےW"(BˆBˆ«¬‘ت+¯¹±N:-ئ -¶¶¸™¼¶¾:§Œ-ہ¶¸™آ¶¾:§x-ؤ¶¸™ئ¶¾:§d-ب¶¸™ت¶¾:§P-ج¶¸™خ¶¾:§<-ذ¶¸™ز¶¾:§(-ش¶¸™ض¶¾:§-ط¶¸™ع¶ـ:اق:,à¹â,¹è¶ى±bx z\|}~$-€8پA‚LƒU„`‰iٹt‹}Œˆچ‘ژœڈ¥گ“²”¶‍¾ںة 4تتٌٍتَô ء°‹¾ُ‹‌ ‎$WWِ÷