Software Requirements Specifications Document

1) Introduction:

1.1)

Purpose: This project is aimed at developing online book shopping that is of significant to those people who use internet .It is an application that can be access by all the people and can save their time instead of doing traditional shopping .Online –shopping is the process consumers go through to purchase products or services over the Internet . An online- shop , e-shop , e-store , internet shop, web shop , web store, online store, or virtual store evokes the physical analogy of buying products or services .Consumers find a product of interest by visiting the website or do a search across many different vendors using a shopping search engine. There are many features like : 1) Add item to cart 2) Delete item from cart 3) Total amount display 4) Bill printing 5) payment through credit card or cash payment on delivery options.

1.2)

Technologies: Operating system: Database:

Windows (any) SQL Server

Page 1

Software Requirements Specifications Document

Frame Work:

1.3)

JAVA 2 Enterprise Edition

Feasibility study:

In order to make sure that the project is feasible, following feasibility studies have been conducted: -

• Economic & financial Feasibility study Economic feasibility study is a measurement of cost effectiveness of the project. This project is going to be developed at sufficient Cost so that it will be acceptable by all the client that need such type of application.

• Technical Feasibility Study It is possible to develop the system using platforms of i.e. Java 2 Enterprise Edition as front-end and Microsoft SQL Server 2005 as back-end. All the functions of a traditional online book shopping can be implemented in the new system. Hence the system is technically feasible.

• Operational Feasibility Study This system is completely operational and can be successfully implemented in any plate-form .

• Legal Feasibility Study Page 2

Software Requirements Specifications Document

Since this project needs no copyrighting, patenting, and doesn’t intent to have any relation with anybody else’s intellectual property rights, it can be considered as a legally feasible project.

1.4) Proposed Solution: Due to the inconvenience in managing the book manually .It is required to have a computer based system where an person can & can purchase book as per his requirement . Firstly have to so that he can himself and can his so that he can from his and name . He can see all the items that he has purchased and can delete from cart if he wants. can well check the total Bill that he has to pay and can get printed copy of that.

2) Specific Requirements:

2.1) Functionality There are number of functions that the application is supposed to perform which are as follows: •

Firstly have to for that he/she have to him/her self , So for that there will be a

Page 3

Software Requirements Specifications Document

Sign Up page where have to fill the entries like name and . •

There will be page / page where have to with their name and .

•

There will be Book searching option on any category (e.g. - title of the book, author, edition, price, etc).

•

After that there will be a book section page will be open where can choose book according to their choice.

•

Maintaining records for books (e.g. books details, title of the book, author, edition, price etc)

•

All the books that have chosen will add-up to the Cart and if want to delete any option than he/she can delete it by just clicking on the delete button.

•

To see the total bill of the book items that have selected for that he/she have to click on the bill option then total bill of the item selected will be displayed to the .

•

To purchase the books there will be two option given to the through on Cash payment or through Debit .

•

In last can log-out, just by clicking on the button.

3) Overall Description: 3.1) Software Interface: Client on Internet: Operating System (any) Data Base Server:

Database, Operating System (any) Page 4

Software Requirements Specifications Document

Software used :

Net Beans , Micromedia Dream Viewer .

3.2) Hardware Interface: Client Side/Server side Minimum requirement Processor - Pentium IV at 900 MHz RAM -1 GB Disk Space- 10 GB Internet Explorer 8.0

Page 5

Software Requirements Specifications Document

3.3) CONTROL FLOW DIAGRAM:

Page 6

Software Requirements Specifications Document

DataBase Content:

Page 7

Software Requirements Specifications Document

Page 8

Software Requirements Specifications Document

ER-DIAGRAM

Page 9

Software Requirements Specifications Document

Page 10

Software Requirements Specifications Document

SNAPSHOTS

Page 11

Software Requirements Specifications Document

Page 12

Software Requirements Specifications Document

Page 13

