Online car servicing system project report

AN INTERNSHIP REPORT ON ONLINE CAR SERVICING SYSTEM PROJECT BY KAMAL ACHARYA (Tribhuvan University) Date: 2023/03/10 1|P ag e Electronic copy available at: https://ssrn.com/abstract=4837832 CHAPTER -1 INTRODUCTION 1.1 Introduction to Company: Our vision is to make ONLINE CAR SERVICING SYSTEM is needed for the country as technology grows fast in the world. The purpose is to develop this project to provide a better solution to the problems that the customers faces. This website will provide customers to reserve their car services from their home or from office. Customer feels hard to send their car for the service, either they need to reserve using mail system or walk in to send their car for service. At the end of these project, a prototype of justified system will develop which will provide a solution for the identify problem to improve the organizations revenue and performance. This system will be web based system where it is able to conduct an overall process of online registration and bookings too. The data will be stored in keep as privacy for each customer who has register. 1.2 Introduction to Project: The Project is ONLINE CAR SERVICING SYSTEM is needed for the country as technology grows fast in the world. The purpose is to develop this project to provide a better solution to the problems that the customers faces. This website will provide customers to reserve their car services from their home or from office. Customer feels hard to send their car for service, either they need to reserve using mail system or walk in to send their car for service. At the end of these project, a prototype of justified system will develop which will provide a solution for the identify problem to improve the organizations revenue and performance. This system will be web based system where it is able to conduct an overall process of online registration and bookings too. The data will be stored in keep as privacy for each customer who has register. The project Online car servicing system main objective of this system is to provide customers with a much convenient and better way of booking their car services. It is an online system for car services reservation and users will have to sign up through the registration page so they'll be able to view the various car services provided by the car services centre. This system is created to manage the reservation processes through online where the previous older ways were done manually. This system would be a productive solution for users and the car services centre. It will also reduce the work process of the admin while the data will be kept securely. Car owner can know the different services details can give his car for whatever the service he wish once he is a registered user. Dealer can post the services offered by them and provide services to the applied persons. Once car servicing completes car owner will get a mail from dealer. So car owner need to wait at the center and waste his time. 2|P ag e Electronic copy available at: https://ssrn.com/abstract=4837832 1.3 Introduction to Modules: User(Car owner) Dealer Register, Login, View service offers, View/edit profile, Apply for the service Register, Login, View service, Accept/reject service, send mail, View/edit service MODLUES  User  Dealer MODULE DESCRIPTION Name of the module-1:User Description: This module helps us to keep register the user and himself. After registration he will get to know what are the services provided by our service after that he can login into our website. Sub modules:  Register  Login  View Service Offers  Search Service – can search by Service Location, Service Provided, Dealer Name etc.  View/Edit Profile  Apply for the Service 3|P ag e Electronic copy available at: https://ssrn.com/abstract=4837832 Name of the module-2: Dealer Description: This module helps to dealer manage his service accounts and he can view the services. Sub modules:  Register  Login  Post Service – Service Location, Experience, Service Type, Service Time, Service Cost and Service Description.  View Services  Accept/Reject Service  Send Mail  View/Edit Profile. 4|P ag e Electronic copy available at: https://ssrn.com/abstract=4837832 CHAPTER-2 ANALYSIS 2.1 Identification of need: The data entry process requires the data on the paper, which is then feed into the application by the operator while doing so; the data entry operator has to look into the paper again &again and thus the chances of in accuracies in the typed contents increases. Also the process includes their registration process, sending messages, etc. In the existing system the servicing is done manually but in proposedsystem we have to computerize all the servicing process by using the Online Car Servicing System. Problems With Existing System Need  Lack of security of data.  More man power.  Time consuming.  Consumes large volume of pare work.  Needs manual calculations.  No direct role for the higher officials.  Damage of machines 2.2 Feasibility Study:  System design is the transformation of the analysis model into a system design model. During system design, developers define the design goals of the project and decompose the system into smaller subsystems that can be realized by individual teams.  The system which is existing and adopted till now is, the customer going to the that service center and waiting in a queue according to the requirement. For that they need to know all that what all the services are provided by them. which is a time taking process i.e., suppose a user need to send his car for service by sitting in home he can send his car to the service center and get service in time and doesn’t have to wait in queue. It is all time consuming process. The online car servicing center will specify all the details the of user needs. 5|P ag e Electronic copy available at: https://ssrn.com/abstract=4837832 2.3 Problem Specification:  After all the design activities were implemented correctly and completely, we will be having the use-cases, class interfaces and designing goals with us. The next step is to implement them to resolve them into a system by developing the code. The code generation should be done in a systematic manner. The process will be explained in this phase.  As the scope of the network is increased a lot, we can make our online car servicing system to the users can take service from his home.  We will tell to user to register the form for what servicing they require. By using register after the user login details he can view all the services provided by our RSN service.  In this service they get to nearest centres to them and they can know what service is available at that time.  After completing of their service they get mail from our servicing centres that their car service had been done. 2.4 Requirement Specification:  Requirement Analysis is the first technical step in software engineering process. It is at this point that a general statement of software scope is refined into concrete specification that becomes the foundation for all software engineering activities that follow. Analysis must focus on information, functional and behavioural domains of the problem. To better understand what is required, models are created and the problem is partitioned. 2.4.1 Client Requirement:  Dealers today must offer more tailored services, be more customer-focused and more efficient in order to compete. Manufacturers and their dealer organizations therefore place exacting requirements on their IT. Flexibility is key to business success. The more efficiently information is processed and employees use data, the more productive the core business becomes. The innovative business process solutions for sales and service provide dealers with a decisive competitive edge. 6|P ag e Electronic copy available at: https://ssrn.com/abstract=4837832 2.4.2 Hardware Requirement: Hardware : Pentium Speed : 1.1GHz RAM : 1GB Hard Disk : 20GB 2.4.2 Software Requirement: Operating System : Windows Technology : Java and J2EE Web Technologies : Html, JavaScript IDE : Eclipse Web Server : Tomcat Database : MySQL Java Version : J2SDK1.7 7|P ag e Electronic copy available at: https://ssrn.com/abstract=4837832 CHAPTER-3 SELECTED SOFTWARE Introduction to software selected: Software used:     java jdk. Apache tomcat MySQL Integrated development environment tool (Ex: eclipse) About java: It was developed by James gosling in 1996 by company called sun microsystems. The advanced java is used to develop applications. There are three types of java 1. J2SE (standalone) 2. J2EE (enterprise) 3. J2ME (micro edition) For standalone applications we use J2SE. Software’s used: windows, OOPs, AWT, swings etc., For enterprise applications like the advanced java web server applications which we are web type or server type are done by using J2EE. Software’s used: JDBC, jsp, servlets etc., For micro edition applications like mobile games which are inbuilt are done by using J2ME. J2EE: Here by using J2EE we are creating a dynamic web application. The architecture of dynamic web application is as follows server Web container Request Client response db. 8|P ag e Electronic copy available at: https://ssrn.com/abstract=4837832 Here we use the server which contains a database. Here web container executes the code, server gets the request from user and it performs operations and send back the response to the user. About JSP: Java Server Pages (JSP) is a technology for developing Webpages that supports dynamic content. This helps developers insert java code in HTML pages by making use of special JSP tags, Here in this project we used java server pages are used to create the dynamic web pages. These dynamic web pages are created by using html tags and Scriptlet [example:<% and end with %>.]. Jsp is more efficient than servlet and In JSP we have four important tags like  Declarative  Expression  Scriptlet In JSP nested tags is not possible.  Scriptlet: JSP also allows you to write blocks of Java code inside the JSP. You do this by placing your Java code between <% and %> characters just like expressions, but without the = sign at the start of the sequence. This block of code is known as a "Scriptlet". By itself, a Scriptlet doesn't contribute any HTML. A Scriptlet contains Java code that is executed every time the JSP is invoked.  Java script Validation: We use form validation to improve the effectiveness of the page. To validate we use some test cases here. 9|P ag e Electronic copy available at: https://ssrn.com/abstract=4837832 About HTML: HTML stands for Hyper Text Mark-up Language and it describes the structure of Web pages using mark-up. The elements are the building blocks of HTML pages here the elements are represented by tags. HTML tags label pieces of content such as "heading", "paragraph", "table", and so on Browsers do not display the HTML tags, but use them to render the content of the page HTML is generally used for creating static web pages. Here in this project we use the HTML tags which are included in the jsp code. We use html version more than 3.0 because below 3.0 version we need to add the servlet mapping more than 3.0 it automatically creates the web annotations we not need to create the servlet mapping externally. Advantages:  An HTML document is a small and hence easy to send over the net. It is small because it does not include format information.  HTML documents are cross platform compatible and device independent. You only need HTML readable browser to view them. Font names, locations etc are required. About JDBC connection: In this java application JDBC is used for connecting to database. To connect Java application with the MySQL database, we need to follow 5 following steps. o Register the driver class: by using for name () method we register. o Creating connection: by using get connection () method we get connected. o Creating statement: by using create Statement () method we crate statement. o Executing queries: by using execute Query (string sql) method we execute dB queries. o Closing connection: by using close () method we close the connection with db. 10 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832 In this application we are using MySQL as the database. So, we need to know following information’s for the MySQL database: Driver class: The driver class for the MySQL database is com. MySQL. Jdbc. Driver. ConnectionURL: Theconnection URL for the MySQL database is jdbc: MySQL:https://localhost:3306/carservice where jdbc is the API, MySQL is the database, localhost is the server name on which MySQL is running, we may also use IP address, 3306 is the port number and car service is the database name. We may use any database, in such case, we need to replace the car service with our database name. Username: The default username for the MySQL database is root. Password: It is the password given by the user at the time of installing the MySQL database. In this example, we are going to use root as the password. After connection to database we perform database operations. About CSS: CSS stands for Cascading Style Sheets. It describes how HTML elements are to be displayed on screen, paper, or in other media. It saves a lot of work. It can control the layout of multiple web pages all at once. External stylesheets are stored in CSS files.CSS is a language that describes the style of an HTML document. We have three ways to insert CSS style sheets  External style sheet  Internal style sheet  Inline style sheet External Style Sheet  With an external style sheet, you can change the look of an entire website by changing just one file!  Each page must include a reference to the external style sheet file inside the <link> element. The <li>element goes inside the <head > section. Internal Style Sheet  An internal style sheet may be used if one single page has a unique style.  Internal styles are defined within the <style> element, inside the <head> section of an HTML page: 11 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832 Inline Styles  An inline style may be used to apply a unique style for a single element.  To use inline styles, add the style attribute to the relevant element. The style attribute can contain any CSS property. Swings: The swing components examined include buttons, labels, toggle buttons, combo boxes, list boxes, scrollbars, slides, text, scroll panes, tables, and toolbars. Common functionality shared across these components and others like borders, tool, tips and icons is also possible. Scroll Panes: The JScrollPane component is an interesting component. It acts as a container for one component. Providing scrolling support for that component, if it is larger than the space available within the JScrollPane. Text Fields: J Text Field implements that old favorite a single line text input box. Text Areas: The J Text Area component, as its name suggests, is used when larger amounts of text need to be input or more often, just displayed. Tool Bar: The J Tool Bar component offers a potentially draggable container to place a component in. Menu Bars: The main purpose of the JMenuBar class is to group together a collection of JMenu instances. 12 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832 About apache tomcat: We two types of servers they are web server and application server. Web server: the server consists only the web container. Application server: the server consists both web container as well as other extensions. In this we use a web server called apache tomcat of version 8. Apache Tomcat is a web container developed at the Apache Software Foundation (ASF). Tomcat implements the servlet and the Java Server Pages (JSP) specifications from Sun Microsystems, providing an environment for Java code to run in cooperation with a web server. It adds tools for configuration and management but can also be configured by editing configuration files that are normally XML-formatted. Tomcat includes its own internal HTTP server. Tomcat is a web server that supports servlets and JSPs. The accompanying Tomcat Jasper compiler compiles JSPs into servlets. Roles of server:     It handles the life cycle methods like init, service, destroy. It handles the security i.e. it provides security using sessions and authentication. Handling of request dispatching (communication of two applications) Handling of multithreading About MySQL: MySQL is the most popular Open Source Relational SQL Database Management System. MySQL is one of the best RDBMS being used for developing various web-based software applications. MySQL is developed, marketed and supported by MySQL AB, which is a Swedish company. This tutorial will give you a quick start to MySQL and make you comfortable with MySQL programming. In this project we use the MySQL database to store the data. in this database we have different tables. reasons to use MYSQL:  MySQL is released under an open-source license. So, you have nothing to pay to use it.  MySQL is a very powerful program in its own right. It handles a large subset of the functionality of the most expensive and powerful database packages.  MySQL uses a standard form of the well-known SQL data language.  MySQL works on many operating systems and with many languages including PHP, PERL, C, C++, JAVA, etc. 13 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832  MySQL works very quickly and works well even with large data sets.  MySQL is very friendly to PHP, the most appreciated language for web development.  MySQL supports large databases, up to 50 million rows or more in a table. The default file size limit for a table is 4GB, but you can increase this (if your operating system can handle it) to a theoretical limit of 8 million terabytes (TB).  MySQL is customizable. The open-source GPL license allows programmers to modify the MySQL software to fit their own specific environments. 14 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832 CHAPTER-4 DESIGN INTRODUCTION: Design is the first step in the development phase for any techniques and principles for the purpose of defining a device, a process or system in sufficient detail to permit its physical realization. Once the software requirements have been analyzed and specified the software design involves three technical activities –design, coding, implementation and testing that are required to build and verify the software. The design activities are of main importance in this phase, because in this activity, decisions ultimately affecting of the software implementation and its ease of maintenance are made. These decisions have the final bearing upon reliability and maintainability of the system. 4.1 RELATIONSHIP DIAGRAM The Unified Modeling Language (UML) is a standard and appropriate language for writing software blueprints and for modeling systems ranging from enterprise information systems to distributed web-based applications and even to hard real time embedded systems. OVERVIEW: The UML is a language for  Visualizing  Specifying  Constructing  Documenting the artifacts of a software-intensive system. A modeling language is a language whose vocabulary and rules focus on the conceptual and physical representation of a system that yields an understanding of the different views of the evolution of software development lifecycle. 15 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832 In visualizing we communicate the conceptual model to others to eradicate errors and developer who cut the code never write the models, so we visualize. Specifying means building model that are precise, unambiguous and complete. Things that are best expressed graphically are done so graphically in UML, whereas things that are best expressed textually are done so in programming language, mapping permits forward engineering in constructing. UML stands for Unified Modelling Language. UML is a language for specifying, visualizing, documenting the system. This is the step while developing any product after analysis. The goal from this is to produce a model of the entities involved in the project which later need to be built. The representation of the entities that are to be used in the product being developed need to be designed. There are various kinds of methods in software design: They are as follows:  Use case diagram  Class diagram  Activity Diagram  State chart Diagram 16 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832 USE CASE DIAGRAM: Applying for register login Search services View services Search garages User Dealer location View garages Send mail Feed back Log out 17 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832 CLASS DIAGRAM: Registration Login User id User name Password Email Gender address phone no car brand car no User name Password User type Log in () Log out () Car owner Dealer Register () Message Dealer id Dealer email Send message () Send solution () Garage Dealer email Dealer password Car owner email Car owner pwd Log in () Log out () View service () View garage () Accept service () View profile () Log in () Log out () View service () View garage () Request service () View profile () Services garage id garage name garage location Add garage () Delete garage () Edit garage () service id service name service time service offer Add service () Delete service () Edit service () 18 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832 Feedback Car owner id Car owner name Car owner email Car owner phone Send feedback () Ask solutions () ACTIVITY DIAGRAM: Login dealer Carowner  login valid Post service Invalid id Accept service View service Apply Send mail Receive mail Receive feed back Send feed back Log out  19 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832 STATE CHART DIAGRAM: For Users module View services Service available No yes For Selection of anotherservices Request service Dealer module Send feedback Dealer Login Get reply Add services From users Retrieve services database View requests From users Receive mails To users Reply mails 20 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832 4.2DATABASE TABLES TABLE FOR GARAGE: NAME GARAGE ID NAME LOCATION ADDRESS PHONE NUMBER EMAIL TYPE VARCHAR (40) VARCHAR (40) VARCHAR (40) VARCHAR(40) VARCHAR(40) VARCHAR(50) NULL/NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL KEY ------------- TYPE VARCHAR(30) VARCHAR(30) VARCHAR(30) VARCHAR(30) VARCHAR(50) NULL/NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL KEY ----------- TYPE VARCHAR(20) VARCHAR(30) VARCHAR(30) VARCHAR(30) VARCHAR(30) NULL/NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL KEY ----------- TYPE INT(15) VARCHAR(30) VARCHAR(40) VARCHAR(40) VARCHAR(15) VARCHAR(30) VARCHAR(20) VARCHAR(30) VARCHAR(40) NULL/NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL KEY ----------------PRIMARY KEY TABLE FOR QUERY: NAME NAME EMAIL PHONE NUMBER FEED BACK SOLUTION TABLE FOR SERVICES: NAME SERVICE ID SERVICE TIME COST OFFERS TABLE FOR USERS: NAME USER ID NAME EMAIL PASSWORD GENDER ADDRESS PHONE NUMBER CARBRAND CAR NUMBER 21 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832 4.3 Data Flow Diagram (DFD) In the DFD there are four symbols: 1. A square defines a source (originator) or destination of system data 2. An arrow identifies data flow- data in motion. It is a pipeline through which information flows. 3. A circle or a ‘bubble’ (some use an oval bubble) represents a process that transforms incoming data flows into outgoing data flows 3. An open rectangle is a data store- data at rest or a temporary repository of data Context Level Diagram: LEVEL 0: customer Online Car service dealer LEVEL 1: View services Database customer Request service Dealer Send feed back LEVEL 2: View services database dealer Accept service customer Send email 22 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832 5.SYSTEM TESTING AND IMPLEMENTATIONS 5.1 TESTCASES Testing is a process of analyzing a system or system components to detect the differences between specified and observed behavior. In other words, testing is a fault detection technique that tries to create failures or erroneous states in a planned way. This allows the developer to detect failures in the system before it is released to the customer. Testing is a process of executing a program with the intent of finding an error. Testing is a crucial element of software quality assurance and presents ultimate review of specification, design and coding. system testing is an important phase. Testing represents an interesting anomaly for the software. Thus, a series of testing are performed for the proposed system before the system is ready for user acceptance testing. A good test case is one that has a high probability of finding an as undiscovered error. A successful test is one that uncovers an as undiscovered error. Test case for Register: Description If dealer wantsregister for his servicing by entering his personal details Expected value Returns an error message by showing. if you entered any wrong name and password or you are already registered for this service. If you entered correct details Then you have successfully registered for this car service Actual value Result When a user tries to register by submitting an incorrect ID or an incorrect Password then it displays an error message “NOT A VALID USER NAME”. If user enter correct details then it displays “Registered successfully” 23 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832 Test case for Name Description If dealer wantsregister for his name he has to enter correct name for that service Returns an error message by showing if you entered any wrong name or you are name is already registered for this service. If you entered correct details Then you have successfully registered for this car service Expected value Actual value Result Test case for Email: Description Expected value If the dealer enters correct email It will return a message as mail has sent success or return an error. If dealer use his correct mail id Then dealer will get mail from our service. Then the output is display as message has send successfully. Actual value Result Test case for phone number: Description Expected value Actual value Result The dealer has to enter his correct phone number details. the service center wants to send any message to dealer by his phone number he can send it. If you gave any wrong details of your number. Then it returns an error. If dealer gave correct phone number. Then you will get message from user. Test case for login Description Expected value Actual value Result If dealer wants to login for the service by entering user id and password Returns a message or show an error If you enter correct details Then you have successfully logged in that service 24 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832 Test case for user id Description In this user id there will be a unique id for every dealer If the id is correct then your output is display or it returns an error. The user need give correct. then your user id is successfully generated. Expected value Actual value Result Test case for password Description In this registration the dealer needs to remember his id and password If he enters any incorrect password then it gets an error message. If dealer enter correct id and password Then your id is center successfully in our service center. Expected value Actual value Result Test case for send message Description When a message is to be sent then the mail id should be valid and it should be in database. If the email id is invalid or not in the data base then it shows an error Dealer should enter correct email id The message will be sent successfully Expected value Actual value Result Test case for view feedback Description Expected value Actual value Result When a message is to be sent then the mail id should be valid and it should be in database. If the email id is invalid or not in the data base then it shows an error user should enter correct email id The message will be sent successfully 25 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832 5.2 IMPLEMENTATION Implementation is the stage where the theoretical design is turned into a working system. The most crucial stage in achieving a new successful system and in giving confidence on the new systems for the users that it will work efficiently and effectively. The system can be implemented only after through testing is done and it is found to work according to the specification. It involves careful planning, investigation of the current system and its constraints on implementation, design of methods to achieve the changeover and an evolution of change over methods apart from planning. Two major tasks of preparing the implementation are education and training of the users and testing of the system. login. Jsp <%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%> <!DOCTYPE html> <html lang="en"> <head> <title>Login</title> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <meta name="description" content="Your description"> <meta name="keywords" content="Your keywords"> <meta name="author" content="Your name"> <link rel="stylesheet" href="css/bootstrap.css" > <link rel="stylesheet" href="css/style.css"> <link rel="stylesheet" href="fonts/font-awesome.css"> <link rel="stylesheet" href="css/owl.carousel.css"> <link rel="stylesheet" href="css/jquery.fancybox.css"> 26 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832 <script src="js/jquery.js"></script> <script src="js/jquery-migrate-1.2.1.min.js"></script> <script src="js/superfish.js"></script> <script src="js/jquery.mobilemenu.js"></script> <script src="js/jquery.easing.1.3.js"></script> <script src="js/jquery.ui.totop.js"></script> <script src="js/jquery.touchSwipe.min.js"></script> <script src="js/jquery.equalheights.js"></script> <script src="js/owl.carousel.js"></script> <script src="js/jquery.fancybox.pack.js"></script> <script src="js/sForm.js"></script> <script src="js/owl.carousel.js"></script> <script> //----------------------------------------------// $(window).load( function(){ //form1 $('#form1').sForm({ ownerEmail:'#', sitename:'sitename.link' }) $(function() {$("a.various").fancybox();}); }); //----------------------------------------------// $(document).ready(function() { var owl = $("#owl-demo"); 27 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832 $(".next").click(function(){ owl.trigger('owl.next'); }) $(".prev").click(function(){ owl.trigger('owl.prev'); }) $("#owl-demo").owlCarousel({ slideSpeed : 300, paginationSpeed : 400, singleItem:true }); }); </script></head><body> <!--============================header=============================--> <header id="header"> <div class="parallax-window" data-parallax="scroll" data-imagesrc="img/bgheader.jpg"> <section class="bgmainhead"> <article class="slogan"> <p>Car Servicing Management System</p> </article> </section> </div> <div id="stuck_container" class="menu-bg"> <div class="container"> 28 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832 <div class="row "> <article class="col-lg-4 col-sm-4 col-xs-12"> <!--<div class="navbar-brand navbar-brand_"><a href="index.html">metamorph_slacal</a></div>--> </article> <article class="col-lg-8 col-sm-8 col-xs-12"> <div class="menuheader"> <nav class="navbar navbar-default navbar-static-top my_navbar" role="navigation"> <ul class="nav sf-menu"> <li ><a href="index.jsp">Home</a></li> <li class="active"><a href="login.html">Login<em class="indicator1"></em></a> <!--<ul> <li><a href="#">Testimonials</a></li> <li><a href="#">Archives</a></li> <li><a href="#">FAQs</a></li> </ul>--> </li> <li><a href="services.jsp">Services</a></li> <li><a href="about.html">About US</a></li> <li><a href="contact.jsp">Contacts</a></li> </ul> </nav> </div> </article> </div> 29 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832 </div> <hr class="headhr"> </div> </header> <!-========================header===============================--> <div id="content"> <!--=========================row_10=============================--> <section class="row_6"> <div class="container"> <div class="row"> <form action="loginAction.jsp" method="post"> <h2 align="center">Login Here........</h2> <imgsrc="img/Loginn.png" class="left img2"></img><br/><br/><br/> <table class="gridtable" align="center"> <tr><td>UserName</td><td><input type="text" name="uname"></td></tr> <tr><td>Password</td><td><input type="password" name="pwd"></td></tr> <tr><td><input type="submit" value="Submit"></td></tr> </table> </form> </div> </div> </section> </div> <!--==========================footer===============================--> <footer> 30 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832 <div class="footerrow1"> <div class="container"> <div class="row"> <article class="col-lg-12"> <p class="footerpriv"><a href="index.html">metamorph_slacal</a><span>&copy;</span><span id="copyrightyear"></span></p> <div id="foo_div">Website Design: <a href="https://www.metamorphozis.com" class="foo_link">metamorphozis</a></div> </article> </div> </div> </div> </footer> <script src="js/bootstrap.min.js"></script> <script src="js/scripts.js"></script> <script src="js/parallax.min.js"></script> </body> </html> Add service. Jsp <%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%> <!DOCTYPE html> <html lang="en"> <head> <title>Services</title> <meta charset="utf-8"> 31 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832 <meta name="viewport" content="width=device-width, initial-scale=1"> <meta name="description" content="Your description"> <meta name="keywords" content="Your keywords"> <meta name="author" content="Your name"> <link rel="stylesheet" href="css/bootstrap.css" > <link rel="stylesheet" href="css/style.css"> <link rel="stylesheet" href="fonts/font-awesome.css"> <link rel="stylesheet" href="css/owl.carousel.css"> <link rel="stylesheet" href="css/jquery.fancybox.css"> <script src="js/jquery.js"></script> <script src="js/jquery-migrate-1.2.1.min.js"></script> <script src="js/superfish.js"></script> <script src="js/jquery.mobilemenu.js"></script> <script src="js/jquery.easing.1.3.js"></script> <script src="js/jquery.ui.totop.js"></script> <script src="js/jquery.touchSwipe.min.js"></script> <script src="js/jquery.equalheights.js"></script> <script src="js/owl.carousel.js"></script> <script src="js/jquery.fancybox.pack.js"></script> <script src="js/sForm.js"></script> <script src="js/owl.carousel.js"></script> <script> //----------------------------------------------// $(window).load( function(){ //form1 32 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832 $('#form1').sForm({ ownerEmail:'#', sitename:'sitename.link' }) $(function() {$("a.various").fancybox();}); }); //----------------------------------------------// $(document).ready(function() { var owl = $("#owl-demo"); $(".next").click(function(){ owl.trigger('owl.next'); }) $(".prev").click(function(){ owl.trigger('owl.prev'); }) $("#owl-demo").owlCarousel({ slideSpeed : 300, paginationSpeed : 400, singleItem:true }); }); </script></head><body> <!--==========================header==============================--> <header id="header"> <div class="parallax-window" data-parallax="scroll" data-imagesrc="img/bgheader.jpg"> <section class="bgmainhead"> 33 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832 <article class="slogan"> <p>Car Servicing Management System</p> </article> </section> </div> <div id="stuck_container" class="menu-bg"> <div class="container"> <div class="row "> <article class="col-lg-4 col-sm-4 col-xs-12"> <!--<div class="navbar-brand navbar-brand_"><a href="index.html">metamorph_slacal</a></div>--> </article> <article class="col-lg-8 col-sm-8 col-xs-12"> <div class="menuheader"> <nav class="navbar navbar-default navbar-static-top my_navbar" role="navigation"><ul class="nav sf-menu"> <li class="active"><a href="index.jsp">Home</a></li> <li><a href="#">Services</a> <ul> <li><a href="addservices.jsp">Add Service</a></li> <li><a href="editservice.jsp">Edit Service</a></li> <li><a href="delservice.jsp">Delete Service</a></li> </ul></li> <li><a href="#">Garages</a> <ul> <li><a href="addgarage.jsp">Add Garage </a></li> 34 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832 <li><a href="editgarage.jsp">Edit Garage</a></li> <li><a href="delsgarage.jsp">Delete Garage</a></li> </ul></li> <li ><a href="viewOrders.jsp">View Orders</a></li> <li ><a href="message.jsp">SendMessage</a></li> <li ><a href="feedback.jsp">View Feedback</a></li> <li><a href="index.jsp">LogOut</a></li> </ul> </nav></div> </article></div></div> <hr class="headhr"> </div> </header> <!--========================header=================================--> <div id="content"> <!--=========================row_10=============================--> <section class="row_6"> <div class="container"> <div class="row"> <form action="serviceAction.jsp" method="post"> <h2 align="center">Add Service Here...........</h2> <table class="gridtable" align="center"> <tr><td>Service Id</td><td><input type="text" name="sid"></td></tr> <tr><td>Service Name</td><td><input type="text" name="name"></td></tr> 35 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832 <tr><td>Service Time</td><td><input type="text" name="time"></td></tr> <tr><td>Service Cost</td><td><input type="text" name="cost"></td></tr> <tr><td>Offer</td><td><textarea rows="5" cols="10" name="offer"></textarea></td></tr> <tr><td><input type="submit" value="Submit"></td></tr> </table></form> <% if(request.getAttribute("ss")!=null){ %> <font color="red">Service Added successfully</font><% }%> </div> </div> </section> </div> <!===========================footer===============================--> <footer> <div class="footerrow1"> <div class="container"> <div class="row"> <article class="col-lg-12"> <p class="footerpriv"><a href="index.html">metamorph_slacal</a><span>&copy;</span><span id="copyrightyear"></span></p> <div id="foo_div">Website Design: <a href="https://www.metamorphozis.com" class="foo_link">metamorphozis</a></div> </article> 36 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832 </div> </div> </div> </footer> <script src="js/bootstrap.min.js"></script> <script src="js/scripts.js"></script> <script src="js/parallax.min.js"></script> </body> </html> Send mail. Jsp <%@page import="java.sql.*"%> <%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "https://www.w3.org/TR/html4/loose.dtd"><html> <head> <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"> <title>Insert title here</title> </head> <body> <% String phno=request.getParameter("phnum"); System.out.println("phnoooooo "+phno); System.out.println("Entered into phnoblock "); %> 37 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832 <table align="center"> <tr><td><font color=white><b>Phone Number</b></font></td><td> <% Class.forName("com.mysql.jdbc.Driver"); Connection con=DriverManager.getConnection("jdbc:mysql:https://localhost:3306/carservice","root",""); PreparedStatementpt=con.prepareStatement("select * from users where userId='"+phno+"'"); ResultSetrs=pt.executeQuery(); while(rs.next()) { %> <input type="text" name=phno value="<%=rs.getString(6)%>"> <% } %> </td></tr></table></body></html> 38 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832 6 OUTPUT SCREENS: HOME PAGE 39 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832 REGISTER PAGE: 40 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832 LOGIN PAGE 41 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832 LOGIN SUCCESSFULLY 42 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832 VIEW SERVICES 43 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832 ADD SERVICES 44 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832 ADDING SERVICE 45 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832 EDIT SERVICES 46 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832 EDITING SERVICE 47 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832 DELETE SERVICE 48 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832 SEARCH GARAGE 49 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832 VIEW GARAGE 50 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832 ADDING GARAGE: 51 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832 EDITING GARAGE 52 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832 DELETE GARAGE 53 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832 SEND MESSAGE 54 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832 MESSAGE SENT SUCCESSFULLY 55 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832 VIEW PROFILE 56 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832 FEED BACK 57 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832 FEED BACK SENT 58 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832 SENT SUCCESSFULLY 59 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832 LOG OUT 60 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832 7.Conclusion: This project developed, incorporated all the activities involved in the browsing centre. It provides all necessary information to the management as well as the customer with the use of this system; the user can simply sit in front of the system and monitor all the activities without any physical movement of the file. Management can service the customer’s request best in time. The system provides quickly and valuable information. These modules have been integrated for effective use of the management for future forecasting and for the current need. 61 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832 8. Scope for Expansion: We think that not a single project is ever considered as complete forever .Because our mind is always thinking something new and our necessities also are growing day by day. We always want something more than what we have. Our application also, If you see at the first glance then you find it to be complete but we want to make it still mature and fully automatically. The future perspective of our project can link our banking system with other centralized bank services so that customer has an ease of transferring money and paying bills. The system can be designed for further enhancement. This could also be developed according to the growing needs of the customer. This project is limited to loan applying, applying credit cards and request cheques. In future we can extend this project by adding more banks, Appling for new check book, Date of transferring money and many more features. 62 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832 9.BIBLIOGRAPHY During the development of our system, we have taken the reference from Books and journals, which we would like to mention in this section. These books acted as our tutors during the system development.  For Java installation   For DB2 installation    https://www.java.com/en/download/ https://www.ibm.com/index.html Reference websites  www.javatpoint.com  www.w3schools.com  https://www.tutorialspoint.com/java/index.htm Reference Books   Thinking in java  OCJP Certified Programmer for Java  Learn Java in Easy Steps  Complete reference Java Researcher Reference Acharya, Kamal. "STUDENT INFORMATION MANAGEMENT SYSTEM." Authorea Preprints (2023). Acharya, Kamal. "Library Management System." Available at SSRN4807104 (2019). ACHARYA, KAMAL, et al. "LIBRARY MANAGEMENT SYSTEM." (2019). Acharya, Kamal. "Online bus reservation system project report." Authorea Preprints (2024). Acharya, Kamal. "Online bus reservation system project report." (2024). Acharya, Kamal. “Online Bus Reservation System.” SSRN ElectroNIC ASIA Journal (2024): n. pag. Acharya, Kamal. “Student Information Management System Project.” SSRN ElectroNIC ASIA Journal (2024): n. pag. Acharya, Kamal. “ATTENDANCE MANAGEMENT SYSTEM.” International Research Journal of Modernization in Engineering Technology and Science (2023): n. pag. Acharya, Kamal. “College Information Management System.” SSRN ElectroNIC 63 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832 ASIA Journal (2024): n. pag. Acharya, Kamal, Attendance Management System Project (April 28, 2024). Available at SSRN: https://ssrn.com/abstract=4810251 or https://dx.doi.org/10.2139/ssrn.4810251 Acharya, Kamal, Online Food Order System (May 2, 2024). Available at SSRN: https://ssrn.com/abstract=4814732 or https://dx.doi.org/10.2139/ssrn.4814732 Acharya, Kamal, University management system project. (May 1, 2024). Availableat SSRN: https://ssrn.com/abstract=4814103 or https://dx.doi.org/10.2139/ssrn.4814103 Acharya, Kamal, Online banking management system. (May 1, 2024). Available at SSRN: https://ssrn.com/abstract=4813597 or https://dx.doi.org/10.2139/ssrn.4813597 Acharya, Kamal, Online Job Portal Management System (May 5, 2024). Available at SSRN: https://ssrn.com/abstract=4817534 or https://dx.doi.org/10.2139/ssrn.4817534 Acharya, Kamal, Employee leave management system. (May 7, 2024). Available at SSRN: https://ssrn.com/abstract=4819626 or https://dx.doi.org/10.2139/ssrn.4819626 Acharya, Kamal, Online electricity billing project report. (May 7, 2024). Available at SSRN: https://ssrn.com/abstract=4819630 or https://dx.doi.org/10.2139/ssrn.4819630 Acharya, Kamal, POLICY MANAGEMENT SYSTEM PROJECT REPORT. (December 10, 2023). Available at SSRN: https://ssrn.com/abstract=4831694 or https://dx.doi.org/10.2139/ssrn.4831694 Acharya, Kamal, Online job placement system project report. (January 10, 2023). Available at SSRN: https://ssrn.com/abstract=4831638 or https://dx.doi.org/10.2139/ssrn.4831638 Acharya, Kamal, Software testing for project report. (May 16, 2023). Available at SSRN: https://ssrn.com/abstract=4831028 or https://dx.doi.org/10.2139/ssrn.4831028 Acharya, Kamal, ONLINE CRIME REPORTING SYSTEM PROJECT. (August 10, 2022). Available at SSRN: https://ssrn.com/abstract=4831015 or https://dx.doi.org/10.2139/ssrn.4831015 Acharya, Kamal, Burber ordering system project report. (October 10, 2022). Available at SSRN: https://ssrn.com/abstract=4832704 or https://dx.doi.org/10.2139/ssrn.4832704 Acharya, Kamal, Teachers Record Management System Project Report (December 10, 2023). Available at SSRN: https://ssrn.com/abstract=4833821 or https://dx.doi.org/10.2139/ssrn.4833821 Acharya, Kamal, Dairy Management System Project Report (December 20, 2020). Available at SSRN: https://ssrn.com/abstract=4835231 or https://dx.doi.org/10.2139/ssrn.4835231 Acharya, Kamal, Electrical Shop Management System Project (December 10, 2019). Available at SSRN: https://ssrn.com/abstract=4835238 or https://dx.doi.org/10.2139/ssrn.4835238 Acharya, Kamal, Online book store management system project report. (Febuary 10, 2020). Available at SSRN: https://ssrn.com/abstract=4835277 or https://dx.doi.org/10.2139/ssrn.4835277 Acharya, Kamal, Paint shop management system project report. (January 10, 2019). Available at 64 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832 SSRN: https://ssrn.com/abstract=4835441 or https://dx.doi.org/10.2139/ssrn.4835441 Acharya, Kamal, Supermarket billing system project report. (August 10, 2021). Available at SSRN: https://ssrn.com/abstract=4835474 or https://dx.doi.org/10.2139/ssrn.4835474 65 | P a g e Electronic copy available at: https://ssrn.com/abstract=4837832