java 创建定时器_javav

定时器要求：

定时执行某存储过程，存储过程实现向某表中插入一条数据

每分钟执行一次

show variables like '%event_scheduler%';

set global event_scheduler=on;

create table user01(

user_id int ,

user_name varchar(3)

);

create procedure shijhian()

begin

declare i int default 0;

declare user_id int default 0;

declare user_name VARCHAR(5) ;

while i<1 do

set user_id=i;

set user_name=concat('我',i);

insert into user01() value (user_id,user_name);

set i=i+1;

end while;

end;

create event e_minute

on schedule every 1 minute

do call shijhian();

select * from user01