package Java;

    //Putting into DB class
import java.sql.*;
import java.text.SimpleDateFormat;

public class Main {

    public static void main(String args[]) {

    }

    public static void DBcon(){
            //Creating connection
        String url = "jdbc:mysql://localhost:3306/Courses??autoReconnect=true&useSSL=false";
        String user = "root";
        String password = "root";
        Connection con;
        Statement stmt;
        ResultSet resultSet;
            //Creating Array
        String[][] mass = new String[0][0];
        mass = new HTMLparser().Parse(mass);
        String parsedDate= ""; //Date from XML
        String DateString = ""; //Date from DB
        try {
            //Formatting Date To sql.Date Format
            String dateInString;
            String initDateFormat = "dd.MM.yyyy";
            String endDateFormat = "yyyy-MM-dd";
            dateInString = mass[0][5];
            java.util.Date date = new SimpleDateFormat(initDateFormat).parse(dateInString);
            SimpleDateFormat formatter = new SimpleDateFormat(endDateFormat);
            parsedDate = formatter.format(date);
        }
        catch (Exception e){

        }
        try {
                //Connection and getting Dates from DB
            Class.forName("com.mysql.jdbc.Driver");
            con = DriverManager.getConnection(url, user, password);
            stmt = con.createStatement();
            resultSet = stmt.executeQuery("SELECT * FROM course;");
            resultSet.last();
            resultSet.getRow();
            resultSet = stmt.executeQuery("SELECT Date FROM course;");
            while (resultSet.next()){
                DateString = resultSet.getString("Date");
            }
            con.close();
            stmt.close();
            resultSet.close();
        }
        catch (SQLException e) {

        }
        catch (Exception e){

        }
                //Putting DATA into DB
            if(DateString.length()==0)
                DateString="0-0-0";
            int x = Integer.parseInt(DateString.replace("-",""));
            int y = Integer.parseInt(parsedDate.replace("-",""));
            if (x!=y) //Date Comparison
                for (int i = 0; i < 33; i++) {
                    try {
                        String Num_id = mass[i][0];
                        String Letter_id = mass[i][1];
                        int Counting = Integer.parseInt(mass[i][2]);
                        String Name = mass[i][3];
                        Double Value = Double.parseDouble(mass[i][4].replace(",", "."));
                        con = DriverManager.getConnection(url, user, password);
                        stmt = con.createStatement();
                            //SQL Query
                        stmt.executeUpdate("INSERT INTO course (Num_id, Letter_id,Counting,Name,Value,Date)" + "VALUES ('" + Num_id + "', '" + Letter_id + "', '" + Counting + "', '" + Name + "', '" + Value + "', '" + parsedDate + "');");
                        con.close();
                        stmt.close();
                    } catch (Exception e) {
                        e.printStackTrace();
                    }
                }
    }
}