mysql-Eclipse用JAVA连接Mysql插入大量数据报错Javaheapspace

 PreparedStatement ps = null; Connection con=null; BufferedReader br=new BufferedReader(new FileReader(Path.path_read_beijing)); StringBuffer s=null; StringBuffer wayId=null; StringBuffer isWay=new StringBuffer("false"); String regex_nd="\\d+"; //用匹配 tmp=new ArrayList(); //找出way类的信息 if(batchCount%100==0) { ps.clearBatch(); } if(s.indexOf("0) { //获得每一组WayId Pattern p1=Pattern.compile(regex_id); Matcher m1=p1.matcher(s); if(m1.find()) { wayId=new StringBuffer(m1.group()); } while (s.indexOf("") <= 0) { count++; s=new StringBuffer(br.readLine()); //获得该wayid下的refid if(s.indexOf("0) { System.out.println("所在行数:"+count); Pattern p=Pattern.compile(regex_nd); Matcher m=p.matcher(s); if(m.find()) { tmp.add(new StringBuffer(m.group())); } } //判断该way是否为道路 if(s.indexOf("0||s.indexOf("0||s.indexOf("0) { isWay=new StringBuffer("true"); } } for(int i=0;i

 } ps.executeBatch(); if(batchCount%100==0) { con.commit(); } } } } con.commit(); } catch (Exception e) { e.printStackTrace(); // TODO: handle exception }finally{ try { if(ps!=null) ps.close(); if(con!=null) con.close(); } catch (Exception e2) { e2.printStackTrace(); } } }