com.googlecode.starflow.engine.repository.impl.ProcessInstanceRepositoryImpl.java Source code

Introduction

Here is the source code for com.googlecode.starflow.engine.repository.impl.ProcessInstanceRepositoryImpl.java

Source

/*
 * 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.googlecode.starflow.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.googlecode.starflow.engine.model.ProcessInstance;
import com.googlecode.starflow.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, mainProcInstId, 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.getMainProcInstId(),
                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.setMainProcInstId(resultSet.getLong("mainProcInstId"));
                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);
    }
}