When a computer software succeeds – when it meets the need of the people who use it, when it Performs flawlessly over a long period of time, when it is easy to modify and even easier to use, it can and does change things for better. We all went to build software that makes things better, avoiding the bad things that lurk in the shadow of failing efforts. To succeed, we need discipline when software is designed and built. We need right approach. The advancement in the field of information technology has raised the need for the trained computer professionals. The courses like computer science & engg . are fulfilling the need of computer professionals largely. As the student of C.S.E we have to undergo one year project Training where we often have opportunities to study and develop an application area. This project report is submitted as a part of the four-year course of B.E, conducted by Govt.engg.collage patan. The report submitted herewith presents the analysis, design and development of “Pro-gator “.
In this project,
We have taken JAVA as FRONT-END as it is secure and robust compared to other platforms, MYSQL Server as a BACK-END because it provides a secure and easier way of creating and maintaining the database.
FRONT-END TOOLS : HTML, HTML5, CSS, java, jsp, Servlet, MVC
BACK-END TOOLS : Mysql
LANGUAGE : Java
HISTORY OF GUJARAT TECHNOLOGICAL UNIVERSITY
Gujarat Technological University has been established with the prime objective of ensuring that education in the fields of Engineering, Pharmacy, MBA and MCA is provided at a high level all over the state. The University is required to work for advancement of quality of life of the mankind in general through its work in the domains of science, engineering, management and
computer applications.
The University is working with all the Colleges to sensitize them to the need for high quality of education.
Faculty Development Programs:
The University during the last year has worked so that it today has the largest Faculty Development Program in the country so that the faculty members, most of them young
and relatively new persons to the profession of teaching, can be informed about and trained in different aspect of pedagogy and technology.
Practice-Orientation:
It is also providing to the students, Professors and Principals/ Directors highly innovative facilities for making the technology education more practice-oriented. The Colleges may use it
facilities, created by GTU. Or they may adopt any other methodology. But an active inter-action with industries & businesses and immersion studies by students are required if our education in technology is to come out of the low level rut, into which it has fallen.
New Syllabus and leadership in Learning:
GTU is working to ask its students and teachers to make their classes, laboratories and workshops interesting and inter-active. GTU wants that not even one day out of the calendar should be wasted and learning must not be exam oriented. However we cannot get rid of rote-learning and move towards real understanding of technology if the students and teachers do not ensure full 90 days of contact through classes, laboratories and workshops.
Silverwing provides global Software solutions and theirs affiliated undertakings.
We have an offshore Development Them in Ahmadabad, India. We are engaging our business activities in US and Gulf countries through our own branch. Additionally, we have done several Indian Government projects too.
Our aim is to understand clients business objectives and considers as critical arms of theirs organizations. We mainly focus on developing easy, efficient, and less effort solutions for our clients.
We also assure fast turnaround time, without any compromise on quality. We are also ready to offer your business or services to a wider audience through our strong SEO (Search Engine Optimization) campaigns.
We make every effort the long run clientele and hence 24X7 supports are not only our strategy but our business value. Silverwing Tech. Pvt. Ltd. Has been in collaboration with state government to automate several government processes like construction, water supply, drainage system and also developed product for the state government to automate admission system.
INTRODUCTION
“Pro-gator” is an online Global Portal which brings to makes the right recruiters and right job seeker meet. This Project allows employers to post work and get done. It is an online portal, in which Client can hire Freelancers and Freelancers are to be worked as per decided schedule.
Freelancer has to complete that project within given time, and submit after completion of each phase and get payment from admin after each phase which is already to be taken in advanced from user/Client, they just has to release it at specified time.
PURPOSE
Purpose of this project is to provide a facility to deal with the various projects online. We are providing a personal account to every user (i.e. Client and Freelancer). User can access their own personal account. Any user can post projects and Developers can do work for that user on that posted project by bidding that project. And after completion of each phase get payment from user as the order to be placed to admin for releasing the payment.
The main purpose is to make easy interaction between all these entities.
SCOPE OF SYSTEM
This web application may become applicable for all users who want to have project and also work as freelancers, so that proper payment should be made on time and requires less effort for this work.
OBJECTIVES
Reduce the effort of client and developers with lowest cost. It has advanced searching facility. Also more dynamic GUI.
Technology:
1) Language: JAVA
2) Relational Database Management System: MYSQL 5.5.30
3) Diagrams & Documentation: MS Word 2007
Introduction to Java-J2EE:
JAVA (The Programming Language):
Java is a programming language originally developed by James Gosling at Sun Microsystems (which is now a subsidiary of Oracle Corporation) and released in 1995 as a core component of Sun Microsyst
ems’ Java platform. The language derives much of its syntax from C and C++ but has a simpler object model and fewer low-level facilities.
Introduction to JSP-Servlet:
JSP:
Java server page is the J2
EE technology for generating dynamic web content. JSP specification is provided by sun micro systems for vendors to implement. JSP specification is based on the functionality provided by Servlet specification. JSP specification provides more convenient web page authoring framework than Servlet and simplifies the creation and management of dynamic web content. JSP provides template-based approach to content generation. JSP pages are textual documents containing HTML, XHTML, or XML markup with embedded Java code and custom JSP tags.
Servlet:
Servlet are Java technology’s answer to CGI programming. They are programs that run on a Web server and build Web pages. Building Web pages on the fly is useful (and commonly done) for a number of reasons:
1. The Web page is based on data submitted by the user. For example the results pages from search engines are generated this way, and programs that process orders for e-commerce sites do this as well.
2. The data changes frequently. For example, a weather-report or news headlines page might build the page dynamically, perhaps returning a previously built page if it is still up to date.
3. The web page uses information from corporate databases or other such sources. For example, you would use this for making a Web page at an on-line store that lists current prices and number of times in stock.
Server: Apache Tomcat 8.0.9
Apache Tomcat (or Jakarta Tomcat or simply Tomcat) is an open source Servlet container developed by the Apache Software Foundation (ASF). Tomcat implements the Java Servlet and the Java Server Pages (JSP) specifications from Sun Microsystems, and provides a “pure Java” HTTP web server environment for Java code to run. Tomcat should not be confused with the Apache web server, which is a C implementation of an HTTP web server; these two web servers are not bundled together. Apache Tomcat includes tools for configuration and management, but can also be configured by editing XML configuration files.
Introduction to Eclipse:
Eclipse is a toolkit which is designed for the creation of complex projects, providing fully dynamic web application utilizing EJB’s. This consist of EJB tools , CMP ,data mapping tools & a universal test client that is designed to aid testing of EJB’s.
Eclipse may also be used to develop applications in other programming
Languages: Ada, ABAP, C, C++, COBOL, Fortran, Haskell, JavaScript, Lasso,Lua, Natural, Perl, PHP, Prolog, Python, R, Ruby, Scala, Clojure, Groovy, Scheme, and Erlang.
It can also be used to develop packages for the software Mathematica. Development environments include the Eclipse Java development tools (JDT) for Java and Scala, Eclipse CDT for C/C++ and Eclipse PDT for PHP, among others.
Introduction to MYSQL:
MySQL was originally founded and developed in Sweden by two Swedes and a Finn: David Axmark, Allan Larsson and Michael “Monty” Widenius, who had worked together since the 1980’s.
MySQL is the world’s most popular open source database software, with over 100 million copies of its software downloaded or distributed throughout it’s history. With its superior speed, reliability, and ease of use, MySQL has become the preferred choice for Web, Web 2.0, SaaS, ISV, Telecom companies and forward-thinking corporate IT Managers because it eliminates the major problems associated with downtime, maintenance and administration for modern, online applications.
Many of the world’s largest and fastest-growing organizations use MySQL to save time and money powering their high-volume Web sites, critical business systems, and packaged software — including industry leaders such as Yahoo!, Alcatel-Lucent, Google, Nokia, YouTube, Wikipedia, and Booking.com.
MySQL is a key part of LAMP (Linux, Apache, MySQL, PHP / Perl / Python), the fast-growing open source enterprise software stack. More and more companies are using LAMP as an alternative to expensive proprietary software stacks because of its lower cost and freedom from platform lock-in.
Requirements Of System
Hardware and Software Requirements
Features of System
REQUIREMENTS OF SYSTEM
User requirement
User requirement include not many things, but important things is user must be aware that system works properly with full availability, reliability, security and safety. The user responsibilities are as follows:
Should know how to use the system.
Should aware to guide lines and prescribed standards.
System Requirements (SRS)
Functional Requirements:
R1 Login
Description: this functionality provides two types of user to login. Every user will entered username and password accordingly.
R1.1 Employee login
Pre – processing: Null
Input : Employee enters username and password.
Output : Employee is redirected to home page.
Processing : Details entered by Employee is verified in database.
R1.2 Employer login
Pre – processing: Null
Input : Employer enters username and password.
Output : Employer is redirected to home page.
Processing : Details entered by Employer is verified in database.
R2 Registration
Description: user’s personal details and Skills will be stored in the database.
R1.1 Employee Registration
Pre – processing: Null
Input : Employee enters its personal details and skills.
Output : Employee’s Profile is created and is redirected to his/her profile.
Processing : Details entered by Employee is verified in database.
R1.2 Employer login
Pre – processing: Null
Input : Employer enters its personal details.
Output :Employer’s Profile is created and is redirected to his/her profile.
Processing : Details entered by Employer is verified in database.
R3 Manage profile
Description: Users can view, update and delete their profile by given tab links.
R3.1 Update profile
Pre-processing: Profile exists.
Input : Update information is entered.
Output : Information successfully updated.
Processing : Update operation is performed in database.
R3.2 View profile
Pre-processing: Profile exists.
Input : User clicks on view button.
Output : Profile of user is displayed.
Processing : Select operation is performed in database.
R3.3 Delete profile
Pre-processing: Profile exists.
Input : User clicks on delete button.
Output : User is redirected to home page of site.
Processing : Delete operation is performed.
R4 Post Project.
Description: This functionality provides to post the job or project on the portal.
R4.1 Create job or project.
Pre-processing: Null
Input : Enter basic details of project.
Output : Redirected on next page of post project.
Processing : Basic details stored in database.
R4.2 Select posting type.
Pre-processing:1st step of post project is completed.
Input : Select category and sub category of the project or job.
Output : Redirected on next
page of post project.
Processing : Category stored in database.
R4.3 Preview.
Pre-processing:1st and 2nd step of post project is completed.
Input : Null.
Output : Display whole project details.
Processing : Fetch from the database.
R5 Hire Process.
Description: Hire the freelancers according to project requirement.
R5.1 List of eligible freelancers.
Pre-processing: Project is posted.
Input : Enter skills for the project.
Output : Display List of the Freelancers.
Processing : Fetch from the database.
R5.2 Bid process.
Pre-processing: Project is posted.
Input : enter the price to do this job.
Output : Display List of the Freelancers.
Processing : Fetch from the database.
R6 Rating.
Description: to give rating of particular Employee.
R6.1 Experienced Employee.
Pre-processing: Null.
Input : give rating.
Output : Profile updated.
Processing : Update operation is performed in database.
R6.2 Fresher’s.
Pre-processing: Null.
Input : give test according their skills.
Output : Rating is given on the base of the test result.
Processing : Update operation is performed in database.
R7 Payment module.
Description: provides facility to users to pay or get money.
Pre-processing: margin already selected and biding is completed.
Input : Account details given to the portal.
Output : Employee’s and Employer’s account credited or debited.
Processing : Update operation is performed in database.
Non Functional Requirement
1.1) Reliability
As the term suggests the entire website must be faultless logically. I.e. each transaction must not put the database in inconsistent state. Our design should be such that customers get satisfaction. It should provide trust to customers for their desired stuffs.
1.2) Availability
Our system should run 24×7. Means our application should be available any time when internet connection is available.
At some stage checkpoint are placed so that checking of a system for consistency and redundancy is carried out.
1.3) Security
System should keep history of transaction so that any illegal activity is running then it can be found.
Customer should not have access of all the parts of system. Some parts are restricted to use only for some people i.e. administrator.
1.4) Portability This is a web-application. So it runs on any type of browser application (e.g. Mozilla Firefox, internet explorer, opera, Google chrome etc…). So it supports all operating systems (e.g. all windows platform, all UNIX flavor, Mac operating system).
Hardware and Software Requirements
Software Requirements:
Operating System : Windows 7 and Above
Client-Side : Browser enabled JavaScript
Programming : Java
Web Application : JDBC, Servlet, JSP
Database : MySQL
Server Deployment : Apache Tomcat Server
Hardware Requirements:
Minimum requirement of Processor of Pentium IV, Hard Disk of 80 GB and more and RAM is of 512 MB.
FEATURES SYSTEM
• Advance search is added for finding jobs, freelancers and browse project.
• User can bid on the project so project can completed according to the hirer.
• Hirer can upload files and images which provide more details of project.
DATA DICTIONARY
TABLE NAME : pro_Registration:
DESCRIPTION : This table is stores information about of users.
PRIMARY KEY: rId
Field name Data type Constraints Description
Rid INT(10) Primary key, Not Null, Auto Increment Registration Id
Fname VARCHAR(20) Not Null FirstName
Lname VARCHAR(20) Not Null LastName
Email VARCHAR(255) Not Null E-Mail Address(unique)
Country VARCHAR(30) Not Null Country Name
Company_name VARCHAR(30) Not Null Company_name
Username VARCHAR(20) Not Null Username(Unique)
Password VARCHAR(40) Not Null Password
Usertype VARCHAR(10) Not Null Confirm Password
Membersince VARCHAR(10) Not Null Member Singce
Timestamp Timestamp Not Null Registration Time and Date(System
Time & Date)
Status Int(5) Not Null Status for E-mail Conformation
Accstatus Int(5) Not Null AccountStatus active or not
TABLE NAME : pro_Categories:
DESCRIPTION : This table stores information about project categories.
PRIMARY KEY: Cid
Field name Data type Constraints Description
cid INT(10) Primary key, Not Null, Auto Increment Category Id
Cname VARCHAR(60) Category Name Name Of Category
Status Int(5) Not Null(Default 1) For Active/Deactive
TABLE NAME : Jobfest_Subcategories
DESCRIPTION : This table is stores information about project subcategories.
PRIMARY KEY: Sid
Field name Data type Constraints Description
Sid INT(10) Primary key, Not Null, Auto Increment Subcategory Id
Sname VARCHAR(60) Not Null Subcategory Name
cid Int(5) Foreign Key Reference Categories Category Id
TABLE NAME : pro_skills
DESCRIPTION : This table is stores the information about developer skill.
PRIMARY KEY:skillid
Field name Data type Constraints Description
Skillid INT(10) Primary key, Not Null, Auto Increment SkillId(AutoIncrement)
Skillname VARCHAR(10) Not Null Skill name
cid Int(5) Foreign key reference Categories Category id
TABLE NAME : pro_postproject
DESCRIPTION : This table is stores information about project.
PRIMARY KEY: Ppid
Field name Data type Constraints Description
Ppid INT(10) Primary key, Not Null, Auto Increment Project id
cid INT(10) Foreign key references cid in Categories Category id
Sid INT(10) Foreign key references sid in subcategories Subcategory id
project_title VARCHAR(45) Not Null Project Title
project_desc VARCHAR(45) Not Null Description about Project
project_skills VARCHAR(45) Not Null Required skill for Project
project_hour VARCHAR(45) Not Null Total hour to complete the project
project_budget VARCHAR(45) Not Null Budget of project
post_date Date Not Null Date of the Project post
Rid INT(15) Foreign key references rid in Registration Registration id
p_sdate Date Not Null Project Start date
p_status INT(5) Not Null Status of the project active/deactivate
< p>
TABLE NAME : pro_profile
DESCRIPTION : This table is stores information about developer profile.
PRIMARY KEY:profileid
Field name Data ty
pe Constraints Description
ProfileId INT(10) Primary key, Not Null, Auto Increment Profile Id
imagepath VARCHAR(8) Not Null Image name
Yourself VARCHAR(500) Not Null About your self
RegId Int(5) Foreign key reference Registration Registration id
Degree VARCHAR(30) Not Null Degree(Graduation-Post Graduation)
Contact VARCHAR(11) Not Null Mobile Number
Experience VARCHAR(10) Not Null Experience in year
Username VARCHAR(15) Not Null UserName of the user
TABLE NAME : pro_bid
DESCRIPTION : This table is stores the information about bid project.
PRIMARY KEY:bid
Field name Data type Constraints Description
Bid INT(5) Primary key, Not Null, Auto Increment Bid Id
Ppid INT(5) Foreigh key reference postproject
Not Null Id of project on which bidding on it
Rid INT(5) Foreign key reference Registration Not Null Id of person who done bidding
Rupees INT(20) Not Null Rupees per project
Days INT(5) Not Null No. Of Days for Bidding Process on
TABLE NAME : pro_postQuery
DESCRIPTION : This table is stores the information about postquery.
PRIMARY KEY:queryid
Field Name DataType Constraints Description
queryId INT(5) Primary key AutoIncrement Query Id of the query
Query VARCHAR(200) Not Null Query who asked by visitor
Timestamp TIMESTAMP Current Time Current time and date of the system
RegId INT(5) Foreign key Reference Registration Id of user who post a Query
Description VARCHAR(255) Not Null Describe about your query
TABLE NAME : pro_answer
DESCRIPTION : This table is stores information about answer by developer.
PRIMARY KEY: ansid
Field Name DataType Constraints Description
AnsId INT(5) Primary keyAuto Increment Answer Id of the Answer
Answer VARCHAR(255) Not Null Answer of the query
queryId INT(5) Foreign key Reference postquery Id of the query
RegId INT(5) Foreign key Reference Registration Id of user who post an Answer
Timestamp TIMESTAMP Default-Current Time & date Current System & Date
TABLE NAME : pro_feedback
DESCRIPTION : This table is stores the information about feedback.
PRIMARY KEY: feedid
Field Name DataType Constraints Description
FeedId INT(5) PRIMARY KEY FeedbackId
Name VARCHAR(20) NOT NULL Name of user
Email VARCHAR(255) NOT NULL Email Address
Message VARCHAR(200) NOT NULL Comment
ENTITY RELATIONSHIP DIAGRAM (ERD):-
USE CASE DIAGRAM
Sequence Diagram
Activity Diagram
WEBSITES:
www.w3schools.com
http://www.javatpoint.com
http://www.tutorialspoint.com/java/
www.google.com