常用工具代码

//读取文件的方法
	public static String txt2String(File file){
        StringBuilder result = new StringBuilder();
        try{
        	InputStreamReader read = new InputStreamReader(new FileInputStream(file),"utf-8");
            BufferedReader br = new BufferedReader(read);//构造一个BufferedReader类来读取文件
            String s = null;
            while((s = br.readLine())!=null){//使用readLine方法，一次读一行
                result.append(s);
            }
            br.close();    
        }catch(Exception e){
            e.printStackTrace();
        }
        return result.toString();
    }

#批量插入数据
delimiter $$
DROP PROCEDURE IF EXISTS extra_chat_info_insert_procedure $$ 
CREATE PROCEDURE extra_chat_info_insert_procedure ( loop_times INT)  
BEGIN  
    DECLARE var INT DEFAULT 0; 
	DECLARE msgid INT DEFAULT 0;
    WHILE var<loop_times DO    
    SET var=var+1;  
	SET msgid=msgid+1;   
    INSERT INTO `extra_chat_info` (`company_id`, `msg_id`, `bind_skill_id`, `chat_skill_id`, `bind_skill_name`, `create_time`, `update_time`) VALUES ('12345', msgid, '1', '2', '1', '2018-07-30 15:47:38', '2018-07-30 15:47:41');
    END WHILE;     
END  $$
delimiter ;
call extra_chat_info_insert_procedure(100000);

查询 grep -n "2022-01-20T16:02" gc.log  显示gc.log中携带2022-01-20T16:02并且显示行号

取行：sed -n '20,30p'  test.txt     显示test.txt文件第20行到第30行的内容