Site Loader

CHAPTER-1
INTRODUCTION
1.1 INTRODUCTION TO THE ORGANIZATION
We will help to generate knowledge and processes to develop software systems that will help to solve client’s problems and to assist all our clients in transferring their IT services replacing cost with value. We will help to develop tools, techniques and systems to help you meet and fulfill client requirements.

1.2 INTRODUCTION TO THE PROJECT
Title of the project: – ONLINE VEGETABLE STORE
Objective: -. The main aim of this project Online Vegetable Store was to sell vegetable online through internet. Customer can give order from one lace and pay cash on delivery. Tis project can also manage the details of order vegetable by customer and payments made by them.
DESCRIPTION OF THE PROJECT:
It tracks all the information of to sell vegetable online order etc.

We Will Write a Custom Essay Specifically
For You For Only $13.90/page!


order now

We Will Write a Custom Essay Specifically
For You For Only $13.90/page!


order now

Manage the information and description of the store..Integration of all records of online vegetable.

CHAPTER-2
CONCEPT/LITERATURE STUDY
PROJECT CONCEPT
The required software and hardware are easily available and easy to work with.

It can assist the user to concentrate on their other activities rather to concentrate on the record keeping. That means that one need not be distracted by information that is not relevant, while being able to reach information.

Basically the project describes how to manage for good performance and better services for the clients.
CHAPTER-3
ENVIRONMENT
3.1 HARDWARE
The following sub-sections define the various aspects of hardware requirements.

3.1.1 Processor
The power of Center Processing Unit (CPU) is fundamental system requirement for any software. Intel Core i3 processor used in the project.

3.1.2 Monitor
A screen that displays peripheral output to the user. A 15” inch color display used.

3.1.3 Hard Disk
Hard Disk is used to store information.500 GB hard disk drive used in the system.

3.2 SOFTWARE
The following sub sections define the various aspects of software requirements.

3.2.1 Operating system
The most common version of Microsoft Windows i.e. Windows 10 is used.

3.2.2 Package
Primary Goals:
There are 3 primary goals to design java language:
It should use object oriented programming methodology.

It should allow the same programs to be executed in multiple systems.

It contains support for computer networks..3.2.3 Database
Build database structures, backup data, inspect status, and work with data records. The official set of MYSQL back-ends tools,
MySQL is easy to learn and it makes the creation ; maintenance of RDBMS as a very short time process.

Data: A collection of facts in row from that becomes information after proper organization or processing.

Field
File
Record
Database: A simple definition would be “The database is an organized collection of related information.” For Example- Telephone directory, Dictionary. In multiuser RDBMS the database can be organized in two ways:
Centralized Database
A database is a collection of stored data used by the application system of some particular organization.

Distributed Database
Across a network of computer that are geographically dispersed and connected via communication links (LAN, WAN).

CHAPTER-4
MANUAL SYSTEM / EARLIER SYSTEM
In the existing system the exams are done only manually but in proposed system
We have some complications the exams using this application
Lack of security of data.

More man power time consuming.

Consumes large volume of paper work.

CHAPTER-5
CURRENT SYSTEM
The System provides proper security and reduces the manual work..
Minimum time needed for the various processing.

Greater Efficiency.

Better Service.

User friendliness and interactive.

Minimum time required.

CHAPTER-6
SYSTEM DEVELOPMENTS
6.1 THE SYSTEM PLANNING
System Planning is the road map for successful project development. The software development process begins with the set of activities that are collectively called as System Planning.

NOTATION:-
The following are the simple notations of a PERT diagram used.

TASK:-
Allows you to define the arrangement of fields and formatting of these fields for the text boxes in the pert chart.DEPENDENCY:-
A dependency is a relationship between tasks. A dependency says that one task must follow another task in some way.

CRITICAL TASK:-
The critical path is a schedule calculation that determines the longest path to the end of a project or the end of a set of task. PERT chart expert can calculate the critical path in two ways.

NON-CRITICAL TASK:-
Allows you to define the arrangement of fields and the formatting of these fields for the text boxes in the PERT chart.

BENEFIT OF PERT PLANNING PROCESS:
The acts that have stack time and that can lend resources to critical path activities.

Activity starts and end dates.

Documentation
24 Days
31st May
8th May
13 Days
7th May
25th April
25 Days
24th April
31st Mar
18 Days
30th Mar
13th Mar
16 Days
12th Mar
28th Feb
10 Days
28th Feb
18th Feb

6.2 THE SYSTEM DESIGN
To develop any system we use phase of system design:-
LOGICAL DESIGN:-
System define involves first logical design then physical design of the system.
PHYSICAL DESIGN:-
Physical construction is the activity that follows the logical design. Design specification instructs programmers about what the system can do. Those accepts input from users process data, produces the reports ; store data in file physical design takes out the details of physical system, plan the system ; specifies new hardware ; software.

System design has the following components:-
SCOPE ; BOUNDARIES
In this we give brief introduction if what will the system will ; will not try to do.

SPECIFIC REQUIREMENTS
In this we give the list of outputs, data files ; inputs necessary for the system.

TANGIBLE BENEFITS
Reduction in direct operating expenses anticipated from new system.

INTANGIBLE BENEFITS
Other anticipated benefits of the new system as the improved information.

COST ; BENEFITS ANALYSIS
Comparison of the cost verses the benefits of the proposed system.

