CHAPTER-1 relevant, while being able to reach information.

CHAPTER-1INTRODUCTION1.

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.

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


order now

2 INTRODUCTION TO THE PROJECTTitle of the project: – ONLINE VEGETABLE STOREObjective: -. 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.

Manage the information and description of the store..Integration of all records of online vegetable.CHAPTER-2CONCEPT/LITERATURE STUDYPROJECT CONCEPTThe 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-3ENVIRONMENT3.1 HARDWAREThe following sub-sections define the various aspects of hardware requirements.3.1.1 ProcessorThe power of Center Processing Unit (CPU) is fundamental system requirement for any software. Intel Core i3 processor used in the project.3.

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

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

2 SOFTWAREThe following sub sections define the various aspects of software requirements.3.2.1 Operating systemThe most common version of Microsoft Windows i.e. Windows 10 is used.

3.2.2 PackagePrimary 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 DatabaseBuild 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.

FieldFile 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 DatabaseA database is a collection of stored data used by the application system of some particular organization.Distributed DatabaseAcross a network of computer that are geographically dispersed and connected via communication links (LAN, WAN).CHAPTER-4MANUAL SYSTEM / EARLIER SYSTEMIn the existing system the exams are done only manually but in proposed system We have some complications the exams using this applicationLack of security of data.More man power time consuming.Consumes large volume of paper work.CHAPTER-5CURRENT SYSTEMThe 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-6SYSTEM DEVELOPMENTS6.1 THE SYSTEM PLANNINGSystem 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.Documentation24 Days31st May8th May13 Days7th May25th April25 Days24th April31st Mar18 Days30th Mar13th Mar16 Days12th Mar28th Feb10 Days28th Feb18th Feb6.2 THE SYSTEM DESIGNTo 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 ; BOUNDARIESIn this we give brief introduction if what will the system will ; will not try to do.

SPECIFIC REQUIREMENTSIn 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 BENEFITSOther anticipated benefits of the new system as the improved information.COST ; BENEFITS ANALYSISComparison of the cost verses the benefits of the proposed system.This package has been prepared with the help of following forms:-Home PageLogin PageRegistration PageFeedback FormAbout UsContact Us6.

3 THE PROGRAM FILESADMIN 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” ;;centerString 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 ALGORITHMFLOW CHARTThe process of drawing a flowchart is known as the flow charting.SYMBOLS USED IN FLOWCHARTTERMINAL: – 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.StartRead PageSelect pageWebsite HomeValidEnter Id & PwdLoginCheck Id & PwdInvalidOrder ListView Order DetailAdd/View ProductAdd/View CategoryAdmin ProfileSearch ProductCategoryView DetailSearch ProductNow OrderTrack OrderContact UsFeedbackView member ListView Feedback ListStop6.5 DATA FLOW DIAGRAMThese 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 systemDFD SymbolsIn 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 DBZero Level:-Buyer/VisitorAdministrator Vegetable Store WebsiteFirst level (Visitor / Buyer):Vegetable Store DBCustomerWebsite HomeContact DBProduct DBOrder ProductSearch ProductSearch WebsiteSearch Item Category Category DBOrder Info DBCheck Order StatusOrder Info DBContact us / FeedbackManager DBFirst level (Admin): Verify LoginAdminLogin Add / View Item CategoryComplaint DBOrder Info DBComplaint List PageView Order ListView Member Customer Category DBAdd / View Product Info Product DB Customer DBE-R DiagramUser name PasswordRemarkCatidCatname User id E-mail AdminCategory InfoFidFeedback infoE-mailSubjectPersonMessageSetup RelationOrder nameOrder dateM NameOrder idPIDPnameMobileOrder infoAddress Product InfoPpriceDiscountPay amt E-mailPimageBatch codeStatusOrder Item InfoBuy Item RelationOrder IdProductDiscountPriceDel chargeOrderitemid Total amountCHAPTER -7SYSTEM IMPLEMENTATIONImplementation 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 DESIGNBASKET INFOCATEGORYITEM INFOLOGIN INFOORDER INFOORDER PRODUCT INFOQUERY INFODATA DICTIONARYBasket 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, orderstatusOrder 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 SCREENSHOME SCREENABOUT USSEARCH SCREENFEEDBACK SCREENCONTACT US SCREENTRACK ORDER SCREENMY ORDER SCREENADMIN LOGIN SCREENADMIN HOME SCREENCATEGORY SCREENITEM SETUP SCREENORDER LIST SCREENFEEDBACK LIST SCREENCHAPTER-8LIMITATIONSList 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-9CONCLUSIONAt 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 PROJECTIt 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-10REFERENCESGoogle 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.

x

Hi!
I'm Mary!

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

Check it out