com.giants.dal.dao.ibatis.AbstractIbatisDao Maven / Gradle / Ivy

Go to download
/**
 * 
 */
package com.giants.dal.dao.ibatis;

import java.io.Serializable;
import java.lang.reflect.ParameterizedType;
import java.sql.SQLException;
import java.text.MessageFormat;
import java.util.Date;
import java.util.List;

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

import com.giants.dal.common.DalConstants;
import com.giants.dal.orm.ibatis.SqlMapClientCallback;
import com.ibatis.sqlmap.client.SqlMapExecutor;
import com.ibatis.sqlmap.engine.execution.BatchException;

/**
 * @author vencent.lu
 *
 */
@SuppressWarnings({"rawtypes", "unchecked"})
public abstract class AbstractIbatisDao extends SqlMapClientDaoSupport
		implements IbatisDao {
	
	private long sqlExecuteThreshold = 200;
	protected final Logger   logger = LoggerFactory.getLogger(AbstractIbatisDao.class);
	
	private final Class entityClass = (Class) ((ParameterizedType) getClass()
			.getGenericSuperclass()).getActualTypeArguments()[0];
	
	private String buildStatementName(String sqlName) {
		return new StringBuffer(this.entityClass.getSimpleName())
				.append('.').append(sqlName).toString();
	}
	
	/**
	 * @return the entityClass
	 */
	public Class getEntityClass() {
		return entityClass;
	}



	/* (non-Javadoc)
	 * @see com.giants.dao.GinatsDao#insert(java.lang.Object)
	 */
	@Override
	public void insert(T entity) {
		String statementName = this.buildStatementName(DalConstants.IBATIS_STATEMENT_INSERT);
		long timeScale=System.currentTimeMillis();
		super.getSqlMapClientTemplate().insert(statementName, entity);
		long executionTime = System.currentTimeMillis() - timeScale;
		if (executionTime > this.sqlExecuteThreshold) {
			this.logger.warn(MessageFormat
							.format("[insert(statementName={0},entity={1})] Insert entity into database in {2}ms",
									statementName, entity, executionTime));
		} else {
			this.logger.info(MessageFormat
							.format("[insert(statementName={0},entity={1})] Insert entity into database in {2}ms",
									statementName, entity, executionTime));
		}
	}

	/* (non-Javadoc)
	 * @see com.giants.dao.GinatsDao#update(java.lang.Object)
	 */
	@Override
	public void update(T entity) {
		String statementName = this.buildStatementName(DalConstants.IBATIS_STATEMENT_UPDATE);
		long timeScale=System.currentTimeMillis();
		super.getSqlMapClientTemplate().update(statementName, entity);
		long executionTime = System.currentTimeMillis() - timeScale;
		if (executionTime > this.sqlExecuteThreshold) {
			this.logger.warn(MessageFormat
							.format("[update(statementName={0},entity={1})] Update entity into database in {2}ms",
									statementName, entity, executionTime));
		} else {
			this.logger.info(MessageFormat
							.format("[update(statementName={0},entity={1})] Update entity into database in {2}ms",
									statementName, entity, executionTime));
		}
	}

	/* (non-Javadoc)
	 * @see com.giants.dao.GinatsDao#insertAll(java.util.List)
	 */
	@Override
	public void insertAll(final List entityList) {
		final String statementName = this.buildStatementName(DalConstants.IBATIS_STATEMENT_INSERT);
		long timeScale=System.currentTimeMillis();
		List result = super.getSqlMapClientTemplate().execute(new SqlMapClientCallback() {
			public List doInSqlMapClient(SqlMapExecutor executor)
					throws SQLException {
				executor.startBatch();
				for (T entity : entityList) {
					executor.insert(statementName, entity);
				}
				try {
					return executor.executeBatchDetailed();
				} catch (BatchException e) {
					logger.error("Batch insert failed!", e);
					throw new SQLException("Batch insert failed!",e);
				}
			}
		});
		long executionTime = System.currentTimeMillis() - timeScale;
		if (executionTime > this.sqlExecuteThreshold) {
			this.logger.warn(MessageFormat
					.format("[insertBatch(statementName={0},entityList={1})] InsertBatch entityList into database in {2}ms",
							statementName, entityList, executionTime));
		} else {
			this.logger.info(MessageFormat
					.format("[insertBatch(statementName={0},entityList={1})] InsertBatch entityList into database in {2}ms",
							statementName, entityList, executionTime));
		}
	}

	/* (non-Javadoc)
	 * @see com.giants.dao.GinatsDao#delete(java.lang.Object)
	 */
	@Override
	public void delete(T entity) {
		String statementName = this
				.buildStatementName(DalConstants.IBATIS_STATEMENT_DELETE);
		long timeScale = System.currentTimeMillis();
		super.getSqlMapClientTemplate().delete(statementName, entity);
		long executionTime = System.currentTimeMillis() - timeScale;
		if (executionTime > this.sqlExecuteThreshold) {
			this.logger.warn(MessageFormat
					.format("[delete(statementName={0},entity={1})] Delete entity from database in {2}ms",
							statementName, entity, executionTime));
		} else {
			this.logger.info(MessageFormat
					.format("[delete(statementName={0},entity={1})] Delete entity from database in {2}ms",
							statementName, entity, executionTime));
		}
	}

	/* (non-Javadoc)
	 * @see com.giants.dao.GinatsDao#deleteAll(java.util.List)
	 */
	@Override
	public void deleteAll(final List entityList) {
		final String statementName = this
				.buildStatementName(DalConstants.IBATIS_STATEMENT_DELETE);
		long timeScale = System.currentTimeMillis();
		super.getSqlMapClientTemplate().execute(
				new SqlMapClientCallback