CapSqlSearchQueryProvider provider = new CapSqlSearchQueryProvider(
search);
String _sql = sqlp.getValue(sqlId, sqlId);
StringBuffer sourceSql = new StringBuffer(_sql).append(
_sql.toUpperCase().lastIndexOf("WHERE") > 0 ? " AND "
: " WHERE ").append(provider.generateWhereCause());
Map<String, Object> params = new HashMap<String, Object>();
params.put(CapJdbcContants.SQLPaging_SourceSQL, sourceSql.toString());
// 準備查詢筆數sql
StringBuffer sql = new StringBuffer().append(CapDbUtil.spelParser(
(String) sqltemp.getValue(CapJdbcContants.SQLPaging_TotalPage),