I found an awesome tool of JetBrains IDEA plugin
https://plugins.jetbrains.com/plugin/24593-daogenerator
It can not only generate DAO classes based on database schema, but also can generate DAO according to query statement and master-detail tables.
Please take a look and try it.