工作遇到oracle数据库迁移到MySQL数据库,用到校验缺失表
表太多随便搞了个文本对比器做下记录
import java.io.BufferedReader;
import java.io.FileReader;
import java.io.IOException;
public class TextComparatorIgnoreCase {
public static void main(String[] args) {
// 文件1中缺失而文件2中存在的内容
String file1Path = "C:\\Users\\Administrator\\Desktop\\file1.txt";
String file2Path = "C:\\Users\\Administrator\\Desktop\\file2.txt";
try {
String file1Content = getFileContent(file1Path);
String file2Content = getFileContent(file2Path);
compareTextIgnoreCase(file1Content, file2Content);
} catch (IOException e) {
e.printStackTrace();
}
}
private static String getFileContent(String filePath) throws IOException {
StringBuilder content = new StringBuilder();
BufferedReader reader = new BufferedReader(new FileReader(filePath));
String line;
while ((line = reader.readLine()) != null) {
content.append(line).append("\n");
}
reader.close();
return content.toString();
}
private static void compareTextIgnoreCase(String text1, String text2) {
String[] lines1 = text1.split("\n");
String[] lines2 = text2.split("\n");
System.out.println("文件1中缺失的内容:");
for (String line2 : lines2) {
boolean found = false;
for (String line1 : lines1) {
if (line1.equalsIgnoreCase(line2)) {
found = true;
break;
}
}
if (!found) {
System.out.println(line2);
}
}
}
}
import java.io.*;
public class TextToLowercase {
public static void main(String[] args) {
String filePath = "C:\\Users\\Administrator\\Desktop\\input.txt";
String outputFilePath = "output.txt";
try {
String fileContent = getFileContent(filePath);
String lowercaseContent = fileContent.toLowerCase();
writeToFile(outputFilePath, lowercaseContent);
System.out.println("文本内容已成功转换为小写并保存到文件 " + outputFilePath);
} catch (IOException e) {
e.printStackTrace();
}
}
private static String getFileContent(String filePath) throws IOException {
StringBuilder content = new StringBuilder();
BufferedReader reader = new BufferedReader(new FileReader(filePath));
String line;
while ((line = reader.readLine()) != null) {
content.append(line).append("\n");
}
reader.close();
return content.toString();
}
private static void writeToFile(String filePath, String content) throws IOException {
BufferedWriter writer = new BufferedWriter(new FileWriter(filePath));
writer.write(content);
writer.close();
}
}