项目中有导出数据的功能,但是导出功能是以sql的形式,导入到txt中,所以用到了String.format方法,以下是代码
SimpleDateFormat sf = new SimpleDateFormat("yyyyMMddHHmmss");
//将系统当前时间初始化
String currentTime = sf.format(System.currentTimeMillis());
//文件路径
String filePath = "D://";
String file = filePath + currentTime + ".txt";
//生成txt文件
FileUtils.mkdirs(filePath);
//查出数据
PageView pageView = new PageView();
pageView = service.getList(pageView,baseForm);
List<Audio> list = pageView.getResult();
//拼接sql前缀
String sql = "insert into radio_t(id,user,code) values";
try{
BufferedWriter bw = new BufferedWriter(new File(file));
for(Audio audio : list){
//拼接sql后缀,%s表示String类型
String ine = String.format("('%s','%s','%s')",audio.getId,audio.getUser,audio.getCode);
line = sql + line;
bw.write(line);
bw.new Line();
}
bw.close();
}catch(Exception e){
e.printStackTrace();
}