summaryrefslogtreecommitdiff
path: root/java/wsi/ra/database/DatabaseConnection.class
blob: 2ec2eed5bebb72085a4a8bd5f3e90a7f3cc266aa (plain)
ofshex dumpascii
0000 ca fe ba be 00 00 00 31 00 b2 0a 00 37 00 55 09 00 27 00 56 09 00 27 00 57 0a 00 58 00 59 09 00 .......1....7.U..'.V..'.W..X.Y..
0020 27 00 5a 08 00 46 0a 00 58 00 5b 09 00 27 00 5c 08 00 5d 0a 00 5e 00 5f 09 00 27 00 60 0a 00 5e '.Z..F..X.[..'.\..]..^._..'.`..^
0040 00 61 07 00 62 0a 00 0d 00 55 08 00 63 0a 00 0d 00 64 0a 00 0d 00 65 0a 00 5e 00 66 08 00 43 08 .a..b....U..c....d....e..^.f..C.
0060 00 67 09 00 27 00 68 08 00 69 08 00 42 08 00 6a 09 00 27 00 6b 08 00 6c 08 00 3e 08 00 6d 09 00 .g..'.h..i..B..j..'.k..l..>..m..
0080 27 00 6e 08 00 6f 08 00 70 0a 00 2a 00 71 0a 00 72 00 73 0a 00 72 00 74 07 00 75 0a 00 23 00 76 '.n..o..p..*.q..r.s..r.t..u..#.v
00a0 0a 00 27 00 77 09 00 27 00 78 07 00 79 0a 00 27 00 55 0b 00 7a 00 7b 07 00 7c 08 00 7d 0b 00 7e ..'.w..'.x..y..'.U..z.{..|..}..~
00c0 00 7f 0b 00 80 00 81 08 00 82 0b 00 80 00 83 0a 00 2a 00 84 0a 00 85 00 86 08 00 87 0a 00 27 00 .................*............'.
00e0 88 0b 00 7a 00 89 08 00 8a 0a 00 5e 00 8b 07 00 8c 01 00 06 6c 6f 67 67 65 72 01 00 1b 4c 6f 72 ...z.......^........logger...Lor
0100 67 2f 61 70 61 63 68 65 2f 6c 6f 67 34 6a 2f 43 61 74 65 67 6f 72 79 3b 01 00 08 69 6e 73 74 61 g/apache/log4j/Category;...insta
0120 6e 63 65 01 00 24 4c 77 73 69 2f 72 61 2f 64 61 74 61 62 61 73 65 2f 44 61 74 61 62 61 73 65 43 nce..$Lwsi/ra/database/DatabaseC
0140 6f 6e 6e 65 63 74 69 6f 6e 3b 01 00 0a 63 6f 6e 6e 65 63 74 69 6f 6e 01 00 15 4c 6a 61 76 61 2f onnection;...connection...Ljava/
0160 73 71 6c 2f 43 6f 6e 6e 65 63 74 69 6f 6e 3b 01 00 06 64 72 69 76 65 72 01 00 12 4c 6a 61 76 61 sql/Connection;...driver...Ljava
0180 2f 6c 61 6e 67 2f 53 74 72 69 6e 67 3b 01 00 0b 69 73 41 76 61 69 6c 61 62 6c 65 01 00 01 5a 01 /lang/String;...isAvailable...Z.
01a0 00 08 6c 6f 63 61 74 69 6f 6e 01 00 08 70 61 73 73 77 6f 72 64 01 00 0e 70 72 6f 70 65 72 74 79 ..location...password...property
01c0 48 6f 6c 64 65 72 01 00 21 4c 77 73 69 2f 72 61 2f 74 6f 6f 6c 2f 42 61 73 69 63 50 72 6f 70 65 Holder..!Lwsi/ra/tool/BasicPrope
01e0 72 74 79 48 6f 6c 64 65 72 3b 01 00 08 75 73 65 72 6e 61 6d 65 01 00 06 3c 69 6e 69 74 3e 01 00 rtyHolder;...username...<init>..
0200 03 28 29 56 01 00 04 43 6f 64 65 01 00 26 28 29 4c 77 73 69 2f 72 61 2f 64 61 74 61 62 61 73 65 .()V...Code..&()Lwsi/ra/database
0220 2f 44 61 74 61 62 61 73 65 43 6f 6e 6e 65 63 74 69 6f 6e 3b 01 00 0b 65 78 69 73 74 73 54 61 62 /DatabaseConnection;...existsTab
0240 6c 65 01 00 15 28 4c 6a 61 76 61 2f 6c 61 6e 67 2f 53 74 72 69 6e 67 3b 29 5a 01 00 0a 45 78 63 le...(Ljava/lang/String;)Z...Exc
0260 65 70 74 69 6f 6e 73 01 00 0d 67 65 74 43 6f 6e 6e 65 63 74 69 6f 6e 01 00 17 28 29 4c 6a 61 76 eptions...getConnection...()Ljav
0280 61 2f 73 71 6c 2f 43 6f 6e 6e 65 63 74 69 6f 6e 3b 01 00 0c 67 65 74 53 74 61 74 65 6d 65 6e 74 a/sql/Connection;...getStatement
02a0 01 00 16 28 29 4c 6a 61 76 61 2f 73 71 6c 2f 53 74 61 74 65 6d 65 6e 74 3b 01 00 03 28 29 5a 01 ...()Ljava/sql/Statement;...()Z.
02c0 00 15 69 73 43 6f 6e 6e 65 63 74 69 6f 6e 41 76 61 69 6c 61 62 6c 65 01 00 08 3c 63 6c 69 6e 69 ..isConnectionAvailable...<clini
02e0 74 3e 0c 00 47 00 48 0c 00 3c 00 3d 0c 00 40 00 41 07 00 8d 0c 00 3a 00 8e 0c 00 44 00 45 0c 00 t>..G.H..<.=..@.A.....:....D.E..
0300 8f 00 90 0c 00 38 00 39 01 00 20 44 61 74 61 62 61 73 65 20 27 75 73 65 72 6e 61 6d 65 27 20 6e .....8.9...Database.'username'.n
0320 6f 74 20 64 65 66 69 6e 65 64 2e 07 00 91 0c 00 92 00 93 0c 00 46 00 3f 0c 00 94 00 52 01 00 17 ot.defined...........F.?....R...
0340 6a 61 76 61 2f 6c 61 6e 67 2f 53 74 72 69 6e 67 42 75 69 6c 64 65 72 01 00 13 44 61 74 61 62 61 java/lang/StringBuilder...Databa
0360 73 65 20 75 73 65 72 20 6e 61 6d 65 3d 0c 00 95 00 96 0c 00 97 00 98 0c 00 99 00 93 01 00 20 44 se.user.name=..................D
0380 61 74 61 62 61 73 65 20 27 70 61 73 73 77 6f 72 64 27 20 6e 6f 74 20 64 65 66 69 6e 65 64 2e 0c atabase.'password'.not.defined..
03a0 00 43 00 3f 01 00 12 44 61 74 61 62 61 73 65 20 70 61 73 73 77 6f 72 64 3d 01 00 20 44 61 74 61 .C.?...Database.password=...Data
03c0 62 61 73 65 20 27 6c 6f 63 61 74 69 6f 6e 27 20 6e 6f 74 20 64 65 66 69 6e 65 64 2e 0c 00 42 00 base.'location'.not.defined...B.
03e0 3f 01 00 12 44 61 74 61 62 61 73 65 20 6c 6f 63 61 74 69 6f 6e 3d 01 00 1e 44 61 74 61 62 61 73 ?...Database.location=...Databas
0400 65 20 27 64 72 69 76 65 72 27 20 6e 6f 74 20 64 65 66 69 6e 65 64 2e 0c 00 3e 00 3f 01 00 10 44 e.'driver'.not.defined...>.?...D
0420 61 74 61 62 61 73 65 20 64 72 69 76 65 72 3d 01 00 00 0c 00 9a 00 9b 07 00 9c 0c 00 9d 00 9e 0c atabase.driver=.................
0440 00 9f 00 a0 01 00 13 6a 61 76 61 2f 6c 61 6e 67 2f 45 78 63 65 70 74 69 6f 6e 0c 00 a1 00 48 0c .......java/lang/Exception....H.
0460 00 4e 00 4f 0c 00 3a 00 3b 01 00 22 77 73 69 2f 72 61 2f 64 61 74 61 62 61 73 65 2f 44 61 74 61 .N.O..:.;.."wsi/ra/database/Data
0480 62 61 73 65 43 6f 6e 6e 65 63 74 69 6f 6e 07 00 a2 0c 00 a3 00 a4 01 00 10 6a 61 76 61 2f 6c 61 baseConnection...........java/la
04a0 6e 67 2f 53 74 72 69 6e 67 01 00 05 54 41 42 4c 45 07 00 a5 0c 00 a6 00 a7 07 00 a8 0c 00 a9 00 ng/String...TABLE...............
04c0 52 01 00 0a 54 41 42 4c 45 5f 4e 41 4d 45 0c 00 aa 00 ab 0c 00 ac 00 4c 07 00 ad 0c 00 4e 00 ae R...TABLE_NAME.........L.....N..
04e0 01 00 0e 63 6f 6e 6e 65 63 74 69 6f 6e 54 65 73 74 0c 00 4b 00 4c 0c 00 af 00 51 01 00 22 77 73 ...connectionTest..K.L....Q.."ws
0500 69 2e 72 61 2e 64 61 74 61 62 61 73 65 2e 44 61 74 61 62 61 73 65 43 6f 6e 6e 65 63 74 69 6f 6e i.ra.database.DatabaseConnection
0520 0c 00 b0 00 b1 01 00 10 6a 61 76 61 2f 6c 61 6e 67 2f 4f 62 6a 65 63 74 01 00 1f 77 73 69 2f 72 ........java/lang/Object...wsi/r
0540 61 2f 74 6f 6f 6c 2f 42 61 73 69 63 50 72 6f 70 65 72 74 79 48 6f 6c 64 65 72 01 00 23 28 29 4c a/tool/BasicPropertyHolder..#()L
0560 77 73 69 2f 72 61 2f 74 6f 6f 6c 2f 42 61 73 69 63 50 72 6f 70 65 72 74 79 48 6f 6c 64 65 72 3b wsi/ra/tool/BasicPropertyHolder;
0580 01 00 0b 67 65 74 50 72 6f 70 65 72 74 79 01 00 38 28 4c 6a 61 76 61 2f 6c 61 6e 67 2f 4f 62 6a ...getProperty..8(Ljava/lang/Obj
05a0 65 63 74 3b 4c 6a 61 76 61 2f 6c 61 6e 67 2f 53 74 72 69 6e 67 3b 29 4c 6a 61 76 61 2f 6c 61 6e ect;Ljava/lang/String;)Ljava/lan
05c0 67 2f 53 74 72 69 6e 67 3b 01 00 19 6f 72 67 2f 61 70 61 63 68 65 2f 6c 6f 67 34 6a 2f 43 61 74 g/String;...org/apache/log4j/Cat
05e0 65 67 6f 72 79 01 00 05 65 72 72 6f 72 01 00 15 28 4c 6a 61 76 61 2f 6c 61 6e 67 2f 4f 62 6a 65 egory...error...(Ljava/lang/Obje
0600 63 74 3b 29 56 01 00 0e 69 73 44 65 62 75 67 45 6e 61 62 6c 65 64 01 00 06 61 70 70 65 6e 64 01 ct;)V...isDebugEnabled...append.
0620 00 2d 28 4c 6a 61 76 61 2f 6c 61 6e 67 2f 53 74 72 69 6e 67 3b 29 4c 6a 61 76 61 2f 6c 61 6e 67 .-(Ljava/lang/String;)Ljava/lang
0640 2f 53 74 72 69 6e 67 42 75 69 6c 64 65 72 3b 01 00 08 74 6f 53 74 72 69 6e 67 01 00 14 28 29 4c /StringBuilder;...toString...()L
0660 6a 61 76 61 2f 6c 61 6e 67 2f 53 74 72 69 6e 67 3b 01 00 05 64 65 62 75 67 01 00 06 65 71 75 61 java/lang/String;...debug...equa
0680 6c 73 01 00 15 28 4c 6a 61 76 61 2f 6c 61 6e 67 2f 4f 62 6a 65 63 74 3b 29 5a 01 00 0f 6a 61 76 ls...(Ljava/lang/Object;)Z...jav
06a0 61 2f 6c 61 6e 67 2f 43 6c 61 73 73 01 00 07 66 6f 72 4e 61 6d 65 01 00 25 28 4c 6a 61 76 61 2f a/lang/Class...forName..%(Ljava/
06c0 6c 61 6e 67 2f 53 74 72 69 6e 67 3b 29 4c 6a 61 76 61 2f 6c 61 6e 67 2f 43 6c 61 73 73 3b 01 00 lang/String;)Ljava/lang/Class;..
06e0 0b 6e 65 77 49 6e 73 74 61 6e 63 65 01 00 14 28 29 4c 6a 61 76 61 2f 6c 61 6e 67 2f 4f 62 6a 65 .newInstance...()Ljava/lang/Obje
0700 63 74 3b 01 00 0f 70 72 69 6e 74 53 74 61 63 6b 54 72 61 63 65 01 00 13 6a 61 76 61 2f 73 71 6c ct;...printStackTrace...java/sql
0720 2f 43 6f 6e 6e 65 63 74 69 6f 6e 01 00 0b 67 65 74 4d 65 74 61 44 61 74 61 01 00 1d 28 29 4c 6a /Connection...getMetaData...()Lj
0740 61 76 61 2f 73 71 6c 2f 44 61 74 61 62 61 73 65 4d 65 74 61 44 61 74 61 3b 01 00 19 6a 61 76 61 ava/sql/DatabaseMetaData;...java
0760 2f 73 71 6c 2f 44 61 74 61 62 61 73 65 4d 65 74 61 44 61 74 61 01 00 09 67 65 74 54 61 62 6c 65 /sql/DatabaseMetaData...getTable
0780 73 01 00 5f 28 4c 6a 61 76 61 2f 6c 61 6e 67 2f 53 74 72 69 6e 67 3b 4c 6a 61 76 61 2f 6c 61 6e s.._(Ljava/lang/String;Ljava/lan
07a0 67 2f 53 74 72 69 6e 67 3b 4c 6a 61 76 61 2f 6c 61 6e 67 2f 53 74 72 69 6e 67 3b 5b 4c 6a 61 76 g/String;Ljava/lang/String;[Ljav
07c0 61 2f 6c 61 6e 67 2f 53 74 72 69 6e 67 3b 29 4c 6a 61 76 61 2f 73 71 6c 2f 52 65 73 75 6c 74 53 a/lang/String;)Ljava/sql/ResultS
07e0 65 74 3b 01 00 12 6a 61 76 61 2f 73 71 6c 2f 52 65 73 75 6c 74 53 65 74 01 00 04 6e 65 78 74 01 et;...java/sql/ResultSet...next.
0800 00 09 67 65 74 53 74 72 69 6e 67 01 00 26 28 4c 6a 61 76 61 2f 6c 61 6e 67 2f 53 74 72 69 6e 67 ..getString..&(Ljava/lang/String
0820 3b 29 4c 6a 61 76 61 2f 6c 61 6e 67 2f 53 74 72 69 6e 67 3b 01 00 10 65 71 75 61 6c 73 49 67 6e ;)Ljava/lang/String;...equalsIgn
0840 6f 72 65 43 61 73 65 01 00 16 6a 61 76 61 2f 73 71 6c 2f 44 72 69 76 65 72 4d 61 6e 61 67 65 72 oreCase...java/sql/DriverManager
0860 01 00 4d 28 4c 6a 61 76 61 2f 6c 61 6e 67 2f 53 74 72 69 6e 67 3b 4c 6a 61 76 61 2f 6c 61 6e 67 ..M(Ljava/lang/String;Ljava/lang
0880 2f 53 74 72 69 6e 67 3b 4c 6a 61 76 61 2f 6c 61 6e 67 2f 53 74 72 69 6e 67 3b 29 4c 6a 61 76 61 /String;Ljava/lang/String;)Ljava
08a0 2f 73 71 6c 2f 43 6f 6e 6e 65 63 74 69 6f 6e 3b 01 00 0f 63 72 65 61 74 65 53 74 61 74 65 6d 65 /sql/Connection;...createStateme
08c0 6e 74 01 00 0b 67 65 74 49 6e 73 74 61 6e 63 65 01 00 2f 28 4c 6a 61 76 61 2f 6c 61 6e 67 2f 53 nt...getInstance../(Ljava/lang/S
08e0 74 72 69 6e 67 3b 29 4c 6f 72 67 2f 61 70 61 63 68 65 2f 6c 6f 67 34 6a 2f 43 61 74 65 67 6f 72 tring;)Lorg/apache/log4j/Categor
0900 79 3b 00 21 00 27 00 37 00 00 00 09 00 0a 00 38 00 39 00 00 00 0a 00 3a 00 3b 00 00 00 02 00 3c y;.!.'.7.......8.9.....:.;.....<
0920 00 3d 00 00 00 02 00 3e 00 3f 00 00 00 02 00 40 00 41 00 00 00 02 00 42 00 3f 00 00 00 02 00 43 .=.....>.?.....@.A.....B.?.....C
0940 00 3f 00 00 00 02 00 44 00 45 00 00 00 02 00 46 00 3f 00 00 00 08 00 02 00 47 00 48 00 01 00 49 .?.....D.E.....F.?.......G.H...I
0960 00 00 01 59 00 03 00 03 00 00 01 45 2a b7 00 01 2a 01 b5 00 02 2a 03 b5 00 03 2a b8 00 04 b5 00 ...Y.......E*...*....*....*.....
0980 05 2a b4 00 05 2a 12 06 b6 00 07 59 4c c7 00 0e b2 00 08 12 09 b6 00 0a a7 00 2a 2a 2b b5 00 0b .*...*.....YL.............**+...
09a0 b2 00 08 b6 00 0c 99 00 1c b2 00 08 bb 00 0d 59 b7 00 0e 12 0f b6 00 10 2b b6 00 10 b6 00 11 b6 ...............Y........+.......
09c0 00 12 2a b4 00 05 2a 12 13 b6 00 07 59 4c c7 00 0e b2 00 08 12 14 b6 00 0a a7 00 2a 2a 2b b5 00 ..*...*.....YL.............**+..
09e0 15 b2 00 08 b6 00 0c 99 00 1c b2 00 08 bb 00 0d 59 b7 00 0e 12 16 b6 00 10 2b b6 00 10 b6 00 11 ................Y........+......
0a00 b6 00 12 2a b4 00 05 2a 12 17 b6 00 07 59 4c c7 00 0e b2 00 08 12 18 b6 00 0a a7 00 2a 2a 2b b5 ...*...*.....YL.............**+.
0a20 00 19 b2 00 08 b6 00 0c 99 00 1c b2 00 08 bb 00 0d 59 b7 00 0e 12 1a b6 00 10 2b b6 00 10 b6 00 .................Y........+.....
0a40 11 b6 00 12 2a b4 00 05 2a 12 1b b6 00 07 59 4c c7 00 0e b2 00 08 12 1c b6 00 0a a7 00 2a 2a 2b ....*...*.....YL.............**+
0a60 b5 00 1d b2 00 08 b6 00 0c 99 00 1c b2 00 08 bb 00 0d 59 b7 00 0e 12 1e b6 00 10 2b b6 00 10 b6 ..................Y........+....
0a80 00 11 b6 00 12 2a b4 00 1d 12 1f b6 00 20 99 00 04 b1 2a b4 00 1d b8 00 21 b6 00 22 57 a7 00 09 .....*............*.....!.."W...
0aa0 4d 2c b6 00 24 b1 2a b6 00 25 57 2a 04 b5 00 03 b1 00 01 01 26 01 31 01 34 00 23 00 00 00 09 00 M,..$.*..%W*........&.1.4.#.....
0ac0 3a 00 4a 00 01 00 49 00 00 00 20 00 02 00 00 00 00 00 14 b2 00 26 c7 00 0d bb 00 27 59 b7 00 28 :.J...I..............&.....'Y..(
0ae0 b3 00 26 b2 00 26 b0 00 00 00 00 00 01 00 4b 00 4c 00 02 00 49 00 00 00 54 00 08 00 06 00 00 00 ..&..&........K.L...I...T.......
0b00 48 03 3d 2a b4 00 02 b9 00 29 01 00 4e 2d 01 01 01 04 bd 00 2a 59 03 12 2b 53 b9 00 2c 05 00 3a H.=*.....)..N-......*Y..+S..,..:
0b20 04 19 04 b9 00 2d 01 00 99 00 1f 19 04 12 2e b9 00 2f 02 00 3a 05 2b 19 05 b6 00 30 99 00 08 04 .....-.........../..:.+....0....
0b40 3d a7 00 06 a7 ff dd 1c ac 00 00 00 00 00 4d 00 00 00 04 00 01 00 23 00 01 00 4e 00 4f 00 01 00 =.............M.......#...N.O...
0b60 49 00 00 00 62 00 04 00 02 00 00 00 46 2a b4 00 02 c7 00 26 2a 2a b4 00 19 2a b4 00 0b 2a b4 00 I...b.......F*.....&**...*...*..
0b80 15 b8 00 31 b5 00 02 a7 00 27 4c 2b b6 00 24 2a 01 b5 00 02 a7 00 1a 2a b4 00 02 c6 00 13 2a 12 ...1.....'L+..$*.......*......*.
0ba0 32 b6 00 33 57 a7 00 09 4c 2a 01 b5 00 02 2a b4 00 02 b0 00 02 00 07 00 1a 00 1d 00 23 00 31 00 2..3W...L*....*.............#.1.
0bc0 38 00 3b 00 23 00 00 00 01 00 50 00 51 00 01 00 49 00 00 00 3a 00 01 00 03 00 00 00 26 2a b4 00 8.;.#.....P.Q...I...:.......&*..
0be0 03 99 00 0a 2a b4 00 02 c7 00 05 01 b0 01 4c 2a b4 00 02 b9 00 34 01 00 4c a7 00 08 4d 2c b6 00 ....*.........L*.....4..L...M,..
0c00 24 2b b0 00 01 00 12 00 1c 00 1f 00 23 00 00 00 01 00 40 00 52 00 01 00 49 00 00 00 11 00 01 00 $+..........#.....@.R...I.......
0c20 01 00 00 00 05 2a b4 00 03 ac 00 00 00 00 00 01 00 53 00 52 00 01 00 49 00 00 00 17 00 01 00 01 .....*...........S.R...I........
0c40 00 00 00 0b 2a b6 00 25 c6 00 05 04 ac 03 ac 00 00 00 00 00 08 00 54 00 48 00 01 00 49 00 00 00 ....*..%..............T.H...I...
0c60 19 00 01 00 00 00 00 00 0d 12 35 b8 00 36 b3 00 08 01 b3 00 26 b1 00 00 00 00 00 00 ..........5..6......&.......