blob: 245013e2ea2cb38377787e1023290962de793b19 (plain)

ofs	hex dump	ascii
0000	ca fe ba be 00 00 00 33 00 7b 07 00 02 01 00 07 73 71 6c 2f 53 51 4c 07 00 04 01 00 10 6a 61 76	.......3.{......sql/SQL......jav
0020	61 2f 6c 61 6e 67 2f 4f 62 6a 65 63 74 01 00 06 3c 69 6e 69 74 3e 01 00 03 28 29 56 01 00 04 43	a/lang/Object...<init>...()V...C
0040	6f 64 65 0a 00 03 00 09 0c 00 05 00 06 01 00 0f 4c 69 6e 65 4e 75 6d 62 65 72 54 61 62 6c 65 01	ode.............LineNumberTable.
0060	00 12 4c 6f 63 61 6c 56 61 72 69 61 62 6c 65 54 61 62 6c 65 01 00 04 74 68 69 73 01 00 09 4c 73	..LocalVariableTable...this...Ls
0080	71 6c 2f 53 51 4c 3b 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	ql/SQL;...getConnection...()Ljav
00a0	61 2f 73 71 6c 2f 43 6f 6e 6e 65 63 74 69 6f 6e 3b 08 00 11 01 00 15 63 6f 6d 2e 6d 79 73 71 6c	a/sql/Connection;......com.mysql
00c0	2e 6a 64 62 63 2e 44 72 69 76 65 72 0a 00 13 00 15 07 00 14 01 00 0f 6a 61 76 61 2f 6c 61 6e 67	.jdbc.Driver...........java/lang
00e0	2f 43 6c 61 73 73 0c 00 16 00 17 01 00 07 66 6f 72 4e 61 6d 65 01 00 25 28 4c 6a 61 76 61 2f 6c	/Class........forName..%(Ljava/l
0100	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 0a 00 13	ang/String;)Ljava/lang/Class;...
0120	00 19 0c 00 1a 00 1b 01 00 0b 6e 65 77 49 6e 73 74 61 6e 63 65 01 00 14 28 29 4c 6a 61 76 61 2f	..........newInstance...()Ljava/
0140	6c 61 6e 67 2f 4f 62 6a 65 63 74 3b 0a 00 1d 00 1f 07 00 1e 01 00 26 6a 61 76 61 2f 6c 61 6e 67	lang/Object;..........&java/lang
0160	2f 52 65 66 6c 65 63 74 69 76 65 4f 70 65 72 61 74 69 6f 6e 45 78 63 65 70 74 69 6f 6e 0c 00 20	/ReflectiveOperationException...
0180	00 06 01 00 0f 70 72 69 6e 74 53 74 61 63 6b 54 72 61 63 65 08 00 22 01 00 40 6a 64 62 63 3a 6d	.....printStackTrace.."..@jdbc:m
01a0	79 73 71 6c 3a 2f 2f 31 32 37 2e 30 2e 30 2e 31 2f 62 77 4c 65 68 72 70 6f 6f 6c 3f 75 73 65 72	ysql://127.0.0.1/bwLehrpool?user
01c0	3d 72 6f 6f 74 26 70 61 73 73 77 6f 72 64 3d 73 6c 78 2d 6e 67 2d 6f 70 65 6e 0a 00 24 00 26 07	=root&password=slx-ng-open..$.&.
01e0	00 25 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 0c 00 0e 00 27	.%...java/sql/DriverManager....'
0200	01 00 29 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 73 71 6c	..)(Ljava/lang/String;)Ljava/sql
0220	2f 43 6f 6e 6e 65 63 74 69 6f 6e 3b 0b 00 29 00 2b 07 00 2a 01 00 13 6a 61 76 61 2f 73 71 6c 2f	/Connection;..).+..*...java/sql/
0240	43 6f 6e 6e 65 63 74 69 6f 6e 0c 00 2c 00 2d 01 00 0d 73 65 74 41 75 74 6f 43 6f 6d 6d 69 74 01	Connection..,.-...setAutoCommit.
0260	00 04 28 5a 29 56 0a 00 2f 00 1f 07 00 30 01 00 15 6a 61 76 61 2f 73 71 6c 2f 53 51 4c 45 78 63	..(Z)V../....0...java/sql/SQLExc
0280	65 70 74 69 6f 6e 07 00 32 01 00 20 6a 61 76 61 2f 6c 61 6e 67 2f 49 6e 73 74 61 6e 74 69 61 74	eption..2...java/lang/Instantiat
02a0	69 6f 6e 45 78 63 65 70 74 69 6f 6e 07 00 34 01 00 20 6a 61 76 61 2f 6c 61 6e 67 2f 49 6c 6c 65	ionException..4...java/lang/Ille
02c0	67 61 6c 41 63 63 65 73 73 45 78 63 65 70 74 69 6f 6e 07 00 36 01 00 20 6a 61 76 61 2f 6c 61 6e	galAccessException..6...java/lan
02e0	67 2f 43 6c 61 73 73 4e 6f 74 46 6f 75 6e 64 45 78 63 65 70 74 69 6f 6e 01 00 01 65 01 00 28 4c	g/ClassNotFoundException...e..(L
0300	6a 61 76 61 2f 6c 61 6e 67 2f 52 65 66 6c 65 63 74 69 76 65 4f 70 65 72 61 74 69 6f 6e 45 78 63	java/lang/ReflectiveOperationExc
0320	65 70 74 69 6f 6e 3b 01 00 03 63 6f 6e 01 00 15 4c 6a 61 76 61 2f 73 71 6c 2f 43 6f 6e 6e 65 63	eption;...con...Ljava/sql/Connec
0340	74 69 6f 6e 3b 01 00 17 4c 6a 61 76 61 2f 73 71 6c 2f 53 51 4c 45 78 63 65 70 74 69 6f 6e 3b 01	tion;...Ljava/sql/SQLException;.
0360	00 0d 53 74 61 63 6b 4d 61 70 54 61 62 6c 65 01 00 0c 77 72 69 74 65 46 54 50 55 73 65 72 01 00	..StackMapTable...writeFTPUser..
0380	3c 28 4c 6a 61 76 61 2f 73 71 6c 2f 43 6f 6e 6e 65 63 74 69 6f 6e 3b 4c 6a 61 76 61 2f 6c 61 6e	<(Ljava/sql/Connection;Ljava/lan
03a0	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 29 49 0b 00 29	g/String;Ljava/lang/String;)I..)
03c0	00 40 0c 00 41 00 42 01 00 0f 63 72 65 61 74 65 53 74 61 74 65 6d 65 6e 74 01 00 16 28 29 4c 6a	.@..A.B...createStatement...()Lj
03e0	61 76 61 2f 73 71 6c 2f 53 74 61 74 65 6d 65 6e 74 3b 07 00 44 01 00 17 6a 61 76 61 2f 6c 61 6e	ava/sql/Statement;..D...java/lan
0400	67 2f 53 74 72 69 6e 67 42 75 69 6c 64 65 72 08 00 46 01 00 50 49 4e 53 45 52 54 20 49 4e 54 4f	g/StringBuilder..F..PINSERT.INTO
0420	20 60 62 77 4c 65 68 72 70 6f 6f 6c 60 2e 60 46 74 70 55 73 65 72 73 60 28 60 55 73 65 72 60 2c	.`bwLehrpool`.`FtpUsers`(`User`,
0440	60 50 61 73 73 77 6f 72 64 60 2c 60 55 69 64 60 2c 60 47 69 64 60 2c 60 44 69 72 60 29 56 41 4c	`Password`,`Uid`,`Gid`,`Dir`)VAL
0460	55 45 53 28 27 0a 00 43 00 48 0c 00 05 00 49 01 00 15 28 4c 6a 61 76 61 2f 6c 61 6e 67 2f 53 74	UES('..C.H....I...(Ljava/lang/St
0480	72 69 6e 67 3b 29 56 0a 00 43 00 4b 0c 00 4c 00 4d 01 00 06 61 70 70 65 6e 64 01 00 2d 28 4c 6a	ring;)V..C.K..L.M...append..-(Lj
04a0	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 2f 53 74 72 69	ava/lang/String;)Ljava/lang/Stri
04c0	6e 67 42 75 69 6c 64 65 72 3b 08 00 4f 01 00 08 27 2c 53 48 41 31 28 27 08 00 51 01 00 2c 27 29	ngBuilder;..O...',SHA1('..Q..,')
04e0	2c 27 31 30 30 30 31 27 2c 27 31 32 33 34 35 27 2c 27 2f 73 72 76 2f 6f 70 65 6e 73 6c 78 2f 6e	,'10001','12345','/srv/openslx/n
0500	66 73 2f 74 65 6d 70 27 29 3b 0a 00 43 00 53 0c 00 54 00 55 01 00 08 74 6f 53 74 72 69 6e 67 01	fs/temp');..C.S..T.U...toString.
0520	00 14 28 29 4c 6a 61 76 61 2f 6c 61 6e 67 2f 53 74 72 69 6e 67 3b 0b 00 57 00 59 07 00 58 01 00	..()Ljava/lang/String;..W.Y..X..
0540	12 6a 61 76 61 2f 73 71 6c 2f 53 74 61 74 65 6d 65 6e 74 0c 00 5a 00 5b 01 00 0d 65 78 65 63 75	.java/sql/Statement..Z.[...execu
0560	74 65 55 70 64 61 74 65 01 00 15 28 4c 6a 61 76 61 2f 6c 61 6e 67 2f 53 74 72 69 6e 67 3b 29 49	teUpdate...(Ljava/lang/String;)I
0580	0b 00 29 00 5d 0c 00 5e 00 06 01 00 06 63 6f 6d 6d 69 74 01 00 04 75 73 65 72 01 00 12 4c 6a 61	..).]..^.....commit...user...Lja
05a0	76 61 2f 6c 61 6e 67 2f 53 74 72 69 6e 67 3b 01 00 04 70 61 73 73 01 00 03 73 74 6d 01 00 14 4c	va/lang/String;...pass...stm...L
05c0	6a 61 76 61 2f 73 71 6c 2f 53 74 61 74 65 6d 65 6e 74 3b 01 00 03 72 65 74 01 00 01 49 01 00 0a	java/sql/Statement;...ret...I...
05e0	44 65 6c 65 74 65 55 73 65 72 01 00 2a 28 4c 6a 61 76 61 2f 73 71 6c 2f 43 6f 6e 6e 65 63 74 69	DeleteUser..*(Ljava/sql/Connecti
0600	6f 6e 3b 4c 6a 61 76 61 2f 6c 61 6e 67 2f 53 74 72 69 6e 67 3b 29 49 08 00 69 01 00 35 44 45 4c	on;Ljava/lang/String;)I..i..5DEL
0620	45 54 45 20 46 52 4f 4d 20 60 62 77 4c 65 68 72 70 6f 6f 6c 60 2e 60 46 74 70 55 73 65 72 73 60	ETE.FROM.`bwLehrpool`.`FtpUsers`
0640	20 77 68 65 72 65 20 55 73 65 72 20 6c 69 6b 65 20 27 08 00 6b 01 00 02 27 3b 01 00 08 67 65 74	.where.User.like.'..k...';...get
0660	49 6d 61 67 65 01 00 2b 28 4c 6a 61 76 61 2f 73 71 6c 2f 43 6f 6e 6e 65 63 74 69 6f 6e 3b 29 4c	Image..+(Ljava/sql/Connection;)L
0680	6a 61 76 61 2f 73 71 6c 2f 52 65 73 75 6c 74 53 65 74 3b 08 00 6f 01 00 35 53 45 4c 45 43 54 20	java/sql/ResultSet;..o..5SELECT.
06a0	69 6d 61 67 65 5f 6e 61 6d 65 20 46 52 4f 4d 20 62 77 4c 65 68 72 70 6f 6f 6c 2e 6d 5f 56 4c 44	image_name.FROM.bwLehrpool.m_VLD
06c0	61 74 61 5f 69 6d 61 67 65 49 6e 66 6f 3b 0b 00 57 00 71 0c 00 72 00 73 01 00 0c 65 78 65 63 75	ata_imageInfo;..W.q..r.s...execu
06e0	74 65 51 75 65 72 79 01 00 28 28 4c 6a 61 76 61 2f 6c 61 6e 67 2f 53 74 72 69 6e 67 3b 29 4c 6a	teQuery..((Ljava/lang/String;)Lj
0700	61 76 61 2f 73 71 6c 2f 52 65 73 75 6c 74 53 65 74 3b 01 00 0e 67 65 74 50 61 74 68 4f 66 49 6d	ava/sql/ResultSet;...getPathOfIm
0720	61 67 65 01 00 3d 28 4c 6a 61 76 61 2f 73 71 6c 2f 43 6f 6e 6e 65 63 74 69 6f 6e 3b 4c 6a 61 76	age..=(Ljava/sql/Connection;Ljav
0740	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
0760	65 74 3b 08 00 77 01 00 4c 53 45 4c 45 43 54 20 69 6d 61 67 65 5f 70 61 74 68 20 46 52 4f 4d 20	et;..w..LSELECT.image_path.FROM.
0780	62 77 4c 65 68 72 70 6f 6f 6c 2e 6d 5f 56 4c 44 61 74 61 5f 69 6d 61 67 65 49 6e 66 6f 20 77 68	bwLehrpool.m_VLData_imageInfo.wh
07a0	65 72 65 20 69 6d 61 67 65 5f 6e 61 6d 65 20 6c 69 6b 65 20 27 01 00 0a 69 6d 61 67 65 5f 6e 61	ere.image_name.like.'...image_na
07c0	6d 65 01 00 0a 53 6f 75 72 63 65 46 69 6c 65 01 00 08 53 51 4c 2e 6a 61 76 61 00 21 00 01 00 03	me...SourceFile...SQL.java.!....
07e0	00 00 00 00 00 06 00 01 00 05 00 06 00 01 00 07 00 00 00 2f 00 01 00 01 00 00 00 05 2a b7 00 08	.................../........*...
0800	b1 00 00 00 02 00 0a 00 00 00 06 00 01 00 00 00 0a 00 0b 00 00 00 0c 00 01 00 00 00 05 00 0c 00	................................
0820	0d 00 00 00 01 00 0e 00 0f 00 01 00 07 00 00 00 c4 00 02 00 02 00 00 00 27 12 10 b8 00 12 b6 00	........................'.......
0840	18 57 a7 00 08 4c 2b b6 00 1c 12 21 b8 00 23 4c 2b 03 b9 00 28 02 00 2b b0 4c 2b b6 00 2e 01 b0	.W...L+....!..#L+...(..+.L+.....
0860	00 04 00 00 00 09 00 0c 00 31 00 00 00 09 00 0c 00 33 00 00 00 09 00 0c 00 35 00 11 00 1f 00 20	.........1.......3.......5......
0880	00 2f 00 03 00 0a 00 00 00 2a 00 0a 00 00 00 0f 00 09 00 10 00 0c 00 11 00 0d 00 13 00 11 00 16	./.......*......................
08a0	00 17 00 17 00 1e 00 18 00 20 00 19 00 21 00 1b 00 25 00 1d 00 0b 00 00 00 2a 00 04 00 00 00 27	.............!...%.......*.....'
08c0	00 0c 00 0d 00 00 00 0d 00 04 00 37 00 38 00 01 00 17 00 09 00 39 00 3a 00 01 00 21 00 04 00 37	...........7.8.......9.:...!...7
08e0	00 3b 00 01 00 3c 00 00 00 0b 00 03 4c 07 00 1d 04 4e 07 00 2f 00 01 00 3d 00 3e 00 01 00 07 00	.;...<......L....N../...=.>.....
0900	00 00 d3 00 04 00 06 00 00 00 41 2b b9 00 3f 01 00 3a 04 19 04 bb 00 43 59 12 45 b7 00 47 2c b6	..........A+..?..:.....CY.E..G,.
0920	00 4a 12 4e b6 00 4a 2d b6 00 4a 12 50 b6 00 4a b6 00 52 b9 00 56 02 00 36 05 2b b9 00 5c 01 00	.J.N..J-..J.P..J..R..V..6.+..\..
0940	15 05 ac 3a 05 19 05 b6 00 2e 02 ac 00 01 00 00 00 37 00 38 00 2f 00 03 00 0a 00 00 00 1e 00 07	...:.............7.8./..........
0960	00 00 00 24 00 08 00 26 00 2f 00 27 00 35 00 28 00 38 00 29 00 3a 00 2b 00 3f 00 2d 00 0b 00 00	...$...&./.'.5.(.8.).:.+.?.-....
0980	00 48 00 07 00 00 00 41 00 0c 00 0d 00 00 00 00 00 41 00 39 00 3a 00 01 00 00 00 41 00 5f 00 60	.H.....A.........A.9.:.....A._.`
09a0	00 02 00 00 00 41 00 61 00 60 00 03 00 08 00 30 00 62 00 63 00 04 00 2f 00 09 00 64 00 65 00 05	.....A.a.`.....0.b.c.../...d.e..
09c0	00 3a 00 05 00 37 00 3b 00 05 00 3c 00 00 00 06 00 01 78 07 00 2f 00 01 00 66 00 67 00 01 00 07	.:...7.;...<......x../...f.g....
09e0	00 00 00 be 00 04 00 05 00 00 00 36 2b b9 00 3f 01 00 4e 2d bb 00 43 59 12 68 b7 00 47 2c b6 00	...........6+..?..N-..CY.h..G,..
0a00	4a 12 6a b6 00 4a b6 00 52 b9 00 56 02 00 36 04 2b b9 00 5c 01 00 15 04 ac 3a 04 19 04 b6 00 2e	J.j..J..R..V..6.+..\.....:......
0a20	02 ac 00 01 00 00 00 2c 00 2d 00 2f 00 03 00 0a 00 00 00 1e 00 07 00 00 00 34 00 07 00 36 00 24	.......,.-./.............4...6.$
0a40	00 37 00 2a 00 38 00 2d 00 39 00 2f 00 3b 00 34 00 3d 00 0b 00 00 00 3e 00 06 00 00 00 36 00 0c	.7.*.8.-.9./.;.4.=.....>.....6..
0a60	00 0d 00 00 00 00 00 36 00 39 00 3a 00 01 00 00 00 36 00 5f 00 60 00 02 00 07 00 26 00 62 00 63	.......6.9.:.....6._.`.....&.b.c
0a80	00 03 00 24 00 09 00 64 00 65 00 04 00 2f 00 05 00 37 00 3b 00 04 00 3c 00 00 00 06 00 01 6d 07	...$...d.e.../...7.;...<......m.
0aa0	00 2f 00 01 00 6c 00 6d 00 01 00 07 00 00 00 83 00 02 00 03 00 00 00 17 2b b9 00 3f 01 00 4d 2c	./...l.m................+..?..M,
0ac0	12 6e b9 00 70 02 00 b0 4d 2c b6 00 2e 01 b0 00 01 00 00 00 0f 00 10 00 2f 00 03 00 0a 00 00 00	.n..p...M,............../.......
0ae0	16 00 05 00 00 00 43 00 07 00 45 00 10 00 48 00 11 00 4a 00 15 00 4e 00 0b 00 00 00 2a 00 04 00	......C...E...H...J...N.....*...
0b00	00 00 17 00 0c 00 0d 00 00 00 00 00 17 00 39 00 3a 00 01 00 07 00 09 00 62 00 63 00 02 00 11 00	..............9.:.......b.c.....
0b20	04 00 37 00 3b 00 02 00 3c 00 00 00 06 00 01 50 07 00 2f 00 01 00 74 00 75 00 01 00 07 00 00 00	..7.;...<......P../...t.u.......
0b40	a0 00 04 00 04 00 00 00 2a 2b b9 00 3f 01 00 4e 2d bb 00 43 59 12 76 b7 00 47 2c b6 00 4a 12 6a	........*+..?..N-..CY.v..G,..J.j
0b60	b6 00 4a b6 00 52 b9 00 70 02 00 b0 4e 2d b6 00 2e 01 b0 00 01 00 00 00 22 00 23 00 2f 00 03 00	..J..R..p...N-..........".#./...
0b80	0a 00 00 00 16 00 05 00 00 00 54 00 07 00 56 00 23 00 59 00 24 00 5b 00 28 00 5f 00 0b 00 00 00	..........T...V.#.Y.$.[.(._.....
0ba0	34 00 05 00 00 00 2a 00 0c 00 0d 00 00 00 00 00 2a 00 39 00 3a 00 01 00 00 00 2a 00 78 00 60 00	4.....*.........*.9.:.....*.x.`.
0bc0	02 00 07 00 1c 00 62 00 63 00 03 00 24 00 04 00 37 00 3b 00 03 00 3c 00 00 00 06 00 01 63 07 00	......b.c...$...7.;...<......c..
0be0	2f 00 01 00 79 00 00 00 02 00 7a	/...y.....z