my city portal

84
Project Report On CITY PORTAL Submitted in partial fulfillment of Award of the degree of Master of Computer Application Submitted by Kiran Chauhan Roll No: 0803814046 I.T.S - Management & IT Institute Mohan Nagar, Ghaziabad Under the supervision of Mr. Vinod Kumar Organization Address: 503, Tradex Tower-II Greater Noida-2010301(UP), INDIA Ph- +91-120-2510038 E:[email protected] http://www.validpage.com

Upload: nishant-mittal

Post on 26-Mar-2015

587 views

Category:

Documents


1 download

TRANSCRIPT

Page 1: My City Portal

Project Report On

CITY PORTAL

Submitted in partial fulfillment of Award of the degree of

Master of Computer Application

Submitted by

Kiran ChauhanRoll No: 0803814046

I.T.S - Management & IT InstituteMohan Nagar, Ghaziabad

Under the supervision of

Mr. Vinod KumarOrganization Address:503, Tradex Tower-II

Greater Noida-2010301(UP), INDIAPh- +91-120-2510038E:[email protected]

http://www.validpage.com

Page 2: My City Portal

Department of Information Technology

I.T.S – Management & IT Institute

Mohan Nagar, Ghaziabad (2008 – 2011)

ACKNOWLEDGEMENT

This project holds a high position in my career. My determination, knowledge and

perseverance have helped me to put my best in this project. My goal was to give an

appreciating an outstanding performance. This project has made me to work and adjust with

people around, and surroundings.

Completing a task is never one-man effort. It is often the result of invaluable contribution of

number of individuals in a direct or indirect manner that helps in sharing a making success. I

take this opportunity to express my deep sense of gratitude and whole hearted thanks to my

guide Mr. Vinod Kumar for his valuable guidance and interest thought the work.

I am also thankful to my project mentor Prof. Simmi Srivastava for his valuable guidance

and interest thought the work.

Last but not the least I would like to thank my parents for their willing help and support at all

time.

Kiran Chauhan

Page 3: My City Portal

I.T.S – Management & IT InstituteMohan Nagar, Ghaziabad

This is to certify that the Project Report (MCA-612) entitled “City Portal” done by Ms

Kiran Chauhan, Roll No. 0803814046 is an authentic work carried out by him at Valid

Page, Noida under my guidance. The matter embodied in this project work has not

been submitted earlier for the award of any degree or diploma to the best of my

knowledge and belief.

Date:30/04/2011 Signature of the Guide(Simmi Srivastava)

I.T.S-Management & IT InstituteMohan Nagar, Ghaziabad

Page 4: My City Portal

CONTENTS

1. Introduction

1.1 Objective of the project

1.2 Purpose

1.3 Technologies used

1.4 Overview

1.5 Key Features of City Portal

1.6 Features of Java and SQL Server

2. Module Description

2.1 Goals of Proposed System

2.2 Project Requirements

2.3 User Characteristics

2.4 Constraints

2.5 Definition of Problems

2.6 Feasibility

3. Analysis

3.1 Data Flow Diagrams

3.2 E-R Diagrams

4. Design

4.1 Table Structure

Page 5: My City Portal

4.2 Data Dictionary

4.3 User Interface (Forms and reports)

5. Screen Layouts & Design

6. Code

7. Conclusion

8. Future Scope

9. References

Page 6: My City Portal

Abstract:

The City Portal is used to give the information’s on various places of Noida. Any user

can view the information online by which the user can improve their skills in various

subjects. User has to register itself before to post the advertisement. As the user

register itself he/she will get a system generated id so that Admin can identify the

users uniquely. After the successfully registration user will be able to post the

advertisement.

City Portal uses SQL Server2005 as the back end for the database and uses all its

Features offered in the web based technology for its transactions.

City Portal uses the Java as the middle ware for its business logic implementation

Page 7: My City Portal

1. Introduction

1.1) Objective of the project

City Portal is an information portal that is proposed to provide various information about

noida like News, Entertainment Places, Educational institutes, social activities, E-

classification, Hotels and other important places such as banks, shopping centers, commercial

complexes etc.

The portal aims to provide complete information about Noida using the following three

mechanisms:

Information compiled by the parent company from different sources is to be presented on

the web site after through verification.

Information to be collected through classifieds posted on the portal by various social,

businesses, educational and professional entities having operations in Noida is to be

presented.

Links of existing websites providing information about Noida are to be provided.

1.2) Purpose

The Software is to get the information about Noida.

It maintains levels of users:- User Level

The Software includes:-Maintaining Noida Details

Page 8: My City Portal

1.3) Technologies used

This project will be an application to be developed in Java having Ms Access as back end.

Database Design (Sql Server 2005)

