(Spring Boot)Daoの実装
Daoの実装。
Java
package webapp.dao; import java.util.List; import org.seasar.doma.Dao; import org.seasar.doma.Select; import org.seasar.doma.boot.ConfigAutowireable; import webapp.entity.Author; import webapp.entity.Book; @ConfigAutowireable @Dao public interface WebAppDao { @Select public List<Author> selectAuthor(int authorId); @Select public List<Book> selectAuthorBooks(int authorId); }
SQLファイル
selectAuthor.sql
SELECT ID , NAME , BIRTH_DAY FROM authors WHERE ID = /* authorId */1 ;
selectAuthorBooks.sql
SELECT ID , TITLE FROM books WHERE AUTHOR_ID = /* authorId */1 ORDER BY ID ASC ;