(select id="listInvoiceRecord" resultMap="invoiceMapper")

                 (foreach collection="tableNames" item="tableName" index="index" open="" close="" separator="union all")

                         SELECT a.* FROM   ${tableName} a

                         (include refid="where_of_listInvoiceRecord_and_countInvoiceRecord"/)

                 (/foreach)

                 (if test="timeType == 0 ")

                         ORDER BY dt_adddate DESC

                 (/if)

                 (if test="timeType == 1 ")

                         ORDER BY invoice_time DESC

                 (/if)

        (/select)

将表名以变量的形式传入，查询结果用union all拼接，完全不用任何分表框架，实现ok