Form Design (Java)

Coding (Java)

Testing (Java)

1.4) Overview

Project is related to City Portal for Noida. The project maintains user levels:-

User Level-Data Entry Operator

Admin Level-Data Handled Operator

Main facilities available in this project are:

Maintaining Information’s about Noida.

Update and removal of add and news will be automatically updated in

the database.

User can publish an Advertisement.

1.5) Key features of City Portal

Data is secured under password protection.

Facility to easily add, finds, edit and delete any information by

ADMIN.

User friendly.

Efficient performance

1.6) Features of Java and Sql Server 2005

Some of the important features of Java have been discussed below:-

Page 9: My City Portal

Java is a pure object oriented programming language.

Java is a platform independent language

Java is a robust language since it has strict compile time and runtime

checking of code.

It supports multithreaded programming, which allows user to write

programs that perform many functions simultaneously.

Java is designed for distributed environment of the internet, because it

handles TCP/IP protocol

Some of the important features of Sql Server 2005 have been discussed below:-

Sql Server 2005 a database management system that delivers a flexible

& cost effective database platform to build robust on demand business

application.

SQL Server 2005 supports rich, full-text search applications.

Cataloging capabilities provide greater flexibility over what is

cataloged. Query performance and scalability have been improved

dramatically, and new management tools provide greater insight into

the full-text implementation.

Microsoft SQL Server 2005 is comprehensive, integrated data

management and analysis software that enables organizations to

reliably manage mission-critical information and confidently run

today’s increasingly complex business applications. SQL Server 2005

allows companies to gain greater insight from their business

information and achieve faster results for a competitive advantage

SQL Server 2005 (codename Yukon), released in October 2005, is the

successor to SQL Server 2000. It included native support for managing

XML data, in addition to relational data. For this purpose, it defined an

xml data type that could be used either as a data type in database

columns or as literals in queries.

Page 10: My City Portal

The database can be managed on other DBMS also but Sql Server 2005 fulfils the least

Requirement of our application.

2. Module Description

2.1) Goals of proposed system

1. Planned approach towards working: - The working in the organization will be well

planned and organized. The data will be stored properly in data stores, which will help in

retrieval of information as well as its storage.

2. Accuracy: - The level of accuracy in the proposed system will be higher. All operation

would be done correctly and it ensures that whatever information incoming from the center is

accurate.

3. Reliability: - The reliability of the proposed system will be high due to the above stated

reasons. The reason for the increased reliability of the system is that now there would be

proper storage of information.

4. No Redundancy: - In the proposed system almost care would be that no information is

repeated anywhere, in storage or otherwise. This would assure economic use of storage space

and consistency in the data stored.

5. Immediate retrieval of information: - The main objective of proposed system is to

provide for a quick and efficient retrieval of information. Any type of information would be

available whenever the user requires.

6. Immediate storage of information: - In manual system there are many problems to store

the largest amount of information.

Page 11: My City Portal

7. Easy to Operate: - The system should be easy to operate and should be such that it can be

developed within a short period of time and fit in the limited budget of the user.

2.2) Project Minimum Requirements

Hardware Requirements

Processor: - Core 2 Duos

RAM: - 1GB

Hard Disk: - 250MB

Software Requirements

Operating System: - Win-98/XP/VISTA/7 O.S.

Sql Server 2005

Java (1.5 or later version)

2.3) User Characteristic

Every user should be:-

Comfortable of working with computer.

She/he must also have basic knowledge of English too.

2.4) Constraints

GUI is only in English.

Login and password are used for identification of user.

The application works on a standalone system.

All the rights are reserved by the Administrator i.e

Administrator can edit/insert/delete the entries.

Page 12: My City Portal

A single field cannot have multiple values.

Primary Key fields cannot have ‘Null’ value.

2.5) Definitions of problems

Problems with conventional system

1. Lack of immediate retrievals: -The information is very difficult to get and to find

particular information like- E.g. - To find out the information about Education in

Noida , the user has to go through various college or school etc . This results in

inconvenience and wastage of time.

2. Preparation of accurate and prompt reports: - This becomes a difficult task as

information is difficult to collect from various registers.

2.6) Feasibility

Depending on the results of the initial investigation the survey is now expanded to a more

detailed feasibility study. “FEASIBILITY STUDY” is a test of system proposal according

to its workability, impact of the organization, ability to meet needs and effective use of the

resources.

Steps in feasibility analysis

Eight steps involved in the feasibility analysis are:

Form a project team and appoint a project leader.

Prepare system flowcharts.

Enumerate potential proposed system.

Define and identify characteristics of proposed system.

Determine and evaluate performance and cost Effective of each

Proposed system.

