Building a Web Application Using Struts 2 - Learn Java for Web Development - page 195

15. public String searchByKeyword() {}
16.
17. public String home() {}
18.
19. public String selectedBooks(){}
20.
21. public String logout() {}
22.
23. // getters and setters
24.
25. }
 Line 5 : responsible for displaying the login form.
 Line 7 : authenticates the user against the database.
 Line 9 : displays the error message, for example if the user is invalid.
 Line 11 : lists all the books in the bookstore.
 Line 13 : lists the books by category.
 Line 15 : allows user to search the books by keyword: book title or
author's name.
 Line 17 : displays the home page when clicked on home link.
 Line 19 : displays the list of selected books.
 Line 21 : allows the user to log out.
Login Using Database
Listing 4-40 illustrates the executelogin() method responsible for authenticating user against the
database. For this you need to add the USER table to the data model you developed in chapter 1
using the following DDL:
CREATE TABLE USER(
ID INT NOT NULL AUTO_INCREMENT,
FIRST_NAME VARCHAR(60) NOT NULL,
LAST_NAME VARCHAR(60) NOT NULL,
USERNAME VARCHAR(60) NOT NULL,
PASSWORD VARCHAR(60) NOT NULL,
PRIMARY KEY (ID)
);
Listing 4-40. executelogin( )method in the BookController
1. public String executelogin() {
2. String executelogin = "failed";
3. session = ActionContext.getContext().getSession();
4. dao = new BookDAOImpl();
5. user = new User();
6. user.setUserName(getUsername());