展开全部
import java.io.File;
import java.io.FileNotFoundException;
import java.util.Arrays;
import java.util.Scanner;
public class $ {
public static void main(String[] args) {
try {
Scanner in = new Scanner(new File("D:/a.sql"));
while (in.hasNextLine()) {
String str = in.nextLine();
String[] arr = str.split(",");
Float[] result = new Float[arr.length - 1];
for (int i = 0; i
result[i] = Float.parseFloat(trim(arr[i + 1]));
}
System.out.println(Arrays.toString(result));
}
in.close();
} catch (FileNotFoundException e) {
e.printStackTrace();
}
}
private static String trim(String str) {
str = str.replaceAll("'", "");
str = str.replaceAll(";", "");
return str;
}
}