private String createGetListBy() {
        StringBuilder sb = new StringBuilder();

        for ( Column column : searchableColumns ) {
            sb.append( "\n" );
            sb.append( TAB );
            sb.append( "<select id=\"getListBy" );
            sb.append( toCamelCase( column.getFldName() ) );
            sb.append( "\" parameterType=\"" );
            sb.append( column.getFldType().toLowerCase() );
            sb.append( "\" resultMap=\"" );
            sb.append( table.getDomName() );
            sb.append( "Mapper\">\n" );

            sb.append( TAB );
            sb.append( TAB );
            sb.append( "select * from " );
            sb.append( table.getTableName() );

            sb.append( "\n" );
            sb.append( TAB );
            sb.append( TAB );

            switch ( databaseType ) {
            case H2:
            case ORACLE:
                sb.append( "where " );
                sb.append( column.getColName() );
                sb.append( " = #{" );
                sb.append( column.getFldName() );
                sb.append( "}\n" );
            }

            sb.append( TAB );
            sb.append( "</select>" );

        }
        sb.append( "\n" );

        return sb.toString();
    }