package kwclan.metodos;

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

public class Dados {

	private File file;
	private Connection conn;
	private Statement stmt;

	private Dados(File file) {
		this.file = file;
		try {
			Class.forName("org.sqlite.JDBC");
			conn = DriverManager.getConnection("jdbc:sqlite:" + this.file);
			stmt = conn.createStatement();
		} catch (ClassNotFoundException | SQLException e) {
			e.printStackTrace();
		}
	}

	private Dados(String urlconn) {
		try {
			conn = DriverManager.getConnection(urlconn);
			stmt = conn.createStatement();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

	public Dados load(File file) {
		return new Dados(file);
	}

	public Dados load(String host, String user, String pass, String database) {
		return new Dados("jdbc:mysql://" + host + "/" + database + "?" + "user=" + user + "&password=" + pass);
	}

	public void update(String query) {
		try {
			stmt.executeUpdate(query);
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

	public ResultSet query(String q) {
		try {
			return stmt.executeQuery(q);
		} catch (SQLException e) {
		}
		return null;
	}

	public void close() {
		try {
			stmt.close();
			conn.close();
		} catch (SQLException e) {
		}
	}

	public boolean isConnected() {
		try {
			return stmt != null && conn != null && !stmt.isClosed() && !conn.isClosed();
		} catch (SQLException e) {
		}
		return false;
	}

	public Connection getConnection() {
		return conn;
	}

	public PreparedStatement ps(String query) throws SQLException {
		return conn.prepareStatement(query);
	}

}