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 ";
}