Amity University Project Report Sample For BCA At projecthelpline.in

A

    PROJECT REPORT ON

“ INVENTORY MANAGEMENT SYSTEM FOR DEPARTMENTAL STORE”

 

UNDER SUPERVISION OF:

……………………..

SUBMITTED BY

NAME:-

ROLL NUMBER ………………

A dissertation submitted in partial fulfillment of the requirements of

Master of Science

MSC(IT)

at the

Amity Center for E-learning

Amity University, Noida

2017

INVENTORY MANAGEMENT SYSTEM FOR DEPARTMENTAL STORE
Under Supervision of     :

Submitted By:

Name                                       :

Address                                    :

Phone No                                 :

Programme                               :

Enrolment No.                          :

 

      BONAFIDE CERTIFICATE

Certified that this project report titled “INVENTORY MANAGEMENT SYSTEM FOR DEPARTMENTAL STORE” is the bonafide work of “………………………&  NAME OF THE CANDIDATE with REG.no .…………” who carried out the project work under my supervision.

 

SIGNATURE

 


ABSTRACT

INVENTORY MANAGEMENT SYSTEM FOR DEPARTMENTAL STORE integrates internal and external management information across an entire organization, embracing finance/accounting, manufacturing, sales and service, customer relationship management, etc. ERP systems automate this activity with an integrated software application. Its purpose is to facilitate the flow of information between all business functions inside the boundaries of the organization and manage the connections to outside stakeholders.

This project is related to sales and inventory. Inventory takes turns under all types of economic systems. In a free market economy, manufacturing is usually directed toward the mass production of products for sale to consumers at a profit. In a collectivist economy, inventory system is more frequently directed by the state to supply a centrally planned economy. In free market economies, manufacturing occurs under some degree of government regulation.


 

DECLARATION

I hereby declare that this project work titled “INVENTORY MANAGEMENT SYSTEM FOR DEPARTMENTAL STORE” is my original work and no part of it has been submitted for any other degree purpose or published in any other from till date.

 

 

 

 

CONTENTS                                                                           

 

BONAFIDE CERTIFICATE                                                                                

ABSTRACT                                                                                                                

DECLARATION                                                                                                   

 

 
 
1.       INTRODUCTION
1.1.   Overview of the System                                                                                                                                       
1.2.   Objectives and Organization of the report                                                                                        
1.3.  Proposed System                                                                                    
 
2.     REQUIREMENT SPECIFICATION
      2.1   Software & Hardware Requirements                                                   
      2.2   Data Flow Diagram                                                                              

      2.3  CONTEXT LEVEL DFD  Diagrams                                                   

      2.4  E-R Diagram                                                                                        

 
3.  SYSTEM DESIGN
 
       3.1  Use Diagram                                                                                       
      3.2  Data Modeling                                                                                    
      3.3   Modules                                                                                            
4. IMPLEMENTATION                                                                                

5. RESULTS                                                                                                  

   5.1 Source Code                                                                                           

 6.  Limitations and future application of the project                                  
 
 7.  Conclusion                                                                                                 
 8.  Bibliography                                                                                             

 

 

LIST OF TABLES

 

Table No.

 

1          Admin

2          Branch

3          Feedback

4          Inventory

5             Login

6          Product

  1. Sales
  2. Purchaes
  3. Target

10        Supplier

11        Emp

 

 

 

CHAPTER 1. INTRODUCTION

 

1.1 OVERVIEW OF THE SYSTEM

 

 

1.2 OBJECTIVES AND ORGANIZATION OF THE REPORT

1. The web-site is to be accessed from any where anytime.

2. As the project is web-based so the software should be platform independent.

3. The data is very important asset for corporation so strong authentication method is to be used to ensure security of information from malicious user.

4. As the valuable data is being transferred through internet so the security of data is to be maintained at any cost.

5. Easy to be customized in future. As the client demand some other additional features. The complexity of customer’s company may be different or if mode of business changes then the system has capability to make appropriate modification to suite that change. Customization is key factor of designing this software.

  1. The web-site manipulates data in an accurate way.
  1. Accuracy of all type of calculations are important and to be achieved at any cost.
  1. This should always be observed during the development of the software that the user is not from technical background, so the software should be user friendly and can be handled easily.
  1. Storage of data should be easily accessible.
  1. The data retrieval and other manipulation related task which is done at the database level should be fast enough. The database should support multiple users at a time.
  1. The product should fulfill user’s requirement.

 

ADVANTAGE

I have designed the given proposed system in the JSP, SERVLETS to automate INVENTORY MANAGEMENT SYSTEM FOR DEPARTMENTAL STORE.

The following steps that give the detailed information of the need of proposed system are:

Performance: 

Efficiency:

Control: 

Security: .

 

PROJECT CATEGORY

  1. I. The User’s layer: tools and languages used à JSP, HTML, and DHTML.

Editors: – NetBeans IDE

There is a front end which is web-pages which are displayed before the user and user directly interact with the software. Web pages are developed by using various design tools like Flash, Photo Shop etc and documentation languages like HTML and DHTML.

  1. The Presentation layer: tools and languages used à JSP, SERVLET

Editor: NetBeans IDE

At this layer all the services related with presentations like format check, mailing interface,   parsing, deployment descriptor etc. this layer is developed in java using servlet, JSP.

III. The Integration Level: tool/technology used àJDBC Type 4

JDBC Type 4 Driver (Pure Java implementation) is used.

This tier is dedicated for database connectivity and connection management with the database. This is tier is developed in java and the components to be used JDBC 2.0.

  1. The Data Resources level: [MySQl]

At the back end, there is a data base which maintains data. This is to be developed in MySQL. In this server tables are created and all primary key –foreign key constraints are implemented. The data base follows all the integrity constraints.

 

Business Intelligence

Gain deeper insight into your business with integrated, comprehensive analysis and reporting for enhanced decision making.

High Availability

Ensure business continuity with the highest levels of system availability through technologies that protect your data against costly human errors and minimize disaster recovery downtime.

 

Performance and Scalability

Deliver an infrastructure that can grow with your business and has a proven record in handling today’s large amounts of data and most critical enterprise workloads.

Security

Provide a secure environment to address privacy and compliance requirements with built-in features that protect your data against unauthorized access.

Manageability

Manage your infrastructure with automated diagnostics, tuning, and configuration to reduce operational costs while reducing maintenance and easily managing very large amounts of data.

Developer Productivity

Build and deploy critical business-ready applications more quickly by improving developer productivity and reducing project life cycle times.

THE NEED OF NEW SYSTEM

  1. Problem of Reliability:

 

  1. Problem of Accuracy:

 

  1. Problem of timeliness:

 

  1. Problem of Validity:

 

  1. Problem of Economy:

 

  1. Problem of Capacity:

 

1.3 PROPOSED SYSTEM

 

  1.  Details: The new proposed system stores and maintains all the online users etc.

 

  1. Calculations: The new proposed system updates tables and other information automatically and it is very fast and accurate.

 

  1. Registers: There is no need of keeping and maintaining accounts and information manually. It remembers each and every record and we can get any report at any time.

 

  1. Speed: The new proposed system is very fast with 100% accuracy and saves time.

 

  1. Manpower: The new proposed system needs less manpower. Less people can do the large work.

 

  1. Efficiency: The new proposed systems complete the work of many people in less time.

 

  1. Past details: The new proposed system contains the details of each enquiry done by visitor.

 

  1. Reduces redundancy: The most important benefit of this system is that it reduces the redundancy of data within the data.

 

  1. Work load:

 

  1. Easy statements:

 

NEED:

I have designed the given proposed system in the JSP,SERVLETS to automate the process The following steps that give the detailed information of the need of proposed system are:

  • Performance:
  • Efficiency: 
  • Control:
  • Security: 


CHAPTER 2 REQUIREMENT SPECIFICATION

 

2.1 SOFTWARE & HARDWARE REQUIREMENTS

HARDWARE:

Processor                     :           Pentium 2.4 GHz or above

Memory                       :           256 MB RAM or above

Cache Memory            :           128 KB or above

Hard Disk                   :           3 GB or above [at least 3 MB free space required]

Pen Drive                    :           2 GB

Printer             :           Laser Printer

 

SOFTWARE:

Operating System       :           Windows 95/98, Win NT, Win 2000,window xp.

Font-End Tool             :          JSP, SERVLETS

Back End Tool             :           MY SQL

 


 SOFTWARE & HARDWARE REQUIREMENTS

“Client-Server approach with XML / JSP, SERVLETS”

 

The need of today’s software development is competence in a GUI based front-end tool, which can connect to Relational Database engines. This gives the programmer the opportunity to develop client server based commercial applications.

 

FRONT END

JSP programming tools are complete programming environments. It allows programmers to build a GUI program using the various on-screen controls such as buttons, text, menus, boxes etc. These controls are placed on a form and then the processing details related with each control are filled in.

 

In the business world, competitive strategies have become the order of the day to improve quality, cut costs and provide a high response customer service base. Most organizations today need to be market driven and do a lot of value addition to their products and services. This naturally calls for rational decision making, which requires information. Information Technology or IT provides that effective channel to support and implement this strategy. Client/Server is the technology that empowers the desktop, thus setting a trend for the way successful organizations will use technology in the next decade.

 

INTRODUCTION TO JSP
Adding dynamic content via expressions

As we saw in the previous section, any HTML file can be turned into a JSP file by changing its extension to .jsp.  Of course, what makes JSP useful is the ability to embed Java.  Put the following text in a file with .jsp extension (let us call it hello.jsp), place it in your JSP directory, and view it in a browser.

<HTML><BODY>Hello!  The time is now <%= new java.util.Date() %></BODY></HTML>

Notice that each time you reload the page in the browser, it comes up with the current time.

The character sequences <%= and %> enclose Java expressions, which are evaluated at run time.

This is what makes it possible to use JSP to generate dyamic HTML pages that change in response to user actions or vary from user to user.

Exercise:  Write a JSP to output the values returned by System.getProperty for various system properties such as java.version, java.home, os.name, user.name, user.home, user.dir etc.

Scriptlets

We have already seen how to embed Java expressions in JSP pages by putting them between the <%= and %> character sequences.

But it is difficult to do much programming just by putting Java expressions inside HTML.

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 (though it can, as we will see down below.)  A scriptlet contains Java code that is executed every time the JSP is invoked.

Here is a modified version of our JSP from previous section, adding in a scriptlet.

<HTML><BODY><%    // This is a scriptlet.  Notice that the “date”    // variable we declare here is available in the    // embedded expression later on.    System.out.println( “Evaluating date now” );    java.util.Date date = new java.util.Date();%>Hello!  The time is now <%= date %></BODY></HTML>

If you run the above example, you will notice the output from the “System.out.println” on the server log.  This is a convenient way to do simple debugging (some servers also have techniques of debugging the JSP in the IDE.  See your server’s documentation to see if it offers such a technique.)

By itself a scriptlet does not generate HTML.  If a scriptlet wants to generate HTML, it can use a variable called “out”.  This variable does not need to be declared.  It is already predefined for scriptlets, along with some other variables.  The following example shows how the scriptlet can generate HTML output.

