Project Title

OnlineTutorial Web-APP Build using Pure JSP,JQuery,AJAX,Bootstrap,CSS3,MySQL,Tomcat

Getting Started

All the source code is available inside Web-Content directory and OnlineTutorialDB.mwb OnlineTutorialDB.png file displays the database scheme built in workbench The database is available inside Data directory with file named onlinetutorialdb.sql

• Use eclipse IDE and create a workspace named DBMSMini OR extract DBMSMini.zip and create that directory as workspace
• Copy the OnlineTutorial into that workspace and simply import the project
• For database connectivity mysql-connector-java-5.1.43-bin.jar is required so locate that file which will be present inside WebContent\WEB-INF\lib directory (Right click on that and select build path)
• For uploading media commons-fileupload-1.2.2.jar & commons-io-2.4.jar is required which will be located in same directory where mysql connector is present
• select index.html from left hand side menu of eclipse drag mouse cursor on the source code->right click->run as->run on server
• copy the url in the feasible browsers you are comfortable with

Prerequisites

• JDK/JRE version 7 or later
• Apache and MySQL Server (Xamp is used in this case)
• IDE like Eclipse
• HTML5 Browser
• Tomcat server plus integration and configuration to Eclipse

Installing

Download the software setups and follow the on screen instructions

step 1

installing java can be downloaded from below link

Click here to visit download page

step 2

installing XAMP Server  v3.2.2 can downloaded from below link

Click here to visit download page

step 3

installing TomCat Server 7.0 can downloaded from below link

Click here to visit download page

step 4

installing Eclipse IDE Version: 2018-09 (4.9.0) 

step 5

Configuring Tomcat Server and importing .sql file by navigating to localhost/phpmyadmin

step 6

Create workspace in IDE,locate the library and right click on lib folder to build path

step 7

enabling apache and mySQL server in xampp application

step 8

Use application in HTML5 Browser the url will generate like this -> localhost:8080/OnlineTutorial where 8080 is the port number of tomcat server

Built With

• Eclipse - Java IDE

Demonstrations

• Take a look at the working project demonstration. Click on the image to view the complete video

Authors

• Shadab Shaikh - shadabsk
• Obaid Kazi - ObaidKazi

Acknowledgments

• The template of readme.md was taken from PurpleBooth