java中使用mysql_在Java中使用MySql

) {

if(Objects.equals(infomation[i], "null")){

infomation[i]="-1";

}

}

PreparedStatement psql;

ResultSet res;

psql= con.prepareStatement("insert into fpxx " +

"(xh,fp_nid,gfxbh,xfsbh,je,se,ze,kpyf,kprq,zfbz) " +

"values(?,?,?,?,?,?,?,?,?,?)");//try {

int len=infomation.length;//for (String s:infomation) {//System.out.println(s);//}

psql.setInt(1,count);

psql.setString(2,infomation[0].substring(1));

psql.setString(3,infomation[1]);

psql.setString(4,infomation[2]);//psql.setString(5,infomation[3]);//psql.setString(6,infomation[4]);//psql.setDouble(4,Double.parseDouble(infomation[infomation.length-5]));//psql.setDouble(5,Double.parseDouble(infomation[infomation.length-4]));

psql.setDouble(5,Double.parseDouble(infomation[3]));

psql.setDouble(6,Double.parseDouble(infomation[4]));

psql.setDouble(7,Double.parseDouble(infomation[5]));

psql.setInt(8,Integer.parseInt(infomation[6]));

psql.setString(9,infomation[7]);

psql.setString(10,infomation[8].charAt(0)+"");

psql.executeUpdate();//执行更新//}catch (Exception e){//errorCount++;//System.out.println("第"+count+"条数据出现错误");//System.out.println("-------------------");//System.out.println(count+" ---- "+str);//}//if(count>500){//break;//}

}long end=System.currentTimeMillis();

System.out.println(end-start);

con.close();//当读取的一行不为空时,把读到的str的值赋给str1//打印出str1

} catch(FileNotFoundException e) {

System.out.println("找不到指定文件");

}catch(IOException e) {

System.out.println("读取文件失败");

}catch (ClassNotFoundException |SQLException e) {

e.printStackTrace();

}finally{try{

br.close();

isr.close();

fis.close();//关闭的时候最好按照先后顺序关闭最后开的先关闭所以先关s,再关n,最后关m

} catch (IOException |NullPointerException e) {

e.printStackTrace();

}

}

}

}