5 Pages with references. Create a test plan.++See attachments for more info/background for creating test plan.++Paper should include the following:· A description of the test plan for your pro

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.

5 Pages with references. Create a test plan.++See attachments for more info/background for creating test plan.++Paper should include the following:· A description of the test plan for your pro 1

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.

5 Pages with references. Create a test plan.++See attachments for more info/background for creating test plan.++Paper should include the following:· A description of the test plan for your pro 2

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.