web programming

BCIS 3680 Assignment 5 Grade Sheet

Points Grades

Creates a session variable to store username 2

JDBC connector file in proper subfolder under \WEB-INF 2 Connection string has correct values for connection (protocol, host, port #, DB name, etc.) 2 Builds connection string correctly 1 Creates Connection and Command objects correctly 2

If table is used, writes header row correctly 1 If table is used, each record is displayed as a table row; each column as a cell in the row 1 Uses proper get???() method to read column values from ResultSet 2 Uses correct methods of out object or JSP expressions to display column values 2

Reads username session variable and displays it 2 SQL statement is correct 2 Sets up navigation to book.jsp

Each bar code is displayed as a hyperlink 1 "href" property of <a> tag includes query string 1 Book barcode is included as a parameter in query string 1

Call number and title are displayed correctly 2 Onloan status is displayed in Yes/No format 2

Correctly retrieves barcode passed from catalog.jsp 2 Title of browser window/tab shows book barcode 1 Reads username session variable and displays it 2 Join SQL statement is correct 4 if statement used to check for empty resultset 2 Message is correctly displayed for a book not on loan 1 Display of book/loan information for a book on loan

Book barcode is displayed correctly 1 Book title is displayed correctly 1 Correct patron name is displayed and has both first and last names 2

Uses include JSP directive to add header and footer to catalog.jsp and book.jsp 2 Database is named <lastName><firstInitial> (e.g., "CaseJ" for Justin Case) 1 Web application runs as required 5

Hard Coding Any hard coding (5 points deduction per occurrence)

Total 50 -

Other (8)

book.jsp (16)

Student:

Presentation of Query Results (6)

catalog.jsp (11)

Database Connection (7)

main.jsp (2)