public String getExecSql(String sqlId,EXAMPLE example) { SqlMapClientImpl sqlMapClient = (SqlMapClientImpl) this.getSqlMapClient(); String sqlString = ""; try { MappedStatement stmt = sqlMapClient.getMappedStatement(sqlId); if (stmt != null) { Sql sql = stmt.getSql(); SessionScope sessionScope = new SessionScope(); // sessionScope.setSqlMapClient(sqlMapClient); sessionScope.incrementRequestStackDepth(); StatementScope statementScope = new StatementScope(sessionScope); stmt.initRequest(statementScope); stmt.getCacheKey(statementScope, example); sqlString = sql.getSql(statementScope, example); Object[] parameters = sql.getParameterMap(statementScope, example).getParameterObjectValues(statementScope, example); DateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); for (Object parameter : parameters) { if ("java.lang.String".equals(parameter.getClass().getName())) sqlString = sqlString.replaceFirst("\\?", "'" + parameter.toString() + "'"); else if ("java.util.Date".equals(parameter.getClass().getName())) sqlString = sqlString.replaceFirst("\\?", "to_date('" + sdf.format(parameter) + "','yyyy-mm-dd hh24:mi:ss')"); else sqlString = sqlString.replaceFirst("\\?", parameter.toString()); } } } catch (Exception e) { logger.error("getExecSql:" + e.getMessage()); } return sqlString; }
0票
开心
0票
板砖
0票
感动
0票
有用
0票
疑问
0票
难过
0票
无聊
0票
震惊
顶
踩