/**
* 获取select语句,并返回List结合,按照select语句的列名顺序
*
* @param nameSpace
* 输入参数
* @param map
* 输入参数对象
* @return sortList 返回结果
*/
public List<String> getSQLString(String nameSpace, Map<String, String> map) {
List<String> sortList = new ArrayList<String>();
String tableSource = (String) map.get("tableSource");
String sql = null;
SqlMapClientImpl sqlmap = (SqlMapClientImpl) this.getSqlMapClient();
MappedStatement stmt = sqlmap
.getMappedStatement("CLEAR_TRANSACTIONDATA." + tableSource);
Sql stmtSql = stmt.getSql();
SessionScope sessionScope = new SessionScope();
sessionScope.setSqlMapClient(this.getSqlMapClient());
StatementScope statementScope = new StatementScope(sessionScope);
statementScope.setStatement(stmt);
sql = stmtSql.getSql(statementScope, map);
String strSQL = sql.substring(sql.indexOf("select") + 6,
sql.indexOf("from")).trim();
String[] sortSQL = strSQL.split(",");
for (String str : sortSQL) {
sortList.add(str.trim());
}
return sortList;
}
* 获取select语句,并返回List结合,按照select语句的列名顺序
*
* @param nameSpace
* 输入参数
* @param map
* 输入参数对象
* @return sortList 返回结果
*/
public List<String> getSQLString(String nameSpace, Map<String, String> map) {
List<String> sortList = new ArrayList<String>();
String tableSource = (String) map.get("tableSource");
String sql = null;
SqlMapClientImpl sqlmap = (SqlMapClientImpl) this.getSqlMapClient();
MappedStatement stmt = sqlmap
.getMappedStatement("CLEAR_TRANSACTIONDATA." + tableSource);
Sql stmtSql = stmt.getSql();
SessionScope sessionScope = new SessionScope();
sessionScope.setSqlMapClient(this.getSqlMapClient());
StatementScope statementScope = new StatementScope(sessionScope);
statementScope.setStatement(stmt);
sql = stmtSql.getSql(statementScope, map);
String strSQL = sql.substring(sql.indexOf("select") + 6,
sql.indexOf("from")).trim();
String[] sortSQL = strSQL.split(",");
for (String str : sortSQL) {
sortList.add(str.trim());
}
return sortList;
}