<HTML><BODY><%    // This scriptlet declares and initializes “date”    System.out.println( “Evaluating date now” );    java.util.Date date = new java.util.Date();%>Hello!  The time is now<%    // This scriptlet generates HTML output    out.println( String.valueOf( date ));%></BODY></HTML>

Here, instead of using an expression, we are generating the HTML directly by printing to the “out” variable.  The “out” variable is of type javax.servlet.jsp.JspWriter.

Another very useful pre-defined variable is “request”.  It is of type javax.servlet.http.HttpServletRequest

A “request” in server-side processing refers to the transaction between a browser and the server.  When someone clicks or enters a URL, the browser sends a “request” to the server for that URL, and shows the data returned.  As a part of this “request”, various data is available, including the file the browser wants from the server, and if the request is coming from pressing a SUBMIT button, the information the user has entered in the form fields.

The JSP “request” variable is used to obtain information from the request as sent by the browser.  For instance, you can find out the name of the client’s host (if available, otherwise the IP address will be returned.)  Let us modify the code as shown:

<HTML><BODY><%    // This scriptlet declares and initializes “date”    System.out.println( “Evaluating date now” );    java.util.Date date = new java.util.Date();%>Hello!  The time is now<%    out.println( date );    out.println( “<BR>Your machine’s address is ” );    out.println( request.getRemoteHost());%></BODY></HTML>

A similar variable is “response”.  This can be used to affect the response being sent to the browser.  For instance, you can call response.sendRedirect( anotherUrl ); to send a response to the browser that it should load a different URL.  This response will actualy go all the way to the browser.  The browser will then send a different request, to “anotherUrl”.  This is a little different from some other JSP mechanisms we will come across, for including another page or forwarding the browser to another page.

Exercise:  Write a JSP to output the entire line, “Hello!  The time is now …” but use a scriptlet for the complete string, including the HTML tags.

Mixing Scriptlets and HTML

We have already seen how to use the “out” variable to generate HTML output from within a scriptlet.  For more complicated HTML, using the out variable all the time loses some of the advantages of JSP programming.  It is simpler to mix scriptlets and HTML.

Suppose you have to generate a table in HTML.  This is a common operation, and you may want to generate a table from a SQL table, or from the lines of a file.  But to keep our example simple, we will generate a table containing the numbers from 1 to N.  Not very useful, but it will show you the technique.

Here is the JSP fragment to do it:

<TABLE BORDER=2><%    for ( int i = 0; i < n; i++ ) {        %>        <TR>        <TD>Number</TD>        <TD><%= i+1 %></TD>        </TR>        <%    }%></TABLE>

You would have to supply an int variable “n” before it will work, and then it will output a simple table with “n” rows.

The important things to notice are how the %> and <% characters appear in the middle of the “for” loop, to let you drop back into HTML and then to come back to the scriptlet.

The concepts are simple here — as you can see, you can drop out of the scriptlets, write normal HTML, and get back into the scriptlet.  Any control expressions such as a “while” or a “for” loop or an “if” expression will control the HTML also.  If the HTML is inside a loop, it will be emitted once for each iteration of the loop.

Another example of mixing scriptlets and HTML is shown below — here it is assumed that there is a boolean variable named “hello” available.  If you set it to true, you will see one output, if you set it to false, you will see another output.

<%    if ( hello ) {        %>        <P>Hello, world        <%    } else {        %>        <P>Goodbye, world        <%    }%>

It is a little difficult to keep track of all open braces and scriptlet start and ends, but with a little practice and some good formatting discipline, you will acquire competence in doing it.

Exercise:  Make the above examples work.  Write a JSP to output all the values returned by System.getProperties with “<BR>” embedded after each property name and value.  Do not output the “<BR>” using the “out” variable.

JSP Directives

We have been fully qualifying the java.util.Date in the examples in the previous sections.  Perhaps you wondered why we don’t just import java.util.*;

It is possible to use “import” statements in JSPs, but the syntax is a little different from normal Java.  Try the following example:

<%@ page import=”java.util.*” %><HTML><BODY><%    System.out.println( “Evaluating date now” );    Date date = new Date();%>Hello!  The time is now <%= date %></BODY></HTML>

The first line in the above example is called a “directive”.  A JSP “directive” starts with <%@ characters.

This one is a “page directive”.  The page directive can contain the list of all imported packages.  To import more than one item, separate the package names by commas, e.g.

<%@ page import=”java.util.*,java.text.*” %>

There are a number of JSP directives, besides the page directive.  Besides the page directives, the other most useful directives are include and taglib.  We will be covering taglib separately.

The include directive is used to physically include the contents of another file.  The included file can be HTML or JSP or anything else — the result is as if the original JSP file actually contained the included text.  To see this directive in action, create a new JSP

<HTML><BODY>Going to include hello.jsp…<BR><%@ include file=”hello.jsp” %></BODY></HTML>

View this JSP in your browser, and you will see your original hello.jsp get included in the new JSP.

Exercise:  Modify all your earlier exercises to import the java.util packages.

JSP Declarations

The JSP you write turns into a class definition.  All the scriptlets you write are placed inside a single method of this class.

You can also add variable and method declarations to this class.  You can then use these variables and methods from your scriptlets and expressions.

To add a declaration, you must use the <%! and %> sequences to enclose your declarations, as shown below.

<%@ page import=”java.util.*” %><HTML><BODY><%!    Date theDate = new Date();    Date getDate()    {        System.out.println( “In getDate() method” );        return theDate;    }%>Hello!  The time is now <%= getDate() %></BODY></HTML>

The example has been created a little contrived, to show variable and method declarations.

Here we are declaring a Date variable theDate, and the method getDate.  Both of these are available now in our scriptlets and expressions.

But this example no longer works!  The date will be the same, no matter how often you reload the page.  This is because these are declarations, and will only be evaluated once when the page is loaded!  (Just as if you were creating a class and had variable initialization declared in it.)

Exercise:  Modify the above example to add another function computeDate which re-initializes theDate.  Add a scriptlet that calls computeDate each time.

Note: Now that you know how to do this — it is in general not a good idea to use variables as shown here. The JSP usually will run as multiple threads of one single instance. Different threads would interfere with variable access, because it will be the same variable for all of them. If you do have to use variables in JSP, you should use synchronized access, but that hurts the performance. In general, any data you need should go either in the session object or the request object (these are introduced a little later) if passing data between different JSP pages. Variables you declare inside scriptlets are fine, e.g. <% int i = 45; %> because these are declared inside the local scope and are not shared.

 

JSP Tags

Another important syntax element of JSP are tags.  JSP tags do not use <%, but just the < character.  A JSP tag is somewhat like an HTML tag.  JSP tags can have a “start tag”, a “tag body” and an “end tag”.  The start and end tag both use the tag name, enclosed in < and > characters.  The end starts with a / character after the < character.  The tag names have an embedded colon character : in them, the part before the colon describes the type of the tag.  For instance:

<some:tag>body</some:tag>

If the tag does not require a body, the start and end can be conveniently merged together, as

<some:tag/>

Here by closing the start tag with a /> instead of > character, we are ending the tag immediately, and without a body.  (This syntax convention is the the same as XML.)

Tags can be of two types: loaded from an external tag library, or predefined tags.   Predefined tags start with jsp: characters.  For instance, jsp:include is a predefined tag that is used to include other pages.

We have already seen the include directive.  jsp:include is similar.  But instead of loading the text of the included file in the original file, it actually calls the included target at run-time (the way a browser would call the included target.  In practice, this is actually a simulated request rather than a full round-trip between the browser and the server).  Following is an example of jsp:include usage

<HTML><BODY>Going to include hello.jsp…<BR><jsp:include page=”hello.jsp”/></BODY></HTML>

Try it and see what you get.  Now change the “jsp:include” to “jsp:forward” and see what is the difference.  These two predefined tags are frequently very useful.

Exercise:  Write a JSP to do either a forward or an include, depending upon a boolean variable (hint:  The concepts of mixing HTML and scriptlets work with JSP tags also!)

JSP Sessions

On a typical web site, a visitor might visit several pages and perform several interactions.

If you are programming the site, it is very helpful to be able to associate some data with each visitor.  For this purpose, “session”s can be used in JSP.

A session is an object associated with a visitor.  Data can be put in the session and retrieved from it, much like a Hashtable.  A different set of data is kept for each visitor to the site.

Here is a set of pages that put a user’s name in the session, and display it elsewhere.  Try out installing and using these.

First we have a form, let us call it GetName.html

<HTML><BODY><FORM METHOD=POST ACTION=”SaveName.jsp”>What’s your name? <INPUT TYPE=TEXT NAME=username SIZE=20><P><INPUT TYPE=SUBMIT></FORM></BODY></HTML>

The target of the form is “SaveName.jsp”, which saves the user’s name in the session.  Note the variable  “session”.  This is another variable that is normally made available in JSPs, just like out and request variables.  (In the @page directive, you can indicate that you do not need sessions, in which case the “session” variable will not be made available.)

<%   String name = request.getParameter( “username” );   session.setAttribute( “theName”, name );%><HTML><BODY><A HREF=”NextPage.jsp”>Continue</A></BODY></HTML>

The SaveName.jsp saves the user’s name in the session, and puts a link to another page, NextPage.jsp.

NextPage.jsp shows how to retrieve the saved name.

<HTML><BODY>Hello, <%= session.getAttribute( “theName” ) %></BODY></HTML>

If you bring up two different browsers (not different windows of the same browser), or run two browsers from two different machines, you can put one name in one browser and another name in another browser, and both names will be kept track of.

The session is kept around until a timeout period.  Then it is assumed the user is no longer visiting the site, and the session is discarded.

My SQL

Introduction

My SQL is an application used to create computer databases for the Microsoft Windows family of server operating systems. It provides an environment used to generate databases that can be accessed from workstations, the web, or other media such as a personal digital assistant (PDA). MY SQL  is probably the most accessible and the most documented enterprise database environment right now. This also means that you can learn it a little quicker than most other database environments on the market.

To start, you must have a computer that runs an appropriate operating system like Microsoft Windows >= XP Home Edition: that includes Windows XP Home Edition, Windows XP Professional, Windows 2000 Professional, or any version of Windows Server 2003. In this case, you must install MY SQL Yog.

 

What is SQL Used for:

Using SQL one can create and maintain data manipulation objects such as table, views, sequence etc. These data manipulation objects will be created and stored on the server’s hard disk drive, in a tablespace, to which the user has been assigned.

Once these data manipulation objects are created, they are used extensively in commercial applications.

DML, DCL, DDL:

In addition to the creation of data manipulation objects, the actual manipulation of data within these objects is done using SQL.

The SQL sentences that are used to create these objects are called DDL’s or Data Definition Language. The SQL sentences used to manipulate data within these objects are called DML’s or Data Manipulation Language. The SQL sentences, which are used to control the behavior of these objects, are called DCL’s or Data Control Language.


DATA TYPE

Built-in data types

In My Sql, each object (such as column, variable, or parameter) has a related data type, which is an attribute that specifies the type of data that the object can hold.

