读取sql表写入txt

读取表信息写入txt备份

List<T> lists = xxxMappper.selectAll();
backFile(lists,tableName);

backFile(List<T> lists,Sstring tableName){
    /指定路径
    String path = 类名.class.getClassLoader().getResource("").getPath()+"out";
    //getResource("")，打完包需要绝对路径（"/"）
    if(!file.getParentFile().exists()){
        file.getParentFile().mkdirs();
    }
    try{
    BufferedWriter bufferedWriter =   new BufferedWriter(new FileWriter(file));
     for(T list:lists){
        bufferedWriter.write(list.toString());
         bufferedWriter.newLine();
     }
      bufferedWriter.flush();  
    }catch(IOException){
        e.printStackTrace();
    }
}