1 / 7

Row Inn Row Chinese Restaurant

Row Inn Row Chinese Restaurant. Proposed Website By Raymond Chieng and Tim. Introduction. 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.

pomona
Download Presentation

Row Inn Row Chinese Restaurant

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Row Inn Row Chinese Restaurant Proposed Website By Raymond Chieng and Tim

  2. Introduction 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

  3. Requirements • 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

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

  5. JDBC Code • Establish a JDBC Connection – 2 steps 1.Loading the JDBC driver - A line of code Class.forName(“org.apache.derby.jdbc.ClientDriver”); - Class.forName – is used to create an instance of a driver and register it with the DriverManager. 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 = DriverManager.getConnection ("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.createStatement();

  6. Testing • 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

  7. Conclusion • 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

More Related