import java.io.BufferedWriter; import java.io.File; import java.io.FileInputStream; import java.io.FileOutputStream; import java.io.FileWriter; import java.io.IOException; import java.io.OutputStreamWriter; import java.net.MalformedURLException; import java.net.URL; import java.nio.file.Files; import java.util.Scanner; import javax.xml.parsers.DocumentBuilder; import javax.xml.parsers.DocumentBuilderFactory; import org.jsoup.Jsoup; import org.jsoup.nodes.Document; import org.jsoup.nodes.Element; import org.jsoup.nodes.Node; import org.jsoup.nodes.Document.OutputSettings; import org.jsoup.select.Elements; public class Main { /** * @param args * @throws IOException * @throws MalformedURLException */ public static void main(String[] args) throws Exception { System.out.println((int)'A'); //65 StringBuffer[] sb=new StringBuffer[26]; for(int j=0;j<sb.length;j++){ sb[j]=new StringBuffer("insert into code_"+(char)(j+97)+" (code,reward) values "); } File file=new File("D:/百度云/DL/一等奖/"); File[] fs=file.listFiles(); for(int i=0;i<fs.length;i++){ Scanner s=new Scanner(fs[i]); while(s.hasNextLine()){ String line=s.nextLine().trim(); if(!line.equals("")){ char ch=line.charAt(0); int chI=(int)ch; sb[chI-65].append("('"+line+"',1),"); } } } for(int j=0;j<sb.length;j++){ sb[j].deleteCharAt(sb[j].length()-1); sb[j].append(";"); } for(int j=0;j<sb.length;j++){ System.out.println(sb[j]); FileOutputStream fos=new FileOutputStream(new File(file.getAbsolutePath()+"/"+(char)(j+97)+".sql")); fos.write(sb[j].toString().getBytes()); fos.close(); } } }