Weight system performance and cost data.

Select the best-proposed system.

2.6.1) Technical feasibility

Page 13: My City Portal

A Study of resource availability that may affect the ability to achieve an acceptable

system. This evaluation determines whether the technology needed for the proposed

system is available or not.

Can the work for the project be done with current equipment existing

Software technology & available personal?

Can the system be upgraded if developed?

If new technology is needed then what can be developed?

This is concerned with specifying equipment and software that will successfully satisfy

the user requirement. The technical needs of the system may include:

Front-end and back-end selection

An important issue for the development of a project is the selection of suitable front-end

and back-end. When we decided to develop the project we went through an extensive study

to determine the most suitable platform that suits the needs of the organization as well as

helps in development of the project.

The aspects of our study included the following factors.

Front-end selection:

1. It must have a graphical user interface that assists employees that are

not from IT background.

2. Scalability and extensibility.

3. Flexibility.

4. Robustness.

5. According to the organization requirement and the culture.

6. Must provide excellent reporting features with good printings support.

7. Platform independent.

8. Easy to debug and maintain.

9. Event driven programming facility.

10. Front end must support some popular back end like Ms Access.

Page 14: My City Portal

According to the above stated features we selected Java as the front-end for developing

our project.

Back-end Selection:

1. Multiple user support.

2. Efficient data handling.

3. Provide inherent features for security.

4. Efficient data retrieval and maintenance.

5. Stored procedures.

6. Popularity.

7. Operating System compatible.

8. Easy to install.

9. Various drivers must be available.

10. Easy to implant with the Front-end.

According to above stated features we selected Sql Server 2005 as the backend.

The technical feasibility is frequently the most difficult area encountered at this stage. it is

essential that the process of analysis and definition be conducted in parallel with an

assessment to technical

Feasibility it centers on the existing computer system (hardware, software etc.) and to what

extent it can support the proposed system.

2.6.2) Economical feasibility

Economic justification is generally the “Bottom Line” consideration for most systems.

economic justification includes a broad range of concerns that includes cost benefit analysis.

In this we weight the cost and the benefits associated with the candidate system and if it suits

the basic purpose of the organization i.e. profit making, the project is making to the analysis

and design phase.

The financial and the economic questions during the preliminary investigation are verified to

estimate the following:

Cost to conduct a full system investigation.

Page 15: My City Portal

The cost of hardware and software for the class of application being

considered.

The benefits in the form of reduced cost.

The proposed system will give the minute information, as a result the

performance is improved which in turn may be expected to provide

increased profits.

This feasibility checks whether the system can be developed with the

available funds.

The City Portal does not require enormous amount of money to be developed. This can be

done economically if planned judicially, so it is economically feasible. The cost of project

depends upon how much information will be containing it.

2.6.3) Operational Feasibility

It is mainly related to human organizations and political aspects. The points to be

considered are:

What changes will be brought with the system?

What organization structures are disturbed?

What new skills will be required?

Do the existing staff members have these skills? If not, can they be trained in due course of

time? The system is operationally feasible as it very easy for the End users to operate it. It

only needs basic information about Windows platform the End users to operate it. It only

needs basic information about Windows platform

.

2.6.4) Schedule Feasibility

Page 16: My City Portal

Time evaluation is the most important consideration in the development of project. The time

schedule required for the developed of this project is very important since more development

time effect machine time, cost and cause delay in the development of other systems

3. Analysis

3.1 Data Flow Diagrams

3.1.1) Context Level DFD for Noida

Page 17: My City Portal

3.1.2) LEVEL–1 DFD for Noida

NoidaPoint

Search Information

View Information

Search Ads

View Ads

Send Response

Registration

Login

Post a new Ad.

Edit & Maintain ads

View Responses

ADMINISTRATOR

Edit Inform

ation

View

Regd. U

sers

Post Inform

ation

VIEWER POSTER

Page 18: My City Portal

Database

Search Ads

View Ads

Send Response

Ads

Category

Database

Login Process

View Responses

Post Ads

EditAds

Registered Users

Administrator

MaintainCategory View

Registered Users

Send Notification

Manage Info

MaintainAdvertisers’Details

Database

Viewer

Search Information

View Information

Poster

New Poster

Page 19: My City Portal

MODULES AND THEIR DESCRIPTION

1. Search Ads:

Through this module Viewer can view ads, can also send

response to particular poster.

2. Login :

In this module Poster enter the User id and password is

checked and only valid user id and password will get entry

into member’s zone. This is a security feature to avoid entry of

unauthorized users.

3. Registration Process:

Through this module new posters can registered them. After

giving their details, they will get a user id and password. Then

to get entry into poster section they need to provide this id and

password and only poster with valid id and password will get

