Java Sql類代碼示例

import com.ibatis.sqlmap.engine.mapping.sql.Sql; //導入依賴的package包/類
public String getSQL(String id,Object params){
	
	try {
		SqlMapClientImpl sci = (SqlMapClientImpl)this.sqlMapClientTemplate.getSqlMapClient();  
    	MappedStatement ms = sci.getMappedStatement(id);  
    	          
    	Sql sql = ms.getSql();    
    	        
    	SessionScope sessionScope = new SessionScope();       
    	sessionScope.incrementRequestStackDepth();       
    	StatementScope statementScope = new StatementScope(sessionScope);       
    	ms.initRequest(statementScope);      
    	ms.getCacheKey(statementScope, params);  
    	
    	String sqlString = sql.getSql(statementScope, params);
    	Object[] sqlParam = sql.getParameterMap(statementScope, params).getParameterObjectValues(statementScope, params);  
    	
    	int sqlParamLen = sqlParam.length;
    	if (sqlParam != null && sqlParamLen > 0) {
    		for (int i=0; i < sqlParamLen; i++) {
    			if (sqlParam[i] instanceof Integer) {
    				sqlString = sqlString.replaceFirst("\\?", sqlParam[i].toString());
    			}
    			else if (sqlParam[i] instanceof String) {
    				sqlString = sqlString.replaceFirst("\\?", "'" + sqlParam[i].toString() + "'");
    			}
    		}
    	}
    	return sqlString;
	} catch (Exception ex) {
		LogConstant.error(ex.getMessage(), ex);
		LogConstant.error("獲取SQL 出錯, id: " + id);
	}
	
	return "[未能獲取 SQL語句](id: " + id + ")";

}
 

import com.ibatis.sqlmap.engine.mapping.sql.Sql; //導入依賴的package包/類
protected String getSqlByStatementName(String statementName, Object parameterObject) {
    SqlMapClientImpl sqlMapClientImpl = (SqlMapClientImpl) getSqlMapClient();
    Sql sql = sqlMapClientImpl.getMappedStatement(statementName).getSql();
    if (sql instanceof StaticSql) {
        return sql.getSql(null, parameterObject);
    } else {
        logger.info("dynamic sql can only return sql id.");
        return statementName;
    }
}
 

import com.ibatis.sqlmap.engine.mapping.sql.Sql; //導入依賴的package包/類
public CacheKey getCacheKey(StatementScope statementScope, Object parameterObject) {
  Sql sql = statementScope.getSql();
  ParameterMap pmap = sql.getParameterMap(statementScope, parameterObject);
  CacheKey cacheKey = pmap.getCacheKey(statementScope, parameterObject);
  cacheKey.update(id);

  // I am not sure how any clustered cache solution would ever have had any cache hits against
  // replicated objects. I could not make it happen
  // The baseCacheKey value which was being used in the update below is consistent across
  // JVMInstances on the same machine
  // but it's not consistent across machines, and therefore breaks clustered caching.

  // What would happen is the cache values were being replicated across machines but there
  // were never any cache hits for cached objects on
  // anything but the original machine an object was created on.

  // After reviewing this implementation I could not figure out why baseCacheKey is used for
  // this anyway as it's not needed, so I removed it.
  // The values used from the pmap.getCacheKey, plus id, plus the params below are unique and
  // the same accross machines, so now I get replicated
  // cache hits when I force failover in my cluster

  // I wish I could make a unit test for this, but I can't do it as the old implementaion
  // works on 1 machine, but fails across machines.
  // cacheKey.update(baseCacheKey);

  cacheKey.update(sql.getSql(statementScope, parameterObject)); // Fixes bug 953001
  return cacheKey;
}
 

import com.ibatis.sqlmap.engine.mapping.sql.Sql; //導入依賴的package包/類
public Sql getSql() {
  return sql;
}
 

import com.ibatis.sqlmap.engine.mapping.sql.Sql; //導入依賴的package包/類
public void setSql(Sql sql) {
  this.sql = sql;
}
 

import com.ibatis.sqlmap.engine.mapping.sql.Sql; //導入依賴的package包/類
@Override
public Sql getSql() {
  return statement.getSql();
}
 

import com.ibatis.sqlmap.engine.mapping.sql.Sql; //導入依賴的package包/類
/**
 * Get the SQL for the request
 *
 * @return - the sql
 */
public Sql getSql() {
  return sql;
}
 

import com.ibatis.sqlmap.engine.mapping.sql.Sql; //導入依賴的package包/類
/**
 * Set the SQL for the request
 *
 * @param sql
 *          - the sql
 */
public void setSql(Sql sql) {
  this.sql = sql;
}