My SQL ships with 27 built-in (system) data types. They are:

Data Types Description
bigint Integer data from -2^63 through 2^63-1
int Integer data from -2^31 through 2^31 – 1
Smallint Integer data from -2^15 through 2^15 – 1
tinyint Integer data from 0 through 255
bit Integer data with either a 1 or 0 value
Decimal Fixed precision and scale numeric data from -10^38 +1 through 10^38 -1
numeric Fixed precision and scale numeric data from -10^38 +1 through 10^38 -1
money Monetary data values from -2^63 through 2^63 – 1
smallmoney Monetary data values from -214,748.3648 through +214,748.3647
float Floating precision number data from -1.79E + 308 through 1.79E + 308
real Floating precision number data from -3.40E + 38 through 3.40E + 38
datetime Date and time data from January 1, 1753, through December 31, 9999,
with an accuracy of 3.33 milliseconds
smalldatetime Date and time data from January 1, 1900, through June 6, 2079,
with an accuracy of one minute
char Fixed-length character data with a maximum length of 8,000 characters
varchar Variable-length data with a maximum of 8,000 characters
text Variable-length data with a maximum length of 2^31 – 1 characters
nchar Fixed-length Unicode data with a maximum length of 4,000 characters
nvarchar Variable-length Unicode data with a maximum length of 4,000 characters
Ntext Variable-length Unicode data with a maximum length of 2^30 – 1 characters
binary Fixed-length binary data with a maximum length of 8,000 bytes
varbinary Variable-length binary data with a maximum length of 8,000 bytes
image Variable-length binary data with a maximum length of 2^31 – 1 bytes
cursor A reference to a cursor
sql_variant A data type that stores values of various data types,
except text, ntext, timestamp, and sql_variant
Table A special data type used to store a result set for later processing
timestamp A database-wide unique number that gets updated every time
a row gets updated
uniqueidentifier A globally unique identifier

Some of these data types (bigint, sql_variant, and table) are only available in MY SQL 0, while some were supported under the previous My SQL r versions.

User-defined data types

My SQL supports user-defined data types too. User-defined data types provide a mechanism for applying a name to a data type that is more descriptive of the types of values to be held in the object. Using user-defined data type can make it easier for a programmer or database administrator to understand the intended use of any object defined with the data type. The user-defined data types are based on the system data types and can be used to predefine several attributes of a column, such as its data type, length, and whether it supports NULL values. To create a user-defined data type, you can use the sp_addtype system stored procedure or you could add one using the Enterprise Manager. When you create a user-defined data type, you should specify the following three properties:

  • Data type’s name.
  • Built-in data type upon which the new data type is based.
  • Whether it can contain NULL values.

The following example creates a user-defined data type based on money data type named cursale that cannot be NULL:

EXEC sp_addtype cursale, money, ‘NOT NULL’ GO

Both system and user-defined data types are used to enforce data integrity. It is very important that we put forth a lot of effort while designing tables: the better you design

your tables, the more time you can work without any performance problems. In an ideal case, you never will update the structure of your tables.

 

ENVIRONMENT / OPERATING SYSTEM

 

 

 


2.2 DATA FLOW DIAGRAM

Data Flow Diagram

 

Data flow diagrams are the most commonly used way of documenting the processing of the candidate system. As their name suggest they are a pictorial way of representing the flow of data into, around, and out of the system. They are easily understandable and are less prone to misinterpretation than textual description. A complete set of DFDs provides a compact top – down representation of the system, which makes it easier for the user and the analyst to envisage the system as a whole.

DFDs are constructed using four major components:

 

  • External entities – represents the sources of the data that enter the system or the recipients of the system that leave the system.

for example – passenger is the usual receiver of information and supplier of data during form filling.

 

  • Data stores – represent the stores of the data within the system example: computer files, databases or in the manual system files, etc. data stores can not be linked directly by data flows either to each other or to external entities without an intervening process to transform them.

 

  • Processes – represent activities in which data is manipulated by being stored or retrieved or transformed in some way. Process names are generally unambiguous and convey as much meaning as possible without being too long. Example: verify data, acquired time schedule etc.

 

Data flows – represents the movement of data between other components.

Data flow diagrams are used to describe how the system transforms information.  They define how information is processed and stored and identify how the information flows through the processes.

  1. Bubbles: –
  2. Data store:-
  • External Entity:-

 

2. Making_New_USER: In this module new user is created. There are two category of users. One is Admin group users and the second is General user. General user has only privilege to insert data and Admin group has privilege to make any modification.

New user can added by the Administrator. The Process Logic to be followed in this module is as follows:-

 

[LOG-IN]

//User log in by passing user id and password.

Id ß [User id]

Pass ß [Password]

 

[CHECK PRIVILEGE]

if (id == “Admin”)  then

//check in Admin table

//db= table at database

if (id = db.id and pass = db.pass)

//Open Admin page

Else

//Check in User page

//db= table at database

if (id = db.id and pass = db.pass)

//Open User page

else

Print “Error”

 

[ADMIN:?]

//Admin chooses Insert User option

 

[NEW USER FORM]

// New user form is opened

 

[SUBMIT]

// Format check is done

if (format not correct)

Print “Error”

Else

//Value is inserted.

 

 

 


2.4 ER Diagram

 

 

 

CHAPTER 3 SYSTEM DESIGN

3.1 Use Case Diagrams
3.2 Data Modeling

 

 

“A modularization consists of well-defined manageable units with well defined interfaces among the units”

Desirable property of modular system include

  1. Each module is a well defined sub-system.
  2. Single, well – defined purpose of each module.
  • Modules can be separately compiled and stored in a library.
  1. Modules can use other module.
  2. Modules should be easier to use than to build.
  3. Modules should be simpler from outside then from inside.

Design constraints to be observed during modularization are:-

Coupling: “Coupling is a measure of the degree of interdependence between software modules”.

Two modules with high coupling are strongly inter connected and thus dependent on each other.

Two modules with low coupling are not dependent on one another.

 

Cohesion: “Cohesion is a measure of the degree to which the elements of a module are functionally related”.

A strongly cohesive module implements functions, which is related to one feature of the solution and requires little interaction with other modules.

 

Module 1: Password Module

 

Module 2: Creating new Entities ( Users, Suppliers, Clients, Purchasers, Salesman)

 

Module 3: Modifying / Updating Existing Entities

 

 

Module 4: Searching

 

Module 5: Validation of Data Entered by the User & Error Handling

 

Module 6: Sales Orders

 

Module 7: Challan

 

Module 8: Stock

 


Module 9: Purchase

 

Module 10: Transactions

 

Data Structure   Requirements according to the modules:

  • Identify The Various Tables Required.
  • Fields for These Tables.
  • The Various Key Fields (for example Primary key and foreign key).
  • Identify The Various Constraints like Not Null, Unique etc.

 

 

3.3 Modules

Data base Design (Data Structures)

Admin Table-1

Field Name Type Constraint Description
User Name Char(30) Primary Key User Name
Password Char(30) Not Null Password

 

Branch Table-2

Field Name Type Constraint Description
B_Id Char(30) Primary Key Branch ID
B_Name Char(30) Not Null Branch Name
Performance Char(100) Not Null Performance
Address Char(100) Not Null Address
Phone Number(10) Not Null Phone
Fax Number(10) Not Null Fax
E mail Char(50) Not Null E mail

 

Feedback Table-3

Field Name Type Constraint Description
Name Char(30) Not Null Name
E mail Char(60) Not Null E mail Id
Phone Number(10) Not Null Phone No
Comment Char(70) Not Null Comment

 

Inventory Table-4

Field Name Type Constraint Description
P_Id Char(30) Not Null Product Id
P_Stock Char(30) Not Null Product in Stock
Unit Char(30) Not Null Measuring Unit
Date_Sale Date Not Null Date of sale

 

Login Table-5

Field Name Type Constraint Description
Id Char(30) Primary Key Login Id
User Name Char(30) Not Null User Name
Password Char(30) Not Null Password
E mail Char(70) Not Null E mail
Ques Char(70) Not Null Security Question
Answer Char(70) Not Null Answer
Phone number Not Null Contact No

 

Product Table-6

Field Name Type Constraint Description
P_id Char(30) Primary Key Product Id
P_Name Char(30) Not Null Product Name
P_desc Char(250) Not Null Product Description
Price Number Not Null Price
Unit Char(30) Not Null Unit
Stock number Not Null Stock

 

Sales Table-7

Field Name Type Constraint Description
Sales_Id Char(30) Primary Key Transaction Id
P_Id Char(30) Not Null Product Id
P_Sales Number Not Null Quantity of Product Sell
__Return Number Not Null No. of Items returned
Damage Number Not Null Damaged Product
Branch_Id Char(30) Not Null Branch Id
Date_Of_Sale Date Not Null Date Of Sale

 

Purchase Table-8

Field Name Type Constraint Description
Purchase_Id Char(30) Primary Key Purchase Id
Product Name Char(50) Not Null Product Name
Qty Number Not Null Quantity Purchased
Price Number Not Null Price
Pur_Date Date Not Null Purchase Date
Supplier Name Char(50) Not Null Supplier Name
Address Char(50) Not Null Supplier Address
City Char(50) Not Null City
Phone Char(30) Not Null Phone
Total Char(50) Not Null Total

 

 

Target Table-9

Field Name Type Constraint Description
P_Id Char(30) Not Null Product_Id
B_id Char(30) Not Null Branch_Id
Target Char(30) Not Null Target
Targer_Date Date Not Null Target Date

 

Supplier Table-10

Field Name Type Constraint Description
Supplier_Id Char(30) Primary Key Supplier Id
Supplier_Name Char(30) Not Null Supplier Name
Address Char(30) Not Null Address
City Char(30) Not Null City
State Char(30) Not Null State
Contact No Number(10) Not Null Contact No.

 


Emp Table-11

Field Name Type Constraint Description
Emp_Id Char(30) Primary Key Employee Id
Name Char(30) Not Null Employee Name
Designation Char(30) Not Null Designation
Department Char(30) Not Null Department
E mail Char(70) Not Null E mail
Date_of_Joining Date Not Null Date of Joining
Age Number Not Null Age
Salary Number Not Null Salary
Contact No. Number Not Null Contact No

 


CHAPTER 4 IMPLEMENTATION

 

COST ESTIMATION OF THE PROJECT

 

Cost in a project is due to the requirements for software, hardware, and human resources. Hardware resources are computer time, terminal time and memory required for the project. Software resources include the tools and compilers needed during development. The bulk of cost of software development is due to human resources needed. Cost estimates are determined in terms of person-months (PM).

 

Total No. Of Persons Involved In This Project:

  1. Administrator
  1. Senior Programmer
  1. Junior Programmers
  1. On line Users.

 

Since this Project will complete in 4 months

 

COST ESTIMATE: (Salary of Project Manager + Salary of Senior Programmer + 2 * Salary of  Junior Programmer) * 2

 

GANTT & PERT CHART

GANTT CHART

 

