为什么我这个文本文件第一行读不出来?在线等
public void readFile(String fileName) {
Connection con=null;
String sql="";
PreparedStatement ps=null;
con=JDBCUtil.getConnection();
String a=null;
String b=null;
try {
File file = new File(fileName);
FileReader readIn = new FileReader(file);
BufferedReader br = new BufferedReader(readIn);
String s1 = null;
//int line=0;
if((s1=br.readLine())==null){
JOptionPane.showMessageDialog(this,"此文件无内容,请重新选择!",
"Message Dlg",JOptionPane.INFORMATION_MESSAGE);
}else{
while((s1 = br.readLine()) != null)
{
//++line;
a=s1.substring(0, 43);
b=s1.substring(44, 49);
//System.out.println("开始导入!");
try {
sql="INSERT INTO TB_TEMP(Col001, Col002) VALUES ('"+a+"','"+b+"')";
ps=con.prepareStatement(sql);
ps.executeUpdate();
// System.out.println("导入ok!");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
//System.out.println("line:"+line);
//System.out.println(a);
//System.out.println(b);
//System.out.println(s1);
}
br.close();
readIn.close();
JOptionPane.showMessageDialog(this,"此文件已经导入完成!",
"Message Dlg",JOptionPane.INFORMATION_MESSAGE);
}
} catch (IOException e) {
System.out.println("Error Opening file");
}finally{
JDBCUtil.close(null, ps, null, con);
}
}