Web Database project

Version Française

This project has been developed during my postgraduate degree specialising in Bioinformatics (DESS Bioinformatique) at Lille University for Database and Web course. It was in collaboration with Emilie Pensec, another student.

The Project

The goal of this projet is to practise Java with database connection and servelts technology. We have developed a bean for connection to a database for the web. In the majority of applications using databases and Java, the problematic is always the same: displaying in a table information from a Resultset. If we look on it, there are in general two use categories: from a query, display the list of resulting rows or display a catalog card describing the first row. In traditionnal Java applications, an object of Object [ ][ ] type is fill in, which used in parameter to Swing JTable constructor. In the web applications, the query result is will be used to build a HTML table.

Project parts

The project is divided in five parts:

To test the objects, for the Java/Swing part, we will present simply the database tables in a JInternalFrame containing JTables.

For the WEB part, we will develop a small website, for managing an student catalog.

Project files

Project files can be find here (documentation and comments in French, tar/gzip format few Kb).