Java tutorial
/* * Copyright 2007-2016 the original author or authors. * * Licensed under the Apache License, Version 2.0 (the "License"); * you may not use this file except in compliance with the License. * You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. */ package net.ymate.platform.persistence.jdbc.base; import net.ymate.platform.core.util.ExpressionUtils; import net.ymate.platform.persistence.base.Type; import net.ymate.platform.persistence.jdbc.IConnectionHolder; import org.apache.commons.lang.StringUtils; import org.apache.commons.lang.time.StopWatch; import org.apache.commons.logging.Log; import org.apache.commons.logging.LogFactory; import java.sql.PreparedStatement; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; /** * ??? * * @author (suninformation@163.com) on 2011-9-22 ?10:19:53 * @version 1.0 */ public abstract class AbstractOperator implements IOperator { private static final Log _LOG = LogFactory.getLog(AbstractOperator.class); private String sql; private IConnectionHolder connectionHolder; private IAccessorConfig accessorConfig; private List<SQLParameter> parameters; private long expenseTime; /** * ? */ private boolean executed; public AbstractOperator(String sql, IConnectionHolder connectionHolder) { this(sql, connectionHolder, null); } public AbstractOperator(String sql, IConnectionHolder connectionHolder, IAccessorConfig accessorConfig) { this.sql = sql; this.connectionHolder = connectionHolder; this.accessorConfig = accessorConfig; this.parameters = new ArrayList<SQLParameter>(); } public void execute() throws Exception { if (!this.executed) { StopWatch _time = new StopWatch(); _time.start(); int _effectCounts = 0; try { _effectCounts = __doExecute(); // ????? this.executed = true; } finally { _time.stop(); this.expenseTime = _time.getTime(); // if (this.connectionHolder.getDataSourceCfgMeta().isShowSQL()) { _LOG.info(ExpressionUtils.bind("[${sql}]${param}[${count}][${time}]") .set("sql", StringUtils.defaultIfBlank(this.sql, "@NULL")) .set("param", __doSerializeParameters()).set("count", _effectCounts + "") .set("time", this.expenseTime + "ms").getResult()); } } } } protected String __doSerializeParameters() { return this.parameters.toString(); } /** * @return ?? * @throws Exception */ protected abstract int __doExecute() throws Exception; protected void __doSetParameters(PreparedStatement statement) throws SQLException { for (int i = 0; i < this.getParameters().size(); i++) { SQLParameter _param = this.getParameters().get(i); if (_param.getValue() == null) { statement.setNull(i + 1, 0); } else { statement.setObject(i + 1, _param.getValue()); } } } public boolean isExecuted() { return executed; } public String getSQL() { return sql; } public IAccessorConfig getAccessorConfig() { return accessorConfig; } public void setAccessorConfig(IAccessorConfig accessorConfig) { this.accessorConfig = accessorConfig; } public IConnectionHolder getConnectionHolder() { return connectionHolder; } public long getExpenseTime() { return expenseTime; } public List<SQLParameter> getParameters() { return this.parameters; } public IOperator addParameter(SQLParameter parameter) { if (parameter != null) { this.parameters.add(parameter); } return this; } public IOperator addParameter(Object parameter) { if (parameter == null) { this.parameters.add(new SQLParameter(Type.FIELD.UNKNOW, null)); } else { this.parameters.add(new SQLParameter(parameter)); } return this; } }