如果平时遇到解释excel表格,就可以使用这个demo来变换你想要的代码,这里只是用于操作批量替换数据库数据库,解释excel文件里,要替换的文件内容,把sql解释出来,执行。
public static void main(String[] args) throws IOException {
String filePath = "D:\\MyDownloads\\Download\\delete.xls";
List<String> list = MyXmlUtil.parse(filePath);
File file = new File("D:\\MyDownloads\\Download\\deleteData1.txt");
OutputStream out = new FileOutputStream(file);
for(String row:list){
String[] lows = row.split(",");
String sql = "delete from waybill.waybill where cp_code='YUNDA' AND mail_no='"+lows[2]+"' AND package_code ='"+lows[1]+"';";
// String sql = "'"+lows[1]+"',";
System.out.println(sql);
out.write(sql.getBytes());