springmvc+mybatis+mysql+log4jdbc+excel 实现sql日志输出和excel导出

package sy.util; import java.io.BufferedReader; import java.io.File; import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.FileOutputStream; import java.io.FileReader; import java.io.FileWriter; import java.io.IOException; import java.io.InputStream; import java.io.PrintWriter; public class FileUtil { /** * 在系统临时文件夹下面创建一个目录 * * @param directory * @return String 临时路径文件夹字符串 */ public static String getTempFolderUnderAvidmTempFolder(String directory) { String tempPath = System.getProperty("java.io.tmpdir"); if (!tempPath.endsWith(File.separator)) { tempPath += File.separator; } tempPath += directory; File fTemp = new File(tempPath); if (!fTemp.exists()) { fTemp.mkdir(); } return tempPath; } /** * 检查一个字符串是否是已存在的目录 */ public static boolean checkFolderPath(String toCheckString) { boolean result = false; File tempFile = new File(toCheckString); if (tempFile.exists()) { if (tempFile.isDirectory()) { result = true; } } return result; } /** * 将文件的字节表示的大小转化成字符串 将字节转换为KB或MB * * @param fileSize * 准换的文件大小(字节) * @return String */ public static String getFileSize(String fileSize) { int docSize; int kSize, mSize; int kOne = 1024; int mOne = 1024 * 1024; String retSize; docSize = new Integer(fileSize).intValue(); kSize = docSize / kOne; mSize = kSize / kOne; if (mSize > 0) { retSize = new Integer(mSize).toString(); retSize += "."; retSize += new Integer((docSize - mSize * mOne) / mOne).toString(); retSize += "MB"; return retSize; } else if (kSize > 0) { retSize = new Integer(kSize).toString(); retSize += "."; retSize += new Integer((docSize - kSize * kOne) / kOne).toString(); retSize += "KB"; return retSize; } else { retSize = new Integer(docSize).toString(); retSize += "B"; return retSize; } } /** * 复制单个文件 * * @param oldPath * 原文件地址,如：c:/a.txt * @param newPath * 新文件地址,如：d:/b.txt * @return */ public static boolean copyFile(String oldPath, String newPath) { InputStream inStream = null; FileOutputStream fs = null; boolean result = false; try { int byteread = 0; File oldfile = new File(oldPath); if (oldfile.exists()) { // 文件存在时 inStream = new FileInputStream(oldPath); // 读入原文件 fs = new FileOutputStream(newPath); byte[] buffer = new byte[1444]; while ((byteread = inStream.read(buffer)) != -1) { fs.write(buffer, 0, byteread); } result = true; } else { result = false; } } catch (Exception e) { System.out.println("复制单个文件操作出错"); e.printStackTrace(); } finally { try { fs.close(); inStream.close(); } catch (IOException e) { e.printStackTrace(); } } return result; } /** * 复制整个文件夹内容 * * @param oldPath * 原文件夹路径,如：c:/t1 * @param newPath * 新文件夹路径,如：d:/t2 */ public static void copyFolder(String oldPath, String newPath) { FileInputStream input = null; FileOutputStream output = null; try { (new File(newPath)).mkdirs(); // 如果文件夹不存在 则建立新文件夹 File a = new File(oldPath); String[] file = a.list(); File temp = null; for (int i = 0; i < file.length; i++) { if (oldPath.endsWith(File.separator)) { temp = new File(oldPath + file[i]); } else { temp = new File(oldPath + File.separator + file[i]); } if (temp.isFile()) { input = new FileInputStream(temp); output = new FileOutputStream(newPath + File.separator + (temp.getName()).toString()); byte[] b = new byte[1024 * 5]; int len; while ((len = input.read(b)) != -1) { output.write(b, 0, len); } output.flush(); } if (temp.isDirectory()) {// 如果是子文件夹 copyFolder(oldPath + File.separator + file[i], newPath + File.separator + file[i]); } } } catch (Exception e) { System.out.println("复制整个文件夹内容操作出错"); e.printStackTrace(); } finally { try { output.close(); input.close(); } catch (IOException e) { e.printStackTrace(); } } } /** * 新建目录, 如：c:/abc * * @param folderPath */ public static void newFolder(String folderPath) { try { String filePath = folderPath; filePath = filePath.toString(); File myFilePath = new File(filePath); if (!myFilePath.exists()) { myFilePath.mkdir(); } } catch (Exception e) { System.out.println("新建目录操作出错"); e.printStackTrace(); } } /** * 新建文件 * * @param filePathAndName * 文件路径(包括文件路径+文件名称),如：c:/fqf.txt * @param fileContent * 文件内容 */ public static void newFile(String filePathAndName, String fileContent) { FileWriter resultFile = null; try { String filePath = filePathAndName; filePath = filePath.toString(); File myFilePath = new File(filePath); if (!myFilePath.exists()) { myFilePath.createNewFile(); } resultFile = new FileWriter(myFilePath); PrintWriter myFile = new PrintWriter(resultFile); String strContent = fileContent; myFile.println(strContent); } catch (Exception e) { System.out.println("新建文件操作出错"); e.printStackTrace(); } finally { try { resultFile.close(); } catch (IOException e) { e.printStackTrace(); } } } /** * 删除文件 * * @param filePathAndName * 文件路径(包括文件路径+文件名称),如：c:/fq.txt */ public static void delFile(String filePathAndName) { try { String filePath = filePathAndName; filePath = filePath.toString(); File myDelFile = new File(filePath); myDelFile.delete(); } catch (Exception e) { System.out.println("删除文件操作出错"); e.printStackTrace(); } } /** * 删除文件夹及文件夹下的所有内容 * * @param folderPath * 文件夹路径,如：c:/acd */ public static void delFolder(String folderPath) { try { delAllFile(folderPath); // 删除完里面所有内容 String filePath = folderPath; filePath = filePath.toString(); File myFilePath = new File(filePath); myFilePath.delete(); // 删除空文件夹 } catch (Exception e) { System.out.println("删除文件夹操作出错"); e.printStackTrace(); } } /** * 删除文件夹里面的所有内容(包括文件夹、子文件夹、文件) * * @param path * 文件夹路径 */ public static void delAllFile(String path) { File file = new File(path); if (!file.exists()) { return; } if (!file.isDirectory()) { return; } String[] tempList = file.list(); File temp = null; for (int i = 0; i < tempList.length; i++) { if (path.endsWith(File.separator)) { temp = new File(path + tempList[i]); } else { temp = new File(path + File.separator + tempList[i]); } if (temp.isFile()) { temp.delete(); } if (temp.isDirectory()) { delAllFile(path + File.separator + tempList[i]);// 先删除文件夹里面的文件 delFolder(path + File.separator + tempList[i]);// 再删除空文件夹 } } } /** * 移动文件到指定目录 * * @param oldPath * 原文件目录,如：c:/abc.txt * @param newPath * 移动后的文件目录,如：d:/acd/abc.txt