This project aims to design and develop a backend administrative portal for the Learner’s Academy using Java EE technologies. I developed it as a project of phase 2 for the Become a back-end expert course. The goal of this project is to apply servlet, jsp and JDBC concepts.
- Create database and tables.
- Connect the database to the project.
- Create models classes.
- Create a database utility class to retrieve data.
- Create login page.
- Create JSP files for all pages of the project.
- Create a servlet to get requests and send responses to the JSP files.
- Add cookies.
- Create a CSS file to format the contents.
- Debug and Test the project.
• Servlet: to do the business logic and works a controller for the project.
• JSP: to handle the presentation view.
• SQL: to create and manage the database.
• JDBC: to make operations on the database for the project.
• CSS: to format the contents.
• phpMyAdmin: to administrate and manage the database manually.
• Eclipse: to write and run the code.
• Tomcat: to run and deploy servlet application.
• Object-Oriented: used to create and model objects for users and their credentials.
• Databases: used to store and retrieve data.
• Data Sources: used to define a set of properties required to identify and access the database.
• Collections: used some collections such arraylist to store collection of data.
• Exception Handling: used to catch problems that arises in the code especially in I/O blocks.
• Cookies: to store log-in data on the client browser.
• clone project
• Import the “database\database.sql” file to your database administration tool.
• Go to “\src\main\webapp\META-INF\context.xml” file and open it.
• Edit the database’ properties such as username, password and driverClassName to be suit to your database administration tool.
• Now run program on a server.
• To login you must enter admin for both username and password.
Screenshots:
