一、背景

%、！、_在sql查詢時需要轉義，轉義的語法

like %?2% escape ?#{escapeCharacter()}

二、activiti轉義配置

String wildcardEscapeClause = "";
if (this.databaseWildcardEscapeCharacter != null && this.databaseWildcardEscapeCharacter.length() != 0) {wildcardEscapeClause = " escape '" + this.databaseWildcardEscapeCharacter + "'";
}properties.put("wildcardEscapeClause", wildcardEscapeClause);

版本8.2.0測試demo配置activiti.cfg.xml

<?xml version="1.0" encoding="UTF-8"?><beans xmlns="http://www.springframework.org/schema/beans"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xsi:schemaLocation="http://www.springframework.org/schema/beans   http://www.springframework.org/schema/beans/spring-beans.xsd"><bean id="processEngineConfiguration"class="org.activiti.engine.impl.cfg.StandaloneProcessEngineConfiguration"><property name="jdbcUrl" value="jdbc:h2:mem:activiti;DB_CLOSE_DELAY=1000" /><property name="jdbcDriver" value="org.h2.Driver" /><property name="jdbcUsername" value="sa" /><property name="jdbcPassword" value="" /><!-- Database configurations --><property name="databaseSchemaUpdate" value="drop-create" /><!-- job executor configurations --><property name="asyncExecutor" ref="asyncExecutor" /><property name="asyncExecutorActivate" value="false" /><property name="defaultFailedJobWaitTime" value="1" /><property name="asyncFailedJobWaitTime" value="1" /><!-- mail server configurations --><property name="mailServerPort" value="5025" /><property name="mailServers"><map><entry key="myEmailTenant"><bean class="org.activiti.engine.cfg.MailServerInfo"><property name="mailServerHost" value="localhost" /><property name="mailServerPort" value="5025" /><property name="mailServerUseSSL" value="false" /><property name="mailServerUseTLS" value="false" /><property name="mailServerDefaultFrom" value="activiti@myTenant.com" /><property name="mailServerUsername" value="activiti@myTenant.com" /><property name="mailServerPassword" value="password" /></bean></entry></map></property><property name="history" value="full" /><property name="enableProcessDefinitionInfoCache" value="true" /><property name="databaseWildcardEscapeCharacter" value="\" /></bean><bean id="asyncExecutor" class="org.activiti.engine.impl.asyncexecutor.DefaultAsyncJobExecutor"><property name="defaultAsyncJobAcquireWaitTimeInMillis" value="1000" /><property name="defaultTimerJobAcquireWaitTimeInMillis" value="1000" /></bean></beans>

其中配置的轉義符為反斜杠。這一句

<property name="databaseWildcardEscapeCharacter" value="\" />

三、項目配置

在注入ProcessEngineConfiguration時，設置。前后代碼省略。

	@Beanpublic SpringProcessEngineConfiguration springProcessEngineConfiguration(){//省略前面代碼...SpringProcessEngineConfiguration configuration = new SpringProcessEngineConfiguration();configuration.setDatabaseWildcardEscapeCharacter(String.valueOf(JPQLTemplates.DEFAULT_ESCAPE));//省略后面代碼...}

配合TemplateFactory使用。

private static final TemplateFactory templateFactory = new TemplateFactory(JPQLTemplates.DEFAULT_ESCAPE);

轉義方法

templateFactory.escapeForLike(str);

四、結論

注入ProcessEngineConfiguration時，設置setDatabaseWildcardEscapeCharacter，配合TemplateFactory（com.querydsl.core.types）使用。