Development of a Web Based B&B Reservation System Elizabeth Gates 22 July 04
Introduction n Customer information Reservations Small B&B business
Goals n n n Maintain customer information and reservations for parent’s B&B Learn database and web application programming Research web testing
Project Description n n Web pages Web application
Web Pages n n For potential B&B customers Available to the public Describes the B&B, owners, immediate area, provides directions, and reservation information Has a victorian look and feel
Web Application n n For the B&B owner only Must login Help page and Quick reference guide AddModifyDeleteView customer information AddModifyDeleteView reservation information
Target Customer n n n Small business owner Well educated, intelligent but not necessarily strong computer skills Wants a tool to make running the B&B easier
User Interface n n Consistent and simple Return button to Welcome Page in same place on each page Logout only from Welcome Page Online help only on Welcome Page but on separate page
User Interface (cont’d) n n All valid choices appear on a menu User given flexibility when entering field information
Database n n n Originally MS-Access because it was readily available Changed to My. SQL because more documentation available The purchased version of My. SQL offers more security for servers
Security n n Form-based authentication Login uses j_security_check, j_username, j_password
Web Application Demonstration Questions?
Design Approach n n Servlet-Centric Model View Controller (MVC) Architecture Database Manager Tomcat Servlet Container
Servlet-Centric n n User servlets to handle information flow Presentation Layer = JSPs Business Logic = Servlets Data Access = Database
MVC n n n View Layer = JSPs Control Layer = Servlets Model Layer = Database
MVC (cont’d) n n n Not the simplest but not the most complicated approach Allows handling of session management, data flow and database access more efficiently Separation of tasks for large project
Database Manager n n n Single access point (singleton class) Error Checking Ties tables together
Database Manager (cont’d) n n n Beans Class for each database table Database. Mgr class
Testing Approach n n n Black Box Testing Automated Test Suite Free
Web Test Research n n n Web Site Management Tools Load & Performance Test Tools Link Checking Tools Web Security Tools Language Specific Web Test Tools
Web Test Research (cont’d) n n n Web. Walker JUnit Http. Unit Servlet. Unit Test. Collector
JUnit & Http. Unit n n Unit tests for Java for white box testing Http. Unit extends JUnit to create automated test suites for web applications
Http. Unit (cont’d) n n Class to replace the browser Verify links Verify forms (number, action, fields) Verify buttons
Test Issues n n n Testers must have knowledge of code Tests break because of change to submit buttons Tests break because of web page sequence changes
Test Issue Solutions n n Black box testing tradeoffs Unique ID created for each form The “Return to Welcome Page” button form has same ID for each page DB test suite
Lessons Learned n DB testing not very effective during development n n Didn’t understand servlets and JSPs Couldn’t get vertical slice to verify design early
Lessons Learned n JSPs and Servlets complicated n n Takes a lot of code and communication between servlets and JSPs to get a small application to run Went back to clean up code after better understanding
Lessons Learned n DB Manager Class works well only for small-medium sized project n n n Becomes too large Need a different design for large project Used to maintain a single point of access and handle DB error checking
Lessons Learned n Credit Card Security n n n Important for B&B owner to keep CC information Form-based authorization can specify SSL for file access Encryption of data in DB May cost money Requires B&B owner’s input
Web Test Suite Demonstration Questions?
Скачать презентацию Development of a Web Based B B Reservation System
8df0e20dcf2b9b930f3abf6267173df8.ppt