Car Showroom Management System JAVA & SQL Project

The Car Showroom Management System consists of four major fields of management i.e. store cars, store Sales Persons, store admins, store customers and store total sales progress. Here the store admin manages all the activities such as viewing and adding car details, salesperson details, and admin details of different stores. Each store has a Manager and the Manager’s task here is to fill in the details of the car, customer, sales, and workers of a particular store.

The main goal of this application is to maintain the records of different stores which are visible only to the admin and can only be updated by him. It helps to achieve ease of access in searching car details of the selected store, salesperson’s details of the selected store, and sales details of the selected store.

CAR Showroom Management System is a software application to maintain day-to-day activities in the store, This JAVA & SQL project helps to maintain the record of the bike, customers, workers, and sales information Admin manages adds, updates, and deletes the cars, salespersons, and admin records. Admin also can add new admins. The software is designed to handle, the daily activities of all the stores. Search the details when required.

PROJECT PURPOSE

Provides a simple way of accessing the database. Allows the admin to make a search and find certain bikes, customers, and sales records that are linked through a TIN of different stores located at different locations. Provides centralized control of store database. Holds complete information about the customer.

PROJECT SCOPE

The Car Showroom Management System application is designed and developed so that there will be the elimination of storing the records and other details in a hardcopy thereby supporting its eco-friendly nature. The Bike Showroom Management System application is quite simple and easy to use. This application has not had many Complications. It has a very simple way of maintaining the store records such as storing the bike Details of a certain store, customers visiting a certain store, and the sales details of the store that the admin chooses to gain access to.

PROJECT GOAL

This CAR Showroom Management System project aims to show the shadow implementation of JAVA & SQL which includes a better storage facility, update, and view of data. The application provides a user-friendly interface so that the admin can access it with ease.

Download Car Showroom Management System JAVA & SQL Project Source Code, Project Report.

Student Result System Desktop Application in Java

Different Users  Based Access

  1. The Student Result System Application uses Users based access/ security for the General user and the Administrator. Both have different access to different pages
  2. The user is prompted to submit and edit the details submitted.
  3. The Administrator is prompted to enter and manage the information.

Screenshots

MAIN PAGE:

This is the main page of the Student Result System project. It consists of the links to log in, to register the user, to search or book shows for authenticated users, to saw the coming up shows for next seven days etc.

LOGIN PAGE:


REGISTRATION PAGE


RESULT PAGE

FOR USER:

SHOW BRANCH RESULT:

SHOW INDIVIDUAL RESULT:

SOFTWARE SPECIFICATION :

Following Student Result System Software’s are required for developing application:

1 Operating System Windows XP, Vista, Window7
2 Front-end Tool Java
3 Backend Tool SQL Server2005

 Data Flow Diagrams:

Data Flow Diagram For My Menu

Data Flow Diagram for Admin:

Data Flow Diagram for User:

Audience Target

Mainly we are trying to target the students and teachers as our audience. From this project students as well as teachers get benefitted.

Advantages

  • This system helps to reduce the waiting time of the students.
  • Students can see their results according to their preferences.

 Disadvantages

  • It requires an internet connection.
  • It requires a large database.

Remote Desktop Administration Java Project

Remote Desktop Administration application provides remote service to its entire client over the network.

It acts as a network administrator to its client to provide remote service like remote shutdown, remote restart, remote logoff,  remote file transfer , remote software installation , remote desktop sharing and Remote Chatting. 

Modules:

  •  Remote control

Remote control module provides remote operation such as remote shutdown, remote restart and remote logoff it request arrives from client. First it parses the request and provides service to its corresponding client.

  • Remote File transfer

Remote File Transfer contains information for transferring files to the remote location. Remote file transfers are used to transfer files from the development environment to a server that can be installed locally or remotely. We can  transfer files between two connected PCs and chat with the remote user. Transfers files and folders between local and remotely accessed computers.

  • Remote Installation

Remote installation module provide remote software installation to its requested client, it gets the client request and transfer the required installation files and run the exe file through network. Remote installation reduces installation time by providing remote services. All files are transmitted to clients.

  •  Remote Desktop Sharing

Remote Desktop Sharing module provides the administrators to gain access to remote Windows desktops in the network.

Administrator can directly access the remote system by sharing the requested system desktop.

Desktop Sharing is a server application that allows to share current session with a user on another machine, who can use a client to view or even control the desktop.

Desktop Sharing lets users call a remote computer to access its shared desktop and applications.With the Desktop sharing we can operate our office computer from our home or viceversa.

  • Remote Messaging

It does not require a central server and uses very little bandwidth by taking advantage of a lightweight protocol and UDP packets.

Administrator can communicate with the remote systems that are connected With in the local network administrator can communicate publicly or privately.

Messaging is nothing but passing data to and from applications over the network which makes the synchronization of data simple. Messaging allows users across the network to exchange data in real time.

