Learn Java for Web Development

CHAPTER 5: Building Java Web Applications with Spring Web MVC 223

public interface BookDAO {
public List findAllBooks();

}

Listing 5-26 illustrates the BookDAO implementation.

Listing 5-26. BookDAO Implementation

1. package com.apress.books.dao;


2. 
   


3. import java.sql.Connection;


4. import java.sql.DriverManager;


5. import java.sql.PreparedStatement;


6. import java.sql.ResultSet;


7. import java.sql.SQLException;


8. import java.sql.Statement;


9. import java.util.ArrayList;


10. import java.util.List;


11. 
    


12. import javax.sql.DataSource;


13. 
    


14. import org.springframework.beans.factory.annotation.Autowired;


15. import org.springframework.jdbc.core.JdbcTemplate;


16. 
    


17. import com.apress.books.model.Author;


18. import com.apress.books.model.Book;


19. import com.apress.books.model.Category;


20. 
    


21. public class BookDAOImpl implements BookDAO {


22. 
    


23. 
    


24. DataSource dataSource;


25. 
    


26. 
    


27. public void setDataSource(DataSource dataSource) {


28. this.dataSource = dataSource;


29. }


30. 
    


31. public List findAllBooks() {


32. List bookList = new ArrayList<>();


33. 
    


34. String sql = "select * from book inner join author on book.id = author.book_id";


35. 
    


36. JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);


37. bookList = jdbcTemplate.query(sql, new BookRowMapper());


38. return bookList;


39. }


40. 
    


41. }