March 31st – Project Update
Code Implementation
I spent the whole of today immersed studying into JSP pages in detail and their utilization alongside Oracle. I needed to be able to insert, automatically query and also dynamically query the database of the employees activity. I spent a lot of time reading through tutorials online about what to do and how to do it.
Having successfully implemented the functionality to be able to log the temporary internet files that are downloaded during an employees internet connectivity session I further went on to develop a JSP page that could display the temporary internet files downloaded by all employees as a whole in an effort to ensure I had connectivity for this new functionality.
Reporting is a major piece of functionality that is essential is an logging application. The ability to export excel reports was on the list of functionalities that I wanted to very much incorporate into this application and I did just that. I incorporated into my JSP query result-set pages the ability to export them as an “.xls” file.
Testing
After testing the functionality of my system and manually (for the purpose of the tests solely!) inserting different users activities into the database I was alerted to the fact that I had a serious primary key issue that would cause me to loose important information. Initially prior to discovering the bug upon testing I had the URL address as the primary key of each entry but if two different users registered the same URL one of them would lose their record thus meaning that their activity wouldn’t be stored. To solve this problem I made the primary key into a composite primary key made up of the URL address and the user it is attributed to.
Current Problem
I can’t get the JSP pages to pass parameters!
