package com.power.Economy;

import java.io.File;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.Statement;

public class Database {


	private Connection connection;
	private File file;
	private Statement stmt;

	public Database(File f) {
		this.file = f;
		try {
			DriverManager.registerDriver(new org.sqlite.JDBC());
			this.connection = DriverManager.getConnection("jdbc:sqlite:" + this.file);
			this.stmt = this.connection.createStatement();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	private Database(String urlconn) {
		try {
			DriverManager.registerDriver(new com.mysql.jdbc.Driver());
			this.connection = DriverManager.getConnection(urlconn);
			this.stmt = this.connection.createStatement();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	public Database(String host, String database, String user, String pass) {
		this("jdbc:mysql://" + host + "/" + database + "?" + "user=" + user + "&password=" + pass);
	}

	public Connection getConnection() {
		return this.connection;
	}

	public void update(String sql){
		try {
			this.stmt.executeUpdate(sql);
		} catch (Exception e) {
			e.printStackTrace();
			System.out.println("Erro ao Executar SQL");
		}
	}

	public void update(PreparedStatement sql){
		try {
			sql.executeUpdate();
		} catch (Exception e) {
			e.printStackTrace();
			System.out.println("Erro ao Executar SQL");
		}
	}

	public PreparedStatement prepareStatement(String sql){
		try {
			return this.connection.prepareStatement(sql);
		} catch (SQLException e) {
			System.out.print("[MsSQLConnection] SQLException: " + e.getCause());
		}
		return null;
	}

}