Proposed Website By Raymond Chieng and Tim This

Proposed Website By Raymond Chieng and Tim

This website design is based on a local Chinese restaurant which basically need to facilitate online ordering and table reservations. Netbeans is the software mainly used to build this website. In relation to this project, the following will be explained: � Requirements � Design � Code � Testing

� The purpose of the requirements documentation is to get a better understanding and help the design of the project from different stakeholders. � The requirements are generated from -Customers -Administrators -Bank -System

� Technology - applied JDBC (Java Database Connectivity) JSP (Java Server Page) HTML (Hypertext Markup Language) CSS (Cascading Style Sheet)

Establish a JDBC Connection – 2 steps 1. Loading the JDBC driver - A line of code Class. for. Name(“org. apache. derby. jdbc. Client. Driver”); - Class. for. Name – is used to create an instance of a driver and register it with the Driver. Manager. When you have loaded a driver, it is available for making a connection with a DBMS (Database Management System). � 2. Making the connection - To establish a connection you need to have the appropriate driver connect to the DBMS. - Connection con = Driver. Manager. get. Connection ("jdbc: derby: //localhost: 1527/ROWINNROW"); � Create JDBC statements - You create a Statement object and then execute it, supplying the appropriate execute method with the SQL - Statement stmt = con. create. Statement();

Black box testing – based on requirement document � Use test cases to get actual results, comparing to the expected results � Example of a Test Case: Test Case #: 14 Objective: Login with wrong username Input(s): ” raymon”; “ 1234”; click “login”button Expected Output: Alert message and can not log in Requirement tested: WS-1001; WS-1002; WS-2001 � Example of Test Result Actual Output: Message of “User Name not found Try again” comes up; Can not login Result: Pass �

�A practical project of setting up a website for restaurant/ catering business � Useful techniques: JDBC, JSP, CSS, HTML � Problem Solving – google; related journals or articles; consulting friends/teamwork � Need good Project planning – time related, effect related, need good teamwork