3 Pages with references. Use attachments A and B to answer the below.Prepare a document which describes the development and deployment plan for your project. Your development cycles should conform to
PART 1
Prototype for the integrated system of Online Store’s business process of payment/checkout
The online store website’s business process of payment/checkout in the form of customer interface is designed in correspondence to shopping process and Web server in the form of administrative module is utilized for management procedures. The database involvement and utilization in undoubtedly an inevitable component of the whole particular business process of the online store. The prototype of Online Store’s payment process is based on WAP (Wireless Application Protocol) as the distribution process of the logistic functions involves more intricate and complex development procedures. The prototype of Online Store’s process based on WAP’s customer interface creates a dynamic service in order to facilitate customers in buying products or services of the store. The administrative module facilitates the managers or administrators by providing them the authority of manipulating the customer interface besides updating the records of store’s employees. The same module provides connector for storing the data of customers in the database system. Moreover, the edited or updated information of store’s items/products is also saved in the database system.
Basic Visual Interface to support navigation of the program
The navigation along the program is available in a user friendly way as it is designed in accordance with the principles and standards defined for efficient human-computer interface designs. The option like homepage, shop, about, and career are placed in the above horizontal tabs whereas the sliding bar can be used to navigate through the program in vertical direction.
Future functionality of the Application
Functionality is the key to the future of web applications as they need to be continuously updated with the changing modern trends. The application lacking in upgrades are discarded by the users and their demand becomes trifling which affects the business of their manufacturers. The integrated system designed for the payment process of online store is enriched with such options that it can be constantly upgraded and amended in the future in accordance with the shifting requirements of the users.
Identification of stubs to connectivity points for subsystems
The figure 2 shows the integrated system for online store’ business process of checkout/payment in which many external routes are identified which constitute a major portion of topology database. The advertisements in such areas that are not linked with outside network can be suppressed so that the amount of memory utilized by the nodes can be reduced.
The stub areas are used to control the advertisement of external routes into specific areas. The area 0.0.0.3 in the above figure is not in direct connection with any outside network. This area can be designated as stub area so that the size of the database topology can be minimized by limiting the route entries to only such routes that are internal to this stub. The area 0.0.0.4 also has no external connections but has static customer routes that are not the internal routes. However the external routes from the other areas cannot be advertised within the boundaries of other stubs.
Code with comments (Checkout process)
import java.io.*; // initializing input and output for java Library
import java.sql.*; // initializing SQL
import javax.servlet.*;
import javax.servlet.http.*;
public class chkout extends HttpServlet // checkout class created
public void doGet(HttpServletRequest req,HttpServletResponse res) throws ServletException,IOException
{
Connection con; // connection generation
Statement stmt;
ResultSet rs;
res.setContentType("text/html");
PrintWriter pw=res.getWriter();
try
{ // class for the customer data like name
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:sri","scott","tiger");
//pw.println("Connection Established and Driver Loaded");
stmt=con.createStatement();
String qry="select * from cart"; // cart selected by the customer for adding items
rs=stmt.executeQuery(qry);
//pw.println("Statement Prepared and Executed...");
pw.println("<pre><b><font size=6>"+"\t\t\t"+"<u>"+"BILL"+"</pre></u></b></font>");
//pw.println("<form action=\"http://localhost:8080/servlet/addcart\" method=post>");
pw.println("<br><font size=4><b>"); // font size of 4 selected
pw.println("<pre>"+"ITEM NAME\t\t\tQUANTITY\t\tRATE\t\tVALUE"+"</pre></font></b>"); // for printing customer items’ data on screen like ITEM, NAME, QUANTITY, RATE, and VALUE
while(rs.next()) //while condition for initialing the list
{
String t=rs.getString(1);
int len=t.length();
len=40-len;
String s=" ";s=s.concat(t);
len=t.length();
for(int i=len;i<40;i++)
s=s.concat(".");
t=rs.getString(2);
s=s.concat(t);
len=t.length();
for(int i=len;i<8;i++) // for loop for length
s=s.concat(".");
t=rs.getString(3);
len=t.length();
s=s.concat(t);
pw.println(s);
for(int i=len;i<8;i++) // for loop executed for items list
s=s.concat(".");
int n1=Integer.parseInt(rs.getString(2));
int n2=Integer.parseInt(rs.getString(3));
int n=n1*n2; // variable n formula declaration
pw.println(s);
/*s=s.concat(String.valueOf(n));
pw.println(s+"\t "+n);
pw.println(s+"<br>");*/
}
int r=stmt.executeUpdate("delete cart"); // reset the cart option
pw.println("Now your cart is empty");
r=stmt.executeUpdate("update reges set flag='n' where flag='y'");
catch(ClassNotFoundException e){} // no record class
catch(SQLException e){}
/*finally
try
{ if (con!=null) // if condition applied for null values
con.close();
}catch(SQLException e){}}*/
} // main program ends
External System Requirements
User Interface: The user will get two pages with one page of login and other of the shopping options available.
Software Requirement: The user must utilize windows or Linux operating system that can efficiently support networking.
Hardware Requirement: The processor of the hardware must be above Pentium one with minimum RAM of size 128 MB.
Identification of key parts of the Application
The key parts of the application include log in page for existing members/users, sign up page for new users, payment settings options in which account details and other required information is collected, list of available items, available carts, billing of items purchased, delivery procedures to home, promotions of new offers and products in the form of newsfeeds and advertisements, and a section for customers’ feedback.
Summary of how the prototype shows proof-of-concept for the project
STATUS (Summary of current status of the project)
The project at this stage is fully documented with all the required diagrams of uml made. The requirements gathering phase is also complete. The code of the required business process is written besides the completion of the interface’s design of the application.
PART 2
Alpha Version of the Project
Receiving orders
import java.io.*; // Java input output library
import java.sql.*; // sql declaration
import javax.servlet.*;
import javax.servlet.http.*; // connection to hyper text protocol
public class albbut extends HttpServlet
public void doGet(HttpServletRequest req,HttpServletResponse res) throws ServletException,IOException
{
Connection con=null; // connection set to default null
Statement stmt=null;
ResultSet rs=null;
res.setContentType("text/html");
PrintWriter pw=res.getWriter();
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:sri","scott","tiger");
stmt=con.createStatement();
String alph=req.getParameter("albsrh");
String qry="select * from items where title like alph and type='a' ";
rs=stmt.executeQuery(qry);
pw.println("<font size=6><pre><b> <u>TITLE </u> <u>PRICE</b></u></pre>");
pw.println("<br>");
pw.println("<form action=\"http://localhost:8080/addcart\" method=post>");
pw.println("<font size=3><input type=submit value=Add_to_Cart>");
pw.println("<input type=submit value=Check_Out></font>");
pw.println("<select name=bch size=5 >");
while(rs.next())
{
String t=rs.getString("title");
int len=t.length();
len=40-len;
String s=" ";s=s.concat(t);
//for(int i=0;i<len;i++)
s=s.concat(" - ");
s=s.concat(rs.getString("order"));
pw.println("<option>"+s+"</option><br>");
}
pw.println("</select>");
pw.println("</form></font>");
catch(ClassNotFoundException e){}
catch(SQLException e){}
finally
try
{ if (con!=null)
con.close(); // condition closed
}catch(SQLException e){}}
} // end of main program
Invoicing
import java.io.*; // java input output library
import javax.servlet.*;
import javax.servlet.http.*; // connection to net server
import java.sql.*;
public class cartlist extends HttpServlet
public void doGet (HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
{
Connection con=null; // default connection set to null
Statement stmt=null;
ResultSet rs=null;
res.setContentType("text/html"); // content type declaration
PrintWriter out=res.getWriter();
String qry="select * from cart";
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:sri","scott","tiger");
stmt=con.createStatement();
rs=stmt.executeQuery(qry); // query execution
out.println(qry);
if(rs.next())
{
out.println("Your cart is empty");
System.exit(0);
}
out.println("You currently have the following items in your cart:<br>");
out.println("<ul>");
while(rs.next())
{
String t=rs.getString(1);
int len=t.length();
len=40-len;
String s=" ";s=s.concat(t);
len=t.length();
for(int i=len;i<40;i++)
s=s.concat(".");
t=rs.getString(2);
len=t.length();
s=s.concat(t);
s=s.concat("\t");
t=rs.getString(3);
s=s.concat(t);
out.println("<li>"+s+"</li>");
}
out.println("</ul>");
//out.println("<form action=\"http://localhost:8080/servlet/addcart\" method=post>");
out.println("Would you like to <br>");
// out.println("<input type=submit value=\"Add More Items\"></form>");
out.println("<form action='http://localhost:8080/servlet/chkout' method=get>");
out.println("<input type=submit value=\"Check Out\">");
out.println("</form>");
out.println("</body></html>");
catch(ClassNotFoundException e){System.out.println("In catch1");}
catch(SQLException e){System.out.println("In catch2");}
Shipping of Goods and Services
import java.io.*; // java input output library declaration
import java.sql.*; // sql declaration
import javax.servlet.*;
import javax.servlet.http.*;
public class nrel extends HttpServlet
public void doGet(HttpServletRequest req,HttpServletResponse res) throws ServletException,IOException
{
Connection con=null; // connection set to null
Statement stmt=null;
ResultSet rs=null;
res.setContentType("text/html");
PrintWriter pw=res.getWriter();
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:sri","scott","tiger");
stmt=con.createStatement();
String qry="select title,author,pname,subject,rate from books where rownum<11 order by dop desc ";
rs=stmt.executeQuery(qry);
pw.println("<br>");
pw.println("<pre><b><font size=6>"+"\t\t\t"+"<u>"+"ALPHBATICAL LIST OF ITEMS"+"</pre></u></b></font>");// displays the list of items to be shipped
pw.println("<form action=\"http://localhost:8080/servlet/addcart\" method=post>");
pw.println("<br><font size=4><b>");
pw.println("<pre>"+"CITY\t\t\t\tAREA\t\t\t\tSTREET\t\t\House\t\t PERSON\t\t\t"+"</pre></font></b>");
//pw.println("<pre><select name=selectbk size=5>");
while(rs.next())
{
String t=rs.getString(1);
int len=t.length();
len=40-len;
String s=" ";s=s.concat(t);
len=t.length();
for(int i=len;i<40;i++)
s=s.concat(".");
t=rs.getString(2);
s=s.concat(t);
len=t.length();
for(int i=len;i<40;i++)
s=s.concat(".");
t=rs.getString(3);
len=t.length();
s=s.concat(t);
for(int i=len;i<40;i++)
s=s.concat(".");
t=rs.getString(4);
s=s.concat(t);
len=t.length();
for(int i=len;i<40;i++)
s=s.concat(".");
t=rs.getString(5);
s=s.concat(t);
pw.println("<option>"+s+"</option><br>");
}
//pw.println("</pre></select></font>");
pw.println("<pre> Selected items</pre>");
pw.println("<pre><label> Item name: </label><input type=text name=txtinm></pre>");
pw.println("<pre><label> Item Quantity: </label><input type=text name=txtq></pre>");
pw.println("<pre><label> Item type: </label><input type=text name=txtr></pre>");
pw.println("<pre><label> Please enter N/h for Normal delivery U/u for Urgent delivery M/m for Music B/b for Books</pre></label>");
pw.println("<font size=3><br><br><input type=submit value=Add_to_Cart></font></form>");}
catch(ClassNotFoundException e){}
catch(SQLException e){}
finally
try
{ if (con!=null)
con.close();
}catch(SQLException e){}}
Customer Relations
import java.io.*; // java input output declaration
import java.sql.*; // sql library declaration
import javax.servlet.*;
import javax.servlet.http.*;
public class hware extends HttpServlet
public void doGet(HttpServletRequest req,HttpServletResponse res) throws ServletException,IOException
{
Connection con=null; ‘ default connection set to null
Statement stmt=null;
ResultSet rs=null;
res.setContentType("text/html");
PrintWriter pw=res.getWriter();
try
{ // class body
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:sri","scott","tiger");
stmt=con.createStatement();
String alph=req.getParameter("hwsrh");
String qry="select iname,make,rate from hware where iname like '"+alph+"' ";
rs=stmt.executeQuery(qry);
pw.println("<pre><b><font size=6>"+"\t\t\t"+"<u>"+"LIST OF SELECTED PRODUCTS"+"</pre></u></b></font>"); // displays the list of items purchased
pw.println("<form action=\"http://localhost:8080/servlet/addcart\" method=post>");
pw.println("<br><font size=4><b>");
pw.println("<pre>"+"ITEM NAME\t\tSPECIFICATIONS\t\t\t\t\t\t\t\tRATE"+"</pre></font></b>");
//pw.println("<pre><select name=selectbk size=5>");
while(rs.next())
{
String t=rs.getString(1);
int len=t.length();
len=40-len;
String s=" ";s=s.concat(t);
len=t.length();
for(int i=len;i<20;i++)
s=s.concat(".");
t=rs.getString(2);
s=s.concat(t);
len=t.length();
for(int i=len;i<100;i++)
s=s.concat(".");
t=rs.getString(3);
s=s.concat(t);
pw.println("<option>"+s+"</option><br>");
}
pw.println("<pre> Selected items</pre>");
pw.println("<pre><label> Item name: </label><input type=text name=txtinm></pre>");
pw.println("<pre><label> Item Quantity: </label><input type=text name=txtq></pre>");
pw.println("<pre><label> Item type: </label><input type=text name=txtr></pre>");
pw.println("<pre><label> Please enter H/h for Hardware S/s for Software M/m for Music B/b for Books</pre></label>");
pw.println("<font size=3><br><br><input type=submit value=Add_to_Cart></font></form>");
catch(ClassNotFoundException e){}
catch(SQLException e){}
finally
try
{ if (con!=null)
con.close();
}catch(SQLException e){}}
Updating employee Information
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class register extends HttpServlet
public void doGet(HttpServletRequest req,HttpServletResponse res) throws ServletException,IOException
{
PrintWriter pw=res.getWriter();
String uid =req.getParameter("uid");
String pwd= req.getParameter("pwd");
Connection con=null;
Statement stmt=null;
ResultSet rs=null;
res.setContentType("text/html");
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:sri","scott","tiger");
stmt=con.createStatement();
//String qry="insert into reges(userid,passward) values ('"+req.getParameter("uid")+"','"+req.getParameter("pwd")+"','"+req.getParameter("hques")+"','"+req.getParameter("hans")+"','"+req.getParameter("fname")+"','"+req.getParameter("lname")+"','"+req.getParameter("dd")+"-"+req.getParameter("mm")+"-"+req.getParameter("yy")+"','"+req.getParameter("add")+"','"+req.getParameter("city")+"','"+req.getParameter("pin")+"','"+req.getParameter("state")+"','"+req.getParameter("country")+"','"+req.getParameter("ccdnm")+"','"+req.getParameter("ccdno")+"','"+req.getParameter("email")+"')";
String qry="insert into reges(userid,passward) values('"+uid+"','"+pwd+"')";
pw.println(qry);
int b=stmt.executeUpdate(qry);
pw.println("<a href='c:/sriren/prodlist1.html'>DoShopping</a>");
}
catch(Exception e){e.printStackTrace();}
/*pw.println("<a href='c:/sriren/prodlist1.html'>DoShopping</a>");*/
}
Functional connection to the required database
create table reg (usrid varchar2(10) constraint uid_pk primary key,pwd varchar2(10) not null,
hque varchar2(20),hans varchar2(10),fname varchar2(10) not null,lname varchar2(10) not null,
dob date not null,add varchar2(10) not null,city varchar2(10) not null,pin number(6) not null,
state varchar2(10) not null,country varchar2(10) not null,ccname varchar2(10) not null,
ccno varchar2(10) not null,email varchar2(30) not null);
create table items (tno number(4) constraint tno_pk primary key,title varchar2(10) not null,
dop date not null,subject varchar2(10) not null,pname varchar2(10) not null,nocs number(3) not null,
rate number(7,2)not null);
create table bill (cdno number(4) constraint cdno_pk primary key, type varchar2(1) not null,
title varchar2(10) not null, dor date not null, artist1 varchar2(10) not null,artist2 varchar2(10) not null,
nocs number(3) not null, s1 varchar2(10) not null,s2 varchar2(10) not null, rate number(7,5) not null);
create table adress(ino number(4) constraint hino_pk primary key,iname varchar2(10) not null,
make varchar2(50) not null, rate number(7,2) not null);
create table shippment (ino number(4) constraint sion_pk primary key,iname varchar2(10) not null,
make varchar2(50) not null);
create table cart (usrid varchar2(10) constraint cuid_pk primary key,
ino number(4) not null,iname varchar2(10) not null,
qty number(2) not null, rate number(7,2) not null);
External System Requirements
User Interface: The user will get two pages with one page of login and other of the shopping options available. Then he can view the invoice generated by the application.
Software Requirement: The user must utilize windows or Linux operating system that can efficiently support networking along with an efficient internet connection.
Hardware Requirement: The processor of the hardware must be above Pentium one with minimum R.A.M of size 128 MB that can effectively support any internet browser like Google chrome or Mozilla Firefox.