Maven WebApplication Project with java_servlet + JDBC + SQL Database

In this maven Web application project you should use servlet, sql injections for each page, servlet mapping, and the whole project should be under maven.

To create database with provided you sql files and trigger (you have to use these by joining the tables or through other sql operations).

The sql files are mainly in db2 sql, either you can use db2 database (then you can simply import these file in your db2 database) or you can use other database like Mysql (in that case you need to change the sql files according to that database).

Web application should be look like and accessible each pages described in the pdf file.

You can use Apache tomcat or jetty server to run.

In the word file, description and translation of the tables and terms are provided.

The name of the project should be onlineLearner.

If you need further information, feel free to contact me.

care must be undertaken on the followings:

Correct use of transactions.
• Closing of DB resources in sensible places.
• Prevention of SQL injection.
• For testing the website and for the acceptance, there should be enough sample data in each
generated table.
• All interactions should be carried out by the currently logged in user. A login function is not necessary.
The user can be hard-coded into the program code. If you use the sample solution, you can assign
the number (BNummer) 1 to the user.