Task
Task objective: Create a WAR (web archive) file deployed on Eclipse Tomcat Server. The tasks included the following features:
• Back-end database connecting using JDBC connection. The database software is up to you as long as it enterprise approved. MySQL database for example.
• Create a local database using the provided data model. (Only want employee table)
• Populate the table with employee names
• Create a small JSP file that query the table in database and display in table format just
like database tool.
• Please make sure the UI/Front End is use friendly and responsive with different browser
size( bonus if it work on Iphone browser)
• Create an API call to allow client send request to the database and add/remove employee
as they want. You can test this out with POSTER for firefox or POSTMAN for google
chrome.
• Bonus: Create a login system that require username password store in the database
(return error UI if info provided is incorrect).
This can all be done locally on your machine.
Attached is the data model we only want you to create an employee table, but to be comfortable with a data model and able to write out multiple join query if need to.
If you have any questions please let me know. We can meet back again in a week if you would like. Please let me know and we can schedule a second interview.
Thanks,