请问如何用java创建触发器?报错

大家新年好！问题如题所示，先不用纠结为什么要在java中创建触发器，而不是在数据库里执行。

我的问题是这样，一段可以执行的触发器创建脚本，通过jdbc执行报错，错误的原因，就是这个分隔符关键字：

“delimiter  $$”,触发器脚本如下：DELIMITER $$
CREATE
    TRIGGER `oms_sql_jx`.`OMS_SYS_USER_INFO_INSERT` BEFORE INSERT
    ON `oms_sql_jx`.`OMS_SYS_USER_INFO`
    FOR EACH ROW BEGIN
    INSERT INTO  temp_triger(id,tablename,operation,sync_status,pks,countsql,exesql) VALUES(UUID(),'OMS_SYS_USER_INFO','I','0','INFO_ID',
CONCAT('select count(*) from OMS_SYS_USER_INFO  where INFO_ID=','\'',new.INFO_ID,'\'' ),
CONCAT(' insert into OMS_SYS_USER_INFO (INFO_ID,USER_ID,ORG_ID,ORG_SUBJECTION_ID,LAND_DATE,LEAVE_DATE,IP,NOTE,MODIFI_DATE,CREATE_DATE,CREATOR_ID,CREATOR,BSFLAG,STATE,LOGIN_SYS)  VALUES (','\'',CASE  WHEN ISNULL(new.INFO_ID) THEN 'null' ELSE REPLACE(new.INFO_ID,'\'','\\\'')  END,'\'',' , ','\'',CASE  WHEN ISNULL(new.USER_ID) THEN 'null' ELSE REPLACE(new.USER_ID,'\'','\\\'')  END,'\'',' , ','\'',CASE  WHEN ISNULL(new.ORG_ID) THEN 'null' ELSE REPLACE(new.ORG_ID,'\'','\\\'')  END,'\'',' , ','\'',CASE  WHEN ISNULL(new.ORG_SUBJECTION_ID) THEN 'null' ELSE REPLACE(new.ORG_SUBJECTION_ID,'\'','\\\'')  END,'\'',' , ','\'',CASE  WHEN ISNULL(new.LAND_DATE) THEN  'null' ELSE  CONCAT('to_date(\'',new.LAND_DATE,'\',\'yyyy-mm-dd hh24:mi:ss\'',' )')  END ,'\'',' , ','\'',CASE  WHEN ISNULL(new.LEAVE_DATE) THEN  'null' ELSE  CONCAT('to_date(\'',new.LEAVE_DATE,'\',\'yyyy-mm-dd hh24:mi:ss\'',' )')  END ,'\'',' , ','\'',CASE  WHEN ISNULL(new.IP) THEN 'null' ELSE REPLACE(new.IP,'\'','\\\'')  END,'\'',' , ','\'',CASE  WHEN ISNULL(new.NOTE) THEN 'null' ELSE REPLACE(new.NOTE,'\'','\\\'')  END,'\'',' , ','\'',CASE  WHEN ISNULL(new.MODIFI_DATE) THEN  'null' ELSE  CONCAT('to_date(\'',new.MODIFI_DATE,'\',\'yyyy-mm-dd hh24:mi:ss\'',' )')  END ,'\'',' , ','\'',CASE  WHEN ISNULL(new.CREATE_DATE) THEN  'null' ELSE  CONCAT('to_date(\'',new.CREATE_DATE,'\',\'yyyy-mm-dd hh24:mi:ss\'',' )')  END ,'\'',' , ','\'',CASE  WHEN ISNULL(new.CREATOR_ID) THEN 'null' ELSE REPLACE(new.CREATOR_ID,'\'','\\\'')  END,'\'',' , ','\'',CASE  WHEN ISNULL(new.CREATOR) THEN 'null' ELSE REPLACE(new.CREATOR,'\'','\\\'')  END,'\'',' , ',
'\'',CASE  WHEN ISNULL(new.BSFLAG) THEN 'null' ELSE REPLACE(new.BSFLAG,'\'','\\\'')  END,'\'',' , ',
'\'',CASE  WHEN ISNULL(new.STATE) THEN 'null' ELSE REPLACE(new.STATE,'\'','\\\'')  END,'\'',' , ',
'\'',CASE  WHEN ISNULL(new.LOGIN_SYS) THEN 'null' ELSE REPLACE(new.LOGIN_SYS,'\'','\\\'')  END,'\'',')' ));
     END$$
DELIMITER ;

执行后报错如下：

java.sql.BatchUpdateException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`DELIMITER` $$
CREATE
    TRIGGER `oms_sql_jx`.`OMS_SYS_USER_INFO_INSERT` BEFO' at line 1
 at com.mysql.jdbc.Statement.executeBatch(Statement.java:949)

在此，请教大家如何能在java里把这个触发器创建成功。先谢过！！