1
2
3
4
5
6
7
8
9
10
11
12
| package com.fgkj.db;
|
| public class DaoTrigger {
| //触发器，添加新的电池组信息时要往超级管理组中管理
| public static String test_trigger_baoji="CREATE TRIGGER trigger_insert AFTER INSERT ON tb_battinf FOR EACH ROW "
| + " BEGIN "
| + " INSERT INTO tb_user_battgroup_baojigroup_battgroup (baoji_group_id,battgroupid,stationid) "
| + " VALUES(100011,new.battgroupid,new.stationid); "
| + " END";
| //再information_schema中查找触发器是否存在
| public static String _trigger=" select * from information_schema.TRIGGERS where trigger_name LIKE ? limit 1 ";
| }
|
|
