mysql 批量数据提交jdbc

public void insertDate(){
   
 PreparedStatement prepstmt = null;
 try {
  long start=System.currentTimeMillis();
  DBConnect con=new DBConnect();
  Connection conn=con.getConnection();
  conn.setAutoCommit(false);  //速度大大提高，加入这个
   
  String sql="insert into scn_sensor_main(endpoint_id,value_id,sensor_value,record_at,payload_id) VALUES(?,?,?,?,?)";
  prepstmt=conn.prepareStatement(sql,ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
  for(int i=0;i<100000;i++){
   prepstmt.setInt(1, 346);
   prepstmt.setInt(2, 7);
   prepstmt.setString(3, "2561.5");
   prepstmt.setString(4, "2010-11-25 12:53:49");
   prepstmt.setInt(5, 56791);
   prepstmt.addBatch();
  }
  prepstmt.executeBatch();
  conn.commit();
  long end=System.currentTimeMillis();
  con.close();
  
  long time=end-start;
  System.out.println("ext time="+time);
 } catch (Exception e) {
  // TODO Auto-generated catch block
  e.printStackTrace();
 }
   
   }