entry into poster zone. This is also a security feature to avoid

entry of unauthorized user.

4. Manage Information:

Through this module works to provide information details

about various companies, institutes, banks, famous places and

social activities etc.

Page 20: My City Portal

5. Poster :

Through this module a poster can post a new ad, update ad

details. He/she can update including user name and password

and search and shortlist the Viewers, check the status of

advertisement’s response. He/she can reply to the viewers In

short this module deals with the whole advertisement process.

6. Administrator:

This is the Administrator’s module by which he/she keep the

eye on whole site and maintain and upgrade the site’s service

for sake of users. Administrator can show banner ads of others,

which help the site in revenue.

Page 21: My City Portal

3.2 E-R Diagrams

AD

Category AD Viewer

Phone no

AD poster

Category description

Views

Date of viewing

M

M

Sends response

V id

AD idResponse id

Response text

Date

1

M

Posts

AD id1 M

Maintains

1 MDate

Belongs

1

1

Category id

P_id

AD id

Date

Responses

Title

AD id

Category

Image

City

Status

Description

Category id

AD id

Poster ID

Address

Passwod

Email

NameCategory

Page 22: My City Portal

4. Design

4.1 Table Structure

1.Poster Login: This table shall store login information of the registered users who post

their classifieds on the portal. It contains following fields.

Fields Data Type Size Constraint

userid number 10 Foreign key(poster)

Login Varchar2 20

Passwrd Varchar2 15 Primary Key

2. Poster Table: This table shall store information about the registered users who post

their classifieds on the portal. It contains following fields.

Field name Data type Constraint/Description

userId Number Primary key, (Auto Generated)

regdate Number Not Null

firstname Varchar2 Not Null

lastname Varchar2 Not Null

address Varchar2 Not Null

sex Varchar2 Not Null

emailid Varchar2 Not Null

password Varchar2 Not Null

Page 23: My City Portal

3. Classified: This table shall store information about the classifieds posted by the users on

the portal. It contains following fields.

Field name Data type Constraint/Description

CategoryId Varchar2 Not Null

Title Varchar2 Not Null

userId Number Foreign key (Poster)

postingDate Date Not Null

expirayDate Date Not Null

description Varchar2 Not Null

photos Varchar2 Not Null

city Varchar2 Not Null

adderess Varchar2 Not Null

email Varchar2 Not Null

mobilenumber number Not Null

4. ATM: This table contains information of all the ATMs of Noida. It contains following

fields.

Field name Data type Constraint/Description

atmId Number Primary key, (Auto Generated)

bankName Varchar2 Not Null

location Varchar2 Not Null

landmark Varchar2

Page 24: My City Portal

5. Bank: This table contains information of all the Banks of Noida. It contains following

fields.

Field name Data type Constraint/Description

bankId Number Primary key, (Auto Generated)

bankName Varchar2 Not Null

6. BankBranch: This table contains information of all the branches of a Bank in Noida. It

contains following fields.

Field name Data type Constraint/Description

branchId Number Primary key, (Auto Generated)

bankId Number Foreign key, (Auto Generated)

location Varchar2 Not Null

landmark Varchar2

contactNo Varchar2

faxNo Varchar2

7. BookShop: This table contains information of all the Book shops of Noida. It contains

following fields.

Field name Data type Constraint/Description

shopId Number Primary key, (Auto Generated)

shopName Varchar2 Not Null

location Varchar2 Not Null

Page 25: My City Portal

landmark Varchar2

contactNo Varchar2

8. ITCompany: This table contains information of all the IT Companies situated in

Noida. It contains following fields..

Field name Data type Constraint/Description

companyId Number Primary key, (Auto Generated)

Name Varchar2 Not Null

location Varchar2 Not Null

workArea Varchar2

landmark Varchar2

contactNo Varchar2

9. Markets: This table contains information of all the Markets of Noida. It contains

following fields.

Field name Data type Constraint/Description

marketId Number Primary key, (Auto Generated)

Name Varchar2 Not Null

location Varchar2 Not Null

landmark Varchar2

Page 26: My City Portal

4.2) Data Dictionary

A Data dictionary is a repository or a catalogue of the entire element in a system. It is the

document that collect coordinated & confirms what a specific data term means to different

item in an organization.

It contain about the data held in the in the database including all the record & field type range

of acceptable value &access authorization information.

The Data Dictionary is a system file rather than a user a file also knows as catalogue or

Repository.

I used Data Dictionary to furnished information to the faculty that which type of data it is

where used.

Data dictionary is important for following reason:

To manage the details

Communicate meaning

Facilitates system analysis

Locate error & omission

Page 27: My City Portal

4.3) User Interface

Admin table:

