测试的SQL
<!-- lang: sql -->
create trigger testxxa after insert on zima_ for each row
begin -- 修正lonlat值,以lonlatWKT值为准 declare fid bigint default 0;begin set fid=0;set fid=2; end; end
使用的测试
<!-- lang: java -->
public class CreateTriggerTest extends TestCase {
ApplicationContext context;
@Override
public void setUp(){
context=new ClassPathXmlApplicationContext("trigger/create.xml");
}
@Override
public void tearDown(){
}
public void testCreate(){
JdbcTemplate template=(JdbcTemplate) context.getBean("jdbcTemplate");
String trigger="create trigger testxxa after insert on zima_stat for each row\nbegin\n-- 修正lonlat值,以lonlatWKT值为准\ndeclare fid bigint default 0;begin\nset fid=0;set fid=2;end;end";
template.execute(trigger);
}
}
使用的配置
<!-- lang: xml -->
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans" xmlns:context="http://www.springframework.org/schema/context" 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 http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-2.5.xsd" xmlns:jdbc="http://www.springframework.org/schema/jdbc"> <bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"> <property name="locations"> <list> <!-- 数据库配置参数取自属性文件 --> <value>classpath*:monitor/jdbc.properties</value> </list> </property> </bean> <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close"> <property name="driverClass" value="${jdbc.driverClass}" /> <property name="jdbcUrl" value="${jdbc.jdbcUrl}" /> <property name="user" value="${jdbc.user}" /> <property name="password" value="${jdbc.password}" /> <property name="minPoolSize" value="${jdbc.miniPoolSize}" /> <property name="maxPoolSize" value="${jdbc.maxPoolSize}"/>
<property name="initialPoolSize" value="${jdbc.initialPoolSize}"/> <property name="maxIdleTime" value="${jdbc.maxIdleTime}"/> <property name="acquireIncrement" value="${jdbc.acquireIncrement}"/> <property name="acquireRetryAttempts" value="${jdbc.acquireRetryAttempts}"/> <property name="acquireRetryDelay" value="${jdbc.acquireRetryDelay}"/> <property name="testConnectionOnCheckin" value="${jdbc.testConnectionOnCheckin}"/> <property name="automaticTestTable" value="${jdbc.automaticTestTable}"/> <property name="idleConnectionTestPeriod" value="${jdbc.idleConnectionTestPeriod}"/> <property name="checkoutTimeout" value="${jdbc.checkoutTimeout}"/> </bean> <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate"> <property name="dataSource" ref="dataSource"/> </bean>
</beans>