Gantt charts mainly used to allocate resources to activities. The resources allocated to activities include staff, hardware, and software. Gantt charts (named after its developer Henry Gantt) are useful for resource planning. A Gantt chart is special type of bar chart where each bar represents an activity. The bars are drawn along a timeline. The length of each bar is proportional to the duration of the time planned for the corresponding activity.

Gantt chart is a project scheduling technique. Progress can be represented easily in a Gantt chart, by coloring each milestone when completed. The project will start in the month of September and end after 4 months at the end of December.  

 

                  

 

 

Pert Chart

PERT (Project Evaluation and Review Technique) charts consist of a network of boxes and arrows. The boxes represent activities and the arrows represent task dependencies.

PERT chart represents the statistical variations in the project estimates assuming a normal distribution. Thus in a PERT chart instead of making a single estimate for each task, pessimistic, likely, and optimistic estimates are also made. The boxes of PERT charts are usually annotated with the pessimistic, likely, and optimistic estimates for every task. Since all possible completion times between the minimum and maximum durations for every task have to be considered, there are many critical paths, depending on the permutations of the estimates for each task. This makes critical path analysis in PERT charts very complex. A critical path in a PERT chart is shown by using thicker arrows. The PERT chart representation of the companies problem of Figure A. is shown in Figure B.

 

Task ES EF LS LF ST
Specification Part 0 15 0 15 0
Design Database Part 15 60 15 60 0
Design GUI Part 15 45 90 120 75
Code Database Part 60 165 60 165 0
Code GUI Part 45 90 120 165 75
Integrate and Test 165 285 165 285 0
Write User Manual 15 75 225 285 210

 

 

PERT charts are a more sophisticated form of activity chart. In activity diagrams only the estimated task durations are represented. Since the actual durations might vary from the estimated durations, the utility of the activity diagrams is limited.


CHAPTER 5 RESULTS

5.1 Source Code

Index.jsp

<%@ page language=”java” import=”java.sql.*” %>

<%@ page session=”true” %>

<html>

<head>

<title>Inventory Management System for Departmental Store</title>

 

<style type=”text/css”>

<!–

.style2 {

font-size: 16px;

font-weight: bold;

color: #990000;

}

