读书人

txt文件下传数据 批量解析批量存入数据

发布时间: 2012-11-18 10:51:21 作者: rapoo

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;}

读书人网 >其他数据库

热点推荐