Java Reference
In-Depth Information
public interface BookDAO {
public List<Book> 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<Book> findAllBooks() {
32. List<Book> 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. }
