/*
 * Click nbfs://nbhost/SystemFileSystem/Templates/Licenses/license-default.txt to change this license
 * Click nbfs://nbhost/SystemFileSystem/Templates/Classes/Class.java to edit this template
 */
package emf.wrk;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.SimpleDateFormat;

/**
 *
 * @author DiasMadeiraL
 */
public class WrkDB {

    private Connection conn = null;

    public boolean ouvrirDB() {
        boolean isOk = false;
        if (conn == null) {
            isOk = open();
        }
        return isOk;
    }

    private boolean open() {
        boolean ok = false;
        String piloteOBDCPathDb = "jdbc:mysql://localhost:3306/133ex04db" + "?zeroDateTimeBehavior=convertToNull";
        try {
            Class.forName("com.mysql.jdbc.Driver");
            conn = DriverManager.getConnection(piloteOBDCPathDb, "root", "");
            ok = true;
        } catch (SQLException e) {
            System.out.println(e.getMessage());
        } catch (ClassNotFoundException e) {
            System.out.println(e.getMessage());
        } catch (Exception e) {
            System.out.println(e.getMessage());
        }
        return ok;
    }

    private boolean close() {
        boolean ok = false;
        try {
            if (conn != null) {
                if (!conn.isClosed()) {
                    conn.close();
                }
            }
            ok = true;
        } catch (SQLException e) {
            System.out.println(e.getMessage());
        }
        return ok;
    }

    public String getClasses() {
        String results = "AUCUNE CLASSE TROUVEE";
        String statement = "SELECT nom_classe FROM t_classe;";

        try {
            PreparedStatement prepared = conn.prepareStatement(statement);
            ResultSet resultset = prepared.executeQuery();
            results = "";

            while (resultset.next()) {
                results += resultset.getString("nom_classe") + " ";
            }

        } catch (Exception e) {
            results = e.getMessage() + " CAUSE : " + e.getCause();
        }

        return results;
    }

    public String getMatchs() {
        String results = "AUCUNE MATCH TROUVEE";
        String statement = "SELECT * FROM 133ex04db.t_match;";
        
        try {
            PreparedStatement prepared = conn.prepareStatement(statement);
            ResultSet resultset = prepared.executeQuery();
            results = "";
            
            while (resultset.next()) {
                results += "<p>"+ resultset.getInt("pk_match") 
                        +" "+ resultset.getString("date_match")
                        +" "+ resultset.getTime("heure_match") + "</p>";
                
            }//new SimpleDateFormat(format).format(new Date())

        } catch (Exception e) {
            results = e.getMessage() + " CAUSE : " + e.getCause();
        }

        return results;
    }
}