Page 28: My City Portal

Details Of admin Table:

Page 29: My City Portal

School Table:

Page 30: My City Portal

College Table:

Page 31: My City Portal

Mall Table:

Page 32: My City Portal

Police Station Table:

Page 33: My City Portal

Hospital Table:

Page 34: My City Portal

5. Screen Layouts & Design

1. Home Form

2. Login Form

3. Registeration Form

4. Noida Information Form

4.1 Map of Noida

5. Education Details in Noida

5.1. University in Noida

5.2 College in Noida

5.3 Schools in Noida

5.4 Coaching institute in Noida

6. Hotels in Noida

6.1 Booking in a Hotel

7. Classified Form

Page 35: My City Portal

Home Form

Page 36: My City Portal

Noida Information Form:

Page 37: My City Portal
Page 38: My City Portal

Login Form:

Page 39: My City Portal

Registration Form:

Page 40: My City Portal

Education Form:

Page 41: My City Portal

University Form:

Page 42: My City Portal

School Form:

Page 43: My City Portal

Insitute Form:

Page 44: My City Portal

Coaching centers:

Page 45: My City Portal

Hotels in Noida:

Page 46: My City Portal

Booking form :

Page 47: My City Portal

Classified Form:

Page 48: My City Portal

6. code:

<HTML><HEAD><TITLE>eschoppe International - Equestrian Products

Supplier</TITLE>

<form method=get action=./log.jsp>

<META content="text/html; charset=windows-1252" http-equiv=Content-Type>

<META content="MSHTML 5.00.2919.6307" name=GENERATOR>

<script language="javascript" src="Rtclk.js"></script>

</HEAD>

<BODY leftMargin=0 topMargin=0 marginwidth="0" marginheight="0"

bgcolor="#D9E6EC">

<DIV align=center>

<DIV align=center>

<TABLE bgColor=#ffffff border=0 cellPadding=0 cellSpacing=0 width=770>

<TBODY>

<TR>

<TD align=middle vAlign=center width=160 rowspan="2">&nbsp;

</TD>

<TD align=right vAlign=center width=446>&nbsp;

</TD>

<TD align=right vAlign=center width=203 rowspan="2">&nbsp;

</TD>

</TR>

<TR>

<TD align=right vAlign=center width=446>&nbsp;

</TD>

</TR>

<TR>

<TD align=middle vAlign=center width=160>

Page 49: My City Portal

<img border="0" src="images/noida3.JPG" width="203" height="178"></TD>

<TD align=right vAlign=center width=446>

<marquee style="color: #FFFFFF; font-weight: bold" bgcolor="#4F0000">Welcome to

Noida City </marquee></TD>

<TD align=right vAlign=center width=203>

<img border="0" src="images/noida7.jpg" width="203" height="178"></TD>

</TR></TBODY></TABLE></DIV>

<DIV align=center>

<CENTER><TABLE border=0 cellPadding=0 cellSpacing=0 width=770>

<TBODY> <TR><TD width="100%" height="69"> <DIV align=center>

<TABLE border=0 cellPadding=0 cellSpacing=0 width="100%">

<TBODY> <TR> <TD height="58">

<DIV align=center>

<TABLE border=0 cellPadding=0 cellSpacing=0 width="100%" height="55">

<TBODY>

<TR>

<TD height=46 width="100%">

<DIV align=center>

<TABLE border=0 cellPadding=0 cellSpacing=0 width="100%" height="38">

<TBODY>

<TR>

<TD align=left class=dark vAlign=top height="31"></TD>

<TD class=dark width="100%" height="31"

bgcolor="#FFFFCC"><I>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs

p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

<font color="#4F0000">&nbsp;</font></I><font color="#4F0000"><b><font

size="6">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&

nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;City portal

</font></b></font>

<TABLE border=0 cellPadding=0 cellSpacing=0 width=770>

Page 50: My City Portal

<TBODY>

<TR>

<TD width="100%" height="646">

<DIV align=center>

<TABLE border=0 cellPadding=0 cellSpacing=0 width="100%">

<TBODY>

<TR>

<TD height="617">

<DIV align=center>

<TABLE border=0 cellPadding=0 cellSpacing=0 class=border

width="100%" height="607">

<TBODY>

<TR>

<TD bgColor=#ffffff width="100%" height="591">

<DIV align=center>

<TABLE bgColor="#F8FCF8" border=0 cellPadding=0 cellSpacing=0

width="100%" height="384">

<TBODY>

<TR>

<TD width="51%" height="284" align=middle vAlign=top>

<img border="2" src="images/Noida-Entry-Gate.gif" width="338" height="323"></TD>

<TD align=middle vAlign=top width="49%" height="384<fieldset style="border:1px solid

