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
- Sales
- Purchaes
- 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.
- The web-site manipulates data in an accurate way.
- Accuracy of all type of calculations are important and to be achieved at any cost.
- 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.
- Storage of data should be easily accessible.
- 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.
- 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
- 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.
- 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.
- 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
- Problem of Reliability:
- Problem of Accuracy:
- Problem of timeliness:
- Problem of Validity:
- Problem of Economy:
- Problem of Capacity:
1.3 PROPOSED SYSTEM
- Details: The new proposed system stores and maintains all the online users etc.
- Calculations: The new proposed system updates tables and other information automatically and it is very fast and accurate.
- 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.
- Speed: The new proposed system is very fast with 100% accuracy and saves time.
- Manpower: The new proposed system needs less manpower. Less people can do the large work.
- Efficiency: The new proposed systems complete the work of many people in less time.
- Past details: The new proposed system contains the details of each enquiry done by visitor.
- Reduces redundancy: The most important benefit of this system is that it reduces the redundancy of data within the data.
- Work load:
- 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.
- Bubbles: –
- 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
- Each module is a well defined sub-system.
- Single, well – defined purpose of each module.
- Modules can be separately compiled and stored in a library.
- Modules can use other module.
- Modules should be easier to use than to build.
- 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:
- Administrator
- Senior Programmer
- Junior Programmers
- 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”> </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> </p>
<p> </p>
<p> </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 management information across an entire organization, embracing finance/ sales and service, customer relationship management, etc. Inventory systems automate this activity with an integrated 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 "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." <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. 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. </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”> </td>
<td width=”395″ align=”left” valign=”top”> </td>
<td width=”218″ align=”left” valign=”top”> </td>
</tr>
<tr>
<td align=”left” valign=”top”> </td>
<td colspan=”2″ align=”left” valign=”top”> </td>
</tr>
<tr>
<td align=”left” valign=”top”> </td>
<td align=”left” valign=”top”> </td>
<td align=”center” valign=”middle”> </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> </td>
<td><a href=”aboutus.jsp” class=”style2″>Create New Account </a></td>
</tr>
<tr>
<td> </td>
<td><a href=”forget password.jsp” class=”style2″></a></td>
</tr>
</table></td>
</tr>
</table> <p> </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”> </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”> </td>
<td align=”left” valign=”top”> </td>
<td align=”left” valign=”top”> </td>
</tr>
<tr>
<td width=”59″ align=”left” valign=”top”> </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”> </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”> </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”> </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”> </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”> </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”> </td>
<td align=”left” valign=”top”> </td>
<td align=”center” valign=”middle”><input type=”submit” name=”Submit” value=”Submit”></td>
</tr>
<tr>
<td align=”left” valign=”top”> </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”> </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> </p>
<p> </p>
<p> </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’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>
- Accuracy of all type of calculations are important and to be achieved at any cost.<br>
- 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>
- Storage of data should be easily accessible.<br>
- 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>
- The product should fulfill user’s requirement.</p>
<strong><u><br clear=”all”>
</u></strong></td>
</tr>
<tr>
<td width=”4″ align=”left” valign=”top”> </td>
<td width=”395″ align=”left” valign=”top”> </td>
<td width=”218″ align=”left” valign=”top”> </td>
</tr>
<tr>
<td align=”left” valign=”top”> </td>
<td colspan=”2″ align=”left” valign=”top”> </td>
</tr>
<tr>
<td align=”left” valign=”top”> </td>
<td align=”left” valign=”top”> </td>
<td align=”center” valign=”middle”> </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> </td>
<td><a href=”aboutus.jsp” class=”style2″>Create New Account </a></td>
</tr>
<tr>
<td> </td>
<td><a href=”forget password.jsp” class=”style2″></a></td>
</tr>
</table></td>
</tr>
</table> <p> </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”> </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> </p>
<p> </p>
<p> </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)
{
}
%>
</td>
<td align=”left” valign=”top” bgcolor=”#FFFFFF”> </td>
<td colspan=”2″ align=”left” valign=”top” bgcolor=”#FFFFFF”> </td>
</tr>
<tr>
<td align=”left” valign=”top”> </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”> </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”> </td>
<td width=”109″ align=”left” valign=”top”><p> </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”> </td>
<td colspan=”2″ align=”left” valign=”top”><p> </p>
<p>Get connected to incredible excess inventory deals from the world most trusted brands. </p></td>
</tr>
<tr>
<td align=”left” valign=”top”> </td>
<td align=”left” valign=”top”> </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”> </td>
<td width=”110″ align=”center” valign=”middle”> </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”> </td>
<td align=”left” valign=”top”> </td>
<td align=”center” valign=”middle”><label></label></td>
<td align=”center” valign=”middle”> </td>
<td align=”center” valign=”middle”> </td>
<td align=”center” valign=”middle”> </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”> </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> </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”> </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″> </h2>
<h2 align=”center” class=”style14″>Login</h2>
<label> User name
<input type=”text” name=”textfield”>
</label>
<p>
<label> <br> Password
<input type=”password” name=”textfield2″>
</label>
</p>
<p> </p>
<label>
<input type=”submit” name=”Submit” value=”Submit”>
</label>
<p align=”center” class=”style14″> </p></td>
</tr>
</table>
<h1 class=”style8″> </h1>
<p> </p>
<h1> </h1> <p class=”style7″ __designer:dtid=”281479271677962″> </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”> </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> </p>
<p>Administrator Menu </p>
<p> </p>
</div></td>
</tr>
<tr>
<td width=”285″><p align=”center” class=”style15″> </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> </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”> </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> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
</table>
</form>
<h1 class=”style8″> </h1>
<p> </p>
<h1> </h1> <p class=”style7″ __designer:dtid=”281479271677962″> </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”> </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″> </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> </td>
</tr>
<tr>
<td><strong>Product Name </strong></td>
<td><input name=”textfield2″ type=”text” id=”textfield2″></td>
<td> </td>
</tr>
<tr>
<td><strong>Product Description</strong> </td>
<td><input name=”textfield3″ type=”text” id=”textfield3″></td>
<td> </td>
</tr>
<tr>
<td><strong>Price</strong></td>
<td><input name=”textfield4″ type=”text” id=”textfield4″></td>
<td> </td>
</tr>
<tr>
<td><strong>Unit</strong></td>
<td><input name=”textfield5″ type=”text” id=”textfield5″></td>
<td> </td>
</tr>
<tr>
<td><strong>Stock</strong></td>
<td><input name=”textfield6″ type=”text” id=”textfield6″></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td><input type=”submit” name=”Submit” value=”Submit”></td>
<td> </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”> </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″> </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> </td>
</tr>
<tr>
<td><strong>Branch Name </strong></td>
<td><input name=”textfield2″ type=”text” id=”textfield2″></td>
<td> </td>
</tr>
<tr>
<td><strong>Performance</strong></td>
<td><input name=”textfield3″ type=”text” id=”textfield3″></td>
<td> </td>
</tr>
<tr>
<td><strong>Address</strong></td>
<td><input name=”textfield4″ type=”text” id=”textfield4″></td>
<td> </td>
</tr>
<tr>
<td><strong>Phone</strong></td>
<td><input name=”textfield5″ type=”text” id=”textfield5″></td>
<td> </td>
</tr>
<tr>
<td><strong>Fax</strong></td>
<td><input name=”textfield6″ type=”text” id=”textfield6″></td>
<td> </td>
</tr>
<tr>
<td><strong>Email</strong></td>
<td><input name=”textfield7″ type=”text” id=”textfield7″></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td><input type=”submit” name=”Submit” value=”Submit”></td>
<td> </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”> </td>
<td width=”750″ align=”center” valign=”top”><p> </p>
<table width=”380″ border=”0″>
<tr>
<td height=”32″ colspan=”2″><strong>Add Target Details </strong></td>
<td width=”85″> </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> </td>
</tr>
<tr>
<td><strong>Product Sale </strong></td>
<td><input type=”text” name=”textfield”></td>
<td> </td>
</tr>
<tr>
<td><strong>Return</strong></td>
<td><input name=”textfield2″ type=”text” id=”textfield2″></td>
<td> </td>
</tr>
<tr>
<td><strong>Damage</strong></td>
<td><input name=”textfield4″ type=”text” id=”textfield4″></td>
<td> </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> </td>
</tr>
<tr>
<td><strong>Date of Sales</strong> </td>
<td><input name=”textfield5″ type=”text” id=”textfield5″></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td><input type=”submit” name=”Submit” value=”Submit”></td>
<td> </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> </td>
</tr>
</table>
<table width=”931″ border=”0″ cellspacing=”0″ cellpadding=”0″>
<tr>
<th width=”180″ height=”67″ align=”left” valign=”top” scope=”col”> </th>
<th width=”106″ scope=”col”> </th>
<th width=”645″ align=”left” valign=”top” scope=”col”><p> </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″> </p></th>
</tr>
</table>
<h2 align=”center” class=”style8″> </h2>
</th>
</tr>
</table>
<p> </p>
<p> </p>
<p> </p> </p>
<p>
<label></label>
</p>
<p> </p>
<p align=”center”>
<label></label>
</p>
</form> <p align=”center” class=”style8″> </p></th>
</tr>
</table></th>
</tr>
</table>
<p> </p>
<p> </p>
<p> </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> </td>
</tr>
</table>
<table width=”931″ border=”0″ cellspacing=”0″ cellpadding=”0″>
<tr>
<th width=”180″ height=”67″ align=”left” valign=”top” scope=”col”> </th>
<th width=”106″ scope=”col”> </th>
<th width=”645″ align=”left” valign=”top” scope=”col”><p> </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″> </p></th>
</tr>
</table>
<h2 align=”center” class=”style8″> </h2>
</th>
</tr>
</table>
<p> </p>
<p> </p>
<p> </p> </p>
<p>
<label></label>
</p>
<p> </p>
<p align=”center”>
<label></label>
</p>
</form> <p align=”center” class=”style8″> </p></th>
</tr>
</table></th>
</tr>
</table>
<p> </p>
<p> </p>
<p> </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> </td>
</tr>
</table>
<table width=”931″ border=”0″ cellspacing=”0″ cellpadding=”0″>
<tr>
<th width=”180″ height=”67″ align=”left” valign=”top” scope=”col”> </th>
<th width=”106″ scope=”col”> </th>
<th width=”645″ align=”left” valign=”top” scope=”col”><p> </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″> </p></th>
</tr>
</table>
<h2 align=”center” class=”style8″> </h2>
</th>
</tr>
</table>
<p> </p>
<p> </p>
<p> </p> </p>
<p>
<label></label>
</p>
<p> </p>
<p align=”center”>
<label></label>
</p>
</form> <p align=”center” class=”style8″> </p></th>
</tr>
</table></th>
</tr>
</table>
<p> </p>
<p> </p>
<p> </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> </td>
</tr>
</table>
<table width=”931″ border=”0″ cellspacing=”0″ cellpadding=”0″>
<tr>
<th width=”180″ height=”67″ align=”left” valign=”top” scope=”col”> </th>
<th width=”106″ scope=”col”> </th>
<th width=”645″ align=”left” valign=”top” scope=”col”><p> </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″> </p></th>
</tr>
</table>
<h2 align=”center” class=”style8″> </h2>
</th>
</tr>
</table>
<p> </p>
<p> </p>
<p> </p> </p>
<p>
<label></label>
</p>
<p> </p>
<p align=”center”>
<label></label>
</p>
</form> <p align=”center” class=”style8″> </p></th>
</tr>
</table></th>
</tr>
</table>
<p> </p>
<p> </p>
<p> </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> </td>
</tr>
</table>
<table width=”931″ border=”0″ cellspacing=”0″ cellpadding=”0″>
<tr>
<th width=”180″ height=”67″ align=”left” valign=”top” scope=”col”> </th>
<th width=”106″ scope=”col”> </th>
<th width=”645″ align=”left” valign=”top” scope=”col”><p> </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″> </p></th>
</tr>
</table>
<h2 align=”center” class=”style8″> </h2>
</th>
</tr>
</table>
<p> </p>
<p> </p>
<p> </p> </p>
<p>
<label></label>
</p>
<p> </p>
<p align=”center”>
<label></label>
</p>
</form> <p align=”center” class=”style8″> </p></th>
</tr>
</table></th>
</tr>
</table>
<p> </p>
<p> </p>
<p> </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”%> </td>
</tr>
</table>
<table width=”931″ border=”0″ cellspacing=”0″ cellpadding=”0″>
<tr>
<th width=”180″ height=”67″ align=”center” valign=”top” scope=”col”> </th>
<th width=”106″ scope=”col”> </th>
<th width=”645″ align=”left” valign=”top” scope=”col”><p> </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″> </p></th>
</tr>
</table>
<h2 align=”center” class=”style8″> </h2>
</th>
</tr>
</table>
<p> </p>
<p> </p>
<p> </p> </p>
<p>
<label></label>
</p>
<p> </p>
<p align=”center”>
<label></label>
</p>
</form> <p align=”center” class=”style8″> </p></th>
</tr>
</table></th>
</tr>
</table>
<p> </p>
<p> </p>
<p> </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.
- 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 .
- 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