/*
						Output of UpdateCountA.java -
	Uses a Stored Procedure and CallableStatement to execute Multiple Queries
*/

$ java UpdateCountA

Test Case 1: SELECT
CallableStatement is: true
1 a
2 b
3 c
CallableStatement is: false
Update Count is: 0
Test Complete

Test Case 2: SELECT - SELECT
CallableStatement is: true
1 a
2 b
3 c
CallableStatement is: true
3 c
2 b
1 a
CallableStatement is: false
Update Count is: 0
Test Complete

Test Case 3: SELECT - UPDATE
CallableStatement is: true
1 a
2 b
3 c
CallableStatement is: false
Update Count is: 3
Test Complete

Test Case 4: UPDATE - SELECT
CallableStatement is: true
1 Bar
2 Bar
3 Bar
CallableStatement is: false
Update Count is: 0
Test Complete

Test Case 5: SELECT - UPDATE - SELECT
CallableStatement is: true
1 a
2 b
3 c
CallableStatement is: true
1 Bar
2 Bar
3 Bar
CallableStatement is: false
Update Count is: 0
Test Complete

Test Case 6: UPDATE - SELECT - DELETE
CallableStatement is: true
1 Bar
2 Bar
3 Bar
CallableStatement is: false
Update Count is: 1
Test Complete

Test Case 7: SELECT - UPDATE - SELECT - DELETE - SELECT
CallableStatement is: true
1 a
2 b
3 c
CallableStatement is: true
1 Bar
2 Bar
3 Bar
CallableStatement is: true
1 Bar
3 Bar
CallableStatement is: false
Update Count is: 0
Test Complete