Our two demonstrators are: Dayo (Adedayo Adetoye) and Ton (Tonworio Oguaro)
Their office hours are
|
Day
|
Time
|
Room
|
Demonstrator
|
| Tuesdays |
14:00-15:00
|
218 | Ton |
| Thursdays |
11:00-12:00
|
218 | Dayo |
Aside from the Wednesday tutorial and Dayo's Wednesday "office" hour which are both in the Lab, you should approach the demonstrators during their office hours in their office (they sit side by side in the forward left hand corner of the room as you enter the door). You can bring your laptop in to show your work or just printouts if you like. Otherwise, they may want to go down to the lab with you if they can't solve the problem away from the computers. If so they will leave a notice on their desks saying that they can be found in the lab.
There will be a tutorial each week, given by both Dayo and Ton, on Wednesdays from 12:00-13:00 in lab LG04.
Please try to find machines in the forward left hand corner of the room so that you are all together for the tutorial. You can politely ask other students not taking the module to change to a different machine if necessary (or ask one of the demonstrators to do so for you if you prefer).
To submit those exercises for which an electronic submission is required, you must package up all the necessary files in a jar file using a command (from the command prompt) such as
jar cvf exNN_123456.jar exNN
where you should replace the NN with the exercise number and the 123456 with your student id number and I assume that all your submission files are in a directory called exNN
To submit the jar file, you must use special submit program. On the school windows systems this is
J:\shortcuts\BOSS Student
On the School Unix/Linux systems it is
/bham/common/java/packages/boss-3.2.1/bin/student
IMPORTANT: The first time you use it, enter your school login name into the box where it asks you for your University ID (Library No.). DO NOT enter a password: you have to get one sent to you first. Click on Options from the menu bar and select "Get New Password". A new password (for the exercise submission system only - not for your school login) will be emailed to your school email address.Once you have a password you can login in and, by choosing Options from the menubar again, you can change your password to something you can remember.
To submit your exercise, login to Boss. Select the module (18156.2 Internet Computing Workshop). Select the current problem of the current assessment underneath that. You can then click on the browse button to browse in the file system to find your jar file to submit. Select it and then click on the submit button. You will receive an email confirming your submission.
You can submit as many times as you like until the deadline. Each new submission will simply REPLACE the old submission.
Handouts are available from the school library from the box in the shelves. The librarian always has a master copy so if they run out from the shelf box, ask the librarian to run off extra copies.
Handout 1: JDBC
This covers use of JDBC, using transactions via JDBC and describes the "Shop" database and the exercises. There are links to the files used for the exercise in the handout.
For Postgresql, the school has copies of the online manuals here, and some further documentation about the school installations of Postgresql here. If you have forgotten your postgresql password, you can reset it here.
Handout 2: Use Cases
This handout discusses Use Cases, recasts the second exercise of the first handout in a Use Case form, and sets the first assessed exercise.
Handout 3: Hibernate
This handout introduces Hibernate and provides the sample files for a Hibernate exercise.
Handout 4: Spring
This handout introduces Spring and provides some sample Spring applications. Note that this handout will be extended.
I have extracted the exercises from the individual handouts and collected them here (mostly for administrative purposes). The latest exercise is added at the end.
Assessed exercise descriptions are only available from within the school network or via tunneling, using SSH, through our web cache.
The latest exercise, EX05 has been added. Deadline is 12:00 Wednesday 16th March
Solution 1: AddBook.java
What I was looking for in this exercise was a clear understanding of the basic JDBC mechanisms and the ability to turn a Use Case into the corresponding sequence of JDBC calls. On item that came up: A number of students wrote quite large amounts of code where much smaller amounts would have been satisfactory. The aim should always be to keep your code simple and readable so that it can be easily understood and maintained.
Solution 2: Ex02_solution.jar
Use the command "jar -xvf Ex02_solution.jar" to create a directory called Ex02_Solution with the .xml and .java files containing my solution to the problem. It is not the only possible solution, nor is the the best solution but it is a good solution to the problem as required.