.style7 {font-size: 16px; color: #1863a6; }

.style9 {color: #990033}

.style10 {color: #990000}

–>

</style>

</head>

<body>

<form name=”form1″ method=”post” action=”log.jsp”>

<table width=”728″ border=”0″ align=”center” cellspacing=”0″>

<tr>

<td colspan=”2″ height=”154″><%@ include file=”header1.jsp” %></td>

</tr>

<tr>

<td width=”2″ align=”left” valign=”top”>&nbsp;</td>

<td width=”903″ align=”left” valign=”top”><table width=”519″ border=”0″ align=”left” cellpadding=”0″ cellspacing=”0″>

<tr>

<td height=”230″ align=”left” valign=”top”><p>&nbsp;</p>

<p>&nbsp;</p>

<p>&nbsp;</p></td>

<td colspan=”2″ align=”left” valign=”top”><p align=”justify” class=”style7″><strong>Iventory Mangement System for Departmental Store </strong><span class=”style10″><strong> </strong>integrates internal and external&nbsp;management information&nbsp;across an entire organization, embracing finance/ sales and service,&nbsp;customer relationship management, etc. Inventory systems automate this activity with an integrated&nbsp;&nbsp;application. Its purpose is to facilitate the flow of information between all business functions inside the boundaries of the organization and manage the connections to outside stakeholders  is </span><span class=”style9″>a subset of the overall internal  controls of a business covering the application of people, documents,  technologies, and procedures by management accountants to solving business  problems such as costing a product, service or a business-wide strategy.  Management information systems are distinct from regular information systems in  that they are used to analyze other information systems applied in operational  activities in the organization. Academically, the term is commonly used to  refer to the group of information management methods tied to the automation or  support of human decision making, e.g. Decision Support Systems, Expert  systems, and Executive information systems.<br>

A ‘Iventory Mangement System for Departmental Store’ is a planned system of the collecting,  processing, storing and disseminating data in the form of information needed to  carry out the functions of management. In a way it is a documented report of  the activities those were planned and executed. According to Philip Kotler  &quot;A marketing information system consists of people, equipment, and  procedures to gather, sort, analyze, evaluate, and distribute needed, timely,  and accurate information to marketing decision makers.&quot; <br>

This project is  inventory management software, which provides management of marketing data.  This software is being developed for companies which have work in marketing or  dealer. The sample data collected to design and test is Net Co Ltd. Net Co Ltd  is a marketing company. The company has branches at almost all state-capitals  in India.  The company wants to manage marketing information like sell, wear out,  performance by an easy, fast and cheaper way. The software is being designed  keeping in mind the problems which the observers have find out in the company.&nbsp; The software will work on-line. This is made  to provide accessibility to everywhere. It works centrally and data entry is  done from all the branch offices. This software takes marketing information  from all branches and keeps it at one central location. At the central location  (The Head Office) the data is analyzed on the basis of various parameters like  total sell (branch wise/overall), total sell return (branch wise/area  wise/overall) etc.<br>

The software  project is very big and includes almost all aspects of Enterprise application. The project mentioned  is based on one unit of this. This unit is concerned with getting data from  branches and maintenance of data at the central location. In this unit  web-based forms are designed which facilitate entry of data and there is  facility to store it in the database which is centrally installed at the head  office. As the complete architecture is distributed and on-line so the  maintenance and management of data is done on-line. To manage data like update,  delete, etc. is to be developed. The data which is collected branch wise and  area wise are stored at the central database. At this location the data is  collected and analyzed by passing various parameters. Here strong  authentication mechanism is used to ensure security of data. The software is  designed in such a scalable manner that it can incorporate further  enhancements.&nbsp;&nbsp; </span></p>

<div align=”justify”><span class=”style7″><a href=”products.jsp?cat=Jewellary and Watches&type=Rings”></a></span></div></td>

</tr>

<tr>

<td width=”4″ align=”left” valign=”top”>&nbsp;</td>

<td width=”395″ align=”left” valign=”top”>&nbsp;</td>

<td width=”218″ align=”left” valign=”top”>&nbsp;</td>

</tr>

<tr>

<td align=”left” valign=”top”>&nbsp;</td>

<td colspan=”2″ align=”left” valign=”top”>&nbsp;</td>

</tr>

<tr>

<td align=”left” valign=”top”>&nbsp;</td>

<td align=”left” valign=”top”>&nbsp;</td>

<td align=”center” valign=”middle”>&nbsp;</td>

</tr>

</table>

<table border=”1″ bordercolor=”#660033″>

<tr>

<td height=”212″><table width=”200″ height=”191″ border=”0″ cellpadding=”0″ cellspacing=”0″ bordercolor=”#0000FF”>

<tr>

<td width=”79″>Username</td>

<td width=”105″><input name=”user” type=”text” id=”user”></td>

</tr>

<tr>

<td height=”85″ valign=”top”><p>Password</p></td>

<td valign=”top”><input name=”pass” type=”password” id=”pass”>

<br>

<input type=”submit” name=”Submit” value=”Submit”></td>

</tr>

<tr>

<td>&nbsp;</td>

<td><a href=”aboutus.jsp” class=”style2″>Create New Account </a></td>

</tr>

<tr>

<td>&nbsp;</td>

<td><a href=”forget password.jsp” class=”style2″></a></td>

</tr>

</table></td>

</tr>

</table>  <p>&nbsp;</p></td>

</tr>

</table>

</form>

</body>

</html>
Aboutus.jsp

<%@ page language=”java” %>

<%@ page session=”true” %>

<%@ page import=”java.sql.*” %>

<html>

<head>

<title>Resource Planning System</title>

<style type=”text/css”>

<!–

.style1 {font-family: Verdana, Arial, Helvetica, sans-serif}

.style2 {

font-size: 12px;

color: #0000FF;

}

.style5 {color: #0000FF}

.style6 {font-style: italic; font-family: Verdana, Arial, Helvetica, sans-serif;}

–>

</style>

</head>

<body>

<script language=”javascript”>

function validate(form)

{

if (form.user.value==””)

{          alert(“Username should not be blank. Please enter it.”);

form.name.focus(); return false;

}

if (form.pass.value==””)

{          alert(“Password should not be blank. Please enter it.”);

form.email.focus(); return false;

}

if (form.email.value==””)

{          alert(“Email should not be blank. Please enter it.”);

form.email.focus(); return false;

}

if (form.address.value==””)

{          alert(“Question should not be blank. Please enter it.”);

form.address.focus(); return false;

}

if (form.country.value==””)

{          alert(“Answer should not be blank. Please enter it.”);

form.country.focus(); return false;

}

if (form.phone.value==””)

{          alert(“Phone No. should not be blank. Please enter it.”);

form.phone.focus(); return false;

}

if(isNaN(form.phone.value))

{

alert(“Phone No. Should be a number “);

form.phone.focus();

return false;

}

}

</script>

<form name=”form1″ method=”post” action=”newmember.jsp” onSubmit=”return validate(this)”>

<table width=”731″ border=”0″ align=”center” cellspacing=”0″>

<tr>

<td colspan=”2″ height=”120″><%@ include file=”header1.jsp” %></td>

</tr>

 

<tr>

<td width=”150″ align=”left” valign=”top”>&nbsp;</td>

<td width=”750″ align=”left” valign=”top”><table width=”409″ border=”0″ align=”left” cellpadding=”5″ cellspacing=”0″>

<tr>

<td align=”left” valign=”top”>&nbsp;</td>

<td align=”left” valign=”top”>&nbsp;</td>

<td align=”left” valign=”top”>&nbsp;</td>

</tr>

<tr>

<td width=”59″ align=”left” valign=”top”>&nbsp;</td>

<td width=”124″ align=”left” valign=”top”>Username</td>

<td width=”196″ align=”left” valign=”top”>

<label>

<div align=”center”>

<input name=”user” type=”text” id=”user”>

</div>

</label>    </td>

</tr>

<tr>

<td align=”left” valign=”top”>&nbsp;</td>

<td align=”left” valign=”top”>Password</td>

<td align=”center” valign=”middle”><label>

<input name=”pass” type=”password” id=”pass”>

</label></td>

</tr>

<tr>

<td align=”left” valign=”top”>&nbsp;</td>

<td align=”left” valign=”top”>Email Id </td>

<td align=”center” valign=”middle”><input name=”email” type=”text” id=”email”></td>

</tr>

<tr>

<td align=”left” valign=”top”>&nbsp;</td>

<td align=”left” valign=”top”>Security Question </td>

<td align=”center” valign=”middle”><input name=”address” type=”text” id=”address”></td>

</tr>

<tr>

<td align=”left” valign=”top”>&nbsp;</td>

<td align=”left” valign=”top”>Answer</td>

<td align=”center” valign=”middle”><input name=”country” type=”text” id=”country”></td>

</tr>

<tr>

<td align=”left” valign=”top”>&nbsp;</td>

<td align=”left” valign=”top”>Phone</td>

<td align=”center” valign=”middle”><input name=”phone” type=”text” id=”phone”></td>

</tr>

<tr>

<td align=”left” valign=”top”>&nbsp;</td>

<td align=”left” valign=”top”>&nbsp;</td>

<td align=”center” valign=”middle”><input type=”submit” name=”Submit” value=”Submit”></td>

</tr>

<tr>

<td align=”left” valign=”top”>&nbsp;</td>

<td colspan=”2″ align=”left” valign=”top”>

<span class=”style1″>

<label>

</label>

</span> <span class=”style5″>

<label></label>

</span>

<label>

<div align=”justify” class=”style2″><span class=”style6″>By clicking Register , you are indicating that you have read and agree to the Users Agreement and Privacy Policy. </span></div>

</label>    </td>

</tr>

</table></td>

</tr>

</table>

</form>

</body>

</html>

Registeration.jsp

<%@ page language=”java” import=”java.sql.*” %>

<%@ page session=”true” %>

<html>

<head>

<title>Resource Planning System</title>

<style type=”text/css”>

<!–

.style2 {

font-size: 16px;

font-weight: bold;

color: #990000;

}

.style5 {

font-size: 12px;

font-weight: bold;

}

–>

</style>

</head>

<body>

<form name=”form1″ method=”post” action=”log.jsp”>

<table width=”728″ border=”0″ align=”center” cellspacing=”0″>

<tr>

<td colspan=”2″ height=”154″><%@ include file=”header1.jsp” %></td>

</tr>

 

<tr>

<td width=”2″ align=”left” valign=”top”>&nbsp;</td>

<td width=”903″ align=”left” valign=”top”><table width=”519″ border=”0″ align=”left” cellpadding=”0″ cellspacing=”0″>

<tr>

<td height=”230″ align=”left” valign=”top”><p>&nbsp;</p>

<p>&nbsp;</p>

<p>&nbsp;</p></td>

<td colspan=”2″ align=”left” valign=”top”><a href=”products.jsp?cat=Jewellary and Watches&type=Rings”></a>

<h2 class=”style5″>ABOUT US </h2>

<h2 class=”style5″>1. The web-site is to be accessed from any where anytime.</h2>

<h2 class=”style5″>2. As the project is web-based so the software should be  platform independent.</h2>

<h2 class=”style5″>3. The data is very important asset for corporation so strong  authentication method is to be used to ensure security of information from  malicious user.</h2>

<h2 class=”style5″>4. As the valuable data is being transferred through internet  so the security of data is to be maintained at any cost.</h2>

<h2 class=”style5″>5. Easy to be customized in future. As the client demand some  other additional features. The complexity of customer&rsquo;s company may be  different or if mode of business changes then the system has capability to make  appropriate modification to suite that change. Customization is key factor of  designing this software.</h2>

<p class=”style5″>6. The web-site  manipulates data in an accurate way.<br>

  1. Accuracy of all type of calculations are important and to be achieved at any cost.<br>
  2. This should always be observed during the development of the software that the user is not  from technical background, so the software should be user friendly and can be  handled easily.<br>
  3. Storage of data should be easily accessible.<br>
  4. The data retrieval and other manipulation related task which is done at the database  level should be fast enough. The database should support multiple users at a  time. <br>
  5. The product should fulfill user&rsquo;s requirement.</p>

<strong><u><br clear=”all”>

</u></strong></td>

</tr>

<tr>

<td width=”4″ align=”left” valign=”top”>&nbsp;</td>

<td width=”395″ align=”left” valign=”top”>&nbsp;</td>

<td width=”218″ align=”left” valign=”top”>&nbsp;</td>

</tr>

<tr>

<td align=”left” valign=”top”>&nbsp;</td>

<td colspan=”2″ align=”left” valign=”top”>&nbsp;</td>

</tr>

<tr>

<td align=”left” valign=”top”>&nbsp;</td>

<td align=”left” valign=”top”>&nbsp;</td>

<td align=”center” valign=”middle”>&nbsp;</td>

</tr>

</table>

<table border=”1″ bordercolor=”#660033″>

<tr>

<td height=”195″><table width=”200″ height=”191″ border=”0″ cellpadding=”0″ cellspacing=”0″ bordercolor=”#0000FF”>

<tr>

<td width=”79″>Username</td>

<td width=”105″><input name=”user” type=”text” id=”user”></td>

</tr>

<tr>

<td height=”85″ valign=”top”><p>Password</p></td>

<td valign=”top”><input name=”pass” type=”password” id=”pass”>

<br>

<input type=”submit” name=”Submit” value=”Submit”></td>

</tr>

<tr>

<td>&nbsp;</td>

<td><a href=”aboutus.jsp” class=”style2″>Create New Account </a></td>

</tr>

<tr>

<td>&nbsp;</td>

<td><a href=”forget password.jsp” class=”style2″></a></td>

</tr>

</table></td>

</tr>

</table>  <p>&nbsp;</p></td>

</tr>

</table>

</form>

</body>

</html>

Login.jsp

<%@ page language=”java” %>

<%@ page session=”true” %>

<html>

<head>

<title>Enterprise marketing</title>

<style type=”text/css”>

<!–

.style3 {font-family: “Courier New”, Courier, monospace; font-size: 14px; }

–>

</style>

</head>

<body>

<script language=”javascript”>

function validate(form)

{

if (form.user.value==””)

{          alert(“Username should not be blank. Please enter it.”);

form.user.focus(); return false;

}

if (form.pass.value==””)

{          alert(“Password should not be blank. Please enter it.”);

form.pass.focus(); return false;

}

}

</script>

<form action=”log.jsp” method=”post” onsubmit=”return validate(this)”>

<table width=”731″ border=”0″ align=”center” cellspacing=”0″>

<tr>

<td colspan=”2″ height=”120″><%@ include file=”header1.jsp” %></td>

</tr>

<tr>

<td width=”150″ align=”left” valign=”top”>&nbsp;</td>

<td width=”750″ align=”left” valign=”top”><table width=”653″ border=”0″ align=”left” cellpadding=”5″ cellspacing=”0″>

<tr>

<td align=”left” valign=”top” bgcolor=”#FFFFFF”><p>&nbsp;</p>

<p>&nbsp;</p>

<p>&nbsp;</p></td>

<td colspan=”2″ align=”left” valign=”top” bordercolor=”#CC9999″ bgcolor=”#FFFFFF”><%

try

{

String u=(String)session.getAttribute(“login” );

if(u.equals(“yes”))

response.sendRedirect(“loged in.jsp”);

}

catch(Exception ed)

{

}

%>

&nbsp;</td>

<td align=”left” valign=”top” bgcolor=”#FFFFFF”>&nbsp;</td>

<td colspan=”2″ align=”left” valign=”top” bgcolor=”#FFFFFF”>&nbsp;</td>

</tr>

<tr>

<td align=”left” valign=”top”>&nbsp;</td>

<td colspan=”2″ align=”left” valign=”top” bordercolor=”#CC9999″ bgcolor=”#CC6699″><span class=”style3″>Existing Users Login Here </span></td>

<td align=”left” valign=”top”>&nbsp;</td>

<td colspan=”2″ align=”left” valign=”top” bgcolor=”#CCCCCC”><span class=”style3″>Don’t Have an Account Yet </span></td>

</tr>

<tr>

<td width=”95″ height=”84″ align=”left” valign=”top”>&nbsp;</td>

<td width=”109″ align=”left” valign=”top”><p>&nbsp;</p>

<p>Username</p>

<p>Password</p></td>

<td width=”160″ align=”left” valign=”top”><label>

<br>

<br>

<input name=”user” type=”text” id=”user”>

<br>

<br>

<input name=”pass” type=”password” id=”pass”>

</label>    </td>

<td width=”2″ align=”left” valign=”top”>&nbsp;</td>

<td colspan=”2″ align=”left” valign=”top”><p>&nbsp;</p>

<p>Get connected to incredible excess inventory deals from the world most trusted brands. </p></td>

</tr>

<tr>

<td align=”left” valign=”top”>&nbsp;</td>

<td align=”left” valign=”top”>&nbsp;</td>

<td align=”left” valign=”middle”><label><a  href=”log.jsp”>

<input type=”submit” name=”Submit” value=”Sign In”>

 

</a></label></td>

<td align=”center” valign=”middle”>&nbsp;</td>

<td width=”110″ align=”center” valign=”middle”>&nbsp;</td>

<td width=”118″ align=”center” valign=”middle”><a href=”aboutus.jsp”><img src=”images/regist.jpg” width=”96″ height=”37″ border=”0″></a></td>

</tr>

 

<tr>

<td align=”left” valign=”top”>&nbsp;</td>

<td align=”left” valign=”top”>&nbsp;</td>

<td align=”center” valign=”middle”><label></label></td>

<td align=”center” valign=”middle”>&nbsp;</td>

<td align=”center” valign=”middle”>&nbsp;</td>

<td align=”center” valign=”middle”>&nbsp;</td>

</tr>

</table></td>

</tr>

</table>

<form>

</body>

</html>

Contactus.jsp

<%@ page language=”java” %>

<%@ page session=”true” %>

<html>

<head>

<title>Resource Planning System</title>

<style type=”text/css”>

<!–

.style2 {font-family: Arial, Helvetica, sans-serif}

.style4 {

font-size: 16px;

font-family: Arial, Helvetica, sans-serif;

font-weight: bold;

color: #0000FF;

}

.style6 {font-family: Arial, Helvetica, sans-serif; font-weight: bold; }

–>

</style>

</head>

<body>

<table width=”731″ border=”0″ align=”center” cellspacing=”0″>

<tr>

<td colspan=”2″ height=”120″><%@ include file=”header1.jsp” %></td>

</tr>

<tr>

<td width=”150″ align=”left” valign=”top”>&nbsp;</td>

<td width=”750″ align=”center” valign=”top”><p><span class=”style4″>Contact Us</span><BR __designer:dtid=”2251804108652552″ />

<BR __designer:dtid=”2251804108652553″ />

<span class=”style6″>For your Suggetions contact us at<BR __designer:dtid=”2251804108652554″ />

Email:[email protected]<BR __designer:dtid=”2251804108652555″ />

Phone : 985643458,98543354646</span></p>

<p>&nbsp;</p>

<p><span class=”style2″><img src=”images/cont.jpg” width=”94″ height=”124″><BR __designer:dtid=”2251804108652556″ />

</span></p></td>

</tr>

</table>

</body>

</html>

Admin.jsp

<%@ page language=”java” %>

<%@ page session=”true” %>

<html>

<head>

<title>Resource Planning System</title>

<style type=”text/css”>

<!–

.style7 {

font-family: Arial, Helvetica, sans-serif;

font-size: 16px;

font-weight: bold;

color: #0000FF;

}

.style8 {

font-size: 18px;

color: #CC3300;

}

.style14 {color: #0000FF}

–>

</style>

</head>

<body>  <form name=”form” method=”post” action=”naw.jsp”>

<table width=”731″ border=”0″ align=”center” cellspacing=”0″>

<tr>

<td colspan=”2″ height=”120″><%@ include file=”header1.jsp” %></td>

</tr>

<tr>

<td width=”89″ align=”left” valign=”top”>&nbsp;</td>

<td width=”638″ align=”left” valign=”top” bgcolor=”#FFFFFF”><table width=”538″ border=”0″>

<tr>

<td width=”463″ height=”170″ align=”left” valign=”top”><h2 align=”center” class=”style14″>&nbsp;</h2>

<h2 align=”center” class=”style14″>Login</h2>

<label>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;User name

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

<input type=”text” name=”textfield”>

</label>

<p>

<label>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br>     &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Password&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

<input type=”password” name=”textfield2″>

</label>

</p>     &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

<p>&nbsp;</p>

<label>

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

<input type=”submit” name=”Submit” value=”Submit”>

</label>

<p align=”center” class=”style14″>&nbsp;</p></td>

</tr>

</table>

<h1 class=”style8″>&nbsp;</h1>

<p>&nbsp;</p>

<h1>&nbsp;</h1>  <p class=”style7″ __designer:dtid=”281479271677962″>&nbsp;</p>  </td>

</tr>

</table>  </form>

</body>

</html>

Adminmenu.jsp

<%@ page language=”java” import=”java.sql.*” %>

<%@ page session=”true” %>

<html>

<head>

<title>Resource Planning System</title>

<style type=”text/css”>

<!–

.style7 {

font-family: Arial, Helvetica, sans-serif;

font-size: 16px;

font-weight: bold;

color: #0000FF;

}

.style8 {

font-size: 18px;

color: #CC3300;

}

.style10 {font-size: 24px; color: #0000FF;}

.style12 {

font-size: 16px;

font-weight: bold;

}

.style13 {

color: #0000FF;

font-weight: bold;

}

.style15 {font-size: 16px; font-weight: bold; color: #FF0000; }

–>

</style>

</head>

<body>

<table width=”731″ border=”0″ align=”center” cellspacing=”0″>

<tr>

<td colspan=”2″ height=”120″><%@ include file=”header1.jsp” %></td>

</tr>

<tr>

<td width=”150″ align=”left” valign=”top”>&nbsp;</td>

<td width=”750″ align=”left” valign=”top” bgcolor=”#FFFFFF”><form name=”form1″ method=”get” action=””>

<table width=”671″ height=”604″ border=”0″>

<tr>

<td height=”75″ colspan=”2″><div align=”center” class=”style10″>

<p>&nbsp;</p>

<p>Administrator Menu </p>

<p>&nbsp;</p>

</div></td>

</tr>

<tr>

<td width=”285″><p align=”center” class=”style15″>&nbsp;</p>        </td>

<td width=”376″><p align=”center” class=”style15″>Reports Available </p>

<p align=”center” class=”style12″></p></td>

</tr>

<tr>

<td><div align=”center” class=”style13″><a href=”product.jsp”>Add Products </a></div></td>

<td><span class=”style13″><a href=”repo_users.jsp”>Users Details</a></span></td>

</tr>

<tr>

<td><div align=”center” class=”style13″></div></td>

<td>&nbsp;</td>

</tr>

<tr>

<td><div align=”center” class=”style13″>

<p><a href=”branch.jsp”>Add Branch Details </a></p>

<a href=”sales.jsp”><strong>Add Product Sales Details</strong></a>

</p>

</div></td>

<td background=”repo_items.jsp”><p><strong><a href=”repo_product.jsp”>Product  Details</a> </strong></p>

<p><strong><a href=”repo_sales.jsp”>Product Sales Details</a></strong></p></td>

</tr>

<tr>

<td height=”43″><div align=”center” class=”style13″><a href=”purchase.jsp”><strong>Add Purchase Details</strong></a></div></td>

<td><p><strong><a href=”repo_product1.jsp”>Inventory  Details</a> </strong></p>        </td>

</tr>

<tr>

<td align=”center” valign=”top”><div align=”center” class=”style13″>

<p align=”center”>&nbsp;</p>

<p align=”center”><a href=”target.jsp”><strong>Add Target</strong></a></p>

</div>

<p><strong><a href=”empdetail.jsp”>Add Employee  Details</a></strong></p></td>

<td><p class=”style13″><a href=”repo_target.jsp”>Target   Details</a></p>

<p class=”style13″><a href=”feedbackdet.jsp”>Feedback Details</a></p>

<p class=”style13″><a href=”repo_branch.jsp”>Branch Details</a> </p></td>

</tr>

<tr>

<td><div align=”center”><strong><a href=”customer.jsp”> Add Customer  Details</a></strong></div></td>

<td><a href=”EMPdet.jsp”><strong>Employee Details</strong></a></td>

</tr>

<tr>

<td>&nbsp;</td>

<td>&nbsp;</td>

</tr>

<tr>

<td>&nbsp;</td>

<td>&nbsp;</td>

</tr>

<tr>

<td>&nbsp;</td>

<td>&nbsp;</td>

</tr>

<tr>

<td>&nbsp;</td>

<td>&nbsp;</td>

</tr>

</table>

</form>

<h1 class=”style8″>&nbsp;</h1>

<p>&nbsp;</p>

<h1>&nbsp;</h1>  <p class=”style7″ __designer:dtid=”281479271677962″>&nbsp;</p>  </td>

</tr>

</table>

</body>

</html>

Product.jsp

<%@ page language=”java” import=”java.sql.*” %>

<%@ page session=”true” %>

<html>

<head>

<title>Resource Planning System</title>

<style type=”text/css”>

<!–

.style2 {font-family: Arial, Helvetica, sans-serif}

–>

</style>

</head>

<body>

<script language=”javascript”>

function validate(form)

{

if (form.textfield.value==””)

{          alert(“ID should not be blank. Please enter it.”);

form.textfield.focus(); return false;

}

if (form.textfield2.value==””)

{          alert(“Field should not be blank. Please enter it.”);

form.textfield2.focus(); return false;

}

if (form.textfield3.value==””)

{          alert(“Field should not be blank. Please enter it.”);

form.textfield3.focus(); return false;

}

if (form.textfield4.value==””)

{          alert(“Field should not be blank. Please enter it.”);

form.textfield4.focus(); return false;

}

}

</script>

<form action=”productins.jsp” method=”post” onSubmit=”return validate(this)”>

 

<table width=”731″ border=”0″ align=”center” cellspacing=”0″>

<tr>

<td colspan=”2″ height=”120″><%@ include file=”header1.jsp” %></td>

</tr>

<tr>

<td width=”150″ align=”left” valign=”top”>&nbsp;</td>

<td width=”750″ align=”center” valign=”top”><table width=”380″ border=”0″>

<tr>

<td height=”32″ colspan=”2″><strong>Add Product Details </strong></td>

<td width=”85″>&nbsp;</td>

</tr>

<tr>

<td width=”137″><strong>Product  ID</strong>

<%@ include file=”connect.jsp”%>

<%

String query=”select * from product”;

ResultSet rs = statement.executeQuery(query);

int i=0;

while(rs.next())

{

i=i+1;

}

String id=”P0″+(i+1);

%></td>

<td width=”144″><input name=”textfield” type=”text” id=”textfield” value='<%=id%>’></td>

<td>&nbsp;</td>

</tr>

<tr>

<td><strong>Product Name </strong></td>

<td><input name=”textfield2″ type=”text” id=”textfield2″></td>

<td>&nbsp;</td>

</tr>

<tr>

<td><strong>Product Description</strong> </td>

<td><input name=”textfield3″ type=”text” id=”textfield3″></td>

<td>&nbsp;</td>

</tr>

<tr>

<td><strong>Price</strong></td>

<td><input name=”textfield4″ type=”text” id=”textfield4″></td>

<td>&nbsp;</td>

</tr>

<tr>

<td><strong>Unit</strong></td>

<td><input name=”textfield5″ type=”text” id=”textfield5″></td>

<td>&nbsp;</td>

</tr>

<tr>

<td><strong>Stock</strong></td>

<td><input name=”textfield6″ type=”text” id=”textfield6″></td>

<td>&nbsp;</td>

</tr>

<tr>

<td>&nbsp;</td>

<td><input type=”submit” name=”Submit” value=”Submit”></td>

<td>&nbsp;</td>

</tr>

</table>

<p><BR __designer:dtid=”2251804108652552″ />

<span class=”style2″><BR __designer:dtid=”2251804108652556″ />

</span></p>

</td>

</tr>

</table>

</form></body>

</html>

 

Branch.jsp

 

<%@ page language=”java” import=”java.sql.*” %>

<%@ page session=”true” %>

<html>

<head>

<title>Resource Planning System</title>

<style type=”text/css”>

<!–

.style2 {font-family: Arial, Helvetica, sans-serif}

–>

</style>

</head>

<body>

<script language=”javascript”>

 

function validate(form)

{

if (form.textfield.value==””)

{          alert(“ID should not be blank. Please enter it.”);

form.textfield.focus(); return false;

}

if (form.textfield2.value==””)

{          alert(“Field should not be blank. Please enter it.”);

form.textfield2.focus(); return false;

}

if (form.textfield3.value==””)

{          alert(“Field should not be blank. Please enter it.”);

form.textfield3.focus(); return false;

}

if (form.textfield4.value==””)

{          alert(“Field should not be blank. Please enter it.”);

form.textfield4.focus(); return false;

}

if (form.textfield5.value==””)

{          alert(“Field should not be blank. Please enter it.”);

form.textfield5.focus(); return false;

}

if (form.textfield6.value==””)

{          alert(“Field should not be blank. Please enter it.”);

form.textfield6.focus(); return false;

}

if (form.textfield7.value==””)

{          alert(“Field should not be blank. Please enter it.”);

form.textfield7.focus(); return false;

}

}

</script>

<%@ include file=”connect.jsp”%>

<form action=”branchins.jsp” method=”post” onSubmit=”return validate(this)”>

<table width=”731″ border=”0″ align=”center” cellspacing=”0″>

<tr>

<td colspan=”2″ height=”120″><%@ include file=”header1.jsp” %></td>

</tr>

<tr>

<td width=”150″ align=”left” valign=”top”>&nbsp;</td>

<td width=”750″ align=”center” valign=”top”><table width=”380″ border=”0″>

<tr>

<td height=”32″ colspan=”2″><strong>Add Branch Details </strong></td>

<td width=”85″>&nbsp;</td>

</tr>

<tr>

<td width=”137″><strong>Branch  ID</strong> <%

String query=”select * from branch”;

ResultSet rs = statement.executeQuery(query);

int i=0;

while(rs.next())

{

i=i+1;

}

String id=”B0″+(i+1);

%></td>

<td width=”144″><input name=”textfield” type=”text” id=”textfield” value='<%=id%>’></td>

<td>&nbsp;</td>

</tr>

<tr>

<td><strong>Branch Name </strong></td>

<td><input name=”textfield2″ type=”text” id=”textfield2″></td>

<td>&nbsp;</td>

</tr>

<tr>

<td><strong>Performance</strong></td>

<td><input name=”textfield3″ type=”text” id=”textfield3″></td>

<td>&nbsp;</td>

</tr>

<tr>

<td><strong>Address</strong></td>

<td><input name=”textfield4″ type=”text” id=”textfield4″></td>

<td>&nbsp;</td>

</tr>

<tr>

<td><strong>Phone</strong></td>

<td><input name=”textfield5″ type=”text” id=”textfield5″></td>

<td>&nbsp;</td>

</tr>

<tr>

<td><strong>Fax</strong></td>

<td><input name=”textfield6″ type=”text” id=”textfield6″></td>

<td>&nbsp;</td>

</tr>

<tr>

<td><strong>Email</strong></td>

<td><input name=”textfield7″ type=”text” id=”textfield7″></td>

<td>&nbsp;</td>

</tr>

<tr>

<td>&nbsp;</td>

<td><input type=”submit” name=”Submit” value=”Submit”></td>

<td>&nbsp;</td>

</tr>

</table>

<p><BR __designer:dtid=”2251804108652552″ />

<span class=”style2″><BR __designer:dtid=”2251804108652556″ />

</span></p>

</td>

</tr>

</table>

</form></body>

</html>

Sales.jsp

<%@ page language=”java” import=”java.sql.*” %>

<%@ page session=”true” %>

<html>

<head>

<title>Resource Planning System</title>

<style type=”text/css”>

<!–

.style2 {font-family: Arial, Helvetica, sans-serif}

–>

</style>

</head>

<body>

<%@ include file=”connect.jsp”%>

<script language=”javascript”>

function validate(form)

{

if (form.textfield.value==””)

{          alert(“ID should not be blank. Please enter it.”);

form.textfield.focus(); return false;

}

if (form.textfield2.value==””)

{          alert(“Field should not be blank. Please enter it.”);

form.textfield2.focus(); return false;

}

if (form.textfield4.value==””)

{          alert(“Field should not be blank. Please enter it.”);

form.textfield4.focus(); return false;

}

}

</script>

<form action=”salesins.jsp” method=”post” onSubmit=”return validate(this)”>

<table width=”731″ border=”0″ align=”center” cellspacing=”0″>

<tr>

<td colspan=”2″ height=”120″><%@ include file=”header1.jsp” %></td>

</tr>

<tr>

<td width=”150″ align=”left” valign=”top”>&nbsp;</td>

<td width=”750″ align=”center” valign=”top”><p>&nbsp;</p>

<table width=”380″ border=”0″>

<tr>

<td height=”32″ colspan=”2″><strong>Add Target Details </strong></td>

<td width=”85″>&nbsp;</td>

</tr>

<tr>

<td width=”137″><strong>Product  ID</strong></td>

<td width=”144″><select name=”select”>

<%

String query2=”select * from product”;

ResultSet rs2 = statement.executeQuery(query2);

while(rs2.next())

{

%>

<option><%=rs2.getString(1)%></option>

<%

}

%>

</select>    </td>

<td>&nbsp;</td>

</tr>

<tr>

<td><strong>Product Sale </strong></td>

<td><input type=”text” name=”textfield”></td>

<td>&nbsp;</td>

</tr>

<tr>

<td><strong>Return</strong></td>

<td><input name=”textfield2″ type=”text” id=”textfield2″></td>

<td>&nbsp;</td>

</tr>

<tr>

<td><strong>Damage</strong></td>

<td><input name=”textfield4″ type=”text” id=”textfield4″></td>

<td>&nbsp;</td>

</tr>

<tr>

<td><strong>Branch ID</strong> </td>

<td><select name=”select2″>

<%

String query1=”select * from branch”;

ResultSet rs1 = statement.executeQuery(query1);

while(rs1.next())

{

%>

<option><%=rs1.getString(1)%></option>

<%

}

%>

</select></td>

<td>&nbsp;</td>

</tr>

<tr>

<td><strong>Date of Sales</strong> </td>

<td><input name=”textfield5″ type=”text” id=”textfield5″></td>

<td>&nbsp;</td>

</tr>

<tr>

<td>&nbsp;</td>

<td><input type=”submit” name=”Submit” value=”Submit”></td>

<td>&nbsp;</td>

</tr>

</table>

<p><BR __designer:dtid=”2251804108652552″ />

<span class=”style2″><BR __designer:dtid=”2251804108652556″ />

</span></p>

</td>

</tr>

</table>

</form></body>

</html>

 

Purchase.jsp

<%@ page contentType=”text/html; charset=iso-8859-1″ language=”java” import=”java.sql.*” errorPage=”” %>

<!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”>

<html xmlns=”http://www.w3.org/1999/xhtml”>

<head>

<meta http-equiv=”Content-Type” content=”text/html; charset=iso-8859-1″ />

<title>INVENTORY MANAGEMENT SYSTEM FOR DEPARTMENTAL STRORE</title>

<style type=”text/css”>

<!–

.style8 {color: #0000FF}

–>

</style>

</head>

<body>

<%@ include file=”connect.jsp”%>

<table width=”200″ border=”0″ cellspacing=”0″ cellpadding=”2″>

<tr>

<td>&nbsp;</td>

</tr>

</table>

<table width=”931″ border=”0″ cellspacing=”0″ cellpadding=”0″>

<tr>

<th width=”180″ height=”67″ align=”left” valign=”top” scope=”col”>&nbsp;</th>

<th width=”106″ scope=”col”>&nbsp;</th>

<th width=”645″ align=”left” valign=”top” scope=”col”><p>&nbsp;</p>

<table width=”618″ border=”0″ cellspacing=”0″ cellpadding=”0″>

<tr>

<th width=”618″ height=”375″ align=”left” valign=”top” scope=”col”><h2 align=”center” class=”style8″>Users Details</h2>

<%

String query=”select * from login”;

ResultSet rs = statement.executeQuery(query);

%>

<table width=”415″ border=”1″ align=”center” cellspacing=”0″ >

<tr>

<td width=”96″><strong>Product ID </strong></td>

<td width=”112″><strong>Branch ID </strong></td>

<td width=”77″><strong>Target</strong></td>

<td width=”112″><strong>Target Date </strong></td>

</tr>

<%

while(rs.next())

{

%>

<tr>

<td><%=rs.getString(1)%></td>

<td><%=rs.getString(2)%></td>

<td><%=rs.getString(4)%></td>

<td><%=rs.getString(7)%></td>

</tr>

<%}%>

</table>

<p align=”center” class=”style8″>&nbsp;</p></th>

</tr>

</table>

<h2 align=”center” class=”style8″>&nbsp;</h2>

</th>

</tr>

</table>

<p>&nbsp;</p>

<p>&nbsp;</p>

<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p>&nbsp;</p>

<p>

<label></label>

</p>

<p>&nbsp;</p>

<p align=”center”>

<label></label>

</p>

</form>          <p align=”center” class=”style8″>&nbsp;</p></th>

</tr>

</table></th>

</tr>

</table>

<p>&nbsp;</p>

<p>&nbsp;</p>

<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p>

</body>

</html>

Repo_userdetails.jsp

<%@ page contentType=”text/html; charset=iso-8859-1″ language=”java” import=”java.sql.*” errorPage=”” %>

<!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”>

<html xmlns=”http://www.w3.org/1999/xhtml”>

<head>

<meta http-equiv=”Content-Type” content=”text/html; charset=iso-8859-1″ />

<title>INVENTORY MANAGEMENT SYSTEM FOR DEPARTMENTAL STRORE</title>

<style type=”text/css”>

<!–

.style8 {color: #0000FF}

–>

</style>

</head>

<body>

<table width=”200″ border=”0″ cellspacing=”0″ cellpadding=”2″>

<tr>

<td>&nbsp;</td>

</tr>

</table>

<table width=”931″ border=”0″ cellspacing=”0″ cellpadding=”0″>

<tr>

<th width=”180″ height=”67″ align=”left” valign=”top” scope=”col”>&nbsp;</th>

<th width=”106″ scope=”col”>&nbsp;</th>

<th width=”645″ align=”left” valign=”top” scope=”col”><p>&nbsp;</p>

<table width=”618″ border=”0″ cellspacing=”0″ cellpadding=”0″>

<tr>

<th width=”618″ height=”375″ align=”left” valign=”top” scope=”col”><h2 align=”center” class=”style8″>Users Details</h2>

<%

Class.forName(“com.mysql.jdbc.Driver”);

Connection connection = DriverManager.getConnection(“jdbc:mysql://localhost/enterprise”,”root”,”1234″);

Statement statement = connection.createStatement();

String query=”select * from login”;

ResultSet rs = statement.executeQuery(query);

%>

<table width=”415″ border=”1″ align=”center” cellspacing=”0″ >

<tr>

<td width=”96″><strong>Product ID </strong></td>

<td width=”112″><strong>Branch ID </strong></td>

<td width=”77″><strong>Target</strong></td>

<td width=”112″><strong>Target Date </strong></td>

</tr>

<%

while(rs.next())

{

%>

<tr>

<td><%=rs.getString(1)%></td>

<td><%=rs.getString(2)%></td>

<td><%=rs.getString(4)%></td>

<td><%=rs.getString(7)%></td>

</tr>

<%}%>

</table>

<p align=”center” class=”style8″>&nbsp;</p></th>

</tr>

</table>

<h2 align=”center” class=”style8″>&nbsp;</h2>

</th>

</tr>

</table>

<p>&nbsp;</p>

<p>&nbsp;</p>

<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p>&nbsp;</p>

<p>

<label></label>

</p>

<p>&nbsp;</p>

<p align=”center”>

<label></label>

</p>

</form>          <p align=”center” class=”style8″>&nbsp;</p></th>

</tr>

</table></th>

</tr>

</table>

<p>&nbsp;</p>

<p>&nbsp;</p>

<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p>

</body>

</html>

Repo_products

<%@ page contentType=”text/html; charset=iso-8859-1″ language=”java” import=”java.sql.*” errorPage=”” %>

<!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”>

<html xmlns=”http://www.w3.org/1999/xhtml”>

<head>

<meta http-equiv=”Content-Type” content=”text/html; charset=iso-8859-1″ />

<title>INVENTORY MANAGEMENT SYSTEM FOR DEPARTMENTAL STRORE</title>

<style type=”text/css”>

<!–

.style8 {color: #0000FF}

–>

</style>

</head>

<body>

<%@ include file=”connect.jsp”%>

<table width=”200″ border=”0″ cellspacing=”0″ cellpadding=”2″>

<tr>

<td>&nbsp;</td>

</tr>

</table>

<table width=”931″ border=”0″ cellspacing=”0″ cellpadding=”0″>

<tr>

<th width=”180″ height=”67″ align=”left” valign=”top” scope=”col”>&nbsp;</th>

<th width=”106″ scope=”col”>&nbsp;</th>

<th width=”645″ align=”left” valign=”top” scope=”col”><p>&nbsp;</p>

<table width=”618″ border=”0″ cellspacing=”0″ cellpadding=”0″>

<tr>

<th width=”618″ height=”375″ align=”left” valign=”top” scope=”col”><h2 align=”center” class=”style8″>Product Details</h2>

<%

String query=”select * from product”;

ResultSet rs = statement.executeQuery(query);

%>

<table width=”415″ border=”1″ align=”center” cellspacing=”0″ >

<tr>

<td width=”96″><strong>Product ID </strong></td>

<td width=”112″><strong>Product Name </strong></td>

<td width=”77″><strong>Description</strong></td>

<td width=”112″><strong>Price </strong></td>

</tr>

<%

while(rs.next())

{

%>

<tr>

<td><%=rs.getString(1)%></td>

<td><%=rs.getString(2)%></td>

<td><%=rs.getString(3)%></td>

<td><%=rs.getString(4)%></td>

</tr>

<%}%>

</table>

<p align=”center” class=”style8″>&nbsp;</p></th>

</tr>

</table>

<h2 align=”center” class=”style8″>&nbsp;</h2>

</th>

</tr>

</table>

<p>&nbsp;</p>

<p>&nbsp;</p>

<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p>&nbsp;</p>

<p>

<label></label>

</p>

<p>&nbsp;</p>

<p align=”center”>

<label></label>

</p>

</form>          <p align=”center” class=”style8″>&nbsp;</p></th>

</tr>

</table></th>

</tr>

</table>

<p>&nbsp;</p>

<p>&nbsp;</p>

<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p>

</body>

</html>

 

Repo_sales

<%@ page contentType=”text/html; charset=iso-8859-1″ language=”java” import=”java.sql.*” errorPage=”” %>

<!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”>

<html xmlns=”http://www.w3.org/1999/xhtml”>

<head>

<meta http-equiv=”Content-Type” content=”text/html; charset=iso-8859-1″ />

<title>INVENTORY MANAGEMENT SYSTEM FOR DEPARTMENTAL STRORE</title>

<style type=”text/css”>

<!–

.style8 {color: #0000FF}

–>

</style>

</head>

<body>

<%@ include file=”connect.jsp”%>

<table width=”200″ border=”0″ cellspacing=”0″ cellpadding=”2″>

<tr>

<td>&nbsp;</td>

</tr>

</table>

<table width=”931″ border=”0″ cellspacing=”0″ cellpadding=”0″>

<tr>

<th width=”180″ height=”67″ align=”left” valign=”top” scope=”col”>&nbsp;</th>

<th width=”106″ scope=”col”>&nbsp;</th>

<th width=”645″ align=”left” valign=”top” scope=”col”><p>&nbsp;</p>

<table width=”618″ border=”0″ cellspacing=”0″ cellpadding=”0″>

<tr>

<th width=”618″ height=”375″ align=”left” valign=”top” scope=”col”><h2 align=”center” class=”style8″>Sales Details</h2>

<%

String query=”select * from pruduct_sale”;

ResultSet rs = statement.executeQuery(query);

%>

<table width=”415″ border=”1″ align=”center” cellspacing=”0″ >

<tr>

<td width=”96″><strong>Product ID </strong></td>

<td width=”112″><strong>Sales </strong></td>

<td width=”96″><strong>Return </strong></td>

<td width=”112″><strong>Product Damage </strong></td>

<td width=”96″><strong>Branch ID </strong></td>

</tr>

<%

while(rs.next())

{

%>

<tr>

<td><%=rs.getString(1)%></td>

<td><%=rs.getString(2)%></td>

<td><%=rs.getString(3)%></td>

<td><%=rs.getString(4)%></td>

<td><%=rs.getString(5)%></td>

</tr>

<%}%>

</table>

<p align=”center” class=”style8″>&nbsp;</p></th>

</tr>

</table>

<h2 align=”center” class=”style8″>&nbsp;</h2>

</th>

</tr>

</table>

<p>&nbsp;</p>

<p>&nbsp;</p>

<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p>&nbsp;</p>

<p>

<label></label>

</p>

<p>&nbsp;</p>

<p align=”center”>

<label></label>

</p>

</form>          <p align=”center” class=”style8″>&nbsp;</p></th>

</tr>

</table></th>

</tr>

</table>

<p>&nbsp;</p>

<p>&nbsp;</p>

<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p>

</body>

</html>

 

Repo_product1.jsp

 

<%@ page contentType=”text/html; charset=iso-8859-1″ language=”java” import=”java.sql.*” errorPage=”” %>

<!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”>

<html xmlns=”http://www.w3.org/1999/xhtml”>

<head>

<meta http-equiv=”Content-Type” content=”text/html; charset=iso-8859-1″ />

<title>Resource Planning System</title>

<style type=”text/css”>

<!–

.style8 {color: #0000FF}

–>

</style>

</head>

<body>

<%@ include file=”connect.jsp”%>

<table width=”200″ border=”0″ cellspacing=”0″ cellpadding=”2″>

<tr>

<td>&nbsp;</td>

</tr>

</table>

<table width=”931″ border=”0″ cellspacing=”0″ cellpadding=”0″>

<tr>

<th width=”180″ height=”67″ align=”left” valign=”top” scope=”col”>&nbsp;</th>

<th width=”106″ scope=”col”>&nbsp;</th>

<th width=”645″ align=”left” valign=”top” scope=”col”><p>&nbsp;</p>

<table width=”618″ border=”0″ cellspacing=”0″ cellpadding=”0″>

<tr>

<th width=”618″ height=”375″ align=”left” valign=”top” scope=”col”><h2 align=”center” class=”style8″>Product Details</h2>

<%

String query=”select * from product”;

ResultSet rs = statement.executeQuery(query);

%>

<table width=”415″ border=”1″ align=”center” cellspacing=”0″ >

<tr>

<td width=”96″><strong>Product ID </strong></td>

<td width=”112″><strong>Product Name </strong></td>

<td width=”77″><strong>Description</strong></td>

<td width=”112″><strong>Price </strong></td>

<td width=”77″><strong>Unit</strong></td>

<td width=”112″><strong>Stock </strong></td>

</tr>

<%

while(rs.next())

{

%>

<tr>

<td><%=rs.getString(1)%></td>

<td><%=rs.getString(2)%></td>

<td><%=rs.getString(3)%></td>

<td><%=rs.getString(4)%></td>

<td><%=rs.getString(5)%></td>

<td><%=rs.getString(6)%></td>

 

</tr>

<%}%>

</table>

<p align=”center” class=”style8″>&nbsp;</p></th>

</tr>

</table>

<h2 align=”center” class=”style8″>&nbsp;</h2>

</th>

</tr>

</table>

<p>&nbsp;</p>

<p>&nbsp;</p>

<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p>&nbsp;</p>

 

<p>

<label></label>

</p>

<p>&nbsp;</p>

<p align=”center”>

<label></label>

</p>

</form>          <p align=”center” class=”style8″>&nbsp;</p></th>

</tr>

</table></th>

</tr>

</table>

<p>&nbsp;</p>

<p>&nbsp;</p>

<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p>

</body>

</html>

 

Feedback1.jsp

 

<%@ page contentType=”text/html; charset=iso-8859-1″ language=”java” import=”java.sql.*” errorPage=”” %>

<!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”>

<html xmlns=”http://www.w3.org/1999/xhtml”>

<head>

<meta http-equiv=”Content-Type” content=”text/html; charset=iso-8859-1″ />

<title>Resource Planning System</title>

<style type=”text/css”>

<!–

.style8 {color: #0000FF}

–>

</style>

</head>

 

<body>

<%@ include file=”connect.jsp”%>

<table width=”200″ border=”0″ cellspacing=”0″ cellpadding=”2″>

<tr>

<td><%@ include file=”header1.jsp”%>&nbsp;</td>

</tr>

</table>

<table width=”931″ border=”0″ cellspacing=”0″ cellpadding=”0″>

<tr>

<th width=”180″ height=”67″ align=”center” valign=”top” scope=”col”>&nbsp;</th>

<th width=”106″ scope=”col”>&nbsp;</th>

<th width=”645″ align=”left” valign=”top” scope=”col”><p>&nbsp;</p>

<table width=”618″ border=”0″ cellspacing=”0″ cellpadding=”0″>

<tr>

<th width=”618″ height=”375″ align=”center” valign=”top” scope=”col”><h2 align=”center” class=”style8″>Feedback Details </h2> <%

String query=”select * from feedback”;

ResultSet rs = statement.executeQuery(query);

%>

 

<table border=”1″ align=”center” cellspacing=”0″ >

<tr>

<td>NAME</td>

<td><strong>EMAIL</strong></td>

<td><strong>PHONE NO.</strong></td>

<td><strong>COMMENTS</strong></td>

 

</tr>

<%

while(rs.next())

{

%>

<tr>

<td><%=rs.getString(1)%></td>

<td><%=rs.getString(2)%></td>

<td><%=rs.getString(3)%> </td>

<td><%=rs.getString(4)%>

</tr>

<%}%>

</table>

<p align=”center” class=”style8″>&nbsp;</p></th>

</tr>

</table>

<h2 align=”center” class=”style8″>&nbsp;</h2>

</th>

</tr>

</table>

<p>&nbsp;</p>

<p>&nbsp;</p>

<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p>&nbsp;</p>

<p>

<label></label>

</p>

<p>&nbsp;</p>

<p align=”center”>

<label></label>

</p>

</form>          <p align=”center” class=”style8″>&nbsp;</p></th>

</tr>

</table></th>

</tr>

</table>

<p>&nbsp;</p>

<p>&nbsp;</p>

<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p>

 

</body>

</html>

 

CODE EFFICIENCY

 

 

OPTIMIZATION OF CODE

 

 


CHAPTER 6 LIMITATIONS AND FUTURE

APPLICATION OF THE PROJECT

 

SCOPE OF FUTURE APPLICATION

 

 

 

 

NOTE:        In a nutshell we have a lot of scope to further enhance the futures and functionalities of the proposed Solution.

Besides that, the following basic quality in the software always safeguards the future scope of the software.

Correctness:-

 

Reusability:

 

  Extensibility:

 

Robustness:

 

Understandability:

A method is understandable if anyone other than the developer of the method can understand the code (as well as the developer after a time-span).

Cost-effectiveness:

Its cost is under the budget and developed within given time period. It is always desirable to aim for a system with a minimum cost subject to the condition that it must satisfy all the requirements.

 


  1. CONCLUSION

 

 

For designing the system we have used simple data flow diagrams.

Overall the project teaches us the essential skills like:

  • Using system analysis and design techniques like data flow diagram in designing the system.
  • Understanding the database handling and query processing using My SQL .
  1. BIBLIOGRAPHY

[1] Herbert Scheldt, Java Complete Reference, Fifth Edition, Tata McGraw Hill Edition.

[2] Phil Hanna, JSP 2.0: The Complete Reference, Tata McGraw Hill Edition, 2003.

[3] Elmarsi and Navathe, Fundamentals of Database System (Third Edition), Addision Wesley.

[4] Ian Somerville, Software Engineering, Third Edition, Pearson Education.

[5] Ali Bahrami, Object-Oriented System Development, Third Edition, Tata McGraw Hill Edition.

[6] Ivan Bayross, SQL, PL/SQL programming language of Oracle, Second Edition, BPB Publication.

 

WEB REFERENCES

[1] www.google.com

[2] www.htmlcodetutorial.com