This package has been prepared with the help of following forms:-
Home Page
Login Page
Registration Page
Feedback Form
About Us
Contact Us
6.3 THE PROGRAM FILES
ADMIN HOME.jsp
;%@page contentType=”text/html” pageEncoding=”UTF-8″%;
;%@page import=”java.sql.*;” %;
;!DOCTYPE html;;html; ;head;
;meta http-equiv=”Content-Type” content=”text/html; charset=UTF-8″;
;title;Admin Home Page;/title;
;link rel=”stylesheet” type=”text/css” /; ;/head;
;body; ;center;
;div id=”discontent> <div id=”divheader” > <%@include file=”myheader.jsp” %> </div>
<div id=”divbody” ><div id=”divbleft” >
<% String username=””;
String pwd=””;
String secquest=””;
String secans=””;
String email=””;
out.println(“Error is “+sk.getMessage().toString());
} }%> <form id=”frm” name=”frm” action=”” method=”post” ><table><tr>
<td>User Name :</td>
<td><input type=”text” id=”tuser” name=”tuser” value=”;%=username %;” required/></td></tr><tr>
<td>Password :</td>
<td><input type=”Password” id=”tpwd” name=”tpwd” value=”;%=pwd %;” required/></td></tr><tr>
<td>Email :</td>
<td><input type=”text” id=”temail” name=”temail” value=”;%=email %;” required/></td></tr><tr>
<td>Security Question :</td>
<td><input type=”text” id=”tsec_qeust” name=”tsec_quest” value=”;%=secquest %;” required/></td></tr><tr>
<td>Security Answer :</td>
<td><input type=”text” id=”tsec_ans” name=”tsec_ans” value=”;%=secans %;” required/></td></tr><tr>
<td colspan=”2″ ><input type=”submit” id=”sub” name=”sub” value=”Update” /> </td></tr></table></form><%
if(request.getParameter(“sub”)!=null)
{String tusername=request.getParameter(“tuser”).toString();
String tpwd=request.getParameter(“tpwd”).toString();
String temail=request.getParameter(“tsec_quest”).toString();
String tsecqeust=request.getParameter(“tsec_ans”).toString();
String tsecans=request.getParameter(“temail”).toString();
try{String qry=”update logininfo set username='”+tusername+”‘,pwd='”+tpwd+”‘,email='”+temail+”‘,sec_quest='”+tsecqeust+”‘,sec_ans='”+tsecans+”‘ where logid='”+session.getAttribute(“userid”).toString()+”‘”;Class.forName(“com.mysql.jdbc.Driver”); Connectioncon=DriverManager.getConnection(“jdbc:mysql://localhost/foodzone_db”,”root”,””); Statement st=con.createStatement();
if(st.executeUpdate(qry)==1)
}out.println(“Record Updated success”);}
else }out.println(“Record is not updated”);
}}catch(Exception sk)
} out.println(“Error in Code “+sk.getMessage())} } %></div>
<div id=”divbright” > <h1>Welcome to Admin Home Panel</h1> <br /><br />
<img src=”image/images.jpg” height=”300px” width=”400px” />
<h2>We are Manage all the Food for Website and Order of Food from Customers</h2> </div> </div><div id=”divfooter” > <%@include file=”myfooter.jsp” %> </div</div> </center></body></html>
LOGIN INFO.jsp
<%@page contentType=”text/html” pageEncoding=”UTF-8″%>
<%@page import=”java.sql.*;” %>
<!DOCTYPE html><html> <head>
<meta http-equiv=”Content-Type” content=”text/html; charset=UTF-8″>
<title>Member Login Page</title> </head> <body> <center>
<input type=”submit” id=”sub” name=”sub” value=”Login Now” style=”background-color: #000000;color: #cccccc;width:120px;height:30px;” /> <input type=”submit” id=”sub1″ name=”sub1″ value=”Back to Home” style=”background-color: #000000;color: #cccccc;width:120px;height:30px;” /> </td> </tr> </table></form><br/><br/> <%
if(request.getParameter(“sub”)!=null)
{String user=request.getParameter(“tuser”);
String pwd=request.getParameter(“tpwd”);
String qry=”select *from logininfo where username='”+user+”‘ and pwd='”+pwd+”‘”;try{Class.forName(“com.mysql.jdbc.Driver”);Connectioncon=DriverManager.getConnection(“jdbc:mysql://localhost/foodzone_db”,”root”,””);
Statementst=con.createStatement();ResultSetrs=st.executeQuery(qry);
if(rs.next()){{session.setAttribute(“userid”,rs.getString(“logid”).toString();session.setAttribute(“username”, rs.getString(“username”).toString());
response.sendRedirect(“adminhome.jsp”); } else{ out.println(“Login Fail Again Login”); } }catch(Exception sk){ out.println(“Error in Login : Error is “+sk.getMessage());} } %></div></center></body></html>
ABOUT US.jsp
<%@page contentType=”text/html” pageEncoding=”UTF-8″%>
<!DOCTYPE html><html><head>
<meta http-equiv=”Content-Type” content=”text/html; charset=UTF-8″>
<title>Vegetable Store Website Page</title>
<link rel=”stylesheet” type=”text/css” href=”indexcss.css” /><style type=”text/css” ></style></head><body><center><div id=”contentdiv” >
<%@include file=”indexheader.jsp” %><div id=”bodydiv” ><!– bodydiv open here –><div id=”leftdiv” ><%@include file=”indexsidebar.jsp” %>
</div><div id=”rightdiv” ><center>
ADD TO BASKET INFO.jsp
<%@page import=”java.sql.*;” %>
<%String itemname=””;
float price=0;
float discount=0;
float tax=0;
float del_charge=0;
float total_amt=0;
String itemid=request.getParameter(“itemid”).toString();
float qty= Float.parseFloat(request.getParameter(“qty”).toString());
float final_amt=0; try{String qry=”select * from iteminfo where itemid='”+itemid+”‘”;
Class.forName(“com.mysql.jdbc.Driver”);
if(rs.next()){ itemname=rs.getString(“itemname”);
price=Float.parseFloat(rs.getString(“itemprice”).toString());
discount=Float.parseFloat(rs.getString(“itemdiscount”).toString());
tax=Float.parseFloat(rs.getString(“itemtax”).toString());
del_charge=Float.parseFloat(rs.getString(“del_charge”).toString());
total_amt=(price+tax+del_charge)-discount;
qty= Float.parseFloat(request.getParameter(“qty”).toString());
final_amt=total_amt*qty;
Stringqry123=”insertintobusketinfo(itemname,price,discount,tax,del_charge,qty,total_amt)values (‘”+itemname+”‘,'”+price+”‘,'”+discount+”‘,'”+tax+”‘,'”+del_charge+”‘,'”+qty+”‘,'”+final_amt+”‘)”;if(st.executeUpdate(qry123)==1){ out.println(“Item Added Successful”);}else { out.println(“Item have error”) }
}}catch(Exceptionsk){out.println(“Item have error Error is “+sk.getMessage().toString()); }response.sendRedirect(“busketsuccessinfo.jsp”);%>
ADMIN CATEGORY.jsp
<%@page contentType=”text/html” pageEncoding=”UTF-8″%>
<%@page import=”java.sql.*;” %>
<!DOCTYPE html><html><head>
<meta http-equiv=”Content-Type” content=”text/html; charset=UTF-8″>
<title>Admin Home Page</title>
<link rel=”stylesheet” type=”text/css” /></head><body><center><div id=”divcontent” ><div id=”divheader”> <%@include file=”myheader.jsp” %> </div> <div id=”divbody” >
String tremark=request.getParameter(“tremark”).toString();
try{String qry=”Insert into category (catname,catremark) values (‘”+tcatname+”‘,'”+tremark+”‘)”;
Class.forName(“com.mysql.jdbc.Driver”);
Connectioncon=DriverManager.getConnection(“jdbc:mysql://localhost/foodzone_db”,”root”,””);
Statement st=con.createStatement(); if(st.executeUpdate(qry)==1){
out.println(“Category Added successful”); }else{
out.println(“Record is not Added”); }}catch(Exception sk){
out.println(“Error in Code “+sk.getMessage());}} %></div>
<div id=”divbright” ><h1>Category Setup Panel</h1>
<form id=”frm123″ name=”frm123″ action=”” method=”post” >
Search : <input type=”text” id=”tsearch” name=”tsearch” />
<input type=”submit” id=”searchbtn” name=”searchbtn” value=”Search”/></form> <% String search=””;
if(request.getParameter(“searchbtn”)!=null){
search=request.getParameter(“tsearch”).toString(); }
try{ String qry=”select *from category where catname like ‘”+search+”%’ order by catname”; Class.forName(“com.mysql.jdbc.Driver”);
Connectioncon=DriverManager.getConnection(“jdbc:mysql://localhost/foodzone_db”,”root”,””);
Statement st=con.createStatement();ResultSet rs=st.executeQuery(qry);
ResultSetMetaData rst=rs.getMetaData();
int count=rst.getColumnCount();out.print(“;table border=’1′ ;”);
out.print(“;tr style=’background-color:#000000;color:#ffffff;font-size:20px;’ ;”);
out.print(“;th;Category Id;/th;”);out.print(“;th;Category Name;/th;”);
out.print(“;th;Remark;/th;”); out.print(“;th;More Details;/th;”); out.print(“;/tr;”);while(rs.next()){ out.print(“;tr;”);
for(int p=1;p<=count;p++){
out.print(“;td;”+rs.getString(p).toString()+”;/td;”) }out.print(“;td;;a href=’admin_categoryupdate.jsp?catid=”+rs.getString(1).toString()+”‘ ;More Details;/a;;/td; out.print(“</tr>”);}out.print(“</table>”); }catch(Exception sk) {out.println(“Error is “+sk.getMessage().toString());
}%; ;/div;;/div;;div id=”divfooter” ; ;%@include file=”myfooter.jsp” %;;/div; ;/div;;/center;;/body;;/html;
ADMIN CATEGORY UPDATE.jsp
;%@page contentType=”text/html” pageEncoding=”UTF-8″%;
;%@page import=”java.sql.*;” %;
;!DOCTYPE html;;html;;head;
;meta http-equiv=”Content-Type” content=”text/html; charset=UTF-8″; ;title;Admin Home Page;/title;;link rel=”stylesheet” type=”text/css” /;;/head;;body;;center;;div id=”divcontent” ;;div id=”divheadeer”;;%@include file=”myheader.jsp” %;
;/div;;div id=”divbody” ; ;div id=”divbleft” ;;br;
;form id=”frm” name=”frm” action=”” method=”post” ;;table;
;tr;;td;Enter Category ;/td;;td;;input type=”text” id=”tcatname” name=”tcatname” value=”<%=catname %>” required/; ;/td;;/tr;;tr;
;td;Remark ;/td;;td;;input type=”text” id=”tremark” name=”tremark” value=”<%=catremark %>” required/; ;/td;;/tr; ;tr;;td colspan=”2″ ;
;input type=”submit” id=”sub” name=”sub” value=”Update” /;
;input type=”submit” id=”sub1″ name=”sub1″ value=”Delete” /; ;/td;;/tr; ;/table;;/form; ;%if(request.getParameter(“sub”)!=null)) {
String tcatname=request.getParameter(“tcatname”).toString();
String tremark=request.getParameter(“tremark”).toString();
try{Stringqry=”updatecategorysetcatname='”+tcatname+”‘,catremark='”+tremark+”‘ where catid='”+catid+”‘”;
Class.forName(“com.mysql.jdbc.Driver”);
Connectioncon=DriverManager.getConnection(“jdbc:mysql://localhost/foodzone_db”,”root”,””); Statement st=con.createStatement();
if(st.executeUpdate(qry)==1){
out.println(“Category Updated successful”);
response.sendRedirect(“admin_category.jsp”);}else{out.println(“Record is not Added”);}con.close();}catch(Exception sk){ out.println(“Error in Code “+sk.getMessage());}} if(request.getParameter(“sub1″)!=null){try{
String qry=”delete from category where catid='”+catid+”‘”; Class.forName(“com.mysql.jdbc.Driver”);
Connectioncon=DriverManager.getConnection(“jdbc:mysql://localhost/foodzone_db”,”root”,””);Statement st=con.createStatement();
if(st.executeUpdate(qry)==1){out.println(“Category Deleted Successful”);
response.sendRedirect(“admin_category.jsp”);}else{
out.println(“Record is not Deleted”);}con.close();}catch(Exception sk)
{ out.println(“Error in Code “+sk.getMessage())}} %; ;/div;
;div id=”divbright” ; ;/div;;/div;;div id=”divfooter” ;
;%@include file=”myfooter.jsp” %;;/div; ;/div;;/center;;/body;;/html;
ADMIN FEEDBACK LIST.jsp
;%@page contentType=”text/html” pageEncoding=”UTF-8″%;
;%@page import=”java.sql.*;” %;
;!DOCTYPE html;;html;;head;
;meta http-equiv=”Content-Type” content=”text/html; charset=UTF-8″; ;title;Admin Home Page;/title;
;link rel=”stylesheet” type=”text/css” /;;/head; ;body;;center;;div id=”divcontent” ;;div id=”divheader” ;
;%@include file=”myheader.jsp” %;;/div;;div id=”divbody”;;div id=”divbright” style=”width:99%;”
ResultSetMetaData rst=rs.getMetaData();
int count=rst.getColumnCount();out.print(“<table border=’1′ >”);
out.print(“<tr style=’background-color:#000000;color:#ffffff;font-size:20px;’ >”);out.print(“<th>Query Id</th>”);out.print(“<th>Query Date</th>”);
out.print(“<th>Query Person Name</th>”);out.print(“<th>Mobile </th>”);
out.print(“<th>Email </th>”);out.print(“<th>Subject </th>”);
out.print(“<th>Message </th>”);out.print(“<th>More Details</th>”);
out.print(“</tr>”); while(rs.next()){ out.print(“<tr>”);
out.print(“<td>”+rs.getString(“queryid”).toString()+”</td>”);
out.print(“<td>”+rs.getString(“querydate”).toString()+”</td>”);
out.print(“<td>”+rs.getString(“queryperson”).toString()+”</td>”);
out.print(“<td>”+rs.getString(“mobile”).toString()+”</td>”);
out.print(“<td>”+rs.getString(“email”).toString()+”</td>”);
out.print(“<td>”+rs.getString(“subject”).toString()+”</td>”);
out.print(“<td>”+rs.getString(“message”).toString()+”</td>”);
out.print(“<td><a href=” >More Details</a></td>”);
out.print(“</tr>”)} out.print(“</table>”);}catch(Exception sk){
out.println(“Error is “+sk.getMessage().toString());}%;;/div;
;/div;;div id=”divfooter” ;;%@include file=”myfooter.jsp” %;
;/div;;/div;;/center;;/body;;/html;
ADMIN ITEM.jsp
;%@page contentType=”text/html” pageEncoding=”UTF-8″%;
;%@page import=”java.sql.*;” %;
;!DOCTYPE html;;html;;head;
;meta http-equiv=”Content-Type” content=”text/html; charset=UTF-8″;
;title;Admin Home Page;/title;
;link rel=”stylesheet” type=”text/css” /;;/head; ;body;;center;;div id=”divcontent” ;;div id=”divheader” ;
;%@include file=”myheader.jsp” %;;/div;;div id=”divbody” ;
;div id=”divbleft”;;br;
out.println(“Error in Code “+sk.getMessage());}%;;/select;;/td;;/tr;;tr;
;td;Item Name ;/td;;td;;input type=”text” id=”tname” name=”tname” required/; ;/td;;/tr;;tr;;td;Item Details ;/td;
;td;;textarea id=”tdetails” name=”tdetails” rows=”3″ cols=”35″ reqired;;/textarea;;/td;;/tr;;tr;;td;Item Price ;/td;
;td;;input type=”text” id=”tprice” name=”tprice” required/; ;/td;;/tr;;tr;
;td;Item Discount ;/td;
;td;;input type=”text” id=”tdiscount” name=”tdiscount” required/; ;/td;;/tr;
;tr;;td;Any Taxes ;/td;
;td;;input type=”text” id=”ttax” name=”ttax” required/; ;/td;;/tr;;tr;
;td;Delivery Charge ;/td;
;td;;input type=”text” id=”tdelcharge” name=”tdelcharge” required/; ;/td;;/tr;
;tr;;td colspan=”2″ ;
;input type=”submit” id=”btnadd” name=”btnadd” value=”Add Item” /; ;/td;;/tr;;/table;;/form;;%if(request.getParameter(“btnadd”)!=null){
String tcatname=request.getParameter(“tcatname”).toString();
String titemname=request.getParameter(“tname”).toString();
String tdetail=request.getParameter(“tdetails”).toString();
String tprice=request.getParameter(“tprice”).toString();
String tdiscount=request.getParameter(“tdiscount”).toString();
String ttax=request.getParameter(“ttax”).toString();
String tdelcharge=request.getParameter(“tdelcharge”).toString();
String tpath=”items/defaultitem.jpg”;try{String qry=”insert into iteminfo (catid,itemname,itemdetail,itemprice,itemdiscount,itemtax,del_charge,itemphoto) values(‘”+tcatname+”‘,'”+titemname+”‘,'”+tdetail+”‘,'”+tprice+”‘,'”+tdiscount+”‘,'”+ttax+”‘,'”+tdelcharge+”‘,'”+tpath+”‘)”;Class.forName(“com.mysql.jdbc.Driver”);
Connectioncon=DriverManager.getConnection(“jdbc:mysql://localhost/foodzone_db”,”root”,””);Statement st=con.createStatement();
if(st.executeUpdate(qry)==1){out.println(“Item Information Added successful”);
qry=”select max(itemid) from iteminfo”;
ResultSet rs1=st.executeQuery(qry);if(rs1.next()){
session.setAttribute(“itemid”, rs1.getString(1));
response.sendRedirect(“admin_itemphoto.jsp”);}}else{
out.println(“Record is not Added”);}}catch(Exception sk){
out.println(“Error in Code “+sk.getMessage());}}%;;/div; ;div id=”divbright” ;
;h1;Item List Panel;/h1;;form id=”frm123″ name=”frm123″ action=”” method=”post” ;Search : ;input type=”text” id=”tsearch” name=”tsearch” /;
;input type=”submit” id=”searchbtn” name=”searchbtn” value=”Search” /;
;/form;;% String search=””;if(request.getParameter(“searchbtn”)!=null){
search=request.getParameter(“tsearch”).toString();}try{
Stringqry=”selectitemid,itemname,catname,itemdetail,itemprice,itemdiscount,itemtax,del_charge from iteminfo inner join category on category.catid=iteminfo.catid where catname like ‘”+search+”%’ order by itemid desc”;
Class.forName(“com.mysql.jdbc.Driver”);
Connectioncon=DriverManager.getConnection(“jdbc:mysql://localhost/foodzone_db”,”root”,””); Statement st=con.createStatement();
ResultSet rs=st.executeQuery(qry);
ResultSetMetaData rst=rs.getMetaData();int count=rst.getColumnCount();
out.print(“<table border=’1′ >”);
out.print(“<tr style=’background-color:#000000;color:#ffffff;font-size:20px;’ >”); out.print(“<th>Item Id</th>”);out.print(“<th>Item Name</th>”);
out.print(“<th>Category Name</th>”); out.print(“<th>Item Details</th>”);
out.print(“<th>Price</th>”); out.print(“<th>Discount</th>”);
out.print(“<th>Tax</th>”);out.print(“<th>Delivery Charge</th>”);
out.print(“<th>More Details</th>”);out.print(“</tr>”); while(rs.next()){
out.print(“<tr>”);for(int p=1;p;=count;p++){
out.print(“<td>”+rs.getString(p).toString()+”</td>”);}out.print(“<td><a href=’admin_itemupdate.jsp?itemid=”+rs.getString(1).toString()+”‘>More Details</a></td>”);out.print(“</tr>”);}out.print(“</table>”);}catch(Exception sk){
out.println(“Error is “+sk.getMessage().toString());}%;;/div;;/div;;div id=”divfooter”;;%@includefile=”myfooter.jsp”%;;/div;;/div;;/center;;/body;;/html;
ADMIN ITEM PHOTO.jsp
;%@page contentType=”text/html” pageEncoding=”UTF-8″%;
;%@page import=”java.sql.*;” %;
;!DOCTYPE html;;html;;head;
;meta http-equiv=”Content-Type” content=”text/html; charset=UTF-8″;
;title;Admin Home Page;/title;
;link rel=”stylesheet” type=”text/css” /;;/head;
;body;;center;;div id=”divcontent” ;;div id=”divheader” ;
;%@include file=”myheader.jsp” %;;/div;;div id=”divbody” ;
;div id=”divbleft” ;;br;
{String tcatname=request.getParameter(“tcatname”).toString();
String titemname=request.getParameter(“tname”).toString();
String tdetail=request.getParameter(“tdetails”).toString();
String tprice=request.getParameter(“tprice”).toString();
String tdiscount=request.getParameter(“tdiscount”).toString();
String ttax=request.getParameter(“ttax”).toString();
String tdelcharge=request.getParameter(“tdelcharge”).toString();
String tpath=”items/defaultitem.jpg”; try{Stringqry=”insertintoiteminfo(catid,itemname,itemdetail,itemprice,itemdiscount,itemtax,del_charge,itemphoto)values(‘”+tcatname+”‘,'”+titemname+”‘,'”+tdetail+”‘,'”+tprice+”‘,'”+tdiscount+”‘,'”+ttax+”‘,'”+tdelcharge+”‘,'”+tpath+”‘)”; Class.forName(“com.mysql.jdbc.Driver”);
Connectioncon=DriverManager.getConnection(“jdbc:mysql://localhost/foodzone_db”,”root”,””);Statement st=con.createStatement();
if(st.executeUpdate(qry)==1){ out.println(“Item Information Added successful”);
qry=”select max(itemid) from iteminfo”;
ResultSet rs1=st.executeQuery(qry);if(rs1.next()){
session.setAttribute(“itemid”, rs1.getString(0));
response.sendRedirect(“admin_itemphoto.jsp”);}}else{
out.println(“Record is not Added”);}}catch(Exception sk){
out.println(“Error in Code “+sk.getMessage());}}*/ %;;/div;
;div id=”divbright” ; ;h1;;a href=”admin_item.jsp” ;Back to Item Setup Panel;/a;;/h1;;/div;;/div;
;div id=”divfooter” ;;%@include file=”myfooter.jsp” %;;/div;;/div;;/center;
ADMIN ITEM UPDATE.jsp
;%@page contentType=”text/html” pageEncoding=”UTF-8″%;
;%@page import=”java.sql.*;” %;
;!DOCTYPE html;;html;;head;
;meta http-equiv=”Content-Type” content=”text/html; charset=UTF-8″; ;title;Admin Home Page;/title;
;link rel=”stylesheet” type=”text/css” /;;/head;;body;
;center;;div id=”divcontent” ;;div id=”divheader”;;%@include file=”myheader.jsp” %;;/div;;div id=”divbody” ;;%
String itemid=request.getParameter(“itemid”).toString();
;br /;;h1;Item Setup :;/h1;;form id=”frm” name=”frm” action=”” method=”post” ;;table;;tr;;td;Item Name ;/td;
;td;;input type=”text” id=”tname” name=”tname” value=”<%=s1%>” required/; ;/td;;/tr;;tr;;td;Item Details ;/td;;td;;textarea id=”tdetails” name=”tdetails” rows=”3″ cols=”35″ reqired;;%=s2%;;/textarea;;/td;;/tr;;tr;
;td;Item Price ;/td;
;td;;input type=”text” id=”tprice” name=”tprice” value=”<%=s3%>” required/; ;/td;;/tr;;tr;;td;Item Discount ;/td;
;td;;input type=”text” id=”tdiscount” name=”tdiscount” value=”<%=s4%>” required/; ;/td;;/tr;;tr;;td;Any Taxes ;/td;
;td;;input type=”text” id=”ttax” name=”ttax” value=”<%=s5%>” required/; ;/td;;/tr;;tr;;td;Delivery Charge ;/td;
;td;;input type=”text” id=”tdelcharge” name=”tdelcharge” value=”<%=s6%>” required/; ;/td;;/tr;;tr;;td colspan=”2″ ;
;input type=”submit” id=”btnadd” name=”btnadd” value=”Update Item” /;
;input type=”submit” id=”btndelete” name=”btndelete” value=”Delete Item” /; ;/td;;/tr;;/table;;/form;;%if(request.getParameter(“btnadd”)!=null){
String titemname=request.getParameter(“tname”).toString();
String tdetail=request.getParameter(“tdetails”).toString();
String tprice=request.getParameter(“tprice”).toString();
String tdiscount=request.getParameter(“tdiscount”).toString();
String ttax=request.getParameter(“ttax”).toString();
String tdelcharge=request.getParameter(“tdelcharge”).toString();
String tpath=”items/defaultitem.jpg”;try{
String qry=”update iteminfo set itemname='”+titemname+”‘,itemdetail='”+tdetail+”‘,itemprice='”+tprice+”‘,itemdiscount='”+tdiscount+”‘,itemtax='”+ttax+”‘,del_charge='”+tdelcharge+”‘,itemphoto='”+tpath+”‘ where itemid='”+itemid+”‘”;Class.forName(“com.mysql.jdbc.Driver”);
Connectioncon=DriverManager.getConnection(“jdbc:mysql://localhost/foodzone_db”,”root”,””);Statement st=con.createStatement();
if(st.executeUpdate(qry)==1){out.println(“Item Information Updated successful”);
session.setAttribute(“itemid”, itemid);
response.sendRedirect(“admin_itemphoto.jsp”);}else{out.println(“Record is not Added”);}}catch(Exception sk){out.println(“Error in Code “+sk.getMessage());}
}%;;/div;;div id=”divfooter” ;;%@include file=”myfooter.jsp” %;;/div;;/div;;/center;;/body;;/html;
ADMIN ORDER LIST.jsp
;%@page contentType=”text/html” pageEncoding=”UTF-8″%;
;%@page import=”java.sql.*;” %;;!DOCTYPE html;;html;;head;
;meta http-equiv=”Content-Type” content=”text/html; charset=UTF-8″;
;title;Admin Home Page;/title;
;link rel=”stylesheet” type=”text/css” /;
;/head;;body;;center;;div id=”divcontent” ;;div id=”divheader” ; ;%@include file=”myheader.jsp” %;;/div;;div id=”divbody” ;;br /;
Connectioncon=DriverManager.getConnection(“jdbc:mysql://localhost/foodzone_db”,”root”,””); Statement st=con.createStatement();
ResultSet rs=st.executeQuery(qry);ResultSetMetaData rst=rs.getMetaData();
int count=rst.getColumnCount();out.print(“<table border=’1′ >”);
out.print(“<tr style=’background-color:#000000;color:#ffffff;font-size:20px;’ >”); out.print(“<th>Order No</th>”);out.print(“<th>Order Date</th>”);
out.print(“<th>Order Person Name</th>”); out.print(“<th>Address </th>”);
out.print(“<th>Postcode </th>”);out.print(“<th>Mobile </th>”);
out.print(“<th>Email </th>”);out.print(“<th>Order Amount </th>”);
out.print(“<th>Orer Status </th>”);out.print(“<th>More Details</th>”);
out.print(“<th>UpdateStatus</th>”);out.print(“</tr>”);while(rs.next()){ out.print(“<tr>”);
out.print(“<td>”+rs.getString(“orderid”).toString()+”</td>”);
out.print(“<td>”+rs.getString(“orderdate”).toString()+”</td>”);
out.print(“<td>”+rs.getString(“cusname”).toString()+”</td>”);
out.print(“<td>”+rs.getString(“address”).toString()+”</td>”);
out.print(“<td>”+rs.getString(“postcode”).toString()+”</td>”);
out.print(“<td>”+rs.getString(“mobile”).toString()+”</td>”);
out.print(“<td>”+rs.getString(“email”).toString()+”</td>”);
out.print(“<td>”+rs.getString(“final_amt”).toString()+”</td>”);
out.print(“<td>”+rs.getString(“orderstatus”).toString()+”</td>”);
out.print(“<td><a href=’itemorderinfo.jsp?orderid=”+rs.getString(“orderid”)+”‘ >More Details</a></td>”);
out.print(“<td><ahref=’admin_statuschange.jsp?orderid=”+rs.getString(“orderid”)+”&orderstatus=”+rs.getString(“orderstatus”)+”‘ >Change Status</a></td>”);
out.print(“</tr>”);}out.print(“</table>”);}catch(Exception sk){
out.println(“Error is “+sk.getMessage().toString());}%;;/div;;/div;
;div id=”divfooter” ;;%@include file=”myfooter.jsp” %;;/div;
;/div;;/center;;/body;;/html;
ADMIN STATUS CHANGE.jsp
;%@page import=”java.sql.*;” %;
;%String status=request.getParameter(“orderstatus”).toString();
String orderid=request.getParameter(“orderid”).toString();
String qry=”update orderinfo set orderstatus='”+status+”‘ where orderid='”+orderid+”‘”; if(status.equals(“running”)){
qry=”update orderinfo set orderstatus=’completed’ where orderid='”+orderid+”‘”; }else{qry=”update orderinfo set orderstatus=’running’ where orderid='”+orderid+”‘”;}try{Class.forName(“com.mysql.jdbc.Driver”);
Connectioncon=DriverManager.getConnection(“jdbc:mysql://localhost/foodzone_db”,”root”,””);Statement st=con.createStatement();
if(st.executeUpdate(qry)==1)){out.println(“Updated successful”);}else{
out.println(“Record is not Updated”);}}catch(Exception sk){
out.println(“Error in Code “+sk.getMessage())}
response.sendRedirect(“admin_orderlist.jsp”);%;
ADMIN LOGOUT.jsp
;%session.removeAttribute(“userid”);session.removeAttribute(“username”);
response.sendRedirect(“index.jsp”);%;
ASK QUERY INFO.jsp
;%@page contentType=”text/html” pageEncoding=”UTF-8″%;
;!DOCTYPE html;;html;;head;
;meta http-equiv=”Content-Type” content=”text/html; charset=UTF-8″;
;title;Vegetable Store Website Page;/title;
;link rel=”stylesheet” type=”text/css” /;
;style type=”text/css” ;;/style;;/head;;body;;center;;div id=”contentdiv” ;
;%@include file=”indexheader.jsp” %;
;div id=”bodydiv” ;;div id=”leftdiv” ;;%@include file=”indexsidebar.jsp” %;
;/div;;div id=”rightdiv” ;;center
String name=request.getParameter(“tname”).toString();
String email=request.getParameter(“temail”).toString();
String mobile=request.getParameter(“tmobile”).toString();
String subject=request.getParameter(“tsubject”).toString();
String message=request.getParameter(“tmsg”).toString();
Date dNow = new Date( );SimpleDateFormat ft =
new SimpleDateFormat (“yyyy-MM-dd”);
String qdate=ft.format(dNow).toString();
String qry=”insert into queryinfo (queryperson,email,mobile,subject,message,querydate) values (‘”+name+”‘,'”+email+”‘,'”+mobile+”‘,'”+subject+”‘,'”+message+”‘,'”+qdate+”‘)”;
try{Class.forName(“com.mysql.jdbc.Driver”);
Connectioncon=DriverManager.getConnection(“jdbc:mysql://localhost/foodzone_db”,”root”,””);Statement st=con.createStatement();
if(st.executeUpdate(qry)==1){out.println(“Query Sent successful”);}else{
out.println(“Record is not sent”);}}catch(Exception sk){
out.println(“Error in Code “+sk.getMessage());}}%;;/center;;/div;
;/div;;div id=”footerdiv” ;;%@include file=”indexfooter.jsp” %;;/div;;/div;
;/center;;/body;;/html;
BASKET ITEM DELETE.jsp
;%@page import=”java.sql.*;” %;
;%if(request.getParameter(“itemid”)!=null){
String itemid=request.getParameter(“itemid”).toString();try{
String qry=”delete from busketinfo where itemid='”+itemid+”‘”;
Class.forName(“com.mysql.jdbc.Driver”);
Connectioncon=DriverManager.getConnection(“jdbc:mysql://localhost/foodzone_db”,”root”,””); Statement st=con.createStatement();
if(st.executeUpdate(qry)==1){out.println(“Busket Item Deleted successful”);
response.sendRedirect(“itemcardinfo.jsp”);}else{
out.println(“Record is not Added”);}}catch(Exception sk){
out.println(“Error in Code “+sk.getMessage());}}%;
BASKET SUCCESS INFO.jsp
;%@page contentType=”text/html” pageEncoding=”UTF-8″%;
;!DOCTYPE html;;html;;head;
;meta http-equiv=”Content-Type” content=”text/html; charset=UTF-8″;
;title;Vegetable Store Website Page;/title;
;link rel=”stylesheet” type=”text/css” href=”indexcss.css” /;
;style type=”text/css” ;;/style;;/head;;body;;center;;div id=”contentdiv” ;
;%@include file=”indexheader.jsp” %;;div id=”bodydiv” ;;div id=”leftdiv” ;
;%@include file=”indexsidebar.jsp” %;;/div;;div id=”rightdiv” ;;center;
;h1;;a href=”itemsearch.jsp” style=”color: #ff0000;” ;Back to Items;/a;;/h1;
;/center;;/div;;/div;;div id=”footerdiv” ;
;%@include file=”indexfooter.jsp” %;;/div;;/div;;/center;;/body;;/html;
CATEGORY ITEM.jsp
;%@page contentType=”text/html” pageEncoding=”UTF-8″%;
;!DOCTYPE html;;html;;head;
;meta http-equiv=”Content-Type” content=”text/html; charset=UTF-8″;
;title;Vegetable Store Website Page;/title;
;link rel=”stylesheet” type=”text/css” href=”indexcss.css” /;
;style type=”text/css” ;;/style;;/head;;body;;center;;div id=”contentdiv” ;
;%@include file=”indexheader.jsp” %;;div id=”bodydiv” ;;div id=”leftdiv” ;
;%@include file=”indexsidebar.jsp” %;;/div;;div id=”rightdiv” ;;center;
out.println(“<br /><img src='”+rs.getString(“itemphoto”) +”‘ style=’height:100px;width:150px;’ />”);
out.println(“<br /><h5 style=’margin:2px;’ >”+rs.getString(“itemname”));
out.println(“<br/>Price : “+rs.getString(“itemprice”)+”</h5><br />”);
out.println(“<h4 style=’margin:2px;’ ><a href=’viewiteminfo.jsp?itemid=”+rs.getString(“itemid”) +”‘ style=’color:#ff0000;’ >More Details</a></h4>”);out.println(“</center></div>”);}
}catch(Exception sk){out.println(“Error is “+sk.getMessage().toString());}%;
;/center;;/div;;/div;;div id=”footerdiv” ;
;%@include file=”indexfooter.jsp” %;;/div;;/div;;/center;;/body;;/html;
CONTACT US.jsp
;%@page contentType=”text/html” pageEncoding=”UTF-8″%;
;!DOCTYPE html;;html;;head;
;meta http-equiv=”Content-Type” content=”text/html; charset=UTF-8″;
;title;Vegetable Store Website Page;/title;
;link rel=”stylesheet” type=”text/css/>
<style type=”text/css” ></style></head><body><center><div id=”contentdiv” >
<%@include file=”indexheader.jsp” %><div id=”bodydiv” ><div id=”leftdiv” >
<%@include file=”indexsidebar.jsp” %></div><div id=”rightdiv”
</center></div></div><divid=”footerdiv”><%@includefile=”indexfooter.jsp”%></div></div></center></body></html>
FUNCTION INFO.jsp
<%@page import=”java.sql.*” %>
<% String execute_record(String qry){return “”;}%>
`INDEX.jsp
<%@page contentType=”text/html” pageEncoding=”UTF-8″%>
<!DOCTYPE html><html><head>
<meta http-equiv=”Content-Type” content=”text/html; charset=UTF-8″>
<title>Vegetable Store Website Page</title>
<link rel=”stylesheet” type=”text/css” href=”indexcss.css” />
<style type=”text/css” ></style></head><body><center><div id=”contentdiv” >
<%@include file=”indexheader.jsp” %><div id=”bodydiv” ><div id=”leftdiv” >
<%@include file=”indexsidebar.jsp” %></div><div id=”rightdiv” ><center>
</center></div></div><div id=”footerdiv” >
<%@include file=”indexfooter.jsp” %></div></div></center></body></html>
INDEX FOOTER.jsp
<center><br />
Powered by ICS Department Ujjain<br />Developed Year 2018</center>
INDEX HEADER.jsp
<%@page import=”java.sql.*;” %>
<h1 id=”titlehead”>Welcome to Vegetable Store Web Site</h1>
<div id=”headerdiv” >
</div><div id=”menudiv” >
<a href=”index.jsp” class=”a1″ >Home</a>
<a href=”aboutus.jsp” class=”a1″ >About Us</a>
<a href=”itemsearch.jsp” class=”a1″ >Search</a>
<a href=”serviceinfo.jsp” class=”a1″ >Services</a>
<a href=”askqueryinfo.jsp” class=”a1″ >Feedback</a>
<a href=”contactus.jsp” class=”a1″ >Contact Us</a>
<a href=”trackorderinfo.jsp” class=”a1″ >Track Order</a>
<a href=”myorders.jsp” class=”a1″ >My Orders</a></div>
INDEX SIDEBAR.jsp
<div id=”cardinfodiv” > <h3>Your Card Item</h3>
<table style=”height:100px;” ><%
int bcountitem=0;
float btotalamt=0;
String busketqry1=”select * from busketinfo”;
try{Class.forName(“com.mysql.jdbc.Driver”);
Connectioncon=DriverManager.getConnection(“jdbc:mysql://localhost/foodzone_db”,”root”,””); Statement st=con.createStatement();
ResultSet rs=st.executeQuery(busketqry1);
while(rs.next())
{
bcountitem=bcountitem+1;
btotalamt+=Float.parseFloat(rs.getString(“total_amt”));
}
}
catch(Exception sk)
{
out.println(“Error is “+sk.getMessage().toString());
}%>

<tr><th>Total Item</th><td><%=bcountitem%></td></tr>
<tr><th>Total Price</th><td><%=btotalamt%></td></tr>
<tr><th colspan=”2″ ><a href=”itemcardinfo.jsp” style=”text- decoration: none;color:#FF0000; ” > while(rs.next())
{
out.println(“;h3 style=’width:80%;color:#ffffff;background-color:#ff3333;margin:3px;’ ;;a href=’categoryitem.jsp?catname=”+rs.getString(“catname”)+”&catid=”+rs.getString(“catid”)+”‘ ;”+rs.getString(“catname”)+”;/a;;/h3;”);
}
}catch(Exception sk)
{
out.println(“Error is “+sk.getMessage().toString());
} %></div>
ITEM CARD INFO.jsp
<%@page contentType=”text/html” pageEncoding=”UTF-8″%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv=”Content-Type” content=”text/html; charset=UTF-8″>
<title>Vegetable Store Website Page</title>
<link rel=”stylesheet” type=”text/css” href=”indexcss.css” />
<style type=”text/css” >
</style>
</head>
<body>
<center>
<div id=”contentdiv” >
<%@include file=”indexheader.jsp” %>
<div id=”bodydiv” ><!– bodydiv open here –>
<div id=”leftdiv” >
<%@include file=”indexsidebar.jsp” %>
</div><div id=”rightdiv” >
<center>
<br />
<h1>Basket Item List </h1>
<br/>
<%
float grand_final_amt=0;
try {
String busketqry=”select *from busketinfo order by itemid”;
Class.forName(“com.mysql.jdbc.Driver”);
Connection con=DriverManager.getConnection(“jdbc:mysql://localhost/foodzone_db”,”root”,””);
Statement st=con.createStatement();
ResultSet rs=st.executeQuery(busketqry);ResultSetMetaData rst=rs.getMetaData();
int count=rst.getColumnCount();
out.print(“;table border=’1′ ;”);
out.print(“;tr style=’background-color:#000000;color:#ffffff;font-size:20px;’ ;”);
out.print(“;th;Item No;/th;”);
out.print(“;th;Item Name;/th;”);
out.print(“;th;Price;/th;”);
out.print(“;th;Discount ;/th;”);
out.print(“;th;Tax;/th;”);
out.print(“;th;Delivery Charge;/th;”);
out.print(“;th;Quantity;/th;”);
out.print(“;th;Total Amount;/th;”);
out.print(“;th;More Details;/th;”);
out.print(“;/tr;”);
while(rs.next())
{
grand_final_amt=grand_final_amt+Float.parseFloat(rs.getString(“total_amt”).toString());
out.print(“;tr;”);
out.print(“;td;”+rs.getString(“itemid”).toString()+”;/td;”);
out.print(“;td;”+rs.getString(“itemname”).toString()+”;/td;”);
out.print(“;td;”+rs.getString(“price”).toString()+”;/td;”);
out.print(“;td;”+rs.getString(“discount”).toString()+”;/td;”);
out.print(“;td;”+rs.getString(“tax”).toString()+”;/td;”);
out.print(“;td;”+rs.getString(“del_charge”).toString()+”;/td;”);
out.print(“;td;”+rs.getString(“qty”).toString()+”;/td;”);
out.print(“;td;”+rs.getString(“total_amt”).toString()+”;/td;”);
out.print(“;td;;a style=’color:#000000;’ href=’busketitemdelete.jsp?itemid=”+rs.getString(“itemid”) +”‘ ;Delete;/a;;/td;”);
out.print(“;/tr;”);
}
out.print(“;tr;;th colspan=’6′ ;”);
out.println(“Final Amount is :;/th;”);
out.print(“;td colspan=’3’ ;”+grand_final_amt+”;/td;”);
out.print(“;/tr;”);
out.print(“;/table;”);
}catch(Exception sk)
{
out.println(“Error is “+sk.getMessage().toString());
}
%>
<br /><br />
<a href=”busketorderinfo.jsp?famt=;%=grand_final_amt%;” style=”background-color: #000000;color:#ffffff;padding-top:5px;padding-bottom: 5px;padding-left: 10px;padding-right: 10px;” >Now Order</a>
<a href=”index.jsp” style=”background-color: #000000;color:#ffffff;padding-top:5px;padding-bottom: 5px;padding-left: 10px;padding-right: 10px;” >Back</a>
</center>
</div>
</div><!– bodydiv closed here –>
<div id=”footerdiv” >
<%@include file=”indexfooter.jsp” %>
</div></div><!– contend div closed here –>
</center>
</body>
</html>
ITEM ORDER INFO.jsp
<%@page contentType=”text/html” pageEncoding=”UTF-8″%>
<%@page import=”java.sql.*;” %>
<!DOCTYPE html>
<html> <head>
<meta http-equiv=”Content-Type” content=”text/html; charset=UTF-8″>
<title>Admin Home Page</title>
<link rel=”stylesheet” type=”text/css” href=”adminhome.css” />
</head>
<body>
<center>
<div id=”divcontent” >
<div id=”divheader” > <%@include file=”myheader.jsp” %>
</div>
<div id=”divbody” > <div id=”divbleft” > <br />
<h1>Item Details Panel :</h1>
</div>
<div id=”divbright” > <h1>Order Items List Panel</h1>
<%
String orderid=request.getParameter(“orderid”);try
{
String qry=”select *from orderinfo where orderid='”+orderid+”‘”;
Class.forName(“com.mysql.jdbc.Driver”);
Connection con=DriverManager.getConnection(“jdbc:mysql://localhost/foodzone_db”,”root”,””);
Statement st=con.createStatement();
ResultSet rs=st.executeQuery(qry);
ResultSetMetaData rst=rs.getMetaData();
int count=rst.getColumnCount();
out.print(“;table border=’1′ ;”);
out.print(“;tr style=’background-color:#000000;color:#ffffff;font-size:20px;’ ;”);
out.print(“;th;Order No;/th;”);
out.print(“;th;Order Date;/th;”);
out.print(“;th;Order Person Name;/th;”);
out.print(“;th;Address ;/th;”);
out.print(“;th;Postcode ;/th;”);
out.print(“;th;Mobile ;/th;”);
out.print(“;th;Email ;/th;”);
out.print(“;th;Order Amount ;/th;”);
out.print(“;th;Orer Status ;/th;”);
out.print(“;/tr;”);
while(rs.next())
{
out.print(“;tr;”);
out.print(“;td;”+rs.getString(“orderid”).toString()+”;/td;”);
out.print(“;td;”+rs.getString(“orderdate”).toString()+”;/td;”);
out.print(“;td;”+rs.getString(“cusname”).toString()+”;/td;”);
out.print(“;td;”+rs.getString(“address”).toString()+”;/td;”);
out.print(“;td;”+rs.getString(“postcode”).toString()+”;/td;”);
out.print(“;td;”+rs.getString(“mobile”).toString()+”;/td;”);
out.print(“;td;”+rs.getString(“email”).toString()+”;/td;”);
out.print(“;td;”+rs.getString(“final_amt”).toString()+”;/td;”);
out.print(“;td;”+rs.getString(“orderstatus”).toString()+”;/td;”);
out.print(“;/tr;”);
}
out.print(“;/table;”); }catch(Exception sk)
{
out.println(“Error is “+sk.getMessage().toString());
}
%>

<br /><br />
<h2>Items Information</h2>
<%
try {
String qry=”select *from orderproductinfo where orderid='”+orderid+”‘”;
Class.forName(“com.mysql.jdbc.Driver”);
Connection con=DriverManager.getConnection(“jdbc:mysql://localhost/foodzone_db”,”root”,””);
Statement st=con.createStatement();
ResultSet rs=st.executeQuery(qry);
ResultSetMetaData rst=rs.getMetaData();
int count=rst.getColumnCount();
out.print(“;table border=’1′ ;”);
out.print(“;tr style=’background-color:#000000;color:#ffffff;font-size:20px;’ ;”);
out.print(“;th;Item No;/th;”);
out.print(“;th;Order Item Name;/th;”);
out.print(“;th;Item Price ;/th;”);
out.print(“;th;Discount ;/th;”);
out.print(“;th;Tax ;/th;”);
out.print(“;th;Delivery Charge ;/th;”);
out.print(“;th;Quantity ;/th;”);
out.print(“;th;Total Amount ;/th;”);
out.print(“;/tr;”); while(rs.next())
{
out.print(“;tr;”);
out.print(“;td;”+rs.getString(“opid”).toString()+”;/td;”);
out.print(“;td;”+rs.getString(“oitemname”).toString()+”;/td;”);
out.print(“;td;”+rs.getString(“oprice”).toString()+”;/td;”);
out.print(“;td;”+rs.getString(“odiscount”).toString()+”;/td;”);
out.print(“;td;”+rs.getString(“otax”).toString()+”;/td;”);
out.print(“;td;”+rs.getString(“odel_charge”).toString()+”;/td;”);
out.print(“;td;”+rs.getString(“oqty”).toString()+”;/td;”);
out.print(“;td;”+rs.getString(“ototal_amt”).toString()+”;/td;”);
out.print(“;/tr;”);
}
out.print(“;/table;”);
}catch(Exception sk)
{
out.println(“Error is “+sk.getMessage().toString());
}
%> </div>
</div>
<div id=”divfooter” > <%@include file=”myfooter.jsp” %>
</div></div>
</center>
</body>
</html>
ITEM SEARCH.jsp
<%@page contentType=”text/html” pageEncoding=”UTF-8″%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv=”Content-Type” content=”text/html; charset=UTF-8″>
<title>Vegetable Store Website Page</title>
<link rel=”stylesheet” type=”text/css” href=”indexcss.css” />
<style type=”text/css” >
</style>
</head>
<body>
<center>
<div id=”contentdiv” >
<%@include file=”indexheader.jsp” %>
<div id=”bodydiv” ><!– bodydiv open here –>
<div id=”leftdiv” >
<%@include file=”indexsidebar.jsp” %>
</div>
<div id=”rightdiv” >
<center>
<br />
<form id=”frm” name=”frm” action=”” method=”post” > Search : <input type=”text” id=”tsearch” name=”tsearch” />
<input type=”submit” id=”btnsearch” name=”btnsearch” value=”Search” />
</form>
<br/>
<%
String search=””;
if(request.getParameter(“btnsearch”)!=null)
{
search=request.getParameter(“tsearch”).toString();
}
try {
String qry=”select * from iteminfo where itemname like ‘%”+search+”%’ order by itemname”;
Class.forName(“com.mysql.jdbc.Driver”);
Connection con=DriverManager.getConnection(“jdbc:mysql://localhost/foodzone_db”,”root”,””);
Statement st=con.createStatement();
ResultSet rs=st.executeQuery(qry);
while(rs.next())
{
out.println(“;div style=’height:250px;width:260px;border:solid 1px #000000;margin:4px;float:left;’ ;;center;”);
out.println(“;br /;;img src='”+rs.getString(“itemphoto”) +”‘ style=’height:100px;width:150px;’ /;”);
out.println(“;br /;;h5 style=’margin:2px;’ ;”+rs.getString(“itemname”));
out.println(“;br/;Price : “+rs.getString(“itemprice”)+”;/h5;;br /;”); out.println(“;h4 style=’margin:2px;’ ;;a href=’viewiteminfo.jsp?itemid=”+rs.getString(“itemid”) +”‘ style=’color:#ff0000;’ ;More Details;/a;;/h4;”);
out.println(“;/center;;/div;”);
}
}catch(Exception sk)
{
out.println(“Error is “+sk.getMessage().toString());
}
%>

</center>
</div>
</div><!– bodydiv closed here –>
<div id=”footerdiv” >
<%@include file=”indexfooter.jsp” %>
</div></div><!– contend div closed here –>
</center>
</body>
</html>
MY FOOTER.jsp
<style type=”text/css” >
#divfoottitle
{
font-size: 20px;color: #ffffff;background-color: #333333;
}
</style>
<div id=”divfoottitle” >
<h1><br />Powered by ICS Department Ujjain<br />Developed Year 2018</h1>
</div>
MY HEADER.jsp
<%
if(session.getAttribute(“userid”)!=null)
{
}
else {
response.sendRedirect(“logininfo.jsp”);
}
%>
<style type=”text/css” >
#divtitle
{
height: 70px;width: 100%;border-top: solid 1px #000000;border-bottom: solid 1px #000000;
}
#divmenu
{
height: 35px;width: 100%;background-color: #000000;color: #ffffff;padding-top: 5px;padding-bottom: 5px;
}
.clsmenu
{
text-decoration: none;font-size: 22px;color: #ffffff;margin-left: 50px;
}
</style>
<div id=”divtitle” >
<center>
<h1>Vegetable Store Website</h1>
</center>
</div><div id=”divmenu” >
<a href=”adminhome.jsp” class=”clsmenu” >Admin Home</a>
<a href=”admin_category.jsp” class=”clsmenu” >Category</a>
<a href=”admin_item.jsp” class=”clsmenu” >Item Setup</a>
<a href=”admin_orderlist.jsp” class=”clsmenu” >Order List</a>
<a href=”admin_feedbacklist.jsp” class=”clsmenu” >Feedback List</a>
<a href=”adminlogout.jsp” class=”clsmenu” >Logout</a></div>
MY ORDER.jsp
<%@page contentType=”text/html” pageEncoding=”UTF-8″%>
<!DOCTYPE html><html><head>
<meta http-equiv=”Content-Type” content=”text/html; charset=UTF-8″>
<title>Vegetable Store Website Page</title>
<link rel=”stylesheet” type=”text/css” href=”indexcss.css” />
<style type=”text/css” ></style>
</head>
<body>
<center>
<div id=”contentdiv” ><%@include file=”indexheader.jsp” %>
<div id=”bodydiv” ><!– bodydiv open here –>
<div id=”leftdiv” >
<%@include file=”indexsidebar.jsp” %>
</div><div id=”rightdiv” >
<center>
<br />
<h2>My Orders Panel</h2>
<form id=”frm123″ name=”frm123″ action=”” method=”post” >
Mobile :<br /> <input type=”text” id=”tmobile” name=”tmobile” /><br /><br />
<input type=”submit” id=”searchbtn” name=”searchbtn” value=”Search” />
</form>
<%
if(request.getParameter(“searchbtn”)!=null)
{
//String orderno =request.getParameter(“torderno”).toString();
String mobile =request.getParameter(“tmobile”).toString();

response.sendRedirect(“orderotpinfo.jsp?mobile=”+mobile);
/*try
{
String qry=”select *from orderinfo where mobile='”+mobile+”‘ order by orderdate desc”;
Class.forName(“com.mysql.jdbc.Driver”);
Connection con=DriverManager.getConnection(“jdbc:mysql://localhost/foodzone_db”,”root”,””);
Statement st=con.createStatement();
ResultSet rs=st.executeQuery(qry);
ResultSetMetaData rst=rs.getMetaData();
int count=rst.getColumnCount();
out.print(“;table border=’1′ ;”);
out.print(“;tr style=’background-color:#000000;color:#ffffff;font-size:20px;’ ;”);
out.print(“;th;Order No;/th;”);
out.print(“;th;Order Date;/th;”);
out.print(“;th;Order Person Name;/th;”);
out.print(“;th;Address ;/th;”);
out.print(“;th;Postcode ;/th;”);
out.print(“;th;Mobile ;/th;”);
out.print(“;th;Email ;/th;”);
out.print(“;th;Order Amount ;/th;”);
out.print(“;th;Orer Status ;/th;”);out.print(“;/tr;”); while(rs.next())
{
out.print(“;tr;”);

out.print(“;td;”+rs.getString(“orderid”).toString()+”;/td;”);
out.print(“;td;”+rs.getString(“orderdate”).toString()+”;/td;”);
out.print(“;td;”+rs.getString(“cusname”).toString()+”;/td;”);
out.print(“;td;”+rs.getString(“address”).toString()+”;/td;”);
out.print(“;td;”+rs.getString(“postcode”).toString()+”;/td;”);
out.print(“;td;”+rs.getString(“mobile”).toString()+”;/td;”);
out.print(“;td;”+rs.getString(“email”).toString()+”;/td;”);
out.print(“;td;”+rs.getString(“final_amt”).toString()+”;/td;”);
out.print(“;td;”+rs.getString(“orderstatus”).toString()+”;/td;”);
out.print(“;/tr;”);
}
out.print(“;/table;”);
}catch(Exception sk)
{
out.println(“Error is “+sk.getMessage().toString());
}*/
} %>
</center>
</div>
</div><!– bodydiv closed here –>
<div id=”footerdiv” >
<%@include file=”indexfooter.jsp” %>
</div>
</div><!– contend div closed here –>
</center>
</body>
</html>
ORDER OTP INFO.jsp
<%@page contentType=”text/html” pageEncoding=”UTF-8″%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv=”Content-Type” content=”text/html; charset=UTF-8″>
<title>Vegetable Store Website Page</title>
<link rel=”stylesheet” type=”text/css” href=”indexcss.css” />
<style type=”text/css” >
</style>
</head>
<body>
<center>
<div id=”contentdiv” >
<%@include file=”indexheader.jsp” %>
<div id=”bodydiv” ><!– bodydiv open here –>
<div id=”leftdiv” >
<%@include file=”indexsidebar.jsp” %>
</div>
<div id=”rightdiv” >
<center>
<br />
<h2>Order Details List Panel</h2>
<form id=”frm123″ name=”frm123″ action=”” method=”post” >
Enter OTP Number :<br /> <input type=”text” id=”totp” name=”totp” /><br /><br />
<input type=”submit” id=”searchbtn” name=”searchbtn” value=”Search” />
</form>
<%
if(request.getParameter(“searchbtn”)!=null)
{
String otpno =request.getParameter(“totp”).toString();
if(otpno.equals(“1234”))
{
String mobile =request.getParameter(“mobile”).toString();
try {
String qry=”select *from orderinfo where mobile='”+mobile+”‘ order by orderdate desc”;
Class.forName(“com.mysql.jdbc.Driver”);
Connection con=DriverManager.getConnection(“jdbc:mysql://localhost/foodzone_db”,”root”,””);
Statement st=con.createStatement();
ResultSet rs=st.executeQuery(qry);
ResultSetMetaData rst=rs.getMetaData();
int count=rst.getColumnCount();
out.print(“;table border=’1′ ;”);
out.print(“;tr style=’background-color:#000000;color:#ffffff;font-size:20px;’ ;”);
out.print(“;th;Order No;/th;”);
out.print(“;th;Order Date;/th;”);
out.print(“;th;Order Person Name;/th;”);
out.print(“;th;Address ;/th;”);
out.print(“;th;Postcode ;/th;”);
out.print(“;th;Mobile ;/th;”);
out.print(“;th;Email ;/th;”);
out.print(“;th;Order Amount ;/th;”);
out.print(“;th;Orer Status ;/th;”);
out.print(“;/tr;”);
int loopcount=0;
while(rs.next())
{
out.print(“;tr;”);
out.print(“;td;”+rs.getString(“orderid”).toString()+”;/td;”);
out.print(“;td;”+rs.getString(“orderdate”).toString()+”;/td;”);
out.print(“;td;”+rs.getString(“cusname”).toString()+”;/td;”);
out.print(“;td;”+rs.getString(“address”).toString()+”;/td;”);
out.print(“;td;”+rs.getString(“postcode”).toString()+”;/td;”);
out.print(“;td;”+rs.getString(“mobile”).toString()+”;/td;”);
out.print(“;td;”+rs.getString(“email”).toString()+”;/td;”);
out.print(“;td;”+rs.getString(“final_amt”).toString()+”;/td;”);
out.print(“;td;”+rs.getString(“orderstatus”).toString()+”;/td;”);
out.print(“;/tr;”);
loopcount++;
}
out.print(“;/table;”);if(loopcount==0)
{
out.println(“Sorry Order is not found”);
}
}catch(Exception sk)
{
out.println(“Error is “+sk.getMessage().toString());
}
}
else {
out.println(“Invalid OTP Number Try Again”);
}
}
%>
</center>
</div>
</div><!– bodydiv closed here –>
<div id=”footerdiv” >
<%@include file=”indexfooter.jsp” %>
</div>
</div><!– contend div closed here –>
</center>
</body>
</html>
ORDER SUCCESSFUL.jsp
<%@page contentType=”text/html” pageEncoding=”UTF-8″%>
<!DOCTYPE html><html>
<head>
<meta http-equiv=”Content-Type” content=”text/html; charset=UTF-8″>
<title>Vegetable Store Website Page</title>
<link rel=”stylesheet” type=”text/css” href=”indexcss.css” />
<style type=”text/css” >
</style>
SERVICE INFO.jsp
<%@page contentType=”text/html” pageEncoding=”UTF-8″%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv=”Content-Type” content=”text/html; charset=UTF-8″>
<title>Vegetable Store Website Page</title>
<link rel=”stylesheet” type=”text/css” href=”indexcss.css” />
<style type=”text/css” ></style>
</head>
<body>
<center>
<div id=”contentdiv” >
<%@include file=”indexheader.jsp” %>
<div id=”bodydiv” ><!– bodydiv open here –>
<div id=”leftdiv” >
<%@include file=”indexsidebar.jsp” %>
</div><div id=”rightdiv” >
<center>
<h1>Our Services Panel</h1>
<h2>Best Quality Vegetable</h2>
<p>Our Mission is to provide best quality services for customer and fresh fast food for customer.</p>
<h2>Home Delivery for Customer</h2>
<p>We are serve facility for customer to deliver food at home with minimum service cast.</p>
</center>
</div>
</div><!– bodydiv closed here –><div id=”footerdiv” >
<%@include file=”indexfooter.jsp” %>
</div></div><!– contend div closed here –>
</center>
</body>
</html></head><body><center><div id=”contentdiv” >
<%@include file=”indexheader.jsp” %><div id=”bodydiv” ><!– bodydiv open here –>
<div id=”leftdiv” ><%@include file=”indexsidebar.jsp” %></div><div id=”rightdiv” ><center><br /><h1>Thanks For Order with Us</h1>
<h3>Our Team Receive Your Order and Contact for Next step soon</h3> </center></div></div><!– bodydiv closed here –><div id=”footerdiv” >
<%@include file=”indexfooter.jsp” %>
</div></div><!– contend div closed here –>
</center>
</body>
</html>
TRACK ORDER INFO.jsp
<%@page contentType=”text/html” pageEncoding=”UTF-8″%>
<!DOCTYPE html><html><head>
<meta http-equiv=”Content-Type” content=”text/html; charset=UTF-8″>
<title>Vegetable Store Website Page</title>
<link rel=”stylesheet” type=”text/css” href=”indexcss.css” />
<style type=”text/css” ></style>
</head><body><center><div id=”contentdiv” >
<%@include file=”indexheader.jsp” %>
<div id=”bodydiv” ><!– bodydiv open here –>
<div id=”leftdiv” >
<%@include file=”indexsidebar.jsp” %>
</div><div id=”rightdiv” >
<center>
<br />
<h2>Item Details Panel : </h2>
<br/>
<%
String search=request.getParameter(“itemid”).toString();
try {
String qry=”select * from iteminfo where itemid='”+search+”‘”;
Class.forName(“com.mysql.jdbc.Driver”);
Connection con=DriverManager.getConnection(“jdbc:mysql://localhost/foodzone_db”,”root”,””);
Statement st=con.createStatement();
ResultSet rs=st.executeQuery(qry);
if(rs.next())
{
float price=Float.parseFloat(rs.getString(“itemprice”).toString());
float discount=Float.parseFloat(rs.getString(“itemdiscount”).toString());
float tax=Float.parseFloat(rs.getString(“itemtax”).toString());
float del_charge=Float.parseFloat(rs.getString(“del_charge”).toString());float total_amt=(price+tax+del_charge)-discount;
out.println(“;div style=’height:440px;width:90%;border:groove 3px #000000;margin:4px;’ ;;center;”);
out.println(“;br /;;img src='”+rs.getString(“itemphoto”) +”‘ style=’height:100px;width:150px;’ /;”);
out.println(“;br /;;h5 style=’margin:2px;’ ;Item Name : “+rs.getString(“itemname”)+”;/h5;”);
out.println(“;h5;Details : “+rs.getString(“itemdetail”)+”;/h5;”);
out.println(“;h5;Price : “+rs.getString(“itemprice”)+”;/h5;”);
out.println(“;h5;Discount : “+rs.getString(“itemdiscount”)+”;/h5;”);
out.println(“;h5;Any Tax : “+rs.getString(“itemtax”)+”;/h5;”);
out.println(“;h5;Delivery Charges : “+rs.getString(“del_charge”)+”;/h5;”);
out.println(“;h5;Total Amount : “+total_amt+”;/h5;”);
// out.println(“;h4 style=’margin:2px;’ ;;a href=’itemcardinfo.jsp?itemid=”+rs.getString(“itemid”) +”‘ style=’color:#ffffff;padding:10px;background-color:#000000;’ ;Add to Card;/a;;a href=’bookorderinfo.jsp?itemid=”+rs.getString(“itemid”) +”‘ style=’color:#ffffff;padding:10px;background-color:#000000;’ ;Order Now;/a;;/h4;”);}
}catch(Exception sk)
{
out.println(“Error is “+sk.getMessage().toString());
}
%>
<form id=”f123″ name=”f123″ action=”” method=”post” >
Item Quantity :
<select id=”qty” name=”qty” >
<option value=”1″ >1 Item</option>
<option value=”2″ >2 Item</option>
<option value=”3″ >3 Item</option>
<option value=”4″ >4 Item</option>
<option value=”5″ >5 Item</option>
</select>
<br />
<input type=”submit” id=”sub123″ name=”sub123″ value=”Add to Card” />
<input type=”submit” id=”sub1″ name=”sub1″ value=”Now Order” /> </form><%
if(request.getParameter(“sub123”)!=null)
{
response.sendRedirect(“addtobusketinfo.jsp?itemid=”+request.getParameter(“itemid”)+”;qty=”+request.getParameter(“qty”));
}
if(request.getParameter(“sub1”)!=null)
{response.sendRedirect(“bookorderinfo.jsp?itemid=”+request.getParameter(“itemid”)+”;qty=”+request.getParameter(“qty”));
}
%><% out.println(“;/center;;/div;”); %>
</center></div>
</div><!– bodydiv closed here –><div id=”footerdiv” >
<%@include file=”indexfooter.jsp” %>
</div></div><!– contend div closed here –></center></body></html>
VIEW ITEMINFO.jsp
<%@page contentType=”text/html” pageEncoding=”UTF-8″%>
<!DOCTYPE html><html><head>
<meta http-equiv=”Content-Type” content=”text/html; charset=UTF-8″>
<title>Vegetable Store Website Page</title>
<link rel=”stylesheet” type=”text/css” href=”indexcss.css” />
<style type=”text/css” ></style></head>
<body>
<center>
<div id=”contentdiv” >
<%@include file=”indexheader.jsp” %><div id=”bodydiv” ><!– bodydiv open here –>
<div id=”leftdiv” >
<%@include file=”indexsidebar.jsp” %>
</div><div id=”rightdiv” >
<center>
<br />
<h2>Track Order Status Panel</h2>
<form id=”frm123″ name=”frm123″ action=”” method=”post” >
Person Name :<br /> <input type=”text” id=”tname” name=”tname” /><br /><br />
Email :<br /> <input type=”text” id=”temail” name=”temail” /><br /><br />
Mobile :<br /> <input type=”text” id=”tmobile” name=”tmobile” /><br /><br />

<input type=”submit” id=”searchbtn” name=”searchbtn” value=”Search” />
</form>
<%
if(request.getParameter(“searchbtn”)!=null)
{
//String orderno =request.getParameter(“torderno”).toString();
String name =request.getParameter(“tname”).toString();
String email =request.getParameter(“temail”).toString();
String mobile =request.getParameter(“tmobile”).toString();
try {
String qry=”select *from orderinfo where cusname='”+name+”‘ and email='”+email+”‘ and mobile='”+mobile+”‘ order by orderdate desc limit 1″;Class.forName(“com.mysql.jdbc.Driver”);
Connection con=DriverManager.getConnection(“jdbc:mysql://localhost/foodzone_db”,”root”,””);
Statement st=con.createStatement();
ResultSet rs=st.executeQuery(qry);ResultSetMetaData rst=rs.getMetaData();
int count=rst.getColumnCount();
out.print(“;table border=’1′ ;”);
out.print(“;tr style=’background-color:#000000;color:#ffffff;font-size:20px;’ ;”);
out.print(“;th;Order No;/th;”);
out.print(“;th;Order Date;/th;”);
out.print(“;th;Order Person Name;/th;”);
out.print(“;th;Address ;/th;”);
out.print(“;th;Postcode ;/th;”);
out.print(“;th;Mobile ;/th;”);
out.print(“;th;Email ;/th;”);
out.print(“;th;Order Amount ;/th;”);
out.print(“;th;Orer Status ;/th;”);out.print(“;/tr;”); while(rs.next())
{
out.print(“;tr;”);
out.print(“;td;”+rs.getString(“orderid”).toString()+”;/td;”);
out.print(“;td;”+rs.getString(“orderdate”).toString()+”;/td;”);
out.print(“;td;”+rs.getString(“cusname”).toString()+”;/td;”);
out.print(“;td;”+rs.getString(“address”).toString()+”;/td;”);
out.print(“;td;”+rs.getString(“postcode”).toString()+”;/td;”);
out.print(“;td;”+rs.getString(“mobile”).toString()+”;/td;”);
out.print(“;td;”+rs.getString(“email”).toString()+”;/td;”);
out.print(“;td;”+rs.getString(“final_amt”).toString()+”;/td;”);
out.print(“;td;”+rs.getString(“orderstatus”).toString()+”;/td;”);
out.print(“;/tr;”);
}
out.print(“;/table;”);
}catch(Exception sk)
{
out.println(“Error is “+sk.getMessage().toString());
}
}
%> </center></div></div><!– bodydiv closed here –><div id=”footerdiv” >
<%@include file=”indexfooter.jsp” %>
</div></div><!– contend div closed here –></center></body></html>
6.4 ALGORITHM
FLOW CHART
The process of drawing a flowchart is known as the flow charting.

SYMBOLS USED IN FLOWCHART
TERMINAL: – It indicates the beginning start and stop in a program logic flow.

INPUT/OUTPUT: – It denoted any function of input/output in a program.

PROCESSING: – It represents arithmetic and data movement’s instructions and more than one instruction are executed consequently.

DECISION: – It indicates the decision point in the program flow.

FLOW LINES: – It shows the flow of the lines.

CONNECTORS: – It shows the number of direction of flow lines.

Start

Read Page

Select page

Website Home
Valid
Enter Id & Pwd
Login

Check Id & Pwd
Invalid

Order List
View Order Detail
Add/View Product
Add/View Category
Admin Profile
Search Product
Category

View Detail
Search Product

Now Order
Track Order

Contact Us

Feedback

View member List

View Feedback List

Stop

6.5 DATA FLOW DIAGRAM
These are the central tool and the basis from which the other components are developed. A full description of a system actually consists of a set of data flow diagrams. The process in the context level diagram is exploded into other process at the first level DFD.

A DFD consists of a series of bubbles joined by data flows in the system
DFD Symbols
In DFD, the following symbols are used:-
SQUARE: A square defines a Source or Destination of system data. External entities represent any entity that supplies or receive information.

CIRCLE OR BUBBLE: Circle or Bubble represents a process that transforms incoming data flows into outgoing data flows.

ARROW: An arrow identifies data flow, a data flow symbols represents the data flow occurring b/w two processes or b/w an external entity.

OPEN RECTANGLE OR PARALLEL LINES: An open rectangle or parallel lines symbols represents a data store.

Vegetable Store DB
Zero Level:-Buyer/Visitor
Administrator

Vegetable Store Website

First level (Visitor / Buyer):
Vegetable Store DB
Customer
Website Home

Contact DB
Product DB
Order Product
Search Product
Search Website

Search Item Category

Category DB

Order Info DB

Check Order Status

Order Info DB

Contact us / Feedback

Manager DB
First level (Admin):
Verify
Login

Admin

Login

Add / View Item Category
Complaint DB
Order Info DB
Complaint List Page
View Order List
View Member Customer

Category DB

Add / View Product Info

Product DB

Customer DB

E-R Diagram
User name

Password
Remark
Catid
Catname
User id

E-mail

Admin

Category Info

Fid
Feedback info
E-mail
Subject
Person

Message
Setup Relation

Order name
Order date

M Name
Order id
PID

Pname

Mobile

Order info

Address
Product Info
Pprice

Discount

Pay amt
E-mail
Pimage
Batch code

Status

Order Item Info
Buy Item Relation

Order Id

Product
Discount

Price

Del charge
Orderitemid

Total amount

CHAPTER -7
SYSTEM IMPLEMENTATION
Implementation means converting a new system design into operation.
IMPLEMENTATION ENTAILS SEVERAL STEPS WHICH ARE AS FOLLOWING:-
1 Review the project plan, test documentation and implementation plan.

2 Convert the files.

3 Conduct the parallel processing.

4 Log the computer run for interface.

5 Discontinue the old system.

6 Plan the post implementation review.

This software will serve the customer with ability to various operations like store, maintain, etc. This increase the security level.
DATABASE DESIGN
BASKET INFO

CATEGORY

ITEM INFO

LOGIN INFO

ORDER INFO

ORDER PRODUCT INFO

QUERY INFO

DATA DICTIONARY
Basket info: itemid, itemname, price, discount, tax, del_charge, qty, total_amt
Category: catid, catname, catremark
Login info: logid, username, pwd, email, sec_quest, sec_ans, usertype
Item info: itemid, catid, itemname, itemdetail, itemprice, itemdiscount, itemtax, del_charge, itemphoto
Order info: ordered, orderdate, cusname, address, postcode, mobile, email, paytype, final_amt, orderstatus
Order product info: opid, ordered, oitemname, oprice, odiscount, otax, odel_charge, oqty, ototal_amt, status
Query info: Queryid, queryperson, email, mobile, subject, message, querydate
INPUT & OUTPUT SCREENS
HOME SCREEN

ABOUT US
SEARCH SCREEN

FEEDBACK SCREEN

CONTACT US SCREEN

TRACK ORDER SCREEN

MY ORDER SCREEN

ADMIN LOGIN SCREEN

ADMIN HOME SCREEN

CATEGORY SCREEN

ITEM SETUP SCREEN

ORDER LIST SCREEN

FEEDBACK LIST SCREEN

CHAPTER-8
LIMITATIONS
List of limitations which are available in the Online Vegetable Store:
Excel report has not been developed for vegetables. Stocks due to some critically.

The transactions are executed in off-line mode, hence online data for order, customer fetch and modification is impossible.

CHAPTER-9
CONCLUSION
At the end it is concluded that we have made effort on following points:
A description of the background and context of the project and its relation to work already done in the area.

Made statement of the aims and objective of the project.

The description of purpose, scope and applicability.

We define the problem on which we are working in the project.

We describe the requirement specifications of the system and the actions that can be done on these things.

FUTURE SCOPE OF THE PROJECT
It can be summarized that the future scope of the project circles around maintaining information regarding:
We can add printer in future.

We can give more advance software for Online Vegetable Store including more facilities.

CHAPTER-10
REFERENCES
Google for problem solving.

http://www.javaworld.com/javaworld/jw-01-1998/jw-01-Credentialreview.html.

Database Programming with JDBC and Java by O’Reilly.
Head First Java 2nd Edition.

http://www.jdbc-tutorial.com/Java and Software Design Concepts by Apress.

http://www.tutorialspoint.com/java/.

http://www.javatpoint.com/java-tutorial.

http://docs.oracle.com/javase/tutorial/http://www.wampserver.com/en/.

http://www.JSP.net/.

http://www.tutorialspoint.com/mysql/.

httpd.apache.org/docs/2.0/misc./tutorials.html.

Post Author: admin

x

Hi!
I'm Chloe

Would you like to get a custom essay? How about receiving a customized one?

Check it out
x

Hi!
I'm Ted!

Would you like to get a custom essay? How about receiving a customized one?

Check it out