/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package com.prometnanesreca;

import com.mysql.fabric.xmlrpc.base.Data;
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.Statement;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import javax.swing.text.DateFormatter;
import org.activiti.engine.delegate.DelegateTask;
import org.activiti.engine.delegate.TaskListener;

/**
 *
 * @author Marcelino
 */
public class DBCreate implements TaskListener {
     // JDBC driver name and database URL
   static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
   static final String DB_URL = "jdbc:mysql://localhost:3306/statistics";

   //  Database credentials
   static final String USER = "root";
   static final String PASS = "root";

    @Override
    public void notify(DelegateTask dt) {

      Connection conn = null;
   Statement stmt = null;
   try{
      //STEP 2: Register JDBC driver
      Class.forName("com.mysql.jdbc.Driver");

      //STEP 3: Open a connection
      System.out.println("Connecting to database...");
      conn = DriverManager.getConnection(DB_URL,USER,PASS);

      //STEP 4: Execute a query
      System.out.println("Creating statement...");
      stmt = conn.createStatement();
      Date date = new Date(System.currentTimeMillis());
      String sql;
     SimpleDateFormat ft =
      new SimpleDateFormat ("YYYY.MM.dd hh:mm:ss");
      sql = "INSERT INTO tasks(task_name,task_asignee,task_idZapisnika, task_zapisnik, task_uprava) " +
                   "VALUES ('"+dt.getName()+"', '"+dt.getAssignee()+"', '"+dt.getVariable("prometnanesreca_stevilka")+"','"+ "http://localhost:8282/share/generated/Zapisnik"+dt.getVariable("prometnanesreca_stevilka")+".pdf" +"', '"+dt.getVariable("prometnanesreca_policijskapostaja")+"')";
      stmt.executeUpdate(sql);
   }catch(Exception e){
       System.out.println("Exception: " );
        e.printStackTrace();
   }

    }




}