final TypeHandlerRegistry registry = config.getTypeHandlerRegistry();
final SqlSource sqlSource = new StaticSqlSource(config,"SELECT b.id, b.author_id, b.title, a.username, a.password, a.email, a.bio" +
" FROM blog b" +
" INNER JOIN author a ON b.author_id = a.id" +
" WHERE b.id = ? and a.id = ?");
final ParameterMap parameterMap = new ParameterMap.Builder(config, "defaultParameterMap", Map.class,
new ArrayList<ParameterMapping>() {
{
add(new ParameterMapping.Builder(config, "blogId", registry.getTypeHandler(int.class)).build());
add(new ParameterMapping.Builder(config, "authorId", registry.getTypeHandler(int.class)).build());
}