package com.AdamMateusz.Kalendarz.Models;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class DatabaseManager {

    Connection connection = null;
    String connectionString = "";
    Statement stmt = null;
    ResultSet rs = null;
    boolean isConnected = false;
    public DatabaseManager() {

      connectionString =
              "jdbc:mysql://db4free.net:3306/kompo2018";
        //pass=JavaApp!

    }
    public boolean getIsConnected(){
        return this.isConnected;
    }
    public Statement getStmt() {
        return stmt;
    }

    public void setStmt(Statement stmt) {
        this.stmt = stmt;
    }

    public ResultSet getRs() {
        return rs;
    }

    public void setRs(ResultSet rs) {
        this.rs = rs;
    }

    public void connect() {
          try {
              connection = DriverManager.getConnection(connectionString, "kalendarzdb", "kalendarz2018");
              this.stmt = this.connection.createStatement();
              isConnected = true;
          }
          catch (Exception e) {
              e.printStackTrace();
          }
          finally {
             // if (connection != null) try { connection.close(); } catch(Exception e) {}
          }

    }
    public void disconnect() {
        try {
            connection.close();
            } catch(SQLException e) {e.printStackTrace();
            }
    }
}