IBatis的问题，高手请进

Question

1.如何执行动态Sql?比如连表名，条件都是动态的.
2.如何在分页时，得到总的记录数?执行一个"select count(*) from t_sometale"的方法不算。

Answer 1

<select id="searchEvent" parameterClass="SearchKeyDTO" resultClass="Event">
        SELECT * FROM $tablename$
<dynamic prepend="where">
<isNotEmpty prepend="$searchValueList[0].andOr$" property="searchValueList[0].value">
$searchValueList[0].column$ $searchValueList[0].operator$#searchValueList[0].value#
</isNotEmpty>
<isNotEmpty prepend="$searchValueList[1].andOr$" property="searchValueList[1].value">
$searchValueList[1].column$ $searchValueList[1].operator$#searchValueList[1].value#
</isNotEmpty>
<isNotEmpty prepend="$searchValueList[2].andOr$" property="searchValueList[2].value">
$searchValueList[2].column$ $searchValueList[2].operator$#searchValueList[2].value#
</isNotEmpty>
</dynamic>
    </select>