Software Requirements Specifications Document

Page 14

Software Requirements Specifications Document

Page 15

Software Requirements Specifications Document

Page 16

Software Requirements Specifications Document

Page 17

Software Requirements Specifications Document

Page 18

Software Requirements Specifications Document

CODING /* * .java * * Created on July 13, 2009, 10:09 AM */ package pack; import java.io.*; import java.net.*; import javax.servlet.*; import javax.servlet.http.*; import utility.ConnectionService; import java.sql.*; /** * * @author Eshan Gupta * @version */ public class extends HttpServlet { /** Processes requests for both HTTP GET and POST methods. * @param request servlet request * @param response servlet response */ protected void processRequest(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { //response.setContentType("text/html;charset=UTF-8");

String 1=request.getParameter(""); String 1=request.getParameter(""); PrintWriter out = response.getWriter();

HttpSession s1=request.getSession(); s1.setAttribute("",1); ResultSet ss=ConnectionService.select("select * from where ='" + 1 + "' and name='"+ 1 + "'"); Page 19

Software Requirements Specifications Document try { if(ss.next()) { response.sendRedirect("Option"); } else { // response.sendRedirect("Invalid"); out.print("

INVALID 1v5ip

"); RequestDispatcher rs=request.getRequestDispatcher("Home.html"); rs.include(request,response); } } catch (SQLException ex) { ex.printStackTrace(); }//try out.close(); } // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code."> /** Handles the HTTP GET method. * @param request servlet request * @param response servlet response */ protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { processRequest(request, response); } /** Handles the HTTP POST method. * @param request servlet request * @param response servlet response */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { processRequest(request, response); } /** Returns a short description of the servlet. */ public String getServletInfo() { return "Short description"; } // }

Page 20

Software Requirements Specifications Document /* * Magazine.java * * Created on July 13, 2009, 11:35 AM */ package pack; import java.io.*; import java.net.*; import javax.servlet.*; import javax.servlet.http.*; import utility.ConnectionService; import java.sql.*; /** * * @author Eshan Gupta * @version */ public class Magazine extends HttpServlet { /** Processes requests for both HTTP GET and POST methods. * @param request servlet request * @param response servlet response */ protected void processRequest(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html;charset=UTF-8"); PrintWriter out = response.getWriter(); HttpSession s1=request.getSession(false); if(s1!=null) { out.print(""); out.print(""); // out.print("

HELLO!"+s1.getAttribute("")+" d3n5b

"); out.print("

WELCOME TO ONLINE BOOK SHOPPING 292r1z

"); out.print(""); out.print("

WELCOME 5pqn

"); out.print("

<marquee direction=up>Magazine Books World 6z5g37

"); out.print("

SignOUT x5c2q

"); try { String query="select * from book where type='magazine'"; Page 21

Software Requirements Specifications Document ResultSet rs = ConnectionService.select(query); out.print("

"); out.print("

"); out.print(" "); while(rs.next()) { String p1=rs.getString(1); String p2=rs.getString(2); String p3=rs.getString(3); String p4=rs.getString(4); String p5=rs.getString(5); String p6=rs.getString(6); //out.print(" "); ///String r=rs.getString(3); out.print(" "); //out.print(" "); } out.print("

Book_id	Type	Book_name	Author	Publication< /th>	Price	Choice
	"+rs.getString(4)+"
"+p1+"	"+p2+"	"+p3+"	"+p4+"	"+p5+"	"+p6+"
"+rs.getString(1)+"	"+rs.getString("type") +"	"+r+"		jlkjl	vjhvgjh

"); out.print(""); out.print("

"); }catch(Exception e){} } else { out.print("

Please to get this page 412b31

"); }

out.close(); } // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code."> /** Handles the HTTP GET method. * @param request servlet request * @param response servlet response */ protected void doGet(HttpServletRequest request, HttpServletResponse response) Page 22

Software Requirements Specifications Document throws ServletException, IOException { processRequest(request, response); } /** Handles the HTTP POST method. * @param request servlet request * @param response servlet response */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { processRequest(request, response); } /** Returns a short description of the servlet. */ public String getServletInfo() { return "Short description"; } // }

/* * Option.java * * Created on July 13, 2009, 10:17 AM */ package pack; import java.io.*; import java.net.*; import javax.servlet.*; import javax.servlet.http.*; import javax.xml.ws.Response; /** * * @author Eshan Gupta * @version */ public class Option extends HttpServlet { /** Processes requests for both HTTP GET and POST methods. * @param request servlet request * @param response servlet response */ protected void processRequest(HttpServletRequest request, HttpServletResponse response) Page 23

Software Requirements Specifications Document throws ServletException, IOException { response.setContentType("text/html;charset=UTF-8"); PrintWriter out = response.getWriter(); HttpSession s1=request.getSession(false); if(s1!=null) { out.print(""); out.print(""); out.print("

HELLO!"+s1.getAttribute("")+" d3n5b

"); out.print("

WELCOME TO ONLINE BOOK SHOPPING 292r1z

"); out.print(""); out.print("

Computer Books 4f651b

"); out.print("

Magazine Books e455t

"); out.print("

Engineering Books 161z38

"); } else { out.print("

Please to get this page 412b31

"); } out.close(); } // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code."> /** Handles the HTTP GET method. * @param request servlet request * @param response servlet response */ protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { processRequest(request, response); } /** Handles the HTTP POST method. * @param request servlet request * @param response servlet response */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { processRequest(request, response); } /** Returns a short description of the servlet. */ Page 24

Software Requirements Specifications Document public String getServletInfo() { return "Short description"; } // }

/* * Remove.java * * Created on July 13, 2009, 11:11 PM */ package pack; import java.io.*; import java.net.*; import javax.servlet.*; import javax.servlet.http.*; import java.sql.*; import utility.ConnectionService; import java.util.*;

/** * * @author Eshan Gupta * @version */ public class Remove extends HttpServlet { /** Processes requests for both HTTP GET and POST methods. * @param request servlet request * @param response servlet response */ protected void processRequest(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html;charset=UTF-8"); PrintWriter out = response.getWriter(); HttpSession s1=request.getSession(false); if(s1!=null) { out.print(""); out.print("HELLO!"+s1.getAttribute("")+"
"); out.print("

" +s1.getAttribute("op1")+ " 2v3x6s

"); out.print("

"); Page 25

Software Requirements Specifications Document out.print("







"); out.print(" "); for(Object ob:(ArrayList)s1.getAttribute("op1")) { String query1="select * from book where book_name='" +ob+ " ' "; ResultSet rs=ConnectionService.select(query1); try { while(rs.next()) { String p1=rs.getString(1); String p2=rs.getString(2); String p3=rs.getString(3); String p4=rs.getString(4); String p5=rs.getString(5); String p6=rs.getString(6); //out.print(" "); ///String r=rs.getString(3); out.print(" "); }//while }catch (SQLException ex) { ex.printStackTrace(); }//for } out.print("

Book_id	Type	Book_name	Author	Publication	Price	Choice
	"+rs.getString(4)+"
"+p1+"	"+p2+"	"+p3+"	"+p4+"	"+p5+"	"+p6+"

"); out.print(""); out.print("

");

Page 26

Software Requirements Specifications Document out.print("

Generate Bill 612r6f

"); } else { out.print("Please to get Page"); }

out.close(); } // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code."> /** Handles the HTTP GET method. * @param request servlet request * @param response servlet response */ protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { processRequest(request, response); } /** Handles the HTTP POST method. * @param request servlet request * @param response servlet response */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { processRequest(request, response); } /** Returns a short description of the servlet. */ public String getServletInfo() { return "Short description"; } // }

Page 27