判断一个文件是否为二进制文件
public static boolean isBinary(File file) {
boolean isBinary = false;
try {
FileInputStream fin = new FileInputStream(file);
long len = file.length();
for (int j = 0; j < (int) len; j++) {
int t = fin.read();
if (t < 32 && t != 9 && t != 10 && t != 13) {
isBinary = true;
break;
}
}
} catch (Exception e) {
e.printStackTrace();
}
return isBinary;
}
将一个student.txt文件的数据导入MySQL数据库中一张student1表中:
import java.io.*;
import java.sql.*;
import java.util.*;
public class TextToDataBase {
/**
* @param args
* 本程序涉及文件IO,字符串分隔StringTokenizer,JDBC,数据库sql语句
*/
public static void main(String[] args) {
Connection con=null;
PreparedStatement pstm=null;
FileReader fr=null;
BufferedReader br=null;
try {
Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection("jdbc:mysql://localhost:3306/exercise1","root","root");
pstm=con.prepareStatement("insert into student1 (ID,name,age,gendar,score) values(?,?,?,?,?)");
fr=new FileReader("D:\\Exercise\\student.txt");
br=new BufferedReader(fr);
for(int i=0;i<5;i++){
String s=br.readLine();
StringTokenizer st=new StringTokenizer(s);
int ID=Integer.parseInt(st.nextToken());
String name=st.nextToken();
int age=Integer.parseInt(st.nextToken());
String gendar=st.nextToken();
int score=Integer.parseInt(st.nextToken());
pstm.setInt(1,ID);
pstm.setString(2,name);
pstm.setInt(3,age);
pstm.setString(4,gendar);
pstm.setInt(5,score);
pstm.executeUpdate();
}
br.close();
pstm.close();
con.close();
} catch (ClassNotFoundException e) {
e.printStackTrace();