/*
* Copyright 2010-2011 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 com.starflow.wf.engine.repository.impl;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Date;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.jdbc.core.support.JdbcDaoSupport;
import com.starflow.wf.engine.model.ProcessInstance;
import com.starflow.wf.engine.repository.IProcessInstanceRepository;
/**
*
* @author libinsong1204@gmail.com
* @version 1.0
*/
public class ProcessInstanceRepositoryImpl extends JdbcDaoSupport implements IProcessInstanceRepository {
private static String insertProcessInstanceSQL = "insert into WF_PROCESSINST (processInstId, processDefId, processInstName, " +
"creator, currentState, subFlow, limitNum, createTime, parentProcInstId, activityInstId) " +
"values(?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
private static String findProcessInstanceSQL = "select * from WF_PROCESSINST where processInstId = ?";
private static String updateProcessStateAndEndTimeSQL = "update WF_PROCESSINST set currentState = ?, endTime = ? where processInstId = ?";
private static String updateProcessStateAndFinalTimeSQL = "update WF_PROCESSINST set currentState = ?, finalTime = ? where processInstId = ?";
private static String updateProcessStateAndStartTimeSQL = "update WF_PROCESSINST set currentState = ?, startTime = ? where processInstId = ?";
public void insertProcessInstance(ProcessInstance processInstance) {
this.getJdbcTemplate().update(insertProcessInstanceSQL, processInstance.getProcessInstId(), processInstance.getProcessDefId(),
processInstance.getProcessInstName(), processInstance.getCreator(), processInstance.getCurrentState(), processInstance.getSubFlow(),
processInstance.getLimitNum(), processInstance.getCreateTime(), processInstance.getParentProcInstId(), processInstance.getActivityInstId());
}
public ProcessInstance findProcessInstance(long processInstId) {
return this.getJdbcTemplate().queryForObject(findProcessInstanceSQL, new RowMapper<ProcessInstance>() {
@Override
public ProcessInstance mapRow(ResultSet resultSet, int index)
throws SQLException {
ProcessInstance processInstance = new ProcessInstance();
processInstance.setProcessInstId(resultSet.getLong("processInstId"));
processInstance.setProcessDefId(resultSet.getLong("processDefId"));
processInstance.setProcessInstName(resultSet.getString("processInstName"));
processInstance.setCreator(resultSet.getString("creator"));
processInstance.setCreateTime(resultSet.getDate("createTime"));
processInstance.setSubFlow(resultSet.getString("subFlow"));
processInstance.setLimitNum(resultSet.getLong("limitNum"));
processInstance.setCurrentState(resultSet.getInt("currentState"));
processInstance.setParentProcInstId(resultSet.getLong("parentProcInstId"));
processInstance.setActivityInstId(resultSet.getLong("activityInstId"));
return processInstance;
}
}, processInstId);
}
public void updateProcessStateAndEndTime(long processInstId, int currentState, Date endTime) {
this.getJdbcTemplate().update(updateProcessStateAndEndTimeSQL, currentState, endTime, processInstId);
}
public void updateProcessStateAndFinalTime(long processInstId, int currentState, Date finalTime) {
this.getJdbcTemplate().update(updateProcessStateAndFinalTimeSQL, currentState, finalTime, processInstId);
}
public void updateProcessStateAndStartTime(long processInstId, int currentState, Date startTime) {
this.getJdbcTemplate().update(updateProcessStateAndStartTimeSQL, currentState, startTime, processInstId);
}
}