[Java Basics] Convert Dates


string format YYYY-MM-DD // 2017-12-31


private java.sql.Date stringToSQLDate(String date){
    java.util.Date dateRes =  stringToDate(date);
    return new java.sql.Date(dateRes.getTime());
}


private java.util.Date stringToDate(String date){

    String YYYY = date.substring(0, 4).toString();
    String MM = date.substring(5, 7).toString();
    String DD = date.substring(8, 10).toString();

    Calendar cl = Calendar.getInstance();

    cl.set(Calendar.YEAR, Integer.parseInt(YYYY));
    cl.set(Calendar.MONTH, Integer.parseInt(MM) -1);
    cl.set(Calendar.DATE, Integer.parseInt(DD));

    java.util.Date dateRes =  cl.getTime();

    return dateRes;
}




public static java.sql.Date UtilDateToSqlDate(java.util.Date date) {
    java.sql.Date result = new java.sql.Date(date.getTime());
    return result;
}