#4F0000; width: 250px; height: 176px; padding-left:4px; padding-right:4px; padding-

top:1px; padding-bottom:1px">

<legend><b><font color="#4F0000" size="4">Login.......</font></b></legend>

<table width="268">

<tr>

<td width="60" height="53">Types of Users&nbsp;&nbsp; </td>

<td width="30">:</td>

<td width="189">

<select name="Users">

Page 51: My City Portal

<Option value="administrator">Administrtor</option>

<Option value="Users">Users</option>

</select>

</td>

</tr>

<tr>

<td height="33">User Name</td>

<td>:</td>

<td><input type="text"name="username"/></td>

</tr>

<tr>

<td height="32">Password</td>

<td>:</td>

<td><input type="text" name="password"></td>

</tr>

</table>

<table width="242">

<tr>

<td align="center" width="236" height="40">

<input type="submit"value="Sign In" name="signin" ></td>

</tr>

</table>

</fieldset>

<p><a href="register.html">Create an Account</a></p>

<input type="submit"value="Sign Up" name="signup" ></a></TD>

</TR>

</TBODY>

</TABLE>

<p>&nbsp;</p></DIV></TD></TR></TBODY></TABLE></DIV></TD></TR>

<TR>

<TD align=left class=dark height=15

Page 52: My City Portal

vAlign=bottom bgcolor="#003300">

<div align="center"><font color="#FFFFFF">INSTITUTE OF TECHNOLOGY

AND SCIENCE</font></div>

</TD>

</TR></TBODY></TABLE></DIV></TD></TR></TBODY></TABLE></DIV></

BODY></HTML>

Log.jsp:

<%@page import="java.io.File"%>

<%@page import="java.util.*"%>

<%@page import="java.awt.*"%>

<%@page import="javax.swing.*"%>

<%@page import="java.sql.*" errorPage="MyError.jsp"%>

<HTML>

<BODY>

<%

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

String url = "jdbc:odbc:DRIVER={SQL Server};Server=Kiran;Database=new data base;";

conn = DriverManager.getConnection(url,"","");

Connection cn=null;

String uname=request.getParameter("uname");

String pass=request.getParameter("pass");

try

{

ResultSet rs=st.executeQuery("Select * from userdetail ");

if(!rs.next())

{

%>

user details given from uname :<%=request.getParameter("uname")%> are not valid

<br/>try again

<%@include file="Login.html"%>

Page 53: My City Portal

</BODY></HTML>

<%

return;

}//close if block

}//close try block

finally

{

try

{

//cn.close();

}catch(Exception e){ }

}

%>

This is a Home Page<br/>

Welcome,<%=uname%>

</BODY>

</HTML>

Classified Form:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<HTML>

<HEAD>

<TITLE> New Document </TITLE>

<META NAME="Generator" CONTENT="EditPlus">

<META NAME="Author" CONTENT="">

<META NAME="Keywords" CONTENT="">

<META NAME="Description" CONTENT="">

<script language="JavaScript" type="text/javascript">

//--------------- LOCALIZEABLE GLOBALS ---------------

var d=new Date();

Page 54: My City Portal

var monthname=new

