LoadData_2.java

String LOADDATA = "LOAD DATA LOCAL INFILE '' INTO TABLE `bike_trip` "
+ "CHARACTER SET UTF8 FIELDS TERMINATED BY '\t' ENCLOSED BY '' "
+ "ESCAPED BY '\\\\' LINES TERMINATED BY '\n'  STARTING BY '' "
+ "(tripduration, starttime, stoptime, start_station_id, start_station_name, "
+ "start_station_latitude, start_station_longitude, end_station_id, "
+ "end_station_name, end_station_latitude, end_station_longitude, "
+ "bike_id, user_type, birth_year, gender)";

int cont = 0;
StringBuilder sb = new StringBuilder();
Iterator<TripEntity> iterator = trips.iterator();
while (iterator.hasNext()) {
    TripEntity trip = iterator.next();
    sb.append(trip.getTripduration()).append("\t");
    sb.append(sdfDateTime.format(trip.getStarttime())).append("\t");
    sb.append(sdfDateTime.format(trip.getStoptime())).append("\t");
    sb.append(trip.getStartStationId()).append("\t");
    sb.append(trip.getStartStationName()).append("\t");
    sb.append(trip.getStartStationLatitude()).append("\t");
    sb.append(trip.getStartStationLongitude()).append("\t");
    sb.append(trip.getEndStationId()).append("\t");
    sb.append(trip.getEndStationName()).append("\t");
    sb.append(trip.getEndStationLatitude()).append("\t");
    sb.append(trip.getEndStationLongitude()).append("\t");
    sb.append(trip.getBikeId()).append("\t");
    sb.append(trip.getUserType()).append("\t");
    sb.append(nullify(trip.getBirthYear())).append("\t");
    sb.append(trip.getGender()).append("\t");
    sb.append("\n");
    cont++;