StringSelection stsel = new StringSelection("复制内容asdfasfdf");
Toolkit.getDefaultToolkit().getSystemClipboard().setContents(stsel, stsel);
mysql创建事件代码片段
create event e_test
on schedule every 1 second
//do insert into user(username,password) values('2','222');
do call test();
alter event e_test disable;
drop event e_test;
create procedure test()
begin
insert into user(username,password) values('2','222');
end
/*
1 get pre date
2 get all the data
3 iterator the cousor
4 insert the data into sys_record
*/
create procedure proc_importdata()
begin
set @pre_date = select date_sub(curdate(),interval 1 day);
declare cursor_data CURSOR FOR
select * from sys_operaterecord ;
OPEN cursor_data;
REPEAT /*循环*/
FETCH cursor_data INTO variable list;
END REPEAT;
CLOSE cursor_data;
end
select distinct (task_id,maker_id) from Sys_operaterecord
SELECT * FROM Sys_operaterecord WHERE operaterecord_id IN (SELECT MAX( operaterecord_id ) FROM Sys_operaterecord GROUP BY task_id,maker_id)
CREATE PROCEDURE `test`.`new_procedure` ()
BEGIN
-- 需要定义接收游标数据的变量
DECLARE a CHAR(16);
-- 游标
DECLARE cur CURSOR FOR SELECT i FROM test.t;
-- 遍历数据结束标志
DECLARE done INT DEFAULT FALSE;
-- 将结束标志绑定到游标
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;
-- 打开游标
OPEN cur;
-- 开始循环
read_loop: LOOP
-- 提取游标里的数据,这里只有一个,多个的话也一样;
FETCH cur INTO a;
-- 声明结束的时候
IF done THEN
LEAVE read_loop;
END IF;
-- 这里做你想做的循环的事件
INSERT INTO test.t VALUES (a);
END LOOP;
-- 关闭游标
CLOSE cur;
END
String path = "http://"+request.getServerName()+":"+request.getServerPort()+request.getContextPath();