Introduction

The whole PC-based systems, which are available right now, are all running through the Network type communication. This type of system is mainly used in net centers, offices, mainly in industries. It is more time consuming to control all the systems connected in a network manually.

So we thought of developing a new type of system called as REMOTE DESKTOP ADMINISTRATOR.

The operations that can be performed by remote desktop administrator are

  • System shut down
  • System restart
  • System log off
  • Remote files transfer through FTP protocol
  • Remote software installation
  • Remote Desktop Sharing
  • Remote Messaging

Network processing is handled by java socket API, Client requests are passed to application and response will be passes to client without delay.

Remote installation reduces installation time by providing remote services. All files are transmitted to clients.

Purpose

The purpose of this document is to give the overview of the project. The main aim of the project is to develop Remote Desktop Administration environment. It acts as a network administrator to its client to provide remote service like remote shutdown, remote restart, remote logoff, remote file transfer, remote software installation , remote desktop sharing and remote chatting.

Scope

This application has a very wide area of usage. As the number of users increase the scope of the project goes on. There is no limit for this application this can be used to any type of page by anyone based on the restrictions given by the developer.
With this type of application the strength of a page can be increased. The knowledge can be distributed to a large extent.

Overview

The whole PC-based systems, which are available presently are all running through the Network type communication. This type of system is mainly used in net centers, offices, mainly in industries It is more time consuming to control all the systems connected in a network manually.

Remote Desktop administration application provides remote service to its entire client over the network. It acts as a network administrator to its client to provide remote service like remote shutdown, remote restart, remote logoff, remote file transfer,remote software installation ,remote desktop sharing and remote messaging.

System Analysis

Existing System

Network Administrator is a crucial job to monitor and manage systems in a LAN. LAN has different platforms and resources so if the administrator want to monitor or share the resources on the remote systems in the LAN, operating systems doesn’t have compatibility. For example if the Client is running on Windows XP and Server is running on Windows 2000 we don’t have the control on the remote system for doing desktop sharing and also if we want to transfer any file to any remote system we have to depend on 3rd party tools to have common platforms and compatibility. To overcome all these problems we can develop Remote Desktop Administration which can manage and monitor the client and control the remote systems.

Limitations of the Existing System:

1. Inefficiency
2. Cost management
3. Hard to maintain
4. Consistency

Proposed system

Remote Desktop Administration application provides remote service to its entire client over the network. It acts as a network administrator to its client to provide remote service like remote shutdown, remote restart, remote logoff, remote file transfer, remote software installation and remote desktop sharing and remote chatting.

Remote operation such as remote shutdown, remote restart and remote logoff it request arrives from client. First it parses the request and provides service to its corresponding client.

File transfer operation from server to the requested client. First receives the request and recognize the file name, if the file exists in server transfers it otherwise sends a file not found error message.

Remote software installation to its requested client, it gets the client request and transfer the required installation files and run the executable file through network.

Remote Desktop Sharing enables the administrators to gain access to remote Windows desktops in the network.

Remote Desktop Sharing lets users call a remote computer to access its shared desktop and applications. With the desktop Sharing we can Operate our office computer from home or vice versa.

Remote Messaging is a small application that facilitates communication between different hosts on the same local area network. It does not require a central server and uses very little bandwidth by taking advantage of a lightweight protocol and UDP packets.

Auto Spare Parts Java Project

Abstract:

Auto spare parts is a java project developed to buy the spare parts online. Auto spare parts manufacturers industry outlook and online parts strategy are also included in our project. Spare Parts business is being developed by selling the spare parts online. It came under a high profit business area. It contributed the highest net income in auto companies balance sheet.

Modules:

Spare:

In this module users can add all the spare information which includes spare id, spare description, spare type, purchase rate, sale rate and quantity. User can add new spare, update spare, remove spare and add new spare type. User can submit data which save the given information.

Invoice:

Invoices module allows users to give customer name, spare type, quantity, discount and package details. User can select the details of the selected item. User can add or remove new item. User can view the details of the selected items by selecting the show option.

Order:

ustomers can place order in this module by filling the details. Customer can search for the required item. Customer can view the price details of the selected item.

Staff:

Staff id, name ,address, contact number and posts can be displayed in this module. Admin can add, update or remove new staff details.

Customer:

All the details of the customer can be viewed in this module. Admin can add, remove and update new customer details.

Distributor:

All the details of the distributor can be viewed in distributor module which includes name, id, address, phone number and purpose. Admin can add or remove the details of new distributor.

Report:

User can view the stock information, generated bill information in this report module.

User:

User can enter the personal details in this module. User can add, remove or update details of new users.

Developer:

User can view the details of the developer by selecting the developer module.

Software Requirements:

Operating System                   : Microsoft Windows 2007/XP

Languages                               : Java Programming Language.

Database System                    : MS Access