Mobile App Regisration SQL Generation

GenerateMobileAppRegistrations.java

package csv;

import java.io.BufferedReader;
import java.io.FileReader;
import java.io.IOException;
import java.io.PrintWriter;

import csv.model.MobileAppRegisration;

public class GenerateMobileAppRegistrations {

    public static String ROOT_DIR = System.getProperty("user.home") + "/Desktop/";
	
    public static void main(String[] args) {

        String file =  "file_name";
        String line = "";
        String cvsSplitBy = ",";

        try (BufferedReader br = new BufferedReader(new FileReader(ROOT_DIR + file + ".csv"))) {
            
            PrintWriter writer = new PrintWriter(ROOT_DIR + file + ".sql");
            

            while ((line = br.readLine()) != null) {

                // use comma as separator
                String[] word = line.split(cvsSplitBy);
                MobileAppRegisration registration = new MobileAppRegisration();
                try{
                	String email = word[1].trim();
                	if(!"NULL".equals(email)){
                		registration.setEmail_address(email);
                	}
                    registration.setEnabled(!word[2].trim().isEmpty() ? word[2].trim() : "1");
                    registration.setMaximum_number_of_current_bookings(word[3].trim());
                    registration.setMobileos(word[4].trim());
                    registration.setMobileosversion(word[5].trim());
                    registration.setName(word[6].trim().replace("'", "''"));
                    registration.setNotification_device_id(word[7].trim());
                    registration.setRecord_created(word[8].trim().length() >9 ? word[8].trim().substring(0, 10) : word[8].trim());
                    registration.setRegistration_code(word[9].trim());
                    registration.setRegistration_code_sent(word[10].trim().length() >9 ? word[10].trim().substring(0, 10) : word[10].trim());
                    registration.setTaxi_company_id(word[11].trim());
                    registration.setTelephone(word[12].trim());
                    registration.setUuid(word[13].trim());
                    registration.setVersion(word[14].trim());
                    registration.setApp_version(word[15].trim());
                    writer.println(registration.toString());
                    System.out.println(registration.toString());
                    
                } catch (ArrayIndexOutOfBoundsException e){
                    //e.printStackTrace();
                }
           
            }
           
            writer.close();

        } catch (IOException e) {
            e.printStackTrace();
        }
       
    }
    
}

MobileAppRegisration.java

package csv.model;

public class MobileAppRegisration {
    
    private String email_address;
    private String enabled;
    private String maximum_number_of_current_bookings;
    private String mobileos;
    private String mobileosversion;
    private String name;
    private String notification_device_id;
    private String record_created;
    private String registration_code;
    private String registration_code_sent;
    private String taxi_company_id;
    private String telephone;
    private String uuid;
    private String version;
    private String app_version;
    
    

    public String getEmail_address() {
        return email_address;
    }
    public void setEmail_address(String email_address) {
        this.email_address = email_address;
    }
    public String getEnabled() {
        return enabled;
    }
    public void setEnabled(String enabled) {
        this.enabled = enabled;
    }
    public String getMaximum_number_of_current_bookings() {
        return maximum_number_of_current_bookings;
    }
    public void setMaximum_number_of_current_bookings(String maximum_number_of_current_bookings) {
        this.maximum_number_of_current_bookings = maximum_number_of_current_bookings;
    }
    public String getMobileos() {
        return mobileos;
    }
    public void setMobileos(String mobileos) {
        this.mobileos = mobileos;
    }
    public String getMobileosversion() {
        return mobileosversion;
    }
    public void setMobileosversion(String mobileosversion) {
        this.mobileosversion = mobileosversion;
    }
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public String getNotification_device_id() {
        return notification_device_id;
    }
    public void setNotification_device_id(String notification_device_id) {
        this.notification_device_id = notification_device_id;
    }
    public String getRecord_created() {
        return record_created;
    }
    public void setRecord_created(String record_created) {
        this.record_created = record_created;
    }
    public String getRegistration_code_sent() {
        return registration_code_sent;
    }
    public void setRegistration_code_sent(String registration_code_sent) {
        this.registration_code_sent = registration_code_sent;
    }
    public String getTaxi_company_id() {
        return taxi_company_id;
    }
    public void setTaxi_company_id(String taxi_company_id) {
        this.taxi_company_id = taxi_company_id;
    }
    public String getTelephone() {
        return telephone;
    }
    public void setTelephone(String telephone) {
        this.telephone = telephone;
    }
    public String getUuid() {
        return uuid;
    }
    public void setUuid(String uuid) {
        this.uuid = uuid;
    }
    public String getVersion() {
        return version;
    }
    public void setVersion(String version) {
        this.version = version;
    }
    public String getApp_version() {
        return app_version;
    }
    public void setApp_version(String app_version) {
        this.app_version = app_version;
    }
    public String getRegistration_code() {
        return registration_code;
    }
    public void setRegistration_code(String registration_code) {
        this.registration_code = registration_code;
    }
    
    @Override
    public String toString(){
        StringBuilder sb = new StringBuilder();
        sb.append("insert ignore into `tmp_table` (`email_address`, `enabled`, `maximum_number_of_current_bookings`, `mobileos`, `mobileosversion`, `name`, `notification_device_id`, `record_created`, `registration_code`, `registration_code_sent`, `taxi_company_id`, `telephone`, `uuid`, `version`, `app_version`)VALUES(");
        sb.append("\'").append(this.email_address != null ? this.email_address : "").append("\'").append(",");
        sb.append(this.enabled).append(",");
        sb.append("\'").append(this.maximum_number_of_current_bookings).append("\'").append(",");
        sb.append(this.mobileos).append(",");
        sb.append("\'").append(this.mobileosversion).append("\'").append(",");
        sb.append("\'").append(this.name).append("\'").append(",");
        sb.append("\'").append(this.notification_device_id).append("\'").append(",");
        sb.append("\'").append(this.record_created).append("\'").append(",");
        sb.append(this.registration_code).append(",");
        sb.append("\'").append(this.registration_code_sent).append("\'").append(",");
        sb.append(this.taxi_company_id).append(",");
        sb.append("\'").append(this.telephone).append("\'").append(",");
        sb.append("\'").append(this.uuid).append("\'").append(",");
        sb.append(this.version).append(",");
        sb.append("\'").append(this.app_version).append("\'");
        sb.append(");");
        return sb.toString();
        
    } 

}