Array("January","February","March","April","May","June","July","August","September","O

ctober","November","December");

//Ensure correct for language. English is "January 1, 2004"

var TODAY = monthname[d.getMonth()] + " " + d.getDate() + ", " + d.getFullYear();

//--------------- END LOCALIZEABLE ---------------

</script>

</HEAD>

<BODY bgcolor="#F8FCF8">

<div>

<table>

<tr bgcolor="#C9C299">

<td colspan="7" height="20">&nbsp;&nbsp;<script

language="JavaScript" type="text/javascript">

document.write(TODAY);

</script>

</table>

<form name="form1" method="post" action="" align="center">

<table align ="center" cellspacing="0">

<tr bgcolor="#FFF8C6">

<td width="428" height="70">

<label for="select">Main category<em>*</em>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</label>

<select name="select" >

<option value="0">Choose</option>

<option value="1"> Electronics </option>

<option value="16"> Real Estate </option>

<option value="25"> Cars &amp; Bikes </option>

<option value="36"> Home &amp; Lifestyle </option>

<option value="550">Jobs</option>

Page 55: My City Portal

<option value="64">Services</option>

<option value="93"> Education &amp; learning</option>

<option value="106">Pets &amp; Pet Care</option>

</select>

<option value="36"> </option>

</select>

</li></td>

</tr>

<tr></tr>

<tr bgcolor="#FFF8C6">

<td height="50">

<label

for="textfield">Title<em>*</em>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

&nbsp;&nbsp;&nbsp;</label><input type="text" name="textfield" id="textfield"

size="40"></td>

<TR>

<TD height="50">Posted

Date :&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp

;

<select ><option value="" selected>Date</option><option value="1">1</option><option

value="2">2</option><option value="3">3</option><option value="4">4</option><option

value="5">5</option><option value="6">6</option><option value="7">7</option><option

value="8">8</option><option value="9">9</option><option

value="10">10</option><option value="11">11</option><option

value="12">12</option><option value="13">13</option><option

value="14">14</option><option value="15">15</option><option

value="16">16</option><option value="17">17</option><option

value="18">18</option><option value="19">19</option><option

value="20">20</option><option value="21">21</option><option

value="22">22</option><option value="23">23</option><option

Page 56: My City Portal

value="24">24</option><option value="25">25</option><option

value="26">26</option><option value="27">27</option><option

value="28">28</option><option value="29">29</option><option

value="30">30</option><option value="31">31</option></select> &nbsp; <select

name="dmth" class=tf>

<option value="" selected>Month</option><option value="1">Jan</option><option

value="2">Feb</option><option value="3">Mar</option><option

value="4">Apr</option><option value="5">May</option><option

value="6">June</option><option value="7">July</option><option

value="8">Aug</option><option value="9">Sep</option><option

value="10">Oct</option><option value="11">Nov</option><option

value="12">Dec</option></select> &nbsp;

<select name="dyr" class=tf><option value="" selected>Year</option><option

value="2011">2011</option><option value="2012">2012</option></select>

</TD>

</TR>

<TR><TD height="50">Expire Date:

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs

p;

<select name="" class=tf><option value="" selected>Date</option><option

value="1">1</option><option value="2">2</option><option value="3">3</option><option

value="4">4</option><option value="5">5</option><option value="6">6</option><option

value="7">7</option><option value="8">8</option><option value="9">9</option><option

value="10">10</option><option value="11">11</option><option

value="12">12</option><option value="13">13</option><option

value="14">14</option><option value="15">15</option><option

value="16">16</option><option value="17">17</option><option

Page 57: My City Portal

value="18">18</option><option value="19">19</option><option

value="20">20</option><option value="21">21</option><option

value="22">22</option><option value="23">23</option><option

value="24">24</option><option value="25">25</option><option

value="26">26</option><option value="27">27</option><option

value="28">28</option><option value="29">29</option><option

value="30">30</option><option value="31">31</option></select> &nbsp; <select

name="rmth" class=tf>

<option value="" selected>Month</option><option value="1">Jan</option><option

value="2">Feb</option><option value="3">Mar</option><option

value="4">Apr</option><option value="5">May</option><option

value="6">June</option><option value="7">July</option><option

value="8">Aug</option><option value="9">Sep</option><option

value="10">Oct</option><option value="11">Nov</option><option

value="12">Dec</option></select> &nbsp;

<select name="ryr" class=tf><option value="" selected>Year</option><option

value="2011">2011</option><option value="2012">2012</option></select>

</tr>

<tr>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</br><br/>

<td width="317"><label for="">Description<em>*<br>

</em>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</

label>

<textarea rows="12" cols="50" name="content" style="resize: none;

tabindex="-1"></textarea>

</td>

Page 58: My City Portal

</tr>

<tr bgcolor="#C9C299">

<td height="70"><label for="descriptionGallery">Photos</label>

<br>

<small class="desc">You

can upload up to 8 photos</small>

<object type=" id="uploadButton" name="uploadButton"

data="http://ovhimg01.icplatform.com/static/tradusadsin/external/sites/tradusadsin/flash/

upload.swf" width="104" height="26">

</object>

</li>

</ul>

</td>

</tr>

<tr></tr>

<tr bgcolor="#C9C299">

<td height="60">

<label

for="select">City<em>*</em>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

&nbsp;&nbsp;&nbsp;</label>

<select name="select" >

<option value="0">Choose</option>

<option value="9">Ghaziabad</option>

<option value="7">Bangalore</option>

<option value="6">Chennai</option>

<option value="1">Delhi</option>

<option value="2">Gurgaon</option>

<option value="4">Hyderabad</option>

Page 59: My City Portal

<option value="8">Mumbai</option>

<option value="3">Noida</option>

<option >Pune</optio

></select>

</li></td>

<tr>

<tr>

</tr>

<tr bgcolor="#FFF8C6">

<td height="60">Address

<em>*</em>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;

<input type="text" name="textfield" id="textfield" size="40">

<label for="textfield"></label></td>

</td>

</tr>

<tr bgcolor="#F8FCF8">

</tr>

<tr bgcolor="#F8FCF8">

<td height="70"><label for="add-email">Email

address<em>*</em>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

</label>&nbsp;

<input type="text" id="add-email" name="email" size="40">

</td>

</tr>

<tr bgcolor="#F8FCF8">

Page 60: My City Portal

<td height="70"><label for="add-email">Mobile Number

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

</label>

<input type="text" name="textfield" id="textfield" size="40">

</td>

</tr>

<tr>

</tr>

<tr>

<td><input type="checkbox" class="required" name="accept"

value="1" id="agreement"> <label for="agreement" class="thin">I hereby agree for

processing my personal details accordance with the law. I am declaring that I am a person of

full legal age.</label>

</td>

</tr>

<tr>

<td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs

p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n

bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs

p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a

href="a.html"><label for="">Publish Add</label></a>

</td>

</tr>

Page 61: My City Portal

</table>

</form>

</div>

</BODY>

</HTML>

Page 62: My City Portal

Result:

E-government is now recognized as the most effective way to make service delivery efficient

and to successfully transform governance. However, most of the cities in developing

countries do not have city portals, either because of the lack of staff capacity or lack of

budget.

The City Portal is developed by a taskforce of international development agencies and

universities to provide advanced city portals with a modest installation and maintenance cost,

using a platform approach. It is fully customizable and cities can achieve all the objectives of

e-goverence.

We installed the City Portal and it created a significant improvement in the transparency of

the local government services.

Testing:

SYSTEM TESTING:

Page 63: My City Portal

Here the system testing involved is the most widely used testing process consists of five

stages as shown in the figure. In general, the sequence of testing activities is component

testing, integration testing then user testing. However, as defects are discovered at any one

stage, they required program modifications to correct them and this may required other stages

in the testing process to be repeated.

(component testing) (Integration testing) (user testing)

SYSTEM SECURITY:

There are basically two types of security associated with this system:-

Unit testing

Module testing

Acceptance testing

Sub-system testing

System testing

Page 64: My City Portal

1. Physical security:-

Damage due to natural causes like earth tremor, flooding, water logging, fire

hazards, atmospheric or environmental conditions etc..For overcoming these difficulties

the replica of the data are automatically stored at various networks and for environmental

conditions Air conditioning environment is created.

2. Data security:-

There are basically two problems associated with data security:-

a). Data not being available to the authorized person at the time of need.

