Java Project Interview Question

Posted By freeproject on October 19, 2016
  • What are the technologies, have you used for developing the project ?
  • I have used Java, JSP and MySQL for developing this project. Frontend desing structure has been developed in HTML, CSS and JavaScript and business logic has been implemented in Java and JSP. I have used MySQL database for storing all the information. This project runs on Tomcat Server.
  • What is the frontend of the project ?
  • JSP and Java is the frontend language of the project
  • What is the backend or database of the project ?
  • I have used MySQL database for this project.
  • What is JSP ?
  • JavaServer Pages (JSP) is a technology that helps software developers create dynamically generated web pages based on HTML, XML, or other document types. Released in 1999 by Sun Microsystems. JSP is similar to PHP and ASP, but it uses the Java programming language. To deploy and run JavaServer Pages, a compatible web server with a servlet container, such as Apache Tomcat or Jetty, is required.
  • What is MySQL ?
  • MySQL is an open-source relational database management system (RDBMS). The MySQL development project has made its source code available under the terms of the GNU General Public License, as well as under a variety of proprietary agreements. MySQL was owned and sponsored by a single for-profit firm, the Swedish company MySQL AB,now owned by Oracle Corporation. MySQL is a central component of the LAMP open-source web application software stack (and other "AMP" stacks). LAMP is an acronym for "Linux, Apache, MySQL, Perl/PHP/Python". Applications that use the MySQL database include: TYPO3, MODx, Joomla, WordPress, phpBB, MyBB, and Drupal. MySQL is also used in many high-profile, large-scale websites, including Google (though not for searches), Facebook, Twitter, Flickr and YouTube.
  • On which server your project is running ?
  • I am using Tomcat Server 7 for running the project.
  • Show me the source code of the project ? (For basic project user)
  • Open the C:\Program Files (x86)\Apache Software Foundation\Tomcat 7.0\webapps\PROJECT-NAME folder
  • How the database is connecting from Java and JSP ?
  • I am using MySQL JConnector for making the connection from Java and JSP.
  • Show me the database connection coding part ?
  • Open \WEB-INF\classes\com\Connect.java file for database connection.
  • Show me the database and all tables of the project.
  • Start WAMP or XAMP server and open the URL in browser http://127.0.0.1/phpmyadmin and click on the database
  • What is PHPMyAdmin ?
  • PHPMyAdmin is a GUI tool for performing different operations and running SQL Queries on MySQL database.
  • Show me the queries which you have written in the project for MySQL.
  • Open \WEB-INF\classes\Model folder of your project and open any of the .java file. All SQL Queries has been written there.
  • Steps to Install Softwares
  • Step 1: Uninstall all MySQL Softwares from Control Panel if you have.
    Step 2: Uninstall XAMPP Server from Control Panel
    Step 3: Install JDK 1.8
    Step 4: Install Tomcat7
    Step 5: Open browser and open the URL : http://127.0.0.1:8080/. It will show you the Tomcat Home Page
    Step 6: Install WAMP Server 2.5
    Step 7: Open browser and open the URL : http://127.0.0.1/. It will show you the WAMP Server Home Page
  • Steps to Configure Project
  • Step 1 : Download and extract the project, there will be 2 things inside the extracted folder, first is the folder which contains source code and second .sql file
    Step 2 : Copy the project inside the "C:\Program Files\Apache Software Foundation\Tomcat 7\webapps", sometimes Apache Software Foundation software can be available inside the "Program Files x(86)". You need to copy the underscored name project into it.
    Step 3 : Open browser and open the URL : http://127.0.0.1:8080/##ProjectName##
    Note : ##ProjectName## will be replaced by your project name, like student_management_system, employee_management_system etc, which you have copied into the webapps folder.
    Step 4 : If your project runs then follow the next steps else try tomcat server is running or not
    Step 5 : Import database : Open the URL http://127.0.0.1/phpmyadmin and click on create database and create the database with same name as the sql file, it will be available into your extracted folder
    Step 6 : Choose the database from left sidepanel
    Step 7 : Click on Import and choose the sql file from extracted project folder
    Step 8 : Click on Go, all the tables will be imported into the database.
    Step 9 : Create Enviroment Variables and set class path:
    • Copy mysql.jar file into tomcat7/lib directory, mysql.jar will be available inside your Java Software Download folder
    • Right click on "My PC" or "My Computer" and click on properties.
    • Click on "Advanced System Settings" link, it will be available on your left sidebar
    • Click on "Advanced" tab.
    • Click on "Enviroment Variables" button
    • In System Variables click on "New"
    • In "Variable Name" enter "CLASSPATH" and in "Variable Value" enter ";##Path of mysql.jar file##"
      Note: ##Path of mysql.jar file## will be your mysql.jar file, dont forget to add semicolon (;) at beginning
    • Click on "Ok" and exit from it.
    Step 10 : Restart your tomcat7 server and open the URL http://127.0.0.1:8080/##ProjectName##
    Step 11 : Your project will work properly
  • Show me the running process of the project. (For normal project)
  • Step 1 : Start WAMP Server
    Step 2 : Start Tomcat Server
    Step 3 : Open the browser
    Step 4 : Open the URL http://127.0.0.1:8080/PROJECT_NAME
  • What are the software requirements for running your project ?
  • JDK Version 1.8
    JRE Version 1.8
    Tomcat Version 7
    WAMP or XAMP server for MySQL

Explanation Video of Java Project Structure