String procedureSQL = "create procedure USER_EXIST(in loginName varchar(50),out amount int)" + "select count(*) from sys_menu"; String trigger = "create TRIGGER bj_customer before insert on t_user"+ " for each row begin insert into t_role(id,rolename) values(new.id,new.username);end"; try { Connection connection = getConnection(); PreparedStatement prepareStatement = connection.prepareStatement(trigger); prepareStatement.executeUpdate(); } catch (SQLException e) { e.printStackTrace(); }
存储过程,触发器 的sql和一般sql没有什么两样,同样的执行