public class SM2sql {
public static void main(String[] args){
String inurl="E:\\sys_user.txt";
File infile=new File(inurl);
String outurl="E:\\sql.txt";
File outfile=new File(outurl);
try {
//如果写入的文件不存在创建新文件
if(!outfile.exists()){
outfile.createNewFile();
}
//文件的输入流读取文件
FileInputStream in=new FileInputStream(infile);
FileOutputStream out=new FileOutputStream(outfile);
//读文件
BufferedReader read=new BufferedReader(new InputStreamReader(in));
//写文件
BufferedWriter write=new BufferedWriter(new OutputStreamWriter(out));
String temp="";
while((temp=read.readLine())!=null){
//写入文件
String[] split = temp.split(",");
String encryption = SM2Utils.encryption(split[1]);
temp = "update sys_user set password = '" + encryption + "' where userId = '" + split[0] + "';";
write.write(temp+"\r\n");
System.out.println("update sys_user set password = '" + encryption + "' where userId = '" + split[0] + "';" + "\r\n");
}
read.close();
write.close();
out.close();
in.close();
} catch (Exception e) {
// TODO 自动生成的 catch 块
e.printStackTrace();
}
}
}
加解密代码
https://blog.csdn.net/nutnutnutnutnut/article/details/112610475
txt文件
用户名,密码
1,d7e84f0d9d0e22b38ad88e61974bf4f4
123,d7e84f0d9d0e22b38ad88e61974bf4f4
a,01ea982687acdf109214a8c232a63e0a