txt文件上传数据 批量解析批量存入数据库方法操作(1)
/** * 批量添加航班信息 dao * */public boolean addFlightInfoList(ArrayList<String[]> aList) {// TODO Auto-generated method stubboolean flag=true;//session开启Session session=null;//事物开启Transaction transaction=null;try {session=HibernateSessionFactory.getSession();transaction=session.beginTransaction(); for (int i = 0; i < aList.size(); i++) { //循环遍历所有集合中的数组 System.out.println("aList.size()>>>>>>>>>>>>>>"+aList.size()); String[] arrayFlight=aList.get(i); for (int j = 0; j < arrayFlight.length; j++) {System.out.println(arrayFlight[6]);} System.out.println("%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%"); //将集合中的值遍历存储在每个数组中 TbFlightInfo flightInfo=new TbFlightInfo(); for (int j = 0; j < arrayFlight.length; j++) { //循环每个数组 取值 flightInfo.setDefault1(null); flightInfo.setDefault2(null); flightInfo.setDefault3(null); flightInfo.setDefault4(null); flightInfo.setDefault5(null); flightInfo.setFlightNo("CA1624"); flightInfo.setGuideTime(null); Float float1=Float.parseFloat(arrayFlight[9].toString()); Float float2=Float.parseFloat(arrayFlight[10].toString()); flightInfo.setInsurance(float2); flightInfo.setTicketAll(float1); flightInfo.setLeaveAddress(arrayFlight[7].toString()); flightInfo.setTicketNo(arrayFlight[7].toString()); flightInfo.setPassenger(arrayFlight[6].toString()); flightInfo.setSauaCost(null); flightInfo.setTakeOffTime(null); session.save(flightInfo);} // 判断 数据量到达该数据量时候刷新数据清空缓存 再次加快存储数据速度 if ((i+1)%100==0) {session.flush();session.clear();} } transaction.commit();} catch (Exception e) {// TODO: handle exceptione.printStackTrace();flag=false;}return flag;}