Mybatis实现动态拼接表名、列名

`
public interface FilmOrderMapper {

@Select("select * from ${tableName} where created_at >= #{start} and created_at<#{end}")
List<FilmOrder> findOrders(@Param("tableName") String tableName,@Param("start") Date start, @Param("end") Date end);

}
`

该方式的劣势是select 结果集无法用引用列方式

列中展示动态非数据库表列结果值
`
public interface FilmOrderMapper {

@Select("select id,price,passport,title,pay_method payMethod,plat,order_sn orderSn," +
        "created_at createdAt ,updated_at updatedAt ,paid_at paidAt ,status,commodity_id commodityId ,memo ," +
        "'${tableName}' as 'tableName' from ${tableName} where created_at >= #{start} and created_at<#{end}")
List<FilmOrder> findOrders(@Param("tableName") String tableName,@Param("start") Date start, @Param("end") Date end);

}
`
字段抽取

`
public interface FilmOrderMapper {

@Select("select "+BASE_COLUMN+
        ",'${tableName}' as 'tableName' from ${tableName} where created_at >= #{start} and created_at<#{end}")
List<FilmOrder> findOrders(@Param("tableName") String tableName,@Param("start") Date start, @Param("end") Date end);


String BASE_COLUMN = "id,price,passport,title,info,pay_method payMethod,plat,order_sn orderSn,created_at createdAt ,updated_at updatedAt ,paid_at paidAt ,granted_at grantedAt," +
        "status,commodity_id commodityId ,privilege_id privilegeId,app_id appId,order_status orderStatus,order_addition orderAddition ,memo ,display_status displayStatus,commodity_amount commodityAmount";

}
`