osworkflow与spring的集成

来源：互联网发布：高清网络硬盘播放器编辑：程序博客网时间：2024/06/11 20:09

osworkflow与spring的集成方法，在《OSWorkflow开发指南.pdf》中有描述，但那篇文章中没有代码，这里贴出我自己集成的代码和配置：

1.新的WorkflowStore

package com.opensymphony.workflow.spi.jdbc;import java.sql.Connection;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.util.HashMap;import java.util.Properties;import javax.sql.DataSource;import org.springframework.jdbc.datasource.DataSourceUtils;import org.springframework.jdbc.support.JdbcUtils;import com.opensymphony.module.propertyset.PropertySet;import com.opensymphony.module.propertyset.PropertySetManager;import com.opensymphony.workflow.StoreException;public class SpringJDBCWorkflowStore extends JDBCWorkflowStore {    public void setDataSource(DataSource dataSource){          this.ds = dataSource;      }            public void setJdbcProperties(Properties ps) throws StoreException {    init(ps);    }        @Override      protected Connection getConnection() throws SQLException {          return DataSourceUtils.getConnection(this.ds);      }            @Override      protected void cleanup(Connection connection, Statement statement, ResultSet result) {          JdbcUtils.closeStatement(statement);          JdbcUtils.closeResultSet(result);          DataSourceUtils.releaseConnection(connection, this.ds);                }@Overridepublic PropertySet getPropertySet(long entryId) {HashMap args = new HashMap();        args.put("globalKey", "osff_" + entryId);        args.put("dataSource", ds);        return PropertySetManager.getInstance("spring", args);}        }

2.新的PropertySet

package com.opensymphony.module.propertyset.database;import java.sql.Connection;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.util.Map;import javax.sql.DataSource;import org.springframework.jdbc.datasource.DataSourceUtils;import org.springframework.jdbc.support.JdbcUtils;public class SpringJDBCPropertySet extends JDBCPropertySet {@Overridepublic void init(Map config, Map args) {super.init(config, args);this.ds = (DataSource) args.get("dataSource");}    @Override      protected Connection getConnection() throws SQLException {          return DataSourceUtils.getConnection(this.ds);      }            @Override      protected void cleanup(Connection connection, Statement statement, ResultSet result) {          JdbcUtils.closeStatement(statement);          JdbcUtils.closeResultSet(result);          DataSourceUtils.releaseConnection(connection, this.ds);                }}

3.增加spring配置：

<bean id="jdbcTemplateWorkflowStore"class="com.opensymphony.workflow.spi.jdbc.SpringJDBCWorkflowStore"><property name="jdbcProperties"><props><prop key="entry.sequence">select IFNULL(max(id)+1,1) from os_wfentry</prop><prop key="step.sequence">select IFNULL(GREATEST((select max(id) from os_currentstep),(select max(id) from os_historystep))+1,1)</prop></props></property></bean><bean id="workflowFactory"class="com.opensymphony.workflow.spi.hibernate.SpringWorkflowFactory"init-method="init"><property name="resource"><value>workflows.xml</value></property><property name="reload"><value>true</value></property></bean><bean id="osworkflowConfiguration" class="com.opensymphony.workflow.config.SpringConfiguration"><property name="store"><ref local="jdbcTemplateWorkflowStore" /></property><property name="factory"><ref local="workflowFactory" /></property></bean>

这里用了自动注入

0 0