b). Data becoming available to the unauthorized person.

To overcome these difficulties the following access facilities has been provided:-

i) Identification:-

Unique Ids for the different users have been provided.

ii) Authentication:-

System checks the password under the particular user identification. The computer

permits the various resource to the authorized person.

iii) Authorisation:-

The access control mechanism to prevent unauthorized logging to the system.

7. CONCLUSION:

FINDINGS:-

Page 65: My City Portal

After implementing the system in the market its advantages were incomparable to the present

contemporary systems available in the market. The most admirable feature founded was its

simplicity in terms of application to the user but its highly beneficial outputs can’t be

ignored. The users will be highly benefited after using the system

LIMITATIONS:

Defame abuse, harass, stalk, threaten or otherwise violate the legal rights (such as rights of

privacy and publicity) of others.

Publish post, upload, distribute or disseminate any inappropriate, profane,

defamatory, infringing, obscene, indecent or unlawful topic, name, material or

information.

Upload files that contain software or other material protected by intellectual property

laws (or by rights of privacy of publicity) unless you own or control the rights thereto

or have received all necessary consents.

Upload files that contain viruses, corrupted files, or any other similar software or

programs that may damage the operation of another's computer.

Advertise or offer to sell or buy any goods or services for any business purpose,

unless such Communication Service specifically allows such messages.

Conduct or forward surveys, contests, pyramid schemes or chain letters.

Download any file posted by another user of a Communication Service that you

know, or reasonably should know, cannot be legally distributed in such manner.

Falsify or delete any author attributions, legal or other proper notices or proprietary

designations or labels of the origin or source of software or other material contained

in a file that is uploaded.

Restrict or inhibit any other user from using and enjoying the Communication

Services.

Violate any code of conduct or other guidelines which may be applicable for any

particular Communication Service.

Page 66: My City Portal

Harvest or otherwise collect information about others, including e-mail addresses,

without their consent.

Violate any applicable laws or regulation

8. SCOPE FOR FUTURE WORK :

Since this system has been generated by using Object Oriented programming, there are every

chances of reusability of the codes in other environment even in different platforms. Also its

Page 67: My City Portal

present features can be enhanced by some simple modification in the codes so as to reuse it

in the changing scenario.

References:

1. Wikipedia for Noida detail(http://en.wikipedia.org/wiki/Noida)

Page 68: My City Portal

2. google for imageshttp://www.google.com